Home » RDBMS Server » Server Administration » How to reset sys user password (Oracle 11.1.0.7.0 , Windows)
How to reset sys user password [message #614723] Mon, 26 May 2014 09:49 Go to next message
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.
Re: How to reset sys user password [message #614724 is a reply to message #614723] Mon, 26 May 2014 09:52 Go to previous messageGo to next message
John Watson
Messages: 7212
Registered: January 2010
Location: Global Village
Senior Member
Sure - use the orapwd.exe utility.
Re: How to reset sys user password [message #614726 is a reply to message #614724] Mon, 26 May 2014 10:04 Go to previous messageGo to next message
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
Re: How to reset sys user password [message #614727 is a reply to message #614726] Mon, 26 May 2014 10:07 Go to previous messageGo to next message
BlackSwan
Messages: 25793
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
Re: How to reset sys user password [message #614729 is a reply to message #614727] Mon, 26 May 2014 10:22 Go to previous messageGo to next message
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
Re: How to reset sys user password [message #614730 is a reply to message #614729] Mon, 26 May 2014 10:30 Go to previous messageGo to next message
BlackSwan
Messages: 25793
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.
Re: How to reset sys user password [message #614732 is a reply to message #614730] Mon, 26 May 2014 11:49 Go to previous messageGo to next message
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
Re: How to reset sys user password [message #614763 is a reply to message #614732] Mon, 26 May 2014 19:11 Go to previous messageGo to next message
BlackSwan
Messages: 25793
Registered: January 2009
Location: SoCal
Senior Member
Troubleshooting ORA-1031 Insufficient Privilege While Connecting As SYSDBA [ID 730067.1]
Re: How to reset sys user password [message #614826 is a reply to message #614763] Tue, 27 May 2014 11:48 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Thanks Blackswan
Re: How to reset sys user password [message #614831 is a reply to message #614732] Tue, 27 May 2014 12:44 Go to previous messageGo to next message
joy_division
Messages: 4817
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 Go to previous messageGo to next message
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
Re: How to reset sys user password [message #615073 is a reply to message #615071] Fri, 30 May 2014 00:27 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What about the one that is in the documentation?

Re: How to reset sys user password [message #615094 is a reply to message #615073] Fri, 30 May 2014 03:15 Go to previous message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Michel,

I will check it out in the document.
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:
  


Current Time: Tue Jan 16 14:15:31 CST 2018

Total time taken to generate the page: 0.14696 seconds