Forum Stats

  • 3,768,921 Users
  • 2,252,874 Discussions
  • 7,874,800 Comments

Discussions

callout ORA-29400: data cartridge error ORA-28576: lost RPC connection to external procedure agent:O

Dear  All

needed your support as I am getting below errors . 70-80% cases are executed successfully.. but in certain cases getting error and if I re-execute the query getting success .

Current Setup

Hadoop , Big data sql 3.2.1, Oracle 12c

callout ORA-29400: data cartridge error ORA-28576: lost RPC connection to external procedure agent:ORA-06512

callout ORA-29400: data cartridge error ORA-20000: KUP-11523: external driver failed with unexpected error: unable to retrieve agent context:ORA-06512

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 = xxxxxxxx)(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))

)

Tnsnames.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 = xxxxxxxxx)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = cdb)

    )

  )

ORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxxx)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

extproc_connection_data =

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))

(CONNECT_DATA=(SID=extproc)))

ADR_BASE_LISTENER = /u01/app/oracle

DIAG_ADR_ENABLED_LISTENER = OFF