Q
Problem solve Get help with specific problems with your technologies, process and projects.

Intermittent dblink error for insert

An intermittent Oracle dblink error for an insert is occuring early in the week. After it generates an error, it starts working again on its own after the error occurs. I don't know if this is affecting the dblinks, but a cold Oracle backup occurs every Sunday evening. The error occurs when a batch job runs. The connection is between two Oracle database servers.

I have an Oracle error occuring: "ORA-12570: TNS:packet reader failure." An intermittent Oracle dblink error for an insert is occuring early in the week, typically on Mondays and rarely on Tuesdays. After it generates an error, it starts working again on its own after the error occurs. I don't know if this is affecting the dblinks, but a cold Oracle backup occurs every Sunday evening. The error occurs when a batch job runs in the morning and the evening, mostly in the morning. The connection is between two Oracle database servers. Also, a "ORA-03113: end-of-file on communication channel" error is received when the batch job fails. The Oracle version and platform are Oracle9i Enterprise Edition Release 9.2.0.5.0 with 64-bit Production Unix on both database servers.

The ORA-12570 error is telling you that data is expected to be received, but that data was not received. The cause could be a network hiccup. Check with your network administrators to see if they are noticing any network failures or other problems. If you could let them know the time this error occurred and the systems involved, they may be able to narrow down the problem even more.

A cold backup means that the database is shut down and unavailable. If a transaction is using a link to the database when it is shut down for the cold backup, then the transaction will receive an error. Typically the "ORA-3114: not connected to ORACLE" message is given, but you may also receive the ORA-3113 error.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close