Unexpected behavior if whenever oserror set
Date: Tue, 9 Dec 2008 13:12:55 -0800
Message-ID: <2A8185DC02A8CE4C8413E0A26A8A831A01DC48A0D6@XEDAMAIL2.ex.ad3.ucdavis.edu>
Greetings,
I'm running 9.2.0.8.0 EE on RHEL4 64-bit. Setting whenever oserror exit generates the following behavior...
[oracle_at_critpinndev pinntest ~]$ sqlplus /
SQL*Plus: Release 9.2.0.8.0 - Production on Tue Dec 9 13:05:55 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
SQL> whenever oserror exit
SQL> connect oracle
Enter password:
O/S Message: No such file or directory
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
This does *not* fail on a 10.2.0.4.0 installation also running EE on RHEL4 64-bit and I don't know if this is due to a difference between 9i and 10g or something else. I suspect it is something else. One difference I find is that the environment variable OLDHOME is not set for the 9i server but setting it does not resolve the problem. I have checked the files in the $ORACLE_HOME/sqlplus/admin directory and find no difference that I believe would make a difference, each contains a glogin.sql. I haven't been able to determine what the missing file is. Help resolving this would be appreciated.
Thanks.
Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 09 2008 - 15:12:55 CST