| External Procedure Call For Intermedia [message #367779] |
Tue, 11 April 2000 10:45  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
