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

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


Current Time: Sat Dec 10 07:14:01 CST 2016

Total time taken to generate the page: 0.23311 seconds