RE: connect as sysdba ora-1031

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_at_oracle.com> 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Fuad Arshad Sent: Friday, 18 November 2005 2:23 AM
To: oracle-l_at_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_at_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_at_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