心所嚮往的部落格

oracle password recovery free tool ~ ngorca

COLUMN NAME FORMAT A30
COLUMN PASSWORD FORMAT A30
COLUMN SPARE4 FORMAT A70

SQL> SELECT name,password FROM SYS.USER$ WHERE password is not null and name = 'SYSTEM';

NAME PASSWORD
------------------------------ ------------------------------
SYSTEM D4DF7931AB130E37

SQL> SELECT name,spare4 FROM SYS.USER$ WHERE password is not null and name='SYSTEM';

S:22B95AF42FB2B84115E236B86BBB8DEC5E0366DA46B51C5D49ED2E88AEC8

[ossadmin@nmswp ngorca-1.0.2]$ vi hashlist
SYSTEM:D4DF7931AB130E37:22B95AF42FB2B84115E236B86BBB8DEC5E0366DA46B51C5D49ED2E88AEC8

[root@XXX ngorca-1.0.2]$ ngorca -f hashlist -l7 -c2 -t2 -v4

ngorca 1.0.2 (http://netgarage.org)

starting 2 thread(s) to calculate 1 hash value(s)
.................................................

[passlength=7] status 32 %

found pwd --- beer!
username: SYSTEM password: manager
needed 5994 seconds of cpu time
needed 2998 seconds

.................................................

needed 5994 seconds of cpu time
needed 2998 seconds

ngorca Note:

-f hashlist
To use ngorca a list of username and hash is required, which has the format
username:hash. The hash values are calculated one after another.
example of hash file entry with old DES hash and SHA1 hash:
NETGARAGE:5D7F5FD88AE4C07F:EAC3EAC57FF0635AB298EB40CBDA1BB45DFC1B7F20464AA591C1613A2CB8
<username>:<16 byte DES hash>:<40 byte SHA1 hash + 20 byte salt>
In oracle versions 7-10g there is only the DES hash.

-l password length
Length of the password. If this option is not set the passwords from a length of 5-8 bytes are calculated.

-c charset
The charset of the password. 1 for numeric, 2 for alpha, 3 for alpha numeric
and 4 for alpha numeric with special characters. The default is 3.

-v verbose level
Loglevel for the logfile and standard output 1 - 4 with 4 as the highest level
which contains percent printouts. The default is 1.

-t thread number
The number of threads which should be used. It is recommended to take the
number of cpu's which you want to involve in the calculation for the best
result. The default is 1.

Oracle Complains ORA-01157 and ORA-01110 errors.

# /etc/init.d/dbstart

Sun Microsystems Inc.   SunOS 5.8       Generic Patch   February 2004

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Jun 5 15:46:33 2013

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> Connected to an idle instance.

SQL> ORACLE instance started.

Total System Global Area 1259835096 bytes

Fixed Size                   732888 bytes

Variable Size             486539264 bytes

Database Buffers          771751936 bytes

Redo Buffers                 811008 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 2 - see DBWR trace file

ORA-01110: data file 2: '/oracle/oradata/XXX/undotbs01.dbf'

(1) Determining Which Datafiles got lost

COL df# FORMAT 999
COL df_name FORMAT a40
COL tbsp_name FORMAT a10
COL status FORMAT a7
COL error FORMAT a15

SQL> SELECT r.FILE# AS df#, d.NAME AS df_name, t.NAME AS tbsp_name, d.STATUS, r.ERROR, r.CHANGE#, r.TIME
2 FROM V$RECOVER_FILE r, V$DATAFILE d, V$TABLESPACE t WHERE t.TS# = d.TS# AND d.FILE# = r.FILE#;

DF# DF_NAME                                                     TBSP_NAME  STATUS  ERROR         CHANGE# TIME

---- --------------------                                                    ---------- ------- ---------- ---------- ---------

   2 /oracle/oradata/XXX/undotbs01.dbf    UNDOTBS1   ONLINE  FILE NOT FOUND            0

(2) Re-Creating Datafiles When Backups Are Not Available

### create temp tablespace then switch to this tablespace

SQL> CREATE UNDO TABLESPACE UNDOTBS3 DATAFILE '/oracle/oradata/XXX/undotbs03.dbf' SIZE 25M REUSE AUTOEXTEND ON;

Tablespace created.

SQL> ALTER SYSTEM SET UNDO_TABLESPACE = 'UNDOTBS3';

System altered.

### drop lost undo datafile 

SQL> alter database datafile '/oracle/oradata/XXX/undotbs01.dbf' offline drop;

Database altered.

SQL> DROP TABLESPACE UNDOTBS1 INCLUDING CONTENTS AND DATAFILES;

Tablespace dropped.

### re-create undo tablespace

SQL> CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE '/oracle/oradata/XXX/undotbs01.dbf' SIZE 25M REUSE AUTOEXTEND ON;

Tablespace created.

### switch back to original undo tablespace

SQL> ALTER SYSTEM SET UNDO_TABLESPACE = 'UNDOTBS1';

System altered.

SQL> show parameter undo;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 300
undo_suppress_errors boolean FALSE
undo_tablespace string UNDOTBS1