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
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
Messages: 3202
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 - Production on Mi Sep 20 10:32:08 2006

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

SQL> connect / as sysdba

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: Fri Aug 18 02:02:37 CDT 2017

Total time taken to generate the page: 0.15514 seconds