lost RPC connection to heterogeneous remote agent using...
Good morning.
I am a VB developer and I use an Oracle database (10g).
Our Oracle database has to call (sometimes) a SQL server database to get/check information.
We just migrated our Oracle database to a new server using Windows (64 bit). Because Oracle doesn't have a 64 bit transparency or database gateway (yet), the DBA decided to install the 32 bit database gateway on a 3rd party (32 bit) server.
Now when I run my batch jobs that call these stored procedures, I am getting:
The VB Application identified by the event source logged this Application BatchValidation: Thread ID: 3224 ,Logged:
[1 of 1]07/21/2009 00:00 #9000{batchvalidation EXE}[modMain.Main][RADatabase.SP_BATCH_VALIDATION(,-1)][VBERR:9102][VBERR:-2147467259][Microsoft][ODBC driver for Oracle][Oracle]ORA-20003: SP_VALIDATION.BATCH FAILED. ORA-04067: not executed, %s does not exist
ORA-28511: lost RPC connection to heterogeneous remote agent using SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=m020appcliserv)(PORT=1526)))(CONNECT_DATA=(SID=TCISPROD)). Queue= MaxLevel=-1 RefNo=
ORA-06512: at "SYSADM.SP_VALIDATION", line 1894
ORA-06512: at line 1
[Microsoft][ODBC driver for Oracle][Oracle]ORA-20003: SP_VALIDATION.BATCH FAILED. ORA-04067: not executed, %s does not exist
ORA-28511: lost RPC connection to heterogeneous remote agent using SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=m020appcliserv)(PORT=1526)))(CONNECT_DATA=(SID=TCISPROD)). Queue= MaxLevel=-1 RefNo=
ORA-06512: at "SYSADM.SP_VALIDATION", line 1894
ORA-06512: at line 1
Note that this is an intermittent problem. If I rerun the SP, it sometimes goes through the second or third time.
It happens to different Stored Procedures or Packages - not necessarily the same one each time.
Also note that if I go to a query tool, like SQL Developer and sign in as SYSADM, I can select data from this SQL database (e.g. SELECT * from MARKETER@TCIS).
The issue is that we are running our batch jobs from another Application server (All batch jobs are run under a generic super user - not SYSADM).
Can anyone explain why this would be an intermittent problem? The DBAs are saying it is a data issue, which doesn't sound right.
I am not too familiar with the inner workings of how this is setup, but the DBA assures me that it is setup correctly and is blaming the data. However, the SPs and the VB code did not change. Only the db server changed and the database gateway moved to another server.