RE: Changing SYS password

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Wed, 20 Oct 2004 08:09:07 -0400
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE07A7F9B6@exchsen0a1ma>

Pawan,

The ORAPWD utility only changes the password in the orapwSID file. You also need to run the following within sqlplus:

Alter user sys identified by {newpassword};

I don't think you can be connected as SYS when you do this, so connect as a user with DBA privs.

Good Luck!

Tom Mercadante
Oracle Certified Professional

-----Original Message-----

From: pawan.dalmia_at_pharma.novartis.com
[mailto:pawan.dalmia_at_pharma.novartis.com] Sent: Wednesday, October 20, 2004 5:03 AM To: oracle-l_at_freelists.org
Subject: Changing SYS password

Hi List,
I have recently got the handover of Some Production oracle 9i Database. I want to change the SYS password.
i used orapwd utility and changed password from P1 to P2 but i am able to connect to sys by both password that is P1(old) as well as P2(new) As per Metalink the new password will be in effect after bouncing the db. I cant bounce the database but i want that no one should be able to login with old password that is P1.

How can i do this..My remote _login_ password file is set to exclusive........

Regards
Pawan Dalmia
Oracle DBA-Business Intelligence
Desk-566
Cell 9819718753

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Wed Oct 20 2004 - 07:04:50 CDT