Re: TNS-12500

From: Suzy Vordos <lvordos_at_qwest.com>
Date: Tue, 06 Aug 2002 07:53:27 -0800
Message-ID: <F001.004AC266.20020806075327@fatcity.com>

IIRC, the SID_LIST in listener.ora is only needed for the 8.0.5 database(s). The 8i databases don't need to be included. Then, the 8.1.6 init.ora's need to have local_listener=sid set. Here an example configuration I used with the 8.1.7 listener for both 8.0.6/8.1.7 databases:

LSNR01 =
  (ADDRESS_LIST =

      (ADDRESS= (PROTOCOL= IPC)(KEY=LSNR01))
      (ADDRESS= (PROTOCOL= TCP)(Host=host.domain)(Port= 1521))

  )
SID_LIST_LSNR01 =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = mnet03aX)
      (ORACLE_HOME=/dbms/ora00/app/oracle/product/8.0.6) 

    )
  )
STARTUP_WAIT_TIME_LSNR01 = 0
CONNECT_TIMEOUT_LSNR01 = 10
TRACE_LEVEL_LSNR01 = OFF LSNR02 =
  (ADDRESS_LIST =

      (ADDRESS= (PROTOCOL= IPC)(KEY=LSNR02))
      (ADDRESS= (PROTOCOL= TCP)(Host=host.domain)(Port= 1526))

  )
SID_LIST_LSNR02 =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = mnet03aX)
      (ORACLE_HOME=/dbms/ora00/app/oracle/product/8.0.6) 

    )
  )
STARTUP_WAIT_TIME_LSNR02 = 0
CONNECT_TIMEOUT_LSNR02 = 10
TRACE_LEVEL_LSNR02 = OFF Rick_Cale_at_teamhealth.com wrote:
>
> Hi DBAs,
>
> I have 8.0.5 and 8.1.6 oracle server installed on Win 2000 server.
> Currently the 8.0 listener is being used.
> When I add a new entry to a database that resides in 8.1.6 then restart
> listener I get TNS-12500.
> I have to shutdown all the databases and restart databases and listener
> before it will work without new entry.
> I have processes=300 in init.ora files and there is plenty of RAM and disk
> space. Also I would like to use the 8.1.6 listener
> but none of the databases will start under any conditions. There must be
> some settings that tell each instance what listener to
> use is all I can determine. If this is the case how can I configure for all
> instances to use the 8.1.6 listener.
>
> Thanks
> Rick
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Rick_Cale_at_teamhealth.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: Suzy Vordos
  INET: lvordos_at_qwest.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).

Received on Tue Aug 06 2002 - 10:53:27 CDT