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 OCTOBER 24, 2022

Applies to:

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


Symptoms

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

SQL> WHENEVER OSERROR EXIT SQL.SQLCODE ROLLBACK
SQL> CONNECT <USERNAME>/<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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.