Forgot password 1

[dreampolice]

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?

 

[SantaMufasa]

First, login to your machine as a user that is member of the ORA_DBA administrative group on that machine. Then:

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.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[dreampolice]

Thanks, I tried that and it said "insufficient priviledges" after I tried the "connect / as sysdba" connection.

 

[SantaMufasa]

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:

SQLNET.AUTHENTICATION_SERVICES = (NTS)

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

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[dreampolice]

Thanks