Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sqlcl sql script running in background error(zip file unzipped in unix environment)

295ba3d5-d678-4e89-86cb-906d5f7121c5Sep 3 2018 — edited Sep 13 2018

i am unable to run sql script(saved in file) in background using sqlcl , but it run fines normally . i tried different solution provided on web but nothing worked .  any help on this would be appreciated.

Solutions which i tried are as below .

nohup ksh xyz.ksh 1>/dev/null 2>2018090123181_xyz.log &

same works fine with sqlplus.

Errors i get :

Stopped (tty output)

when i look for detailed processes it holds of at i get below .

pts/10   00:00:00 sh -c stty -icanon min 1 -icrnl -inlcr -ixon < /dev/tty

pts/10   00:00:00 stty -icanon min 1 -icrnl -inlcr -ixon

any fixable solution for this ?

Comments

Processing

Post Details

Added on Sep 3 2018
4 comments
1,078 views