Re: Password file not getting updated
Date: Sun, 9 Oct 2011 16:21:57 +0530
Message-ID: <CAJsOtB4MPgoZu-YN45UokyyWD3mEqLc8v+L1cSUdcZeNdaHN+A_at_mail.gmail.com>
A small addition,
apart from proper path, if you have multiple OH, hence you will have multiple databases of different versions running, so they will have their own sqlnet. tnsnames,, listeners and this also can cause 1031.
whatever the latest (last varible set) in .profile it will be picked up..
to avoid this I generally the current values of SIDs and then proceed..
thanks..subodh
On 9 October 2011 16:11, Subodh Deshpande <deshpande.subodh_at_gmail.com>wrote:
> 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_at_gmail.com> 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_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-l
>>
>>
>>
>
>
> --
> ==============================
> DO NOT FORGET TO SMILE TODAY
> ==============================
>
-- ============================== DO NOT FORGET TO SMILE TODAY ============================== -- http://www.freelists.org/webpage/oracle-lReceived on Sun Oct 09 2011 - 05:51:57 CDT