Home » Infrastructure » Unix » SQL*Plus does not exit - shell script
SQL*Plus does not exit - shell script [message #174047] Thu, 25 May 2006 13:41 Go to next message
arodacki
Messages: 3
Registered: May 2006
Junior Member
Hello All

I am running a shell script with the code below but the script does not close in normal way. I mean, it seems that could not exit from sql*plus!

#! /usr/bin/ksh
sqlplus -s /nolog > $TmpData <<EOF
connect system/$goodone as sysdba
select sysdate from dual;
rem shutdown immediate
exit
EOF

Could anyone help me please.

Thanks

Andrea
Re: SQL*Plus does not exit - shell script [message #184009 is a reply to message #174047] Mon, 24 July 2006 20:52 Go to previous message
ruyue
Messages: 9
Registered: July 2006
Junior Member
sqlplus -s /nolog

You have used the '-s' option,which will not output the login in and out information,but it have already exited sqlplus .
Previous Topic: Open Ports on Solaris
Next Topic: Shell script
Goto Forum:
  


Current Time: Thu Dec 05 01:45:36 CST 2024