"O/S Message: No such file or directory" Error Encountered While Running "WHENEVER OSERROR" Command

(Doc ID 886422.1)

Last updated on MARCH 08, 2017

Applies to:

SQL*Plus - Version 9.2.0.8 to 9.2.0.8 [Release 9.2]
Linux x86
HP-UX PA-RISC (64-bit)
IBM AIX on POWER Systems (64-bit)
Oracle Solaris on SPARC (64-bit)
HP-UX Itanium
Linux x86-64
Linux Itanium
HP Tru64 UNIX
"Checked for relevance on 31-Jan-2013"


Symptoms

After connecting to SQL*Plus, when the following commands are executed :

SQL> WHENEVER OSERROR EXIT SQL.SQLCODE ROLLBACK
SQL> CONNECT &&UCD_USER/&&UCD_PASSWORD

the following error is encountered :

O/S Message: No such file or directory
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit

However, when the "WHENEVER OSERROR" command is executed after the "CONNECT" command, it works properly.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms