Re: Listener consolidation

Stephen-

What kind of errors did you get? Off the top of my head I believe 8i's tnsnames.ora syntax requires you to call your connection data a service_name instead of a sid. Probably some other minor but critical changes to how the config files work. Not sure why tnsping would work and other stuff wouldn't but I don't know what error you got.

Jim

>>> StephenAndert_at_firsthealth.com 03/12/01 06:46PM >>>
Hi all:

Our listeners have evolved over time, whereby when we moved from 8.0 to 8.1, a new listener was created to support this instead of having one listener listening to all databases of different versions. We are trying to consolidate so that we only are running one listener (8.1) and it is listening for 8.1 and 8.0 databases. I also just found out we may need to also include a 7.3 database.

Our initial test today gave us all kinds of problems where when we moved an 8.0.4 database out of the 8.0 listener into the 8.1 listener, it wouldn't allow sqlnet connections. However TNSPING worked just fine.

Does anyone have any hints for doing this?

FWIW, consolidating to a single listener is only the first step. Once we are comfortable that this process is working well, we are going to begin moving all db's that will support it to LDAP.

Help? Thoughts? Guidance? All would be appreciated greatly.

Stephen Andert

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Stephen Andert
  INET: StephenAndert_at_firsthealth.com 

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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jim Conboy
  INET: Jim.Conboy_at_trw.com

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).