Oracle Users/Shell scripts

From: Neil Reardon <nfr_at_archimedes.demon.co.uk>
Date: Tue, 30 Mar 1999 16:52:22 +0100
Message-ID: <3700F336.6C73@archimedes.demon.co.uk>

Hi Folks...

I'm running Oracle 7.3.4 on Solaris 2.5.1 and am trying to call an Oracle script (through sqlplus) from a csh script. I have created both a UNIX and Oracle user called "foobar". The Oracle user was created with the following SQL:

create user foobar identified externally default tablespace appl_data_ts temporary tablespace temp_data_ts;

i.e. the Oracle user has been identified externally.

The csh script contains the following lines:

• BEGIN #!/bin/csh

$PATH_TO_ORACLE_BIN_DIR/sqlplus foobar @users.sql
-- END
The SQL script contains the following:

• BEGIN select * from dba_users;
• END

(Tough stuff, I know!) The scripts aren't working, i.e. I am asked to enter a password when "sqlplus" is fired up. When I enter the password, i.e. the password of user "foobar", I am given an "invalid username/password" message. I thought that identifying the user externally caused Oracle to obtain the information from the O/S's password file. Am I missing something?

Thanks in advance for any help!

Neil Reardon
Technical Consultant
Xyvision Ltd Received on Tue Mar 30 1999 - 09:52:22 CST