Home » RDBMS Server » Server Administration » Password Recovery (Oracle 10g)
Password Recovery [message #361371] Wed, 26 November 2008 02:10 Go to next message
freak
Messages: 2
Registered: November 2008
Junior Member
Hi,

Yesterday i've installed 10g in my personal machine.

While installation provided the username/password.

Once after the completion of installaion enterprise manager was launched and i tried to log-in as Normal, SYSDBA,SYSOPER with the username/password i provided during the installaion.

But it refused to log me in. Sad

Is there any way to recover my password. Confused

I've installed standard version.

If no ways to recover the password i have no other option other than to deinstall and reinstall oracle. Embarassed

Is it possible to get back my password.
Re: Password Recovery [message #361373 is a reply to message #361371] Wed, 26 November 2008 02:26 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You can log into the database with sqlplus using an OS user that is in the DBA Operating system group (which the user you installed oracle with should be) without an password.

sqlplus /nolog


and then

connect / as sysdba


Then you can change the password with the alter user statement
icon14.gif  Re: Password Recovery [message #361539 is a reply to message #361371] Wed, 26 November 2008 20:52 Go to previous messageGo to next message
freak
Messages: 2
Registered: November 2008
Junior Member
Hi Thomas,

Thanks for you reply. Smile

I did as you told and it works.

I tried to locate the userid i provided created while installation as

select * from all_users;

but i'm unable to get the one i created. Confused Sad

Any suggestions on this ? Cool

[Updated on: Wed, 26 November 2008 22:58]

Report message to a moderator

Re: Password Recovery [message #361550 is a reply to message #361539] Wed, 26 November 2008 23:01 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Either you didn't create it or you create it in another database than you are now searching.

Regards
Michel
Previous Topic: ORA-01092:
Next Topic: TNSNAMES.ORA entry
Goto Forum:
  


Current Time: Fri Dec 02 20:56:30 CST 2016

Total time taken to generate the page: 0.22643 seconds