OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » forget sys password

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

forget sys password [message #158228]

Thu, 09 February 2006 05:22

RAY_HT
Messages: 155
Registered: May 2005
Location: Giza

Senior Member

dear all
i'd like to ask
if i forgot sys and system password could i get it again or login to database anyway

there was file
orapwd file=$HOME/ADMIN/PFILE/orapw$ORACLE_SID
but in oracle 10g i didn't found it is it changed

if any one know where to find this file or how to slove this problem plz replay

Report message to a moderator

Re: forget sys password [message #158235 is a reply to message #158228]

Thu, 09 February 2006 06:13

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Generally the default file location is

$ORACLE_HOME/database on windows and $ORACLE_HOME/dbs on UNIX .

Delete the old file from that location and create a new one with the sys password and then you can log in as sys.

Alternatively, you can try to login from the command prompt like the following :