• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 893
  • Last Modified:

ORA-28575: unable to open RPC connection to external procedure

We are getting following errors while running an external procedure.

#-1#ORA-06520: PL/SQL: Error loading external library

ORA-06522: /u01/home/oracle/admin/callout/libdtc.so: cannot open shared object file: No such file or directory#

#-1#ORA-28575: unable to open RPC connection to external procedure agent#

TNSNames entry.

# tnsnames.ora

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

I have also attached the listener files.


#sqlnet.ora
# sqlnet.ora Network Configuration File: c:\11GMigrationTemporary\tnsnames\sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (LDAP,EZCONNECT,TNSNAMES)

ADR_BASE = /u01/app/oracle
listener-old.txt
listener.txt
0
sachin_dba
Asked:
sachin_dba
  • 2
1 Solution
 
Swadhin RaySenior Technical Engineer Commented:
are you able to ping the external TNS entry ?
0
 
Swadhin RaySenior Technical Engineer Commented:
you need to check the following steps mentioned in the below link:

http://www.dba-oracle.com/t_ora_28575_unable_open_rpc_connection.htm
0
 
sachin_dbaAuthor Commented:
I was able to ping external TNS entry after making changes in sqlnet and tnsfiles.

But getting error while executing the procedure., I shall work again and update here.
0
 
Steve WalesSenior Database AdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now