| Korn shell script [message #97305] |
Thu, 28 February 2002 16:31  |
Rahul
Messages: 94
Registered: December 1998
|
Member |
|
|
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 PATH=$ORACLE_HOME/bin:$PATH
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;
EOF
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.
Thanks
|
|
|
|
| Re: Korn shell script [message #97306 is a reply to message #97305] |
Fri, 01 March 2002 10:30  |
Melissa
Messages: 65
Registered: January 2000
|
Member |
|
|
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]]
Explanation:
This is the correct error code for a user interrupting a SQL
statement on the server.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
