RE: Connect as SYSDBA
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 10 May 2004 14:49:58 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Smith, Ron L.
Sent: Monday, May 10, 2004 9:29 AM
To: oracle-l@xxxxxxxxxxxxx
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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
