OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Forgot password

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

Forgot password [message #316652]

Sun, 27 April 2008 02:28

saiphani723
Messages: 38
Registered: July 2006
Location: Hyderabad

Member

I installed oralce in my machine one month back
i fogot all the passwords which i set for system,sys and internal.

Can any body tell how to login to oracle.

Report message to a moderator

Re: Forgot password [message #316654 is a reply to message #316652]

Sun, 27 April 2008 03:23

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Make the OS user to OSDBA group.
And then,

conn / as sysdba
alter user username_here identified by new_password;

Report message to a moderator

Re: Forgot password [message #316669 is a reply to message #316652]

Sun, 27 April 2008 08:14

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Addition with Arju suggestion ...
also set SQLNET.AUTHENTICATION_SERVICES=(NTS) in sqlnet.ora file
Located:$ORACLE_HOME/network/admin directory.
Default value is NTS but if NONE is set then change it.

Regards
Taj

Report message to a moderator

Previous Topic:	Migrate from XE to Standard Edition
Next Topic:	Oracle Scheduler locks packages

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 01:51:52 CST 2024