Re: interMedia Text

As you are running 8.1.7 you should not need the extproc_connection_data entry. What you need is that the LD_LIBRARY_PATH includes $ORACLE_HOME/ctx/lib in the environment *before* you start the Listener. The listener.ora entries are the regular entries for the database SIDs.

Hemant

At 03:48 AM 12-08-02 -0800, you wrote:
>Dear List,
>We have :- Solaris SunOs 5.8, Oracle 8.1.7
>I have created three databases using the dbassist tool and I included, as
>one of the installation options, InterMedia.
>Having read the installation guides (including post installation for Oracle
>InterMedia) and the Oracle interMedia Text - 8.1.5 Overview "Post
>Installation Setup" I have the following questions :-
>1) Having amended the "listener.ora" and "tnsnames.ora" files I'm not sure
>if I have done this correctly because the "Post Installation Setup" refers
>to adding ONE entry (for extproc_connection_data) in the tnsnames.ora file
>for A database.
>But I have three, so I have entered this SID specific info. three times, is
>this correct ?
>2) Having amended the listener.ora file to contain three extra entries is
>this correct ?
>3) I remember one of the NET8 classes I took, where the instructor insisted
>that we amend these files with great caution and in particular to the layout
>of entries. e.g. the number of spaces etc. etc. Well the new entries I added
>don't conform exactly to the already existing entries, here is a snip of my
>listener.ora file
>SID_LIST_LISTENER (SID_LIST (SID_DESC (SID_NAME LSExtProc)
> (ORACLE_HOME u01/app/oracle/product/8.1.7)
> (PROGRAM xtproc)
> )
> (SID_DESC (GLOBAL_DBNAME ATREP)
> (ORACLE_HOME u01/app/oracle/product/8.1.7)
> (SID_NAME ATREP)
> )
> (SID_DESC (GLOBAL_DBNAME QPROD01)
> (ORACLE_HOME u01/app/oracle/product/8.1.7)
> (SID_NAME QPROD01)
> )
> (SID_DESC (GLOBAL_DBNAME QTEST01)
> (ORACLE_HOME u01/app/oracle/product/8.1.7)
> (SID_NAME QTEST01)
> )
> (SID_DESC SID_NAME p_agt1)
> (ORACLE_HOME u01/app/oracle/product/8.1.7)
> (ENVS D_LIBRARY_PATH01/app/oracle/product/8.1
>7/ctx/lib)
> (PROGRAM xtproc)
> )
> (SID_DESC SID_NAME p_agt2)
> (ORACLE_HOME u01/app/oracle/product/8.1.7)
> (ENVS D_LIBRARY_PATH01/app/oracle/product/8.1
>7/ctx/lib)
> (PROGRAM xtproc)
> )
> (SID_DESC SID_NAME p_agt3)
> (ORACLE_HOME u01/app/oracle/product/8.1.7)
> (ENVS D_LIBRARY_PATH01/app/oracle/product/8.1
>7/ctx/lib)
> (PROGRAM xtproc)
> )
> )
>You can see that the SID_DESC entries layout are slightly different that
>those earlier, is this OK?
>
>Thanks in advance, and sorry in advance if any of the above questions are
>dumb, but I'm a bit stuck on this!
>
>best regards,
>
>Ron
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: MCUK
> INET: ron.perrie_at_mci.co.uk
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

Hemant K Chitale
Now using Eudora Email. Try it !

My home page is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).