ORA-12545 client with multiple listener service handlers

From: Woody Mckay <wmckay_at_hydrogenmedia.com>
Date: Thu, 22 Feb 2001 08:29:48 -0800
Message-ID: <F001.002BAAEA.20010222081106@fatcity.com>

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

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)(ARGUMENTS
=64)(SERVICE=LISTENER)(VERSION=135294976)) * status * 0 21-FEB-2001 11:32:24 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=wmckay))(COMMAND=status)(ARGUMENTS
=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)(ARGUMENTS
=64)(SERVICE=LISTENER)(VERSION=135294976)) * status * 0 21-FEB-2001 11:32:58 *
(CONNECT_DATA=(SERVICE_NAME=DEVL2)(CID=(PROGRAM=C:\oracle\ora81\bin\SQLPLUSW
.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).

Received on Thu Feb 22 2001 - 10:29:48 CST