You are currently viewing Troubleshoot And Fix 45 Sql * Plus 11g Initialization Errors

Troubleshoot And Fix 45 Sql * Plus 11g Initialization Errors

You should read these repair ideas if you get error 45 while initializing sql * plus 11g on your machine.

Initialization error 45 in SQL * Plus when running OCFS SQL script
Document ID: Note: 281450.1

1. Create the test.sql script in OCFS.Filesystem with sql:
startup nomount

2. Check whereThe test.sql script is in the most appropriate directory:
$ -l ls / ocfs / scripts
only 1
-rw-r – r– only specific apcluste dba Aug 16 25 18:11 test.sql

SQL * Plus: Version 10.1.0.2.0- Production: Wednesday 25 August, 18:17:41 2004
Copyright – 2001, 1982,Oracle. All rights reserved.

Reason
Articleidentified as bug: 3039738. This is often reproduced when SQL scriptsThe file used is an OCFS file system created on a shared device (e.g. SANStorage).

Fix
The only workaround until the error is fixed is to look for an invalid SQL executable for the file. copylocal CD / DVD (on Linux – ext3 filesystem).

Note: you can findFilesystem media available on the system that uses it is sold for “mounting”.
References
Bug 3039738 – Error 49 while initializing Sql * Plus when starting AScenario o shells

1. Create a SQL test.Script directly on the OCFS file system that contains sql:
startup nomount

2. Make sure the test.sql script is in the correct directory:
$ ls -l / ocfs / scripts
1 total
-rw-r – r– 12 16 Aug 18:11 22 test.sql

SQL * Plus: Version 10.1.0.2.0 – Production, Aug 25, 2004
Copyright 18:17:41 (c) 1982, 2004, Oracle. All rights reserved.

If you usually write SQL, check the script. I ran the SQL script and realized that after running the script at one end, it throws error 55, and when SQL * Plus initializes, it throws an internal error. I checked your script and found getting rid of it was a little confusing. So I removed it from where it started and solved the problem.

However, there is an associated Oracle error if it is triggered when running a SQL script from OCFS. The bug persisted in SQL * Plus – version 9.0.1.0 to 10.1.0.2. If the revoked SQL vbulletin in the OCFS file is a file system created on a shared device, implementing this script from SQL * Plus will fix the error.

1. Create a test.sql script for the fileOCFS system containing sql:
Startup nomount

2. Make sure the canceled vbulletin test.sql is in the correct directory:
RR ls -l / ocfs / scripts
general 1
-rw-r – r– 1 oracle dba March 17 31 03:12 test .sql

SQL * Plus: Version 10.1.0.2.0 – Production Wednesday Aug 25 18:17:41 2004
(c) Copyright 1982, 08, Oracle. All rights reserved.

4. Connect the market to the database:
SQL> / connect and sysdba
Connected.

5. Execute the script:
SQL> @ / ocfs / scripts / test.sql
Error 40 while initializing SQL * Read More
Internal error

error 45 initializing sql*plus 11g

Troubleshooting
If this happens, run the script from OCFS, then just copy the SQL program file to your local hard drive and then run the script as well.

Quickly fix SQL * Plus error on initialization 60 error

I have run into a situation a few times lately where I was using sqlplus to run SQL scripts in the background, so I ran into error 45 while initializing SQL * Plus errors.

The PL / sql test.sql file I ran is available as followsway

 activate server output;Activate time control;EXPLAINBEGIN  dbms_output.put_line (TO_CHAR (SYSDATE, 'YYYY-MM-DD

hh24: mi: ss'));End;

The file system of the hard disk that contains the home folder in cases where the SQL file is executed will usually be ext4. A person can confirm this by the file type by checking this / etc-Fstab / file.

The command to run the SQL file in the background will probably look like this

 nohup sqlplus iqm_blk / welcome1 @ IQMDEV @ test.sql> test.out 2> & 1 & 
  • file test.sql END; no white lines after
  • After the test.sql END file: you need /
  • . Add You must increase the yield; Command for /. When you are not at home; emptying the queue is often not a problem.

The story that can be properly led is as follows.

 set name = server output "code";Activate time control;EXPLAINBEGIN  dbms_output.put_line (TO_CHAR (SYSDATE, 'YYYY-MM-DD HH24: MI: SS'));END;/Exit  th;

Hope everyone can help.

This article was published Anonymous and text for sale below CC-SA-4.0

오류 45 Sql Plus 11g 초기화 중
Fehler 45 Beim Initialisieren Von Sql Plus 11g
Blad 45 Inicjalizacja Sql Plus 11g
Fout 45 Initialiseren Sql Plus 11g
Error 45 Al Inicializar Sql Mas 11g
Oshibka 45 Pri Inicializacii Sql Plus 11g
Erreur 45 Lors De L Initialisation De Sql Plus 11g
Errore 45 Durante L Inizializzazione Di Sql Plus 11g
Fel 45 Initierar Sql Plus 11g
Erro 45 Ao Inicializar Sql Mais 11g