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

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

  1. #1
    Join Date
    Dec 2001
    Posts
    120

    hi,

    Thanks a lot for all your earlier responses!

    This occasion I am taking up a new error (ORA-03113) which is occuring intermittently whenever I am using Native Dynamic SQL (execute immediate) to create views inside a PL/SQL procedure. However if I replace NDS with Dynamic Sql then it works absolutely fine.
    I don't want to use dynamic sql because of its slow speed.


    I am giving below the exact error message :

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

    thanks
    Paul

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    This could be dependent on various scenarios. Take a look into the search forum and I have posted an oracle extract on this error

    http://dbasupport.com/forums/search.php


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Dec 2001
    Posts
    120

    ORA-03113 REOCCURENCE

    hi,

    Thanks for the link!
    As per the solution provided in the link I have added up a new value called "UnusedFileCache" in the NT server's HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session\Manager\Memory Management and set it's value to 18. After this I restarted the NT machine. Now when I execute the NDS statement the same error is reoccuring. However now out of 10 NDS statements executed 5-6 are succeding without failure, earlier 2-3 were succeding rest all were failing with the error ORA:03113. After the ORA:03113 the oracle session is getting disconnected.

    Need further help to sort out this problem of mine.

    thanks!

    Parijat Paul

  4. #4
    Join Date
    Dec 2001
    Posts
    120

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

    hi,

    I missed a valid point in my earler message. Every time I am getting this error (ORA-3113) a corresponding ORA-600 ERROR is occuring internally which gets dumped in the bdump directory. I didn't find any dump of ORA-3113 as such in the dumped .trc files. This could mean that ther's a relation between these two errors. What could be the reason? It's giving line numbers of some procedures but what should be infered from these line numbers? Since the same procedures run fine if I re-logon and pass the same set of parameters.


    Parijat Paul

    ----------------------------------------------------
    I am giving below the exact error messages:
    ----------------------------------------------------
    ORA-00600: internal error code, arguments: [12261], [], [], [], [], [], [], []
    No current SQL statement being executed.
    ----- PL/SQL Call Stack -----
    object line object
    handle number name
    62c9aa8 289 package body DEV1.MY_CACHE
    5814738 17 package body DEV1.MY_CACHE_INT
    62c9aa8 16 package body DEV1.MY_CACHE
    43da900 2 anonymous block


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