OraFAQ Forum: Server Administration » How to reset sys user password

Home » RDBMS Server » Server Administration » How to reset sys user password (Oracle 11.1.0.7.0 , Windows)

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

How to reset sys user password [message #614723]

Mon, 26 May 2014 09:49

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

Hi,

Is it possible to change sys user password without logging into database ? if so how to change it please let me know the steps.

When i try to login to database using sys user i get following error.

Quote:

C:\Documents and Settings\IN00353T>sqlplus

SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 26 15:39:41 2014

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Enter user-name: sys@ORCL / as sysdba
Enter password:
ERROR:
ORA-01031: insufficient privileges

Note : i am using correct password for sys user.

Report message to a moderator

Re: How to reset sys user password [message #614724 is a reply to message #614723]

Mon, 26 May 2014 09:52

John Watson
Messages: 8965
Registered: January 2010
Location: Global Village

Senior Member

Sure - use the orapwd.exe utility.

Report message to a moderator

Re: How to reset sys user password [message #614726 is a reply to message #614724]

Mon, 26 May 2014 10:04

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

Hi John,

Quote:

orapwd file=$ORACLE_HOME/dbs/<password_filename> password=xyz

Can you please confirm the command ?

Thanks

Report message to a moderator

Re: How to reset sys user password [message #614727 is a reply to message #614726]

Mon, 26 May 2014 10:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Mohan10g wrote on Mon, 26 May 2014 08:04

Hi John,

Quote:
orapwd file=$ORACLE_HOME/dbs/<password_filename> password=xyz

Can you please confirm the command ?

Thanks

Confirmed!

http://docs.oracle.com/cd/E16655_01/server.121/e17636/dba.htm#ADMIN12478

Report message to a moderator

Re: How to reset sys user password [message #614729 is a reply to message #614727]

Mon, 26 May 2014 10:22

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

Thanks Blackswan,

How to find ORACLE_HOME in windows and what to give in place of password file name in orawpwd command ?

Thanks

Report message to a moderator

Re: How to reset sys user password [message #614730 is a reply to message #614729]

Mon, 26 May 2014 10:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How to find ORACLE_HOME in windows and what to give in place of password file name in orawpwd command ?
Hmmm, after 5 years you still don't know these basics.
Perhaps Oracle & computers are something you should avoid.

Report message to a moderator

Re: How to reset sys user password [message #614732 is a reply to message #614730]

Mon, 26 May 2014 11:49

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

Even after changing the password of sys using orapwd utility i am unable to connect database as sys user.Please let me know where i am wrong .

Quote:

C:\Oracle\product\10.2.0\database>orapwd file=c:\oracle\product\10.2.0\database
OrapwdORCL password=May2014!

C:\Oracle\product\10.2.0\database>
C:\Oracle\product\10.2.0\database>sqlplus

SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 26 17:44:06 2014

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Enter user-name: sys as sysdba
Enter password:
ERROR:
ORA-01031: insufficient privileges

Quote:

Find below the file under ORACLE HOME ( where i created orapwd utility)

C:\Oracle\product\10.2.0\database>dir
Volume in drive C is System
Volume Serial Number is E031-D729

Directory of C:\Oracle\product\10.2.0\database

18/05/2014 18:35 2,176 PWDORCL.ORA

Thanks

Report message to a moderator

Re: How to reset sys user password [message #614763 is a reply to message #614732]

Mon, 26 May 2014 19:11

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Troubleshooting ORA-1031 Insufficient Privilege While Connecting As SYSDBA [ID 730067.1]

Report message to a moderator

Re: How to reset sys user password [message #614826 is a reply to message #614763]

Tue, 27 May 2014 11:48

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

Thanks Blackswan

Report message to a moderator

Re: How to reset sys user password [message #614831 is a reply to message #614732]

Tue, 27 May 2014 12:44

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Mohan10g wrote on Mon, 26 May 2014 12:49

Even after changing the password of sys using orapwd utility i am unable to connect database as sys user.Please let me know where i am wrong .

Quote:

C:\Oracle\product\10.2.0\database>orapwd file=c:\oracle\product\10.2.0\database
OrapwdORCL password=May2014!

This does not seem to match this:

orapwd file=$ORACLE_HOME/dbs/<password_filename> password=xyz

What is OrapwdORCL?
Where is the password file in the "file" parameter?

[Updated on: Thu, 29 May 2014 12:36]

Report message to a moderator

Re: How to reset sys user password [message #615071 is a reply to message #614831]

Fri, 30 May 2014 00:11

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

Hi Joy,

Quote:

What is OrapwdORCL?
Where is the password file in the "file" parameter?

it is an password file name.

I think my command is wrong.Can you give an correct orapwd command to reset the password ?

Thanks,
Mohan

Report message to a moderator

Re: How to reset sys user password [message #615073 is a reply to message #615071]

Fri, 30 May 2014 00:27

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What about the one that is in the documentation?

Report message to a moderator

Re: How to reset sys user password [message #615094 is a reply to message #615073]

Fri, 30 May 2014 03:15

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

Michel,

I will check it out in the document.

Report message to a moderator

Previous Topic:	We have the requirment for character set conversion from WE8ISO8859P1 to AL32UTF8
Next Topic:	ERROR at line 62: ORA-01652: unable to extend temp segment by 16 in tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 17:21:41 CST 2025