Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calling External Procedure *Problem*

Status
Not open for further replies.

qasif

Programmer
Joined
Jul 18, 2003
Messages
4
Location
PK
Hi,

I am trying to call an external procedure (C language dll) from PL/SQL but I get the following error:
ORA-28575: unable to open RPC connection to external procedure agent

I have read a lot about thie resloution of this problem by configuring tnsnames and listner properly. But the error remains the same. Following are my configuration info:

********* tnsnames.ora entry ***********
extproc_connection_data=
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = DLLTEST)
)
(CONNECT_DATA = (SID = extproc)
)
)
******************************************

*************Listner.ora *************

LISTENER=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=IPC)(KEY=DLLTEST))
(ADDRESS=(PROTOCOL=TCP)(Host=mycomp)(PORT=1521))
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=dlltest)
(ORACLE_HOME=C:\Oracle\Ora81)
(SID_NAME=dlltest)
)
(SID_DESC=
(SID_NAME=extproc)
(ORACLE_HOME=C:\Oracle\Ora81)
(PROGRAM=extproc)
)
)
STARTUP_WAIT_TIME_LISTENER=0
CONNECT_TIMEOUT_LISTENER = 10

********************************************
*********************** Lsnrctl Status ***********

LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=DLLTEST))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 -
tion
Start Date 18-JUL-2003 18:05:44
Uptime 0 days 0 hr. 34 min. 47 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File C:\oracle\ora81\network\admin\listener.ora
Listener Log File C:\oracle\ora81\network\log\listener.log
Services Summary...
DLLTEST has 1 service handler(s)
dlltest has 1 service handler(s)
extproc has 1 service handler(s)

**************************************************
tnsping also returns successful result.
I have tried the demo application in the
\ORA81\RDBMS\extproc as well but same results :(

Everything seems to be on track as experts have mentioned on web. but I think I still miss something.

Looking for ur help.
regards,
Asif
 
Nobody wanna helps me :)
 
Can you run EXTPROC from command prompt?

Regards, Dima
 
Do you use MTS? If so, can you switch from IPC to TCP/IP?

Regards, Dima
 
I am using the dedicated sever mode. Yes, I can successfully run the extproc from command prompt.
regards,
Asif
 
Guys! its urgent and I am getting late :(
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top