I'm trying to execute SQLcl on Linux from shell script via nohup command:
set -xv
OUT=`sql -S username/password@IP_address:1521/ORCL <<EOF
set pagesize 0 feedback off verify off heading off echo off
select * from dual;
exit;
EOF`
echo from oracle=$OUT
The script above runs perfectly fine from command line however when I run it vi nohup I'm getting an error "Stopped" and I see java process so only log out from terminal session or kill -9 helps to terminate this.
If I replace SQLcl with sqlplus it works fine via nohup.
What is wrong here ? Perhaps nohup can not spawn another extra Java process ? Is this a bug in SQLcl ? Just curious if I can use SQLcl to replace SQLPLUS and installing Oracle client for this.
Thank you,
Alex