DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ORA-03113: end-of-file on communication channel

  1. #1
    Join Date
    Feb 2001
    Posts
    39
    Hi All,
    Can someone help me solve this problem I am having creating another database instance on HP. I am running ORACLE 8i and the machine already has three other instances running on it. When I try creating a new instance it give the error above. I know it might have something to do with the Memory, but I do not know the fomula that helps one to set it right. Thanks for your help.

    Bond.
    God Bless

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Is that the only error you get or is there some more ?


    Try setting your /etc/system (in Solaris) HP, I don't know how this had been named ...
    For semmsl,
    Set it to 10 plus the largest initsid.ora PROCESSES parameter of an
    Oracle database on the system.

    For SEMMNS,
    Set it to the sum of the PROCESSES parameter for each Oracle database
    , plus 2 times the largest PROCESSES value, plus 10
    number of Oracle databases.

    For example, consider a system that has three Oracle instances with the PROCESSES parameter in their initsid.ora files set to the following values:

    ORACLE_SID=A, PROCESSES=100
    ORACLE_SID=B, PROCESSES=100
    ORACLE_SID=C, PROCESSES=200


    The value of SEMMNS is calculated as follows:

    SEMMNS = ((A=100) + (B=100)) + ((C=200) * 2) + ((# of instances=3) * 10) = 630



    Sam

    [Edited by sambavan on 09-20-2001 at 11:24 AM]
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227
    I usually get this error when I used my dial-up connection to load or export large table(s). What kind of connection do you have (bandwidth)?
    leonard905
    leonard905@yahoo.com

  4. #4
    Join Date
    Feb 2001
    Posts
    39
    I do not think that it is a band width problem because I am on a network and the speed is in excess of a T-1 line. Here is the error as it appears on the screen:

    Oracle Server Manager Release 3.1.6.0.0 - Production

    Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

    Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.6.0.0 - Production

    SVRMGR> SVRMGR> Connected.
    SVRMGR> ORA-03113: end-of-file on communication channel
    SVRMGR> CREATE DATABASE "database_name"

    Prior to this error I had another error:

    Wait/something I can't even remember anymore.

    Thanks in advance.
    Bond.
    God Bless

  5. #5
    Join Date
    Feb 2001
    Posts
    39
    The first error message that I had will trying to create the fourth database on the system was:

    ORA-27146 post/wait initialization failed

    I went on to adjust some of the parameters on the init.ora file. One of the parameter was the java_pool_size. That is when I started having this new error.

    Thanks for your help.

    Bond.
    God Bless

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Looks like that your system resource is low...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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