Hello,
I have an odd situation. I have data that I want to transfer between an XE database and another database using a DBLINK.
Each process takes a bit of time and does not use all my CPU, so I have spawned two concurrent processes. Randomly, one or both processes will fail with the dreaded ORA-12592 error (TNS: Bad Packet).
The process is a PLSQL package and simply reads through several tables in a loop and transfers the data via a DBLINK. The process dies at different tables each time and may fail early or later in the process or not at all.
I have trapped the ORA-12592 error and have attempted to "retry" the process but that does not seem to work. It seems that once the ORA-12592 error has occurred, your process is toast?
I have used this process many times transferring data between my enterprise edition systems without any issue even with over a hundred of concurrent connections.
Does anyone have any ideas of how to resolve/troubleshoot this? I have support for my enterprise database instances, but I don't think I can use it for the XE product?
Cheers,
Paul