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

[parijat67]

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

[sambavan]

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

[parijat67]

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

[parijat67]

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