ORA-03113: end-of-file on communication channel
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

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

  1. #1
    Join Date
    Nov 2000
    Posts
    51
    Hi all. I tried to create a database using the scripts generated by dbassist. When I run the create script, I got ORA-03113:end-of-file on communication channel. I checked the listener file, all the setting is correct. I then manually run create database command on svrmgrl, got the same message. anyone have any ideas?

    Thanks.

  2. #2
    Join Date
    Nov 2000
    Posts
    51

    no lk<SID> file

    Hi,

    I found out there is no lk file under $ORACLE_HOME/dbs. Is it the reason cause the ora-03113 error? Does it mean I need to re-install the software. BTW, it's a solaris box and the oracle version is 8.1.7.

    Thanks.

  3. #3
    Join Date
    Mar 2001
    Posts
    286
    Some recommednation:

    1. Check to see if you have privilege to write in the directory where you want to create your datafiles.

    2. If 1 is OK, I would like to suggest re-install Oracle and use dbassist to create a database. See if that helps!

  4. #4
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    it is highly possible that this comes from kernel parameters not being weel adjusted. try these values :

    set shmsys:shminfo_shmmax=4294967295
    set shmsys:shminfo_shmmin=1
    set shmsys:shminfo_shmmni=200
    set shmsys:shminfo_shmseg=50
    set semsys:seminfo_semmni=100
    set semsys:seminfo_semmsl=700
    set semsys:seminfo_semmns=1200
    set semsys:seminfo_semopm=100
    set semsys:seminfo_semvmx=32767

  5. #5
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Check on Metalink for this issue.
    1. there are known reasons for this error.
    2. this error crops up during db creation in 8.1.6 (that I know of), dunno if this was fixed.

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Check your umask -a it should be set to 022


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  7. #7
    Join Date
    Nov 2000
    Posts
    51

    ora-03113

    Thanks for your reply.

    I checked everything you mentioned, still get the error. Do you think I shoud reboot the server? There is another weird thing, when I shutdown the database abort and
    svrmgr> connect internal
    svrmgr>connected
    Since the database is not started, it should show 'connect to idle database' instead of 'connect'. Anyone have ideas?

    Thanks

  8. #8
    Join Date
    May 2001
    Posts
    1

    Unhappy

    I am also getting this same error ( Ora-03113) but I am using Winnt Workstation 4.0 with SP6a. I only run Oracle on this workstation for stand-alone testing..

    I am installing Oracle 8.1.6. and have installed 3 times with the same error. The error happens DURING install.

    I can tnsping the database...but when I try to access via SQL*NET it fails.
    I have tried to recreate the tnsnames.ora file (several times) using Net8 with no luck.
    changed my ip from DHCP to static


    any suggestions

    Thanks in advance

    [Edited by thood on 05-09-2001 at 03:15 PM]

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