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)(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: [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).
