RE: connect as sysdba ora-1031
- From: Fuad Arshad <fuadar@xxxxxxxxx>
- To: Pete Sharman <peter.sharman@xxxxxxxxxx>
- Date: Fri, 18 Nov 2005 03:15:11 -0800 (PST)
the problem was a control character in the sqlnet.ora that was causing this
issue. thank you all for your help on thisi ssue
Pete Sharman <peter.sharman@xxxxxxxxxx> wrote:
How are you testing the password file is not corrupted? I hit a corrupt
password file just today and had to recreate it. Not enough time to debug the
problem when it happened, so recreating was the easiest answer for me.
Remember if you take this route you need to restart the database for it to be
effective.
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
---------------------------------
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Fuad Arshad
Sent: Friday, 18 November 2005 2:23 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: connect as sysdba ora-1031
opracle versionj 9.2.0.4
oracle software owner is oracle
and group is dba and all the permissions seem fine
i am logged in directly thru the account owner
os is aix 5.4 ml05
Paul Drake <bdbafh@xxxxxxxxx> wrote:
On 11/17/05, Fuad Arshad wrote:
> We're having this issue which started today and we cant get ot the bottom
> of it
>
>
> looged in as the oracle owner TWO_TASK is unset
> SQL> connect sys@dbname as sysdba
> Enter password:
> Connected.
> SQL> connect / as sysdba
> ERROR:
> ORA-01031: insufficient privileges
>
> Warning: You are no longer connected to ORACLE.
>
> now the user i'm using is the oracle software owner
> password file is not corrupted remote_login_password is also set to
> exclusive.
>
>
> what steps can i take to further debug this. i"m thinking about oradebug
> but then since i'm disconnected how would oradebug capture anything .
> need some advice before i brave the tar and all the same questions with
> oracle.
Please repost listing your Oracle version, operating system version
and the account that you are logged onto the server as and its group
membership.
Paul
--
#/etc/init.d/init.cssd stop
-- play a Sony CD, install a rootkit today
Other related posts:
