script help

[jackfiled]

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.

[Fred Ruffet]

Can you post your script ? It will surely help.

Regards,

Fred

[jackfiled]

# 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

[T G Manikandan]

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

[Fred Ruffet]

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

Regards,

Fred

[Muthukumar_5]

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