Home » Infrastructure » Unix » Korn shell script
Korn shell script [message #97305] Thu, 28 February 2002 16:31 Go to next message
Messages: 94
Registered: December 1998
I have a script called start.ksh which has this content-
export ORACLE_HOME=/mark/oracle/product/8.1.7
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export ORACLE_SID=markdb
unset TWO_TASK
stty intr "^C"
trap 'echo Ctrl-C trapped' 2 3
nohup test.ksh &
read select
read select
And another script called
sqlplus system/manager > mark.log 2>&1 < set echo on
set pause off
whenever sqlerror exit 1
whenever oserror exit 1
execute dbms_lock.sleep(15)
select * from v$database;

Change ORACLE_HOME, ORACLE_SID and then run as ./start.ksh. Press ctrl-c twice an then view the mark.log file . You would find from 8i it shows 1013 and prior to 8i it works fine. Any reasons for the same?
Is it a problem with the shell script.

Re: Korn shell script [message #97306 is a reply to message #97305] Fri, 01 March 2002 10:30 Go to previous messageGo to next message
Messages: 65
Registered: January 2000
Error: ORA 1013
Text: user requested cancel of current operation
Cause: The user interrupted an Oracle operation by entering CTRL-C, Control-C,
or another canceling operation.
This forces the current operation to end.
This is an informational message only.
Action: Continue with the next operation.

*** Important: The notes below are for experienced users - See [[NOTE:22080.1]]

This is the correct error code for a user interrupting a SQL
statement on the server.
Re: Korn shell script [message #97919 is a reply to message #97305] Tue, 03 June 2003 05:46 Go to previous message
Messages: 11
Registered: October 2001
Junior Member
Previous Topic: Keyboard mapping problems - 2
Next Topic: OuterJoint
Goto Forum:

Current Time: Sat Sep 30 12:15:24 CDT 2023