Hi,
I have two databases ORCL817 and ORCL816 in version
817, 816 on the same machine Sun 5.7. I'd like to
configure seperate listener for each database. I used
different port, listener name (1521 and LISTENER817
for ORCL817 , 1522 and LISTENER816 for ORCL816), but
somehow the listener on 1522 cannot be started.
Why???
Here is the listener.ora and tnsnames.ora for both
database:
listener.ora for 816
=========================
LISTENER816 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
gatech-denver1)(PORT = 1522))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST =
gatech-denver1)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORCL816)
(ORACLE_HOME =
/export/apps/oracle/admin/product/8.1.6)
(SID_NAME = ORCL816)
)
tnsnames.ora for 816
=========================
ORCL816 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
gatech-denver1)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL816)
)
)
listener.ora for 817
=========================
LISTENER817 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
gatech-denver1)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST =
gatech-denver1)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORCL817)
(ORACLE_HOME =
/export/apps/oracle/admin/product/8.1.7)
(SID_NAME = ORCL817)
)
)
tnsnames.ora
=================
ORCL817 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
gatech-denver1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL817)
)
)
Anyone knows what went wrong? Thank you!
Janet
__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janet Linsy
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).
