ORA-28575: unable to open RPC connection to external procedure agent
547367Jun 4 2009 — edited Feb 26 2011Hi
I have this error when I try to startup the gateway (dbms_mgwadm.startup). I see the error with this query:
select * from mgw_gateway (AGENT_STATUS=NOT_STARTED and LAST_ERROR_MSG is the ORA-28575)
I've looked at the listener.ora and tnsnames.ora files and i don't see anything wrong:
My tnsnames:
SICONET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = puesto160)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SICONET)
)
)
MGW_AGENT =
(DESCRIPTION=
(ADDRESS_LIST= (ADDRESS= (PROTOCOL=IPC)(KEY=EXTPROC)))
(CONNECT_DATA= (SID=mgwextproc) (PRESENTATION=RO)))
My listener.ora:
LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=puesto160)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME= mgwextproc)
(ENVS="LD_LIBRARY_PATH=C:\oracle\ora92\jdk\jre\lib\ext:C:\oracle\ora92\lib")
(ORACLE_HOME=C:\oracle\ora92)
(PROGRAM = extproc)
)
)
My mgw.ora:
set ORACLE_SID=SICONET