OraFAQ Forum: Security » forgot password for sys/system

Home » RDBMS Server » Security » forgot password for sys/system

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

forgot password for sys/system [message #207913]

Thu, 07 December 2006 05:52

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

Report message to a moderator

Re: forgot password for sys/system [message #207921 is a reply to message #207913]

Thu, 07 December 2006 06:24

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

Report message to a moderator

Re: forgot password for sys/system [message #208080 is a reply to message #207921]

Fri, 08 December 2006 01:53

jasonnoble
Messages: 15
Registered: June 2005

Junior Member

but i cant conn / as sysdba

so now what do i do?

Report message to a moderator

Re: forgot password for sys/system [message #208133 is a reply to message #208080]

Fri, 08 December 2006 05:08

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.

Report message to a moderator

Re: forgot password for sys/system [message #208269 is a reply to message #208080]

Fri, 08 December 2006 23:43

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

Report message to a moderator

Re: forgot password for sys/system [message #208371 is a reply to message #207913]

Sat, 09 December 2006 23:33

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.

Report message to a moderator

Re: forgot password for sys/system [message #210003 is a reply to message #207913]

Mon, 18 December 2006 22:01

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/

Report message to a moderator

Re: forgot password for sys/system [message #210046 is a reply to message #210003]

Tue, 19 December 2006 02:07

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

But the problem here is forgotten Oracle SYS (SYSTEM) password, not Windows.

Report message to a moderator

Previous Topic:	Encryption of a tablespace
Next Topic:	Fine Grain Access Control

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 19:51:25 CST 2024