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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
