ERROR 45 Initializing SQL*PLUS Internal Error Oracle Database Tips by Donald Burleson

Question:  I'm getting the "ERROR 45 INITIALIZING SQL*PLUS INTERNAL ERROR" error message.  How do you resolve the ERROR 45 Initializing SQL*PLUS Internal Error error?   

Answer:  MOSC 281450.1 notes:

Error 45 Initializing In SQL*Plus When Running A Sql Script From OCFS
Doc ID: Note:281450.1


Steps to reproduce are shown by example as follows:

1. Create a test.sql script on OCFS filesystem containing sql:
startup nomount

2. Check that test.sql script is in correct directory:
$ ls -l /ocfs/scripts
total 1
-rw-r--r-- 1 apcluste dba 16 Aug 25 18:11 test.sql

3. Invoke SQL*Plus:
$ sqlplus /nolog

SQL*Plus: Release 10.1.0.2.0 - Production on Wed Aug 25 18:17:41 2004
Copyright - 1982, 2004, Oracle. All rights reserved.

4. Connect to database:
SQL> connect / as sysdba
Connected.

5. Execute script:
SQL> @/ocfs/scripts/test.sql
Error 45 initializing SQL*Plus
Internal error


Cause
The issue is identified as Bug:3039738. This typically reproduces when SQL script file is on a OCFS filesystem created on shared device (for example, SAN storage).

Fix
The only workaround, until bug is fixed, is to copy the SQL script file to a local disk (in case of Linux, a ext3 filesystem).

Note: You can find the filesystem mount points available on system using command "mount".
References
Bug 3039738 - Error 45 Initializing Sql*Plus Running A Shell Script

 

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.