OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Password Recovery (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Password Recovery [message #361371]

Wed, 26 November 2008 02:10

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.

Report message to a moderator

Re: Password Recovery [message #361373 is a reply to message #361371]

Wed, 26 November 2008 02:26

ThomasG
Messages: 3211
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

Report message to a moderator

Re: Password Recovery [message #361539 is a reply to message #361371]

Wed, 26 November 2008 20:52

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

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

Michel Cadot
Messages: 68666
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

Report message to a moderator

Previous Topic:	ORA-01092:
Next Topic:	TNSNAMES.ORA entry

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 07:28:31 CDT 2024