Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ORA-01031

ORA-01031

From: John P Weatherman <asahoshi_at_infionline.net>
Date: Mon, 16 Feb 2004 16:44:19 -0500
Message-ID: <410-220042116214419735@infionline.net>


Hi all,
I have a 9.2.0.4 database on Solaris 2.9 that is being very unhappy with remote connections as sysdba. The owner of the process (sqlplus for testing, but IA also as I am ultimately trying to get things scheduled with Enterprise Manager) is the oracle owner which is in the dba group. If I "connect sys/<passwd> as sysdba" on the local machine, it works without any problems. However, when I throw SQL*Net into the mix ("connect sys/<passwd>@<sid> as sysdba") I am getting an ORA-1031. I have tried recreating the passwd file and even "resetting" the sys password, just to make sure the password file is "synchronized" with the actual password (per a note on google).

Has anyone seen anything like this and have any suggestions?

TIA,
John P Weatherman
Oracle Database Administrator
Advance America



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Mon Feb 16 2004 - 15:44:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US