RE: how to retrieve sys password

RE: how to retrieve sys password

 

  

Even if you change the SYS password,one can logon as SYS using "conn sys as
sysdba" it will ask you the password,but you no need to type the
password,you just press enter key,that's it.
OR
Use this: Conn /as sysdba.It wont ask you the password it will automatically
logon to the DB as SYS.

Hope this helps you.

-Raaj

-----Original Message-----
From: John Thomas
[mailto:oracledba-ezmlmshield-x26398410.[Email address protected]
Sent: Thursday, May 31, 2007 2:20 AM
To: LazyDBA Discussion
Subject: Re: how to retrieve sys password


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
>
>



---------------------------------------------------------------------
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