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@xxxxxxxxxx]
Sent: Friday, 18 November 2005
1:33 PM
To: fuadar@xxxxxxxxx
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@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
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
--
//www.freelists.org/webpage/oracle-l