RE: Unexpected behavior if whenever oserror set

  • From: William Wagman <wjwagman@xxxxxxxxxxx>
  • To: Dan Norris <dannorris@xxxxxxxxxxxxx>
  • Date: Wed, 10 Dec 2008 14:32:17 -0800


I did that and indeed login.sql is one of the files not found. This does not 
fail on a 10gR2 installation and tracing that also reveals that there is indeed 
no login.sql. In the 9i trace file there are 44 occurrences of NOENT and 38 in 
the 10g installation. Interestingly the last ENOENT entry in 10g is for 
login.sql. After the ENOENT for login.sql in the 9i instance there are two 

$ORACLE_HOME/lib/ and

I'm trying to determine what these files are and how they are used. Any 
thoughts greatly appreciated.


Bill Wagman
Univ. of California at Davis
IET Campus Data Center
(530) 754-6208

-----Original Message-----
From: Dan Norris [mailto:dannorris@xxxxxxxxxxxxx] 
Sent: Wednesday, December 10, 2008 8:46 AM
To: William Wagman
Cc: Goulet, Richard; oracle-l@xxxxxxxxxxxxx
Subject: Re: Unexpected behavior if whenever oserror set

Hi Bill,

If you think the error is generated on the client side (I suspect it 
is), then you might find some interesting information by tracing the 
sqlplus execution. If it's missing a file, you'll see the ENOENT error 
in the trace output. Start sqlplus like this:

strace -o /tmp/sqlplus-trace.log sqlplus <sqlplus-args>

As soon after the error as possible, exit sqlplus, open the logfile in 
an editor and search for ENOENT from the bottom up (in vi, that's 
"ctrl-G, ?ENOENT"). I suspect that will help you determine/confirm the 
file that sqlplus can't find. Searching for login.sql should also get a 
hit or two in that trace output.


William Wagman wrote:
> Richard,
> Neither system, either the 9i or the 10g installation has a login.sql however 
> there is glogin.sql in the $ORACLE_HOME/sqlplus/admin directory of each 
> server. That brings up the interesting question as to why 
> # sqlplus / 
> works but when connected a 
> SQL> connect <different user> 
> generates the error. I would expect that if the login.sql is not found I 
> would get the same error when initially invoking sqlplus. Am I missing 
> something?
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of William Wagman
> Sent: Tuesday, December 09, 2008 4:13 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Unexpected behavior if whenever oserror set
> Greetings,
> I'm running EE on RHEL4 64-bit. Setting whenever oserror exit
> generates the following behavior...
> [oracle@critpinndev pinntest ~]$ sqlplus /
> SQL*Plus: Release - Production on Tue Dec 9 13:05:55 2008
> Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
> Connected to:
> Oracle9i Enterprise Edition Release - 64bit Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release - Production
> SQL> whenever oserror exit
> SQL> connect oracle
> Enter password: 
> O/S Message: No such file or directory
> Disconnected from Oracle9i Enterprise Edition Release - 64bit
> Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release - Production
> This does *not* fail on a 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.

Other related posts: