Thursday 3 May 2012

Error 45 initializing SQL*PLUS Internal Error

During pre-11g check the sql script execution fails with the "Error 45 Initializing SQL*PLUS" on the sqlplus as below

SQL> spool utlu1112i.log
SQL> @utlu112i.sql
Error 45 initializing SQL*Plus
Internal error

The reason is the path where the 11g script utlu112i.sql script copied to on the 10g database server.

Solution:
Copy the utlu112i.sql script to the $ORACLE_HOME/rdbms/admin directory and execute the script.


SQL> spool utlu1112i.log
SQL> @utlu112i.sql

No comments: