Home » Server Options » Text & interMedia » Problem configuring Net8 listener
Problem configuring Net8 listener [message #366442] Mon, 07 August 2000 21:38 Go to next message
Daniel Zwolenski
Messages: 1
Registered: August 2000
Junior Member
Hi,

I am running Oracle with interMedia on an NT server and am having trouble setting up the listener. The doco I've got is Unix oriented and says I should add the following to the listener SID_LIST:

(SID_DESC = (SID_NAME = ep_agt1)
(ORACLE_HOME = /oracle
(ENVS = LD_LIBRARY_PATH=oracle/ctx/lib)
(PROGRAM = extproc))

<NOTE: Ive changed the paths to use windows directories and to point to my own oracle_home)

The one that worries me is the ENVS value. What should this be on NT? The <orahome>/ctx directory exits on my server but there is no lib directory under it.

Ive also added the extproc entry to tnsnames.ora (I've done this on the client end, is this OK?). It looks like this:

extproc_connection_data =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)
(HOST = taipan)
(PORT = 1521)
(KEY = WDBTEST))
(CONNECT_DATA = (SID = ep_agt1)))

Im pretty sure Ive got everything else configured OK but any suggestions are welcome.

This is the error message I get when I try to use the interMedia stuff:

ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
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.TEXTINDEXMETHODS", line 34
ORA-06512: at line 1

Thanks for your help,
daniel.
Re: Problem configuring Net8 listener [message #366449 is a reply to message #366442] Thu, 31 August 2000 14:20 Go to previous message
jj wang
Messages: 3
Registered: August 2000
Junior Member
Please note extproc uses IPC, not TCP. You would need to add an IPC entry in the listener.ora file

LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

.
.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = hideplsextproc)
(ORACLE_HOME = /ora01/app/oracle/product/8.1.6)
(PROGRAM = extproc)
)
.
.

In tnsnames.ora, use

extproc_connection_data.world =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = extproc0))
(CONNECT_DATA = (SID = hideplsextproc))
)

If you are running MTS, declare an IPC entry in init.ora.

Also, amke sure that the fully qualified name .world is used in tnsnames.ora should sqlnet.ora use the domain since sqlnet's domain will overwrite init.ora's domain declaration.

To see whether your NT8 is configured properly, test it via

exec ctx_output.start_log('yourlog')

CTAPP role is a minimu for granting the public synonyms of CTX_OUTPUT etc.

To use additional features for datastore and stoplist, you will need to find the specific CTX_DDL to grant to user. Otherwise, your index optimizing and synchronization will not work.

jj wang
Previous Topic: Problems with file_datastore index.
Next Topic: SYS Passwd
Goto Forum:
  


Current Time: Thu Mar 28 08:42:49 CDT 2024