Wednesday, November 28, 2007

After 9.2.0.8 patchset adgrants.sql fails "O/S Message: No such file or directory"

SYMPTOM:

sqlplus "/ as sysdba" @adgrants.sql

SQL*Plus: Release 9.2.0.8.0 - Production on Sun Nov 18 16:14:16 2007

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

O/S Message: No such file or directory

SQL*PLUS exits O/S message "No such file or directory" or "Permission denied"


Solution:

Apply the RDBMS patch 5495695. Review the README.txt for instructions.

No comments: