Home » RDBMS Server » Security » recover password from file
recover password from file [message #126205] Fri, 01 July 2005 09:22 Go to next message
batstru
Messages: 3
Registered: June 2005
Junior Member
Hi all!
I probably have to restore my orcale password's file deleting orapw (lost sys/system password)...
so I would know if it's possible to recover usernames/passwords reading that file after deleting an setting up new sys password.

Can you help me?
Re: recover password from file [message #126256 is a reply to message #126205] Sat, 02 July 2005 02:38 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

hi,

Only Sysdba and Sysoper password are stored in password file and the rest username/passwords are stored in Oracle itself. So u jst delete the old file and create a new one using ORADIM utility and then u would be able to access the database.

Tarun
Re: recover password from file [message #126263 is a reply to message #126256] Sat, 02 July 2005 06:55 Go to previous messageGo to next message
Frank Naude
Messages: 4569
Registered: April 1998
Senior Member
Message reported by shettyshetty:

"ORADIM is used to create Oracle Service/instance in Windows platform, where as to create a password file ORAPWD is used."

Best regards.

Frank
Re: recover password from file [message #126264 is a reply to message #126263] Sat, 02 July 2005 08:00 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
Sorry to all,

It's ORAPWD utility.

Thanks for correcting the mistake, Frank.

Tarun
Re: recover password from file [message #126327 is a reply to message #126205] Sun, 03 July 2005 13:11 Go to previous message
Steve Callan
Messages: 44
Registered: January 2004
Member
orapwd does it outside of oradim, but oradim will also do it when you specify the "-intpwd" parameter. So, if you already have a service and just want to re-create the password file, use orapwd. There is also no harm in re-creating the service (along with the password file) either.

http://download-west.oracle.com/docs/cd/B10501_01/win.920/a95491/create.htm#1008939
-INTPWD password is the password for the new instance. This is the password for the user logged in with SYSDBA privileges. Option -INTPWD is not required. If you do not specify it, then operating system authentication is used, and no password is required.

[Updated on: Sun, 03 July 2005 13:11]

Report message to a moderator

Previous Topic: Lost password
Next Topic: HELP Please
Goto Forum:
  


Current Time: Fri Sep 24 04:18:52 CDT 2021