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
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

Could anyone help me please.


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
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: Fri Oct 21 15:57:18 CDT 2016

Total time taken to generate the page: 0.33241 seconds