My Oracle Support Banner

"O/S Message: No such file or directory" Error Encountered While Running "WHENEVER OSERROR" Command (Doc ID 886422.1)

Last updated on FEBRUARY 03, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.