Changing SYS password

From: <pawan.dalmia_at_pharma.novartis.com>
Date: Wed, 20 Oct 2004 14:33:21 +0530
Message-ID: <OFF29FEC4B.96E79E25-ON65256F33.0030F6A0-65256F33.0031CB05@EU.novartis.net>

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

Received on Wed Oct 20 2004 - 03:59:46 CDT