ERROR 45 Initializing SQL*PLUS Internal Error

ERROR 45 Initializing SQL*PLUS Internal Error

Oracle Tips by Burleson Consulting

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