Home » SQL & PL/SQL » SQL & PL/SQL » recovering lost dba password
recovering lost dba password [message #193917] Tue, 19 September 2006 22:57 Go to next message
vilas_mankar
Messages: 1
Registered: September 2006
Location: Pune India
Junior Member
Please tell me how to recover the DBA password in oracle 10g
Re: recovering lost dba password [message #193970 is a reply to message #193917] Wed, 20 September 2006 03:40 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You should still be able to log in with the Oracle OS User on the server without a password:

$/home/oracle > sqlplus /nolog

SQL*Plus: Release 9.2.0.6.0 - Production on Mi Sep 20 10:32:08 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> connect / as sysdba
Connected.
SQL>


Then you can set the password with "alter user ... identified by ..." to something you don't lose. Wink
Previous Topic: Reindexing the tables in oracle
Next Topic: ORACLE
Goto Forum:
  


Current Time: Mon Dec 05 09:01:43 CST 2016

Total time taken to generate the page: 0.17368 seconds