Re: Password file not getting updated

  • From: Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
  • To: veeeraman@xxxxxxxxx
  • Date: Sun, 9 Oct 2011 16:11:31 +0530

So Ram,
the issue is resolved..
if you are getting 1031, then check sqlnet.ora for proper value of
NTS.authentication parameter.. and some times domain value
'which sqlplus is used',  can differ if you have multiple OH and their
entries exists in PATH..

thanks and take care..subodh
On 9 October 2011 01:55, Ram Raman <veeeraman@xxxxxxxxx> wrote:

> 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@xxxxxxxxx
> > 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@xxxxxxxxx> 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
> >
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>


-- 
==============================
DO NOT FORGET TO SMILE TODAY
==============================


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


Other related posts: