Home » RDBMS Server » Server Administration » Forgot password
Forgot password [message #316652] Sun, 27 April 2008 02:28 Go to next message
Messages: 36
Registered: July 2006
Location: Hyderabad
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.
Re: Forgot password [message #316654 is a reply to message #316652] Sun, 27 April 2008 03:23 Go to previous messageGo to next message
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;
Re: Forgot password [message #316669 is a reply to message #316652] Sun, 27 April 2008 08:14 Go to previous message
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.

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

Current Time: Fri Oct 28 19:12:10 CDT 2016

Total time taken to generate the page: 0.13268 seconds