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