Re: Using shell script to log into SQLPLUS

From: <bdbafh_at_gmail.com>
Date: 13 Jan 2006 11:44:48 -0800
Message-ID: <1137181488.447089.68660@o13g2000cwo.googlegroups.com>

Apparently, ou're attempting to use operating system authentication to a remote database instance. That doesn't work by default. Its not a good idea to make it work, not by default.

You're going to need to supply the password for the sys account in this case.

Another option would be to connect to the remote database server (e.g. via an ssh client) and execute the script there. Since you would be running under the credentials of a local account (most likely in the local group "dba" or something similar)

SQL> connect / as sysdba

would succeed.

hth

An additional suggestion would be to post the exact error message, such as "insufficient privileges".

-bdbafh Received on Fri Jan 13 2006 - 13:44:48 CST