| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Connect as SYSDBA
What Oracle version?
What platform (OS)?
What database authentification model are you using?
What Oracle error are you getting?
If you are on UNIX and use OS authentification then if someone set the TWO_TASK environment and you tried to connect like 'sqlplus "user/pasword as sysdba" ' you would get ORA-01031: insufficient privileges. In this case unset TWO_TASK and you are good to go.
If you use other authentification models or are getting a different error message then the cause is probably different.
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Smith, Ron L.
Sent: Monday, May 10, 2004 9:29 AM
To: oracle-l_at_freelists.org
Subject: Connect as SYSDBA
I have a batch script that has been running for several months but all
of a sudden failed this weekend.
For some reason I can no longer do a sqlplus "system/password as
sysdba". I don't know that anyone has changed anything.
Any idea why this would quit working?
Thanks!
Ron Smith
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |