Forum Stats

  • 3,770,284 Users
  • 2,253,089 Discussions
  • 7,875,387 Comments

Discussions

ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error ORA-28576: lo

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)))