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

Thread: ORA-03113: end-of-file on communication channel error After mounting the database

  1. #1
    Join Date
    Oct 2003
    Location
    INDIA
    Posts
    3

    Question ORA-03113: end-of-file on communication channel error After mounting the database

    Dear all,

    We are using ORACLE 8.1.7.4 on AIX 4.3, IBM Server. We are facing problem when open the database. After mounting the database it is giving "ORA-03113: end-of-file on communication channel" error. After that the instance itself getting down and we couln't see the process in OS level itself.

    I found the system datafile is not getting updated the time stamp, but the controlfile is getting updated the time stamp.

    If somebody can help me that will be really helpful..

    Please find the details below..

    SVRMGR> connect internal
    Connected.
    SVRMGR> startup pfile=/mm2/db/MMDEV/dbs/initMMDEV.ora
    ORACLE instance started.
    Total System Global Area 92311444 bytes
    Fixed Size 73620 bytes
    Variable Size 52838400 bytes
    Database Buffers 39321600 bytes
    Redo Buffers 77824 bytes
    Database mounted.
    ORA-03113: end-of-file on communication channel
    SVRMGR> exit

    /mm2>ps -ef |grep MMDEV
    mrm 32254 33378 1 10:45:20 pts/2 0:00 grep MMDEV
    /mm2>





    =================
    Starting ORACLE instance (normal)
    LICENSE_MAX_SESSION = 0
    LICENSE_SESSIONS_WARNING = 0
    Fri Oct 10 10:44:31 2003
    Starting ORACLE instance (normal)
    LICENSE_MAX_SESSION = 0
    LICENSE_SESSIONS_WARNING = 0
    LICENSE_MAX_USERS = 0
    Starting up ORACLE RDBMS Version: 8.1.7.4.0.
    System parameters with non-default values:
    processes = 70
    timed_statistics = TRUE
    shared_pool_size = 30720000
    nls_date_format = YYYYMMDD
    control_files = /mm2/db/MMDEV/dblog1/control/ctrl1MMDEV.ctl, /mm2/db/MMDEV/dblog2/control/ctrl2MMDEV.ctl
    db_block_buffers = 4800
    db_block_size = 8192
    log_buffer = 32768
    log_checkpoint_interval = 10000
    db_files = 64
    dml_locks = 100
    rollback_segments = rbs_01, rbs_02, rbs_03, rbs_04, rbs_05
    max_enabled_roles = 100
    global_names = FALSE
    db_name = MMDEV
    open_cursors = 200
    ifile = /mm2/db/MMDEV/dbs/configMMDEV.ora
    optimizer_mode = CHOOSE
    background_dump_dest = /mm2/db/MMDEV/dblog1/log
    user_dump_dest = /mm2/db/MMDEV/dblog1/log
    core_dump_dest = /mm2/db/MMDEV/dblog1/core
    PMON started with pid=2
    DBW0 started with pid=3
    LGWR started with pid=4
    CKPT started with pid=5
    SMON started with pid=6
    RECO started with pid=7
    Fri Oct 10 10:44:33 2003
    alter database mount
    Fri Oct 10 10:44:37 2003
    Successful mount of redo thread 1, with mount id 768785685.
    Fri Oct 10 10:44:37 2003
    Database mounted in Exclusive Mode.
    Completed: alter database mount
    Fri Oct 10 10:44:37 2003
    alter database open
    Fri Oct 10 10:44:38 2003
    Errors in file /mm2/db/MMDEV/dblog1/log/dbw0_36704_mmdev.trc:
    ORA-00600: internal error code, arguments: [17585], [33554433], [538610432], [], [], [], [], []
    Fri Oct 10 10:44:38 2003
    Errors in file /mm2/db/MMDEV/dblog1/log/dbw0_36704_mmdev.trc:

    THANKS IN ADVANCE..

  2. #2
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    Could u pls post or email the contents of this file
    Errors in file /mm2/db/MMDEV/dblog1/log/dbw0_36704_mmdev.trc:

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    have you set the kernel parameters or have they changed recently?

  4. #4
    Join Date
    Oct 2003
    Posts
    38
    Try increasing the processes. give it a try

  5. #5
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Has this database been running then all of a sudden this is happening? If so what has changed?


    As everyone knows UNIX operating systems are one of the most stable enviornments. You said that your system datafile isn't getting updated. Could of someone gone in and changed the permissions to that folder (or file) so that the database owner can't write to it? Is the disk full where the datafiles reside?
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  6. #6
    Join Date
    Oct 2003
    Posts
    38
    Read metalink Notes: 17613.1

  7. #7
    Join Date
    Oct 2003
    Location
    INDIA
    Posts
    3
    I didn't change the kernel parameters recently. I have more than 4GB free space available in the file system. And nobody changed the permission of the file.

  8. #8
    Join Date
    Oct 2003
    Location
    INDIA
    Posts
    3

    trace file

    Please find the log file. Since the trace file is too big, i removed last part of the file.
    Attached Files Attached Files

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