RE: Connect as SYSDBA - FIXED!

  • From: "Smith, Ron L." <rlsmith@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 10 May 2004 13:44:13 -0500

Turned out to be a misleading error message.  The error said
"insufficient permissions".  It turned out a batch script on MS2000 was
trying to run SQLPLUS and write to a file.  The file was previously
opened for update by another program and was still being held by the
program.  I killed the other program and the error went away.

Thanks!
Ron

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark
Sent: Monday, May 10, 2004 1:03 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Connect as SYSDBA


Ron,

Specifically, what error do you get?  What Oracle version?  What =3D
platform?

-----Original Message-----
From: Smith, Ron L. [mailto:rlsmith@xxxxxxx]
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
-----------------------------------------------------------------
----------------------------------------------------------------
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:

  • » RE: Connect as SYSDBA - FIXED!