Home » RDBMS Server » Security » forgot password for sys/system
forgot password for sys/system [message #207913] Thu, 07 December 2006 05:52 Go to next message
jasonnoble
Messages: 15
Registered: June 2005
Junior Member
Hi all,

I forgot the passwords for sys and system. Is there any way to retrive/reset these passwords , so that i can login as sys/system with the same passwords.

would appreciate any response.

thanks & regards
jason
Re: forgot password for sys/system [message #207921 is a reply to message #207913] Thu, 07 December 2006 06:24 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi, yes you can reset ur sys or system password like below.
[B]SQL> conn / as sysdba[/B] #in ur sqlnet.ora "SQLNET.AUTHENTICATION_SERVICES= (NTS)" or not 'NONE'.
Connected.
SQL> select password from dba_users where username in ( 'SYS','SYSTEM');

PASSWORD
------------------------------
8A8F025737A9097A
2D594E86F93B17A1

SQL> alter user sys identified by values '8A8F025737A9097A';

User altered.

SQL> alter user system identified by values '2D594E86F93B17A1';

User altered.

SQL> conn sys/oracle as sysdba
Connected.
SQL> conn system/oracle
Connected.
SQL>




IF YOU CHANGE UR PASSWORD AGAIN THE YOU HAVE TO KNOW UR PREVIOUS PASSWORD VALUES THEN YOU CAN AGAIN RESET UR OLD PASSWORD.

hope this helps
Taj
Re: forgot password for sys/system [message #208080 is a reply to message #207921] Fri, 08 December 2006 01:53 Go to previous messageGo to next message
jasonnoble
Messages: 15
Registered: June 2005
Junior Member
but i cant conn / as sysdba

so now what do i do?
Re: forgot password for sys/system [message #208133 is a reply to message #208080] Fri, 08 December 2006 05:08 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
The sqlnet.authentication_services=(NTS) would assume you were on Windows. You could always just recreate the password file with ORAPWD utility.
Re: forgot password for sys/system [message #208269 is a reply to message #208080] Fri, 08 December 2006 23:43 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,
as mention by "ebrian"

for sql>conn / as sysdba
you change ur sqlnet.ora file. (NONE TO NTS.)


or for orapwd utility.

start >>>>> run >>>> cmd
cmd>orapwd file=d:\oracle\product\10.1.0\db_2\database\pwd<sid>.ora password=pwd force=y


http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14231/dba.htm#i1006740

hope this helps
Taj

Re: forgot password for sys/system [message #208371 is a reply to message #207913] Sat, 09 December 2006 23:33 Go to previous messageGo to next message
jasonnoble
Messages: 15
Registered: June 2005
Junior Member
Thanks all

Its working now.

alter user username identified by password default profile

in the sqlnet.ora file it was already NTS.
Re: forgot password for sys/system [message #210003 is a reply to message #207913] Mon, 18 December 2006 22:01 Go to previous messageGo to next message
holllow
Messages: 1
Registered: December 2006
Junior Member
Hello,

To reset lost or forgotten windows password I suppose using Active@ Password Changer. It can quickly perform the operation
http://www.password-changer.com/
Re: forgot password for sys/system [message #210046 is a reply to message #210003] Tue, 19 December 2006 02:07 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
But the problem here is forgotten Oracle SYS (SYSTEM) password, not Windows.
Re: forgot password for sys/system [message #657957 is a reply to message #208371] Tue, 29 November 2016 04:57 Go to previous message
wekonnoot
Messages: 1
Registered: November 2016
Junior Member
jasonnoble wrote on Sat, 09 December 2006 23:33
Thanks all

Its working now.

alter user username identified by password default profile

in the sqlnet.ora file it was already NTS.
wow, this worked for me too. Tried a few hours to finally fix it. thanks
Previous Topic: DEBUG ANY PROCEDURE
Goto Forum:
  


Current Time: Sun Dec 04 08:49:56 CST 2016

Total time taken to generate the page: 0.07277 seconds