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.

Quick and Easy PC Repair

  • 1. Download and install ASR Pro
  • 2. Open the program and click "Scan"
  • 3. Click "Repair" to start the repair process
  • Enjoy a faster

    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).

    Quick and Easy PC Repair

    Is your computer running a little slower than it used to? Maybe you've been getting more and more pop-ups, or your Internet connection seems a bit spotty. Don't worry, there's a solution! ASR Pro is the revolutionary new software that helps you fix all of those pesky Windows problems with just the click of a button. With ASR Pro, your computer will be running like new in no time!

  • 1. Download and install ASR Pro
  • 2. Open the program and click "Scan"
  • 3. Click "Repair" to start the repair process

  • 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

    Enjoy a faster

    오류 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