Operating System - HP-UX
1833896 Members
2171 Online
110063 Solutions
New Discussion

error while updating tables from oracle

 
alan_131
Occasional Advisor

error while updating tables from oracle

I have this error encountered while updating a certain fields on a single table via remote. & suddenly I just couldn't update any field but early on I used to update couple of the same fields what i'm trying to update where the error first occured.I tried scanning the full DB profile but nothing seems to reach it's maximum storage. When I browse the logs I have this alert log on the background processes saying.

Sun Dec 19 13:44:04 2004
ORA-07445: exception encountered: core dump [10] [0] [0] [0] [] []
Errors in file oradata/bdmp/reco_29492.trc:
ORA-02019: connection description for remote database not found
ORA-02019: connection description for remote database not found

then I also tried updating some tables locally but still the same problem I encountered...

Does anybody know's how to deal with this?...?
2 REPLIES 2
Steven E. Protter
Exalted Contributor

Re: error while updating tables from oracle

1) look at the core dump. maybe run it through a debugger
2) run a metalink search for both errors.
3) do a bdf and look for a full filesystem.
4) Make sure os and oracle is properly patched.
5) Make sure you have enough shared memory allocated.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Michael Schulte zur Sur
Honored Contributor

Re: error while updating tables from oracle

Hi,

are you using a database link or odbc for database access? Is that remote database in a lan or wan? Have you checked the communication connect for stability?

greetings,

Michael