OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » SYS password

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

SYS password [message #137533]

Thu, 15 September 2005 08:06

muralikumarg
Messages: 33
Registered: August 2005
Location: Chennai

Member

I changed sys password long before for my DB.I forgot the password.I am unable proceed with DB operations.Please suggest me a solution to retrieve or reset my password.

Report message to a moderator

Re: SYS password [message #137537 is a reply to message #137533]

Thu, 15 September 2005 08:17

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Did you change the system password too?
login as system/manager and change the sys password again.

Report message to a moderator

Re: SYS password [message #137540 is a reply to message #137537]

Thu, 15 September 2005 08:30

Jay Munshi
Messages: 30
Registered: July 2004

Member

sys password is stored in a file in the location oracle_home/database/pwd<sid>.ora

delete the file.
recreate the file by the orapwd command line utitlity.
orapwd file=d:/oracle/ora92/database/pwd<sid>.ora password=sys entries=100

Hope this helps,
Jay Munshi
http://jaydba.tripod.com

Report message to a moderator

Re: SYS password [message #137582 is a reply to message #137540]

Thu, 15 September 2005 10:34

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,

Pls check out this link .... i hope you will get answer of your question

http://www.orafaq.com/forum/m/112023/67993/#msg_112023

regard
sunilkumar

[Updated on: Thu, 15 September 2005 10:35]

Report message to a moderator

Re: SYS password [message #137594 is a reply to message #137582]

Thu, 15 September 2005 11:23

alliejane
Messages: 59
Registered: July 2005
Location: Glasgow

Member

My suggestion would be to use Mahesh's method if you can log in as system, as it means you don't have to restart the database, recreating the password file requires a kill and restart.. not something I'd want to do unless I had to.

Good luck

Allie

Report message to a moderator

Re: SYS password [message #137638 is a reply to message #137594]

Thu, 15 September 2005 17:59

cumin
Messages: 82
Registered: August 2005

Member

I have a similar problem; I have Oracle Personal 10g, and created a password for system (system/system) while installing and setting up, as the setup wizard told me I could make passwords for sys and sysdba later. I need to make those passwords now and I do not know how. I only have system/system, and a user john/john now.

Report message to a moderator

Re: SYS password [message #137645 is a reply to message #137638]

Thu, 15 September 2005 19:41

cumin
Messages: 82
Registered: August 2005

Member

never mind (alter user sys identified by pwd)

Report message to a moderator

Re: SYS password [message #137651 is a reply to message #137533]

Thu, 15 September 2005 23:21

muralikumarg
Messages: 33
Registered: August 2005
Location: Chennai

Member

I recreated the password file for DB using 'orapwd'.After that i got TNS Adapter error.what could be the problem.I checked the service for TNSListener and restarted it once.Pls suggest me a way to solve this problem.

[Updated on: Thu, 15 September 2005 23:23]

Report message to a moderator

Re: SYS password [message #137687 is a reply to message #137651]

Fri, 16 September 2005 02:19

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

Hi,

There can be many error related to TSN so pls specify the oracle error number and the message that its generating to get better and perfect solution by experts.

Regards
Sunilkumar

Report message to a moderator

Re: SYS password [message #137688 is a reply to message #137651]

Fri, 16 September 2005 02:23

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

By any means , did u turn off Oracle Service . This error

 ERROR:
ORA-12560: TNS:protocol adapter error

is common if Oracle service is not running.

regards,
tarun

Report message to a moderator

Re: SYS password [message #137936 is a reply to message #137688]

Sun, 18 September 2005 23:22

muralikumarg
Messages: 33
Registered: August 2005
Location: Chennai

Member

thanks for all.I didnt notice that oracle services were stopped.Now it is working fine.

Report message to a moderator

Re: SYS password [message #150773 is a reply to message #137540]

Fri, 09 December 2005 10:36

donlcs
Messages: 62
Registered: October 2005
Location: VA, USA

Member

I'm exactly in the same situation as the original poster's. I just tried your solution. Then restarted oracle instance, its listerner and oracle http server, got login (invalid username/password) error. My env is Oracle8i. What else could I try?

Thanks.

[Updated on: Fri, 09 December 2005 11:48]

Report message to a moderator