Home » RDBMS Server » Networking and Gateways » External Procedure Call For Intermedia
External Procedure Call For Intermedia [message #367779] Tue, 11 April 2000 10:45 Go to next message
Khurram Naseem
Messages: 3
Registered: March 2000
Junior Member
Service OracleOraHome81TNSListener started.
TNSLSNR for 32-bit Windows: Version 8.1.5.0.0 - Production
System parameter file is D:\Oracle\Ora81\network\admin\listener.ora
Log messages written to D:\Oracle\Ora81\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=extproc0)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orfnl)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=extproc0)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 8.1.5.0.0 - Produc
tion
Start Date 11-APR-00 12:32:15
Uptime 0 days 0 hr. 0 min. 2 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File D:\Oracle\Ora81\network\admin\listener.ora
Listener Log File D:\Oracle\Ora81\network\log\listener.log
Services Summary...
PLSExtProc has 1 service handler(s) (Note PLSExtProc is my external procedure ID)
ORCL has 1 service handler(s)
The command completed successfully
LSNRCTL>
**********************************************************************************************
But When I Test My Extproc By This Way
exec ctx_output.start_log('log');
It Gives Me Error

SQL> exec ctx_output.start_log('log')
BEGIN ctx_output.start_log('log'); END;

*
ERROR at line 1:
ORA-20000: ConText error:
DRG-50704: Net8 listener is not running or cannot start external procedures
ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "CTXSYS.DRUE", line 122
ORA-06512: at "CTXSYS.CTX_OUTPUT", line 39
ORA-06512: at line 1

Now What I Do Next I Don't Understand
I Have Very Short Time To Test (InterMedia Text) But It Can Not Create Index.
Please Help Me!!!!!
Thanks In Advance.
Re: External Procedure Call For Intermedia [message #367828 is a reply to message #367779] Wed, 20 September 2000 11:04 Go to previous message
Andrea Luciano
Messages: 1
Registered: September 2000
Junior Member
I had the same problem in two circumstances:

the first time I started up oracle without $ORACLE_HOME/ctx/lib wasn't in the LD_LIBRARY_PATH

the second time having the following entry in sqlnet.ora:

names.default_domain = mydomain.it

I had to use the domain in tnsnames.ora:

EXTPROC_CONNECTION_DATA.mydomain.it =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY=extproc0))
)
(CONNECT_DATA = (SID = PLSExtProc))
)

Bye.
Andrea
Previous Topic: rdbms80.vrf(855) error message
Next Topic: Oracle Connection Manager
Goto Forum:
  


Current Time: Fri Mar 29 04:45:14 CDT 2024