ORA-3113 in database startup(open) URGENT ?
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: ORA-3113 in database startup(open) URGENT ?

  1. #1
    Join Date
    Jun 2001
    Posts
    103
    Hi all.
    OS==> NT 4.0 SP6
    DB==> Oracle 8.1.6.0.0 EE
    This server was running for a year.
    A month ego we switch to MTS and all was ok until today.
    Today because SHUTDOWN IMMEDIATE was very long I do SHUTDOWN ABORT (with down oracle service ).
    After this action :
    connect as internal to sql*plus :
    SQL>STARTUP NOMOUNT;
    OK.
    BUT :
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-03113: end-of-file on communication channel


    SQL>
    -----------------------------------------------------
    Why ORA-03113 ocuured?any suggestion?
    We have not METALINK support.
    I search this error in this forum and any suggestion was unsuccesfull.
    I reboot NT server and drop MTS parameter from init.ora , but this error still exists.
    If anybody access to metalink and knows solution for this problem(with search in metalink) please help me.

    Sorry for my english!!!
    Best Regards.

  2. #2
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Lead

    Hi, 2nd Sep 2001 18:25 hrs chennai

    I too have faced simillar problem and solved it but now i dont remember the solution.

    Before going in to that i would like to Know

    1)Whether you are successfull connecting via SVRMGRL ?

    2)Do You have multiple instances running in your system ?

    To Problem
    ========

    Oracle Docs says:

    Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be
    handled by the Net8, two task, software. This message could occur if the shadow two-task process associated
    with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.

    Action: If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of customer support.

    Awaiting your reply to proceed further.

    Cheers

    Padmam


    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Did you log in as administrator? If not, then you must explicitly name the owner of the NT services.

    Do the following:

    1. Open the "Services" dialog box from the NT Control Panel.

    2. Click on the OracleService then click the "Startup..." button.

    3. Change the "Log on as:" information to "This Account: " plus the appropriate password where username> = the person who created the services.

    4. Repeat steps 2 & 3 for the OracleStart service.

    In some cases the ORA-3113 occurs even if you are logged on as the NT administrator. In this case = Administrator.

  4. #4
    Join Date
    Jun 2001
    Posts
    103
    1) I connect to SVRMGRL but same error occured.
    2) I have one instance on this machine.
    3) I log on NT with Administrator.
    4) after mount database :
    select * from v$recover_file returns no rows.
    I restored backup and recover database .
    But I can't find solution for this error.

    Best Regards.


  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    But I can't find solution for this error.
    [/B]
    Try to do the following:

    1. SHUTDOWN IMMEDIATE
    2. STOP all Oracle services (from the Control Panel)
    3. START the services again
    4 SVRMGRL> SET ORACLE_SID=NAME
    5. SVRMGRL> STARTUP PFILE=...

    Tell me what ORA Error you get now (if you get any).


  6. #6
    Join Date
    Jun 2001
    Posts
    103
    Hello julian.
    First of all , this server is production server , and I have cold backup of one day ego , I restored backup in another machin and it is ok.
    But in main production server still this error exists.
    I do 5 step that you say, but ORA-3113 after mount and when open database occured.
    SVRMGR> startup pfile=...
    ORACLE instance started.
    Total System Global Area 178218252 bytes
    Fixed Size 70924 bytes
    Variable Size 116629504 bytes
    Database Buffers 61440000 bytes
    Redo Buffers 77824 bytes
    Database mounted.

    ERROR at line 1:
    ORA-03113: end-of-file on communication channel.

    and then disconnect from oracle.

    Sorry for my english!!!
    Best regards.


  7. #7
    Join Date
    Mar 2001
    Posts
    65
    my experience with this error says that
    it's most likely due to underlyng network problem
    provided nothing changed at net8 level during the period
    under observation.

    ajay

  8. #8
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    Can you startup DB by using NT Service?

  9. #9
    Join Date
    Dec 2000
    Posts
    19

    Thumbs up

    Shutdown the NT Server and restart and try starting the database. It believe it will work.

  10. #10
    Join Date
    Dec 2000
    Posts
    19

    Thumbs up

    Sometimes shutdown immediate will not shutdown the db. It will take a long time than expected. Use shutdown transactional. Pls don't use shutdown abort. When u use shutdown abort, startup the db and shutdown using either shutdown transactional or shutdown immediate.

    These are documented(Ref to Admin Guide)

    From Dos prompt
    start the listener using lsnrctl start

    c:\> set ORACLE_SID=

    c:\>svrmgrl
    svrmgrl>connect internal
    svrmgrl>startup


    This will surely startup the database.

    Get back to me if u need more clarifications.
    Venkat

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width