Home » RDBMS Server » Networking and Gateways » cannot invoke external procedures
cannot invoke external procedures [message #367840] Tue, 17 October 2000 02:52
Oleg
Messages: 7
Registered: October 2000
Junior Member
I cannot tune listener for him to execute external procedures. Here are the configuration files:

listener.ora:
LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
)

TRACE_LEVEL_LISTENER=16
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=db1)
(SID_NAME=db1)
(ORACLE_HOME=/pt01/app/oracle/product/8.1.5)
)
(SID_DESC=
(GLOBAL_DBNAME=db2)
(SID_NAME=db2)
(ORACLE_HOME=/pt01/app/oracle/product/8.1.5)
)
(SID_DESC=
(GLOBAL_DBNAME=extproc_connection_data)
(SID_NAME=extproc)
(ORACLE_HOME=/pt01/app/oracle/product/8.1.5)
(PROGRAM=extproc)
)
)

tnsnames.ora:
db2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = db2)
)
)

db1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = db1)
)
)

db0 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = db0)
)
)

extproc_connection_data=
(DESCRIPTION = (
(ADDRESS =
(PROTOCOL=IPC)
(KEY=extproc)
)
(CONNECT_DATA =
(SID=extproc)
)
SOURCE_ROUTE=YES
)

When i try to execute any external procedure i receive following message:
SQL> exec globban;
BEGIN globban; END;

*
ERROR at line 1:
ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "COMMON.GLOBBAN", line 0
ORA-06512: at line 1

What can i do?
Previous Topic: dbsnmp
Next Topic: Database Link Problem
Goto Forum:
  


Current Time: Fri Mar 29 05:44:15 CDT 2024