[askdba] Re: How can we reset SYSTEM / SYS password?

  • From: Thiagoo <thiagoodba@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx, oracle_champions@xxxxxxxxxxxxxxx, dba_gurus@xxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 16 Sep 2005 07:40:16 -0700 (PDT)

Thanks Patricia & Deepa!
 
Patricia,
 
Thanks! It worked out.
 
Deepa Kale, Thanks for your mail..Will try that also..!
 
Thanks & Best Regards,
-Thiagu


Patricia Eyenga <patricia.e@xxxxxxxx> wrote:
sqlplus /nolog
SQL> conn / as sysdba
 
 
then you can change the password with "alter user "

-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx] On 
Behalf Of Thiagoo
Sent: Friday, September 16, 2005 9:46 AM
To: oracle_champions@xxxxxxxxxxxxxxx; dba_gurus@xxxxxxxxxxxxxxx; 
askdba@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: [askdba] How can we reset SYSTEM / SYS password?


Hi,
 
My colleague has lost the SYS and SYSTEM password, but we know the Oracle UNIX 
user's password, is there any we to reset/revoer the password.
 
Using oradim the intpwd option, can we reset it?
 
We are in AIX 5.1 and Oracle 9.2!
 
TIA
-Thiagu


http://mail.yahoo.com 

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Other related posts: