RE: ORA-12545 client with multiple listener service handlers

Have you set the service_names and instance_name in init.ora ?. If you plan to use the connect_data section of tnsnames.ora with service_name, you need it too in the init.ora. Also this one should match global_dbname setting in the listener.ora or viceversa.

Regards.

> -----Mensaje original-----
> De: Woody Mckay [SMTP:wmckay_at_hydrogenmedia.com]
> Enviado el: jueves 22 de febrero de 2001 17:11
> Para: Multiple recipients of list ORACLE-L
> Asunto: ORA-12545 client with multiple listener service handlers
>
> I've just installed Oracle 8.1.7 on a Win 2K box and multiple 8.1.7
> clients
> on other NT computers. When I try to connect to the database through SQL
> Plus I get an ora-12545 -CONNECT FAILED BECAUSE TARGET HOST OR OBJECT DOES
> NOT EXISTS error.
>
> Host string is DEVL2. The database server listener status shows:
>
> DEVL2 has 1 service handler(s)
> DEVL2 has 3 service handler(s)
>
> If I stop and restart the listener service the status shows:
>
> DEVL2 has 1 service handler(s)
>
> and the client SQL Plus logs in without trouble. After a couple of minutes
> the database auto registers to add - DEVL2 has 3 service handler(s) - to
> the
> listener status display and the SQL Plus client can not log in and
> receives
> the ora-12545.
>
> What is the best way to deal with this? Get rid of the auto registration
> or
> somehow not use part of listener.ora?
>
> Below is a copy of the client tnsnames.ora, server listener.ora, and log
> files.
>
> Thanks for the help.
>
> Woody
> ............
> tnsnames.ora:
> DEVL2.HYDROGENMEDIA.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.5.81)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = DEVL2)
> )
> )
> .........................
> listener.ora:
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.5.81)(PORT = 1521))
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = c:\Oracle\Ora81)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = DEVL2)
> (ORACLE_HOME = c:\Oracle\Ora81)
> (SID_NAME = DEVL2)
> )
> )
>
> TRACE_LEVEL_LISTENER = USER
> ....................
>
> listener.log:
> TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production on 21-FEB-2001
> 11:31:53
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> System parameter file is c:\Oracle\Ora81\network\admin\listener.ora
> Log messages written to c:\Oracle\Ora81\network\log\listener.log
> Trace information written to c:\Oracle\Ora81\network\trace\listener.trc
> Trace level is currently 4
>
> Listening on:
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.5.81)(PORT=1521)))
> Listening on:
> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
> TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
> 21-FEB-2001 11:31:58 *
> (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=wmckay))(COMMAND=status)(ARGUMEN
> TS
> =64)(SERVICE=LISTENER)(VERSION=135294976)) * status * 0
> 21-FEB-2001 11:32:24 *
> (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=wmckay))(COMMAND=status)(ARGUMEN
> TS
> =64)(SERVICE=LISTENER)(VERSION=135294976)) * status * 0
> 21-FEB-2001 11:32:31 * service_register * DEVL2 * 0
> 21-FEB-2001 11:32:35 *
> (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=wmckay))(COMMAND=status)(ARGUMEN
> TS
> =64)(SERVICE=LISTENER)(VERSION=135294976)) * status * 0
> 21-FEB-2001 11:32:58 *
> (CONNECT_DATA=(SERVICE_NAME=DEVL2)(CID=(PROGRAM=C:\oracle\ora81\bin\SQLPLU
> SW
> .EXE)(HOST=PC-WMCKAY2)(USER=wmckay))) *
> (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.1.52)(PORT=2823)) * establish * DEVL2 *
> 0
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Woody Mckay
> INET: wmckay_at_hydrogenmedia.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: Trassens, Christian
  INET: CTrassens_at_uni2.es

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