we are getting oDBC ORA-03113 end of file on communication channel after upgrading database from 9.2.0.6 to 9.2.0.7 version.
Any quick fix would be appreciated
Printable View
we are getting oDBC ORA-03113 end of file on communication channel after upgrading database from 9.2.0.6 to 9.2.0.7 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
does the file exist
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.