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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Forgot password 1

Status
Not open for further replies.

dreampolice

Technical User
Dec 20, 2006
85
US
I have an Oracle 9i developer database on my Windows workstation. I havent used it in a couple weeks and forgot my Sysdba login password. Please advise how I can reset it or get into the database?
 
First, login to your machine as a user that is member of the ORA_DBA administrative group on that machine. Then:
Code:
C:\> sqlplus /nolog
SQL> connect / as sysdba
connected.
SQL> ALTER USER <username> IDENTIFIED BY <new password>;

User altered.

SQL> exit
Let us know if you have any problems.

[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
 
Thanks, I tried that and it said "insufficient priviledges" after I tried the "connect / as sysdba" connection.
 
Dreampolice,

Your error, above, could have occurred for either or both of these two reasons:

1) You attempted to perform the above tasks as a user that is not a member of ORA_DBA group. (Check group membership via "Start -> Control Panel -> User Accounts"), or,

2) Your file, $ORACLE_HOME\network\admin\sqlnet.ora, must contain the setting:
Code:
SQLNET.AUTHENTICATION_SERVICES = (NTS)

Confirm the correctness of the above issues/settings, try again, then let us know your outcome.

[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top