Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

forgotten password 2

Status
Not open for further replies.

josejoa

Technical User
Oct 4, 2001
3
ES
I made my first installation of an 8.1.6 instance several days ago. Now I can't remember the SYSTEM user password, Can I do something to retrieve it?
Thanks
 
Log into the OS as the owner of the software load.

If on unix:
1. Set your ORACLE_SID to the SID of the new database thwn run . oraenv (ksh) or coraenv (csh) to set up your environment.
2. start the server manager (svrmgrl)
3. type connet internal and enter
4. if you connect then type alter user system identified by aaaaaaaaa; enter
+++ where aaaaaaaaa = the new password

If on NT the start a command window
Set ORACLE_SID = <SID>
set ORACLE_HOME = <oracle home>
make sure the the ORACLE_HOME/bin directory is in the path then execute steps 2 - 4 above.

Hope this helps.

Rick
 

If you have not changed the password of user SYS, try to connect as sys/change_on_install to your database then change the password of SYSTEM.

If you forgot the password of INTERNAL, SYS, and SYSTEM then you'll have to perform more than this procedure.
 
Thanks for all.
I connect as INTERNAL and changed the password for SYSTEM user successfully.
THANKS
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top