Home » RDBMS Server » Server Administration » ORA-03114 coming randomly while updating the data
ORA-03114 coming randomly while updating the data [message #62448] Thu, 22 July 2004 04:41 Go to next message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
I am getting the oracle error ORA-03114 randomly while updating the data. 

Please help.

Report message to a moderator

Re: ORA-03114 coming randomly while updating the data [message #62453 is a reply to message #62448] Thu, 22 July 2004 12:34 Go to previous messageGo to next message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
Check your network .... 3114 is when Oracle is not available. Or the DB is down.

Report message to a moderator

Re: ORA-03114 coming randomly while updating the data [message #62660 is a reply to message #62448] Fri, 06 August 2004 22:50 Go to previous message
charles
Messages: 16
Registered: September 2000
Junior Member
is there a trigger in your Table?
coz if there is the trigger it's the one who is causing to end up communication channel.
Same error i had encountered during updating triggers.

Search more about this error.
This usually occure when updating triggers and long procedures and functions.

Some said that you must adjust its parameters on Init.ora to solved this problem but it causes another problem an ora-27101: shared memory realm does not exist.

I really don't know what to do, just try anything k.

Report message to a moderator

Previous Topic: UNDO tbs related issues
Next Topic: how can u find IP address of th user
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 26 18:12:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.