topic Re: script help in Operating System - HP-UX

script help

jackfiled — Mon, 06 Sep 2004 03:59:03 GMT

Hi all
that's the problem here.
script executed one of commands, so
I want it to execute full command.
ex) sqlplus /nolog
system has executed sqlplus only exclude /nolog.
it must execute not only sqlplus but also /nolog concurrently

truly tips are good to me.

Re: script help

Fred Ruffet — Mon, 06 Sep 2004 04:02:32 GMT

Can you post your script ? It will surely help.

Regards,

Fred

Re: script help

jackfiled — Mon, 06 Sep 2004 04:16:18 GMT

# Get DB info

get_db_info()
{
#$ORACLE_HOME/bin/svrmgrl << EOF > $DB_INFO
$ORACLE_HOME/bin/sqlplus /nolog << EOF > $DB_INFO
#connect internal
connect / as sysdba

Re: script help

T G Manikandan — Mon, 06 Sep 2004 04:28:18 GMT

sqlplus /nolog << EOF >a.log
connect sys / as sysdba
select name from v\$database;
EOF
exit

Re: script help

Fred Ruffet — Mon, 06 Sep 2004 04:29:39 GMT

Sounds good to me if sqlplus input ends with :
exit
EOF

Regards,

Fred

Re: script help

Muthukumar_5 — Mon, 06 Sep 2004 05:42:53 GMT

You have to complete the started read-up command line as,
#$ORACLE_HOME/bin/svrmgrl << EOF > $DB_INFO
$ORACLE_HOME/bin/sqlplus /nolog << EOF > $DB_INFO
#connect internal
connect / as sysdba

EOF

Or you can use as,
#$ORACLE_HOME/bin/svrmgrl << EOF > $DB_INFO
$ORACLE_HOME/bin/sqlplus /nolog <<-EOF > $DB_INFO
#connect internal
connect / as sysdba
EOF

where -EOF to stripe the tabs.

And more there some restriction on using as,
\new-line is
ignored, and \ must be used to quote the
characters \, $, `, and the first character of
word.

see ksh man page for Input/Output part