Re: sqlplus and using the slash as login and password

And set OS_AUTHENTICATION = TRUE in your init.ora.

Yosi

Kenneth C Stahl wrote:

> You need to define an ops$name account in oracle where 'name' is the
> userid of the account that is running the script. Thus, if you log into
> unix with xyzzy then you need to define an account called ops$xyzzy in
> Oracle with "identified externally" and then make sure it has connect
> privileges.
>
> Ken
>
> Jenny Farnham wrote:
>
> > The following portion of a shell script used to work
> > until we moved/changed environments. What makes the
> > slash in the sqlplus command work? It is now saying invalid
> > login and password when I run the shell script.
> >
> > I'm referring to: sqlplus /
> >
> > Here's the portion of code:
> >
> > while (1)
> >
> > $ORACLE_HOME/bin/sqlplus / <<EOF ;
> > set serveroutput on size 50000
> > SELECT TO_CHAR(SYSDATE,'Dy DD-Mon-YYYY HH24:MI:SS') FROM DUAL;
> > begin
> > pack_report_utils.trawl_for_reports($$,$COUNTRY_CODE);
> > commit;
> > end;
> > /
> > exit
> > EOF
> >
> > wait
> > sleep 300
> >
> > end
Received on Fri Jul 16 1999 - 13:48:14 CDT