OraFAQ Forum: Unix » SQL*Plus does not exit

Home » Infrastructure » Unix » SQL*Plus does not exit - shell script

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL*Plus does not exit - shell script [message #174047]

Thu, 25 May 2006 13:41

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

Report message to a moderator

Re: SQL*Plus does not exit - shell script [message #184009 is a reply to message #174047]

Mon, 24 July 2006 20:52

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 .

Report message to a moderator

Previous Topic:	Open Ports on Solaris
Next Topic:	Shell script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 24 21:44:03 CDT 2026