FW: connect as sysdba ora-1031

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: Fri, 18 Nov 2005 13:40:29 +1100
Message-ID: <20051118134029372.00000003756@psharman-au>

Rassifrassing reply all button missed again. L

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: Pete Sharman [mailto:peter.sharman@oracle.com]
Sent: Friday, 18 November 2005 1:33 PM
To: fuadar@yahoo.com
Cc: Peter Ross Sharman
Subject: RE: connect as sysdba ora-1031

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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Fuad Arshad
Sent: Friday, 18 November 2005 2:23 AM
To: oracle-l@freelists.org
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@gmail.com> 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

-- http://www.freelists.org/webpage/oracle-l Received on Thu Nov 17 2005 - 21:44:25 CST