In article <3700F336.6C73_at_archimedes.demon.co.uk>, Neil Reardon
<nfr_at_archimedes.demon.co.uk> writes
>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
Where I have seen external identified users before the scenario was this
Unix user id was foobar
then in the database 'create user foobar identified externally ....
then to get into sqlplus 'sqlplus /'
the forward / is in place of an id and password
If you look in dba users the actual userid may be OPS$foobar
Hope this helps
--
Diane
Received on Tue Mar 30 1999 - 13:11:17 CST
