oracle oDBC ORA-03113 end of file on communication channel
we are getting oDBC ORA-03113 end of file on communication channel after upgrading database from 126.96.36.199 to 188.8.131.52 version.
Any quick fix would be appreciated
more information would be apreciated too
This is happening when we do update a user, remove a user, update password. Any clue dave.
These are the messages in alert log
Errors in file /u01/app/oracle/admin/IPRD/udump/iprd_ora_209178.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/redo02/oradata/IPRD/redo1b.log'
ORA-27037: unable to obtain file status
Last edited by vision; 11-07-2006 at 05:01 PM.
Is database opened?
The fragment of the alert.log you posted woudl most probably leave the database just mounted.
I suspect the part of the aletr.log you posted is completely unrelated to the ora-3113 (please note, the part of the alert.log you posted contains ORA-00313 NOT ora-03113)
Ora-3113 is most oftenly caused by unexpected crash of the dedicated server process. Of cource if the database crashes, that would be the result too.
You'll need to find the trace file generated by the ora-3113 and it will probably contain the query which breaks the server.
Click Here to Expand Forum to Full Width