Home » RDBMS Server » Security » Recovering the sys password
Recovering the sys password [message #62939] Wed, 25 August 2004 03:54 Go to next message
Shakeel
Messages: 8
Registered: July 2003
Junior Member
Hi!
I want to know how to recover the password for sys if we forget it.
Anybody here know how to do this?

Thank you.

Shakeel.
Re: Recovering the sys password [message #62940 is a reply to message #62939] Wed, 25 August 2004 04:03 Go to previous messageGo to next message
nabila
Messages: 13
Registered: April 2003
Junior Member
on your database server

if unix :

export ORACLE_SID=yoursid
sqlplus /nolog
sqlplus> connect / as sysdba
alter sys identified by newpassword
Re: Recovering the sys password [message #62983 is a reply to message #62939] Mon, 30 August 2004 07:00 Go to previous messageGo to next message
easywebtech
Messages: 20
Registered: August 2004
Junior Member
first renam you password file.It should be in database folder <darabases SID>pwd.ora.

Usage: orapwd file=[[path]][[fname]] password=[[password]] entries=[[users]]
where
file - name of password file (mandatory),
password - password for SYS and INTERNAL (mandatory),
entries - maximum number of distinct DBAs and OPERs (optional),
There are no spaces around the equal-to (=) character. .

webmaster
www.easywebtech.com
Re: Recovering the sys password [message #62986 is a reply to message #62983] Mon, 30 August 2004 22:38 Go to previous messageGo to next message
Shakeel
Messages: 8
Registered: July 2003
Junior Member
So I have to rename the password file before changing the sys password?

Thank you both.

Shakeel

:)
Re: Recovering the sys password [message #63009 is a reply to message #62986] Wed, 01 September 2004 09:04 Go to previous messageGo to next message
easywebtech.com
Messages: 6
Registered: September 2004
Junior Member
yes, first you have to rename your password file.
after that you can run the command.

sample.

D:>orapwd file=D:oracleora91databaseabdped.ora password=oracle entries=10

webmaster
www.easywebtech.com
Re: Recovering the sys password [message #63013 is a reply to message #63009] Wed, 01 September 2004 23:20 Go to previous message
Shakeel
Messages: 8
Registered: July 2003
Junior Member
Thanx alot.

:)
Shakeel
Previous Topic: schema access
Next Topic: windows Authentication
Goto Forum:
  


Current Time: Thu Mar 28 16:00:17 CDT 2024