I forgot my Oracle username/password

[2122002]

Dear All,

I installed Oracle on my Laptop 1 1/2 months ago but ive not used it for a while, I have now forgotten the username/password to Oracle DBA studio. what should I do to recover my username+password without re-installing Oracle 8i again.?

I have tried below command but it did not work out:
@c:\oarcle\ora81\rdbms\admin\catalog
@c:\oarcle\ora81\rdbms\admin\catproc

alter user sys identified by <password>

I don't have problem to login into SQL+

 

[SantaMufasa]

So, "Deuce+", If you can successfully log into SQL*Plus as the user "SYS", then your Oracle world is your oyster...It means you can do anything, including change the password of any user on that database/instance. As SYS, you can list the names of the Oracle users that reside on that database by issuing the query:

select username from dba_users;

Next, from those results, identify which of those users is the user with which you log into Oracle DBA Studio. Then (presuming that Oracle DBA Studio uses username/password combinations from your Oracle database), you can give "yourself" (your Oracle DBA Studio user) any password you like with this SQL*Plus syntax:

ALTER USER <your username> IDENTIFIED BY <new password>;

Let us know how this all works for you.


Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.