calling sqlplus from unix shell script error

Hi,

Interactively, I can do the following:

>sqlplus /nolog

SQL> connect sys/system as sysdba

Connected

SQL> But, when I try the following in a script, I get this:

The script:

sqlplus<<! > $CometsLog/create-tst92.log sys/system

connect as sysdba

exit

The log file:

/home/coolidge> cat create-tst92.log

SQL*Plus: Release 9.2.0.1.0 - Production on Tue Sep 9 08:28:25 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR: ORA-01017: invalid username/password; logon denied

Enter user-name: Enter password:

Connected to:

Oracle9i Release 9.2.0.1.0 - 64bit Production

JServer Release 9.2.0.1.0 - Production

SQL> Disconnected from Oracle9i Release 9.2.0.1.0 - 64bit Production

JServer Release 9.2.0.1.0 - Production

It works, but after an initial failed attempt. Any ideas on how to have it work without this error?

Driving me crazy...

Thanks,

-Herb

--
Posted via http://dbforums.com