| 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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
