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 = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/8.1.7)
(PROGRAM = extproc)
)
(SID_DESC (GLOBAL_DBNAME = RATREP)
(ORACLE_HOME = /u01/app/oracle/product/8.1.7)
(SID_NAME = RATREP)
)
(SID_DESC (GLOBAL_DBNAME = CQPROD01)
(ORACLE_HOME = /u01/app/oracle/product/8.1.7)
(SID_NAME = CQPROD01)
)
(SID_DESC (GLOBAL_DBNAME = CQTEST01)
(ORACLE_HOME = /u01/app/oracle/product/8.1.7)
(SID_NAME = CQTEST01)
)
(SID_DESC = (SID_NAME = ep_agt1)
(ORACLE_HOME = /u01/app/oracle/product/8.1.7)
(ENVS = LD_LIBRARY_PATH=/u01/app/oracle/product/8.1
7/ctx/lib)
(PROGRAM = extproc)
)
(SID_DESC = (SID_NAME = ep_agt2)
(ORACLE_HOME = /u01/app/oracle/product/8.1.7)
(ENVS = LD_LIBRARY_PATH=/u01/app/oracle/product/8.1
7/ctx/lib)
(PROGRAM = extproc)
)
(SID_DESC = (SID_NAME = ep_agt3)
(ORACLE_HOME = /u01/app/oracle/product/8.1.7)
(ENVS = LD_LIBRARY_PATH=/u01/app/oracle/product/8.1
7/ctx/lib)
(PROGRAM = extproc)
)
)
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).
