I am facing while calling external procedure . 70-80% time procedure run successfully but same procedure giving me errors
ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error ORA-28576: lost RPC connection to external procedure agent:ORA-06512: at "ORV5_ETL.SM_DS_POPULATE_ADVANCED", line 625.
ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error ORA-20000: KUP-11523: external driver failed with unexpected error: unable to retrieve agent context:ORA-06512: at "ORV5_ETL.SM_DS_POPULATE_ADVANCED", line 625
current setup is Hadoop with oracle 12c, Big data sql 3.2.1 on Linux
Listener file
# listener.ora Network Configuration File: /u01/app/oracle/product/12.1.0.2/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = cdb)
(ORACLE_HOME = /u01/app/oracle/product/12.1.0.2/db_1)
(SID_NAME = cdb)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/12.1.0.2/db_1)
(SID_NAME = cdb)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bigdatahadoop.localdomain)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
LISTENER = (ADDRESS_LIST=
(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))
)
SID_LIST_LISTENER = (SID_LIST=
(SID_DESC=(SID_NAME=orcl)(ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/db_1))
(SID_DESC=(SID_NAME=extproc)(ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/db_1)
(PROGRAM=extproc))
)
ADR_BASE_LISTENER = /u01/app/oracle
DIAG_ADR_ENABLED_LISTENER = OFF
TNSNAME.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0.2/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
CDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bigdatahadoop.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cdb)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bigdatahadoop.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
extproc_connection_data =
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))
(CONNECT_DATA=(SID=extproc)))