RE: connect as sysdba ora-1031

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 17 Nov 2005 10:30:03 -0500
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF41050395BC04@usahm236.amer.corp.eds.com>

Fred, you did not list the sqlplus command option which you used. sqlplus /nolog
then at the prompt
> connect / as sysdba

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Fuad Arshad Sent: Thursday, November 17, 2005 10:09 AM To: oracle-l_at_freelists.org
Subject: connect as sysdba ora-1031

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.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 17 2005 - 10:34:19 CST