Saturday, June 18, 2016

ORA-28575 Unable to open RPC connection to external procedure agent

After patching ,In oracle database user is facing the below error.

Error : ORA-28575

Resolution:
Please add the EXTPROC  entry in Listener.ora and tnsnames.ora and reload the LISTENER on all nodes of a cluster.

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
    )
  )

Note: Please make sure soft links are pointed to our common location from GRID_HOME/network/admin and ORACLE_HOME/network/admin.

[frbucoras1l.em.health.ge.com:/u01/app/oracle/product/11.2.0.3/dbee_1/network/admin]
stgcrln1:oracle>ls -ltrh
total 28K
lrwxrwxrwx 1 oracle oinstall   51 Apr 19  2013 tnsnames.ora -> /u02/app/oracle/admin/ORABUC1S/network/tnsnames.ora
lrwxrwxrwx 1 oracle oinstall   47 Apr 19  2013 ldap.ora -> /u02/app/oracle/admin/ORABUC1S/network/ldap.ora

lrwxrwxrwx 1 oracle oinstall   51 Apr 19  2013 listener.ora -> /u02/app/oracle/admin/ORABUC1S/network/listener.ora

No comments:

Post a Comment