If you have access to the Unix oracle account, or the oracle software
owner or a member of the Unix dba group do:
sqlplus '/ as sysdba'
And reset the sys password to one you can remember.
Cheers,
J
In message <20070530193348.11526.[Email address protected]
Combes Tom VBAHINES
<oracledba-ezmlmshield-x26480186.[Email address protected] writes
>
>If you can connect "... as sysdba"
>then you don't need the SYS password,
>and you can then set it to something you know.
>To my knowledge, in 9i and later you cannot directly
>login as SYS.
>
>-----Original Message-----
>From: Nathaniel Banks Jr.
>[mailto:oracledba-ezmlmshield-x4584711.[Email address protected]
>Sent: Wednesday, May 30, 2007 2:49 PM
>To: LazyDBA Discussion
>Subject: how to retrieve sys password
>
>Hello Gurus,
>
>I've setup an Oracle 10gR2 database on my solaris 10 box and I can't
>seem to remember what I set the sys password to..Does anyone know of a
>way I can retrieve that password?
>
>
>
>
>
>
>
>---------------------------------------------------------------------
>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
>
>
>---------------------------------------------------------------------
>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