Can you login on the command line as oracle? If so,
sqlplus / as sysdba
or
sqlplus '/ as sysdba'
or
sqlplus /nolog
then connect as sysdba at SQL>.

If you cannot get on the server even as the user id oracle, then you have to log on as root, sudo or su - oracle and repeat the steps.

Then change the password.

LS

"640KB ought to be enough for anybody." - Bill Gates, 1981



----- Original Message ----
From: Noorul Abrar <oracledba-ezmlmshield-x51844777.[Email address protected]
To: LazyDBA Discussion <[Email address protected]
Sent: Wednesday, August 8, 2007 12:58:04 AM
Subject: Lost SYS Login Password


Hey gurus,



Incase if we have lost the sys password for oracle database server, do
we have any ways to reset being an DBA. Something like the way we do in
Linux in single usermode.



Any suggestion would be greatly appreciated.



Thanks,

Noorul Abrar.U



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Oracle LazyDBA home page