Re: Password file not getting updated
From: Ram Raman <veeeraman_at_gmail.com>
Date: Sat, 8 Oct 2011 15:25:45 -0500
Message-ID: <CAHSa0M2A5-xvU+=aycSwKEfPedsJXNEdaGMMfbX-BYv6s=YJ0Q_at_mail.gmail.com>
Thank you for the responses
1) I used 'which sqlplus' to verify that the sqlplus is in the OH/bin directory of the OH in consideration.
2) The orapw<db> is in OH/dbs in a Linux server 3) Niall: The whole thing came about because when I try to log in as sys as the oracle software owner (oracle) I get the message "ORA-01031: insufficient privileges". We tried several things and that is when I saw that changing sys password updates the password in the DB, but does NOT update the password file. The timestamp of the password file remains unchanged. As Martin guessed I thought maybe it was in a different OH, but I found that that was not the case, because I set OH explicitly to this home, re-created password file and then proceeded with this exercise. Remote_login_pswd_file is set to exclusive.
Date: Sat, 8 Oct 2011 15:25:45 -0500
Message-ID: <CAHSa0M2A5-xvU+=aycSwKEfPedsJXNEdaGMMfbX-BYv6s=YJ0Q_at_mail.gmail.com>
Thank you for the responses
1) I used 'which sqlplus' to verify that the sqlplus is in the OH/bin directory of the OH in consideration.
2) The orapw<db> is in OH/dbs in a Linux server 3) Niall: The whole thing came about because when I try to log in as sys as the oracle software owner (oracle) I get the message "ORA-01031: insufficient privileges". We tried several things and that is when I saw that changing sys password updates the password in the DB, but does NOT update the password file. The timestamp of the password file remains unchanged. As Martin guessed I thought maybe it was in a different OH, but I found that that was not the case, because I set OH explicitly to this home, re-created password file and then proceeded with this exercise. Remote_login_pswd_file is set to exclusive.
On Sat, Oct 8, 2011 at 2:54 AM, Niall Litchfield <niall.litchfield_at_gmail.com
> wrote:
> If you modify the password file the change does not affect a running
> instance (at least in your version that might be fixed by 11.2).
> However can you not authenticate as the oracle user locally on the
> box?
>
> On Fri, Oct 7, 2011 at 11:52 PM, Ram Raman <veeeraman_at_gmail.com> wrote:
> > Listers,
> > We have a 10.105 database that was installed as part of the application
> > install. We are unable to log into the database as sys user. The password
> > file is there, it has been recreated
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Oct 08 2011 - 15:25:45 CDT