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

  • From: "Patricia Eyenga" <patricia.e@xxxxxxxx>
  • To: <askdba@xxxxxxxxxxxxx>, <oracle_champions@xxxxxxxxxxxxxxx>, <dba_gurus@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 16 Sep 2005 09:49:09 -0400

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


 



==================================================
 
Thanks & Best Regards,
 
Thiagu
 
==================================================

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

Other related posts: