CN105095513B - A kind of method and apparatus cracking oracle database account password - Google Patents
A kind of method and apparatus cracking oracle database account password Download PDFInfo
- Publication number
- CN105095513B CN105095513B CN201510570804.XA CN201510570804A CN105095513B CN 105095513 B CN105095513 B CN 105095513B CN 201510570804 A CN201510570804 A CN 201510570804A CN 105095513 B CN105095513 B CN 105095513B
- Authority
- CN
- China
- Prior art keywords
- password
- super keepe
- field
- storage
- oracle database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 27
- 238000005336 cracking Methods 0.000 title claims abstract description 18
- 238000012790 confirmation Methods 0.000 claims description 12
- 238000013507 mapping Methods 0.000 claims description 5
- 238000007689 inspection Methods 0.000 claims description 2
- 235000013399 edible fruits Nutrition 0.000 claims 1
- 230000006870 function Effects 0.000 description 20
- 230000008859 change Effects 0.000 description 8
- 230000004048 modification Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000000694 effects Effects 0.000 description 2
- 241000270708 Testudinidae Species 0.000 description 1
- 210000000988 bone and bone Anatomy 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Computing Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Storage Device Security (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of method and apparatus cracking oracle database account password, including：System table space is changed by Oracle blocks browser and edit tool,The block address of the data block of super keepe password is stored in setting system table space,Call function obtains the field of the super keepe password of the data block storage,New super keepe password is arranged in the value of the field of acquired storage super keepe password,After determining that the new super keepe password is arranged successfully,It restarts oracle database and obtains data,The above method directly reads the data file of data block by using BBED tools,So that user can by searching for storage super keepe password data block and reset,And then it can log on to and obtain data in oracle database,Allow to regardless of oracle database is using which kind of authentication mode,User may log on oracle database and obtain data.
Description
Technical field
The present invention relates to computer database system field, espespecially a kind of method cracking oracle database account password
And device.
Background technology
Oracle database is that the database in a distributed manner that Oracle companies of the U.S. (inscriptions on bones or tortoise shells) provide is a of core
Relational database management system is the number of current most popular client/server (Client/Server) or B/S architectures
According to one of library.
In the prior art, usually data are obtained from oracle database to need by cipher authentication, Oracle data
There are two types of modes for the cipher authentication in library, are the certification of the certification and database rank of system level respectively, if using being
The other certification of irrespective of size, user, which only needs to log on to, need not input password on host and may log into database, if it is use
Be database certification, user's log database must just input password.
It,, will if user has forgotten password when using the certification of system level but using the prior art
Cause user that can not log in oracle database to go to obtain data.
Invention content
In order to solve the above technical problem, the present invention provides a kind of method cracking oracle database account password and
Device, when enabling to forget Password using which kind of authentication mode and user regardless of oracle database,
User may log on oracle database and obtain data.
In a first aspect, the present invention provides a kind of method of oracle database account password, including：
System table space is changed by Oracle blocks browser and edit tool, is arranged in system table space and stores super pipe
The block address of the data block of reason person's password；
Call function obtains the field of the super keepe password of the data block storage, by the acquired super pipe of storage
The value of the field of reason person's password is arranged to new super keepe password；
After determining that new super keepe password is arranged successfully, oracle database is restarted.
Second aspect, the present invention provide a kind of diagnostic device of processor fault, including：Setup module, crypto module and
Confirmation module；
System is arranged for changing system table space by Oracle blocks browser and edit tool in the setup module
The block address of the data block of super keepe password is stored in table space；
The crypto module obtains the field of the super keepe password of the data block storage for call function, will
The value of the field of the storage super keepe password of acquisition is arranged to new super keepe password；
The confirmation module restarts Oracle data after determining that new super keepe password is arranged successfully
Library.
Compared with prior art, a kind of method cracking oracle database account password provided by the invention, including：It is logical
Oracle blocks browser and edit tool modification system table space are crossed, storage super keepe password in system table space is set
The block address of data block, call function obtain the field of the super keepe password of the data block storage, acquired are deposited
New super keepe password is arranged in the value for storing up the field of super keepe password, determines that the new super keepe password is set
After being set to work(, restarting oracle database obtains data, and the above method directly reads data block by using BBED tools
Data file so that user can by searching for storage super keepe password data block and reset,
And then it can log on to and obtain data in oracle database so that can be regardless of oracle database is using which kind of certification
Mode, user may log on oracle database and obtain data.
Other features and advantages of the present invention will be illustrated in the following description, also, partly becomes from specification
It obtains it is clear that understand through the implementation of the invention.The purpose of the present invention and other advantages can be by specification, rights
Specifically noted structure is realized and is obtained in claim and attached drawing.
Description of the drawings
Attached drawing is used for providing further understanding technical solution of the present invention, and a part for constitution instruction, with this
The embodiment of application technical solution for explaining the present invention together, does not constitute the limitation to technical solution of the present invention.
Fig. 1 is a kind of flow signal of embodiment of the method one cracking oracle database account password provided by the invention
Figure；
Fig. 2 is a kind of flow signal of embodiment of the method two cracking oracle database account password provided by the invention
Figure；
Fig. 3 is a kind of function module for the device embodiment one cracking oracle database account password provided by the invention
Figure.
Specific implementation mode
To make the objectives, technical solutions, and advantages of the present invention clearer, below in conjunction with attached drawing to the present invention
Embodiment be described in detail.It should be noted that in the absence of conflict, in the embodiment and embodiment in the application
Feature mutually can arbitrarily combine.
Step shown in the flowchart of the accompanying drawings can be in the computer system of such as a group of computer-executable instructions
It executes.Also, although logical order is shown in flow charts, and it in some cases, can be with suitable different from herein
Sequence executes shown or described step.
The present embodiments relate to oracle database account password method and apparatus, be applied to oracle database
Each version, specifically can be by being realized on computer cluster or server cluster, but be not limited thereto.
The present embodiments relate to method and apparatus, it is intended to solve in the prior art when recognizing using system level
When card, if user has forgotten password, may result in user can not log in the technical issues of oracle database goes to obtain data.
Fig. 1 is a kind of flow signal of embodiment of the method one cracking oracle database account password provided by the invention
Figure, as shown in Figure 1, this method includes：
S101, system table space is changed by Oracle blocks browser and edit tool, is arranged in system table space and stores
The block address of the data block of super keepe password.
Specifically, Oracle blocks browser and edit tool (Oracle Block Brower and Editor Tool,
Referred to as：BBED it is) for being directly viewable and changing data file data tool, is a inside of oracle database
Tool can directly change the content of Oracle data file blocks, which is not supported by Oracle, so acquiescence is that do not have
Have and generate executable file, need to reconnect before use, allows to change system table sky by the way that BBED tools are arranged
Between, which is that Oracle is automatically created when creating database, and each oracle database can have system table
Space, and system table space will be always maintained under online mode, because required by being run it comprises oracle database
Essential information, such as：Data dictionary, on-line help mechanism, all rollback segments, interim section and bootstrapping section, all user data
The table etc. of library entity, other oracle software product requirements, so as to change in the system table space for needing to change
The address of data block.
S102, call function obtain the field of the super keepe password of the data block storage, by acquired storage
The value of the field of super keepe password is arranged to new super keepe password.
Specifically, getting the data block address for needing to change, found described in storage according to the address of the data block
The data block of the super keepe password of oracle database, and the super pipe that the data block stores is got by call function
The value setting user of the field of acquired storage super keepe password is thought any close of setting by the field of reason person's password
Code, the password can be entirely number, can also be the combination of number and letter, are mainly convenient for user setting, but not
As limit.
S103, after determining that the new super keepe password is arranged successfully, oracle database is restarted.
Specifically, after good new super keepe password to be placed, needing to verify the password, whether success is set, determines
New super keepe password is arranged successfully, restarts oracle database, so that it may to directly acquire data.
A kind of method cracking oracle database account password provided in an embodiment of the present invention, including：Pass through Oracle
Block browser and edit tool change system table space, and the data block of storage super keepe password in system table space is arranged
Block address, call function obtains the field of the super keepe password of the data block storage, by the acquired super pipe of storage
New super keepe password is arranged in the value of the field of reason person's password, determines that the new super keepe password is arranged successfully
Afterwards, restarting oracle database obtains data, and the above method directly reads the data of data block by using BBED tools
File so that user can by searching for storage super keepe password data block and reset, Jin Erke
Data are obtained in oracle database to log on to so that can regardless of oracle database is using which kind of authentication mode,
User may log on oracle database and obtain data.
Fig. 2 is a kind of flow signal of embodiment of the method two cracking oracle database account password provided by the invention
Figure, as shown in Fig. 2, further, on the basis of the above embodiments, above-mentioned steps 102 are specially：
S201, the function that storage super keepe password is obtained by mapping directive, print the result of the function.
Specifically, the address of super keepe password is stored in data block, it is super by sending mapping directive acquisition storage
The function of administrator's password, the function can call the data file of data block to obtain the field for storing super keepe password,
By print command print the function as a result, the result includes the field in relation to super keepe password.
S202, the parsing function result obtain the field of storage super keepe password, and the value for changing the field is
New super keepe password.
Specifically, the function result got to be analyzed to the field of data, the word for storing super keepe password is judged
Section changes the value of the field for new super keepe password, convenient for logging on to Oracle by user according to the wish of oneself
Database obtains data.
Further, on the basis of the above embodiments, above-mentioned steps 103 are specially：
It calculates and checks that the field for the value for storing new super keepe password determines that then the super keepe is close without damage
Code is arranged successfully, restarts oracle database.
Specifically, after setting the value of new super keepe password, calculating inspection is carried out, such as verify can be passed through
Whether order, the order can return damaging as a result, when the value returned determines that the value and field are no damages, it is determined that new
Super keepe password be arranged successfully, user only need restart oracle database can obtain data.
Optionally, the above method can be realized by following procedure code, it is specific as follows：
1, BBED is set, including：The Parameter File and listed files file for generating BBED, then log in BBED.
2, setting needs reference number of a document, data block number and the offset changed.
3, the field value of kdbr is printed.
4, the value of specified field is printed.
5, correct offset is searched.
6, it is revised as new value.
7, it comes into force.
BBED>sum dba 1,54apply
Check value for File 1,Block 54:
Current=0x919b, required=0x919b
8, it verifies.
SQL>conn sys/testpass
Connected.
And select confirms new password hash value:
SQL>Select password from dba_users where username='SYS'；
PASSWORD
E2A109347F6C7832
One of ordinary skill in the art will appreciate that：Realize that all or part of step of above method embodiment can pass through
The relevant hardware of program instruction is completed, and program above-mentioned can be stored in a computer read/write memory medium, the program
When being executed, step including the steps of the foregoing method embodiments is executed；And storage medium above-mentioned includes：ROM, RAM, magnetic disc or light
The various media that can store program code such as disk.
Fig. 3 is a kind of function module for the device embodiment one cracking oracle database account password provided by the invention
Figure, as shown in figure 3, the device includes：Setup module 10, crypto module 20 and confirmation module 30；
The setup module 10, for the modification range of Oracle blocks browser and edit tool to be arranged to system table sky
Between, and the block address of data block in the system table space for needing to change is set；
The crypto module 20 obtains the field of the super keepe password of the data block storage for call function,
The value of the field of the storage super keepe password of acquisition is arranged to new super keepe password；
The confirmation module 30 restarts Oracle data for determining that new super keepe password is arranged successfully
Library.
A kind of device cracking oracle database account password provided in an embodiment of the present invention, including：It is setup module, close
Code module and confirmation module, the setup module are used to change system table space by Oracle blocks browser and edit tool,
The block address of the data block of super keepe password is stored in setting system table space, the crypto module is obtained for call function
The field for taking the super keepe password of the data block storage, by the value of the field of acquired storage super keepe password
New super keepe password is set, after the confirmation module is used to determine that the super keepe password is arranged successfully, again
Starting oracle database, above-mentioned apparatus directly reads the data file of data block by using BBED tools, so that with
Family can by searching for storage super keepe password data block and reset, and then Oracle numbers can be logged on to
According to obtaining data in library so that can be regardless of oracle database to be using which kind of authentication mode, user may log on
Oracle database obtains data.
Further, the crypto module 20 obtains the super keepe password of the data block storage for call function
Field, the value of the field of acquired storage super keepe password is arranged to new super keepe password, refers to：
The crypto module 20 is used to obtain the function of storage super keepe password by mapping directive, prints the letter
Several results；
The crypto module 20 is used to parse the field that the function result obtains storage super keepe password, changes institute
The value for stating field is new super keepe password.
A kind of device cracking oracle database account password provided in an embodiment of the present invention, can execute the above method
Embodiment, implementing principle and technical effect are similar, and details are not described herein.
Further, after the confirmation module 30 is for determining that the new super keepe password is arranged successfully, again
Start oracle database, refers to：
The confirmation module 30, which calculates, checks that the field for the value for storing new super keepe password is determined without damage, then institute
It states super keepe password to be arranged successfully, restarts oracle database.
A kind of device cracking oracle database account password provided in an embodiment of the present invention, can execute the above method
Embodiment, implementing principle and technical effect are similar, and details are not described herein.
Although disclosed herein embodiment it is as above, the content only for ease of understanding the present invention and use
Embodiment is not limited to the present invention.Technical staff in any fields of the present invention is taken off not departing from the present invention
Under the premise of the spirit and scope of dew, any modification and variation, but the present invention can be carried out in the form and details of implementation
Scope of patent protection, still should be subject to the scope of the claims as defined in the appended claims.
Claims (6)
1. a kind of method cracking oracle database account password, which is characterized in that including：
System table space is changed by Oracle blocks browser and edit tool, is arranged in system table space and stores super keepe
The block address of the data block of password；
Call function obtains the field of the super keepe password of the data block storage, by acquired storage super keepe
The value of the field of password is arranged to new super keepe password；
After determining that new super keepe password is arranged successfully, oracle database is restarted.
2. according to the method described in claim 1, it is characterized in that, the call function obtains the super of the data block storage
It is close to be arranged to new super keepe by the field of administrator's password for the value of the field of acquired storage super keepe password
Code, including：
The function that storage super keepe password is obtained by mapping directive, prints the result of the function；
The field that the function result obtains storage super keepe password is parsed, the value for changing the field is super pipe newly
Reason person's password.
3. according to the method described in claim 1, it is characterized in that, the new super keepe password of the determination is arranged successfully
Afterwards, oracle database is restarted, including：
The field determination of the value of the new super keepe password of calculating inspection storage is set without damage, then the super keepe password
It is set to work(, restarts oracle database.
4. a kind of device cracking oracle database account password, which is characterized in that including：Setup module, crypto module and
Confirmation module；
The setup module, for changing system table space by Oracle blocks browser and edit tool, setting system table is empty
Between it is middle storage super keepe password data block block address；
The crypto module obtains the field of the super keepe password of the data block storage for call function, will obtain
The value of field of storage super keepe password be arranged to new super keepe password；
The confirmation module restarts oracle database after determining that new super keepe password is arranged successfully.
5. device according to claim 4, which is characterized in that the crypto module call function obtains the data block and deposits
The value of the field of acquired storage super keepe password is arranged to new super by the field of the super keepe password of storage
Administrator's password refers to：
The crypto module is used to obtain the function of storage super keepe password by mapping directive, prints the knot of the function
Fruit；
The crypto module is used to parse the field that the function result obtains storage super keepe password, changes the field
Value be new super keepe password.
6. device according to claim 4, which is characterized in that the confirmation module determines that the new super keepe is close
After code is arranged successfully, oracle database is restarted, refers to：
The confirmation module, which calculates, checks that the field for the value for storing new super keepe password is determined without damage, then described super
Administrator's password is arranged successfully, restarts oracle database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510570804.XA CN105095513B (en) | 2015-09-09 | 2015-09-09 | A kind of method and apparatus cracking oracle database account password |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510570804.XA CN105095513B (en) | 2015-09-09 | 2015-09-09 | A kind of method and apparatus cracking oracle database account password |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105095513A CN105095513A (en) | 2015-11-25 |
| CN105095513B true CN105095513B (en) | 2018-07-31 |
Family
ID=54575948
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510570804.XA Active CN105095513B (en) | 2015-09-09 | 2015-09-09 | A kind of method and apparatus cracking oracle database account password |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105095513B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111104693A (en) * | 2019-12-26 | 2020-05-05 | 陕西美亚秦安信息科技有限公司 | Android platform software data cracking method, terminal device and storage medium |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107247643A (en) * | 2017-06-28 | 2017-10-13 | 上海优刻得信息科技有限公司 | A kind of data base management method, device, system, storage medium and equipment |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO1997046933A1 (en) * | 1996-06-03 | 1997-12-11 | Electronic Data Systems Corporation | Automated password reset |
| EP2008220B1 (en) * | 2006-03-31 | 2012-09-05 | Hewlett-Packard Development Company, L.P. | Service management framework |
| CN104391874A (en) * | 2014-10-29 | 2015-03-04 | 中国建设银行股份有限公司 | Database password management method and system |
-
2015
- 2015-09-09 CN CN201510570804.XA patent/CN105095513B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO1997046933A1 (en) * | 1996-06-03 | 1997-12-11 | Electronic Data Systems Corporation | Automated password reset |
| EP2008220B1 (en) * | 2006-03-31 | 2012-09-05 | Hewlett-Packard Development Company, L.P. | Service management framework |
| CN104391874A (en) * | 2014-10-29 | 2015-03-04 | 中国建设银行股份有限公司 | Database password management method and system |
Non-Patent Citations (1)
| Title |
|---|
| Oracle数据库块损坏的恢复——浅析BBED在数据库恢复中的应用;陈飞;《计算机光盘软件与应用》;20111116(第21期);全文 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111104693A (en) * | 2019-12-26 | 2020-05-05 | 陕西美亚秦安信息科技有限公司 | Android platform software data cracking method, terminal device and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105095513A (en) | 2015-11-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110495132B (en) | System and method for generating, uploading and executing code blocks within distributed network nodes | |
| WO2020000725A1 (en) | Electronic apparatus, data migration method, and storage medium | |
| KR101707369B1 (en) | Construction method and device for event repository | |
| WO2019140828A1 (en) | Electronic apparatus, method for querying logs in distributed system, and storage medium | |
| US8201079B2 (en) | Maintaining annotations for distributed and versioned files | |
| US11783114B2 (en) | Techniques for view capture and storage for mobile applications | |
| US8468146B2 (en) | System and method for creating search index on cloud database | |
| WO2015176431A1 (en) | Method and device for generating test data | |
| US8874519B1 (en) | Method and apparatus for restoring a table in a database | |
| CN106445643B (en) | It clones, the method and apparatus of upgrading virtual machine | |
| US20210367763A1 (en) | Blockchain-based data evidence storage method and apparatus | |
| CN105573859A (en) | Data recovery method and device of database | |
| CN106649360B (en) | Data repeatability checking method and device | |
| WO2018006587A1 (en) | File storage method, terminal, and storage medium | |
| CN102272751A (en) | Data integrity in a database environment through background synchronization | |
| CN109388614A (en) | A kind of method, system and the equipment of catalogue file number quota | |
| US10083192B2 (en) | Deleted database record reuse | |
| US11899770B2 (en) | Verification method and apparatus, and computer readable storage medium | |
| CN105095513B (en) | A kind of method and apparatus cracking oracle database account password | |
| US11853284B2 (en) | In-place updates with concurrent reads in a decomposed state | |
| KR101588375B1 (en) | Method and system for managing database | |
| CN108234122A (en) | Token method of calibration and device | |
| US20130138683A1 (en) | Systems and methods of automatic generation and execution of database queries | |
| US20210050107A1 (en) | Medical treatment management | |
| CN111427902A (en) | Metadata management method, device, equipment and medium based on lightweight database |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |