SqlPlus connection error ORA-12545

My client SqlPlus uses TNSNAMES to connect to the Ora817 db. One name is ORCL configured as dedicated connection and the other is NETORCL configured as shared connection. The other connection information is the same (ip, port, sid, etc).

However, the dedicated connection works fine, and the shared connection gives error ORA-12545, "Connection failed, Target host or object doesn't exist". Both connections used to work fine. The only thing I can think of is the network DNS server change. But why does the dedicated connectin work and the shared conn not? What configuration parameter affects the difference?

Here is an excerpt from Oracle Documentation:

Quote:

---

ORA-12545: TNS:name lookup failure
Cause: The listener on the remote node cannot be contacted.

Actions:

Verify that the ADDRESS in the tnsnames.ora file and the listener.ora file is correct.

Verify that the listener on the remote node has been started. Enter:

lsnrctl

lsnrctl> status listener_name

listener_name is the name of the listener defined in the listener.ora file. It is not necessary to identify the listener if you are using the default listener, named LISTENER.

If the output indicates the listener is not running, try starting it with the command:

lsnrctl> start listener_name

---

I think your listener is tuned for the dedicated connection only.

I thing you may have simple network problem:
- cable, ip addres ...

1. check ping;
- ping YOUR_HOST
- ping YOUR_IP_ADDRESS

2. check firewalls between client mashine and DB server.
- traceroute ...

3. check tnsping YOUR_TNS_ENTRY
- tnsping YOUR_TNS_ENTRY

Checked listener status. It's fine.

Pinged host and tnsnames. Fine.

Keep in mind that the dedicated connection works.

How do I tune it for shared connection?

I don't know if this has anything to do with it. The SNMP service used to be running, but for security reasons, has been disabled. Thanks.

The SNMP service in this case not needed. SNMP uses only by Oracle Intellegent agent.

Are you configured shared server (MTS_DISPATCHER) in init.ora.
If you can - post tnsnames.ora, listener.ora, and init.ora files.

For security reasons, I am only posting selected information with fititious IP here.

Note that it used to work, and ORCL still works.

INIT.ORA

db_name = "orcl"
db_domain = nt3
instance_name = orcl
service_names = orcl.nt3

remote_login_passwordfile = exclusive
os_authent_prefix = ""

JOB_QUEUE_PROCESSES = 4
job_queue_interval = 60
open_links = 4

mts_dispatchers = "(protocol=TCP)"
mts_servers = 1
mts_max_servers = 10
compatible = 8.1.6.1.0

LISTENER.ORA

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.111.11)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC4))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\orant)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl.nt3)
(ORACLE_HOME = d:\oracle\orant)
(SID_NAME = orcl)
)
)

TNSNAMES.ORA

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nt3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = orcl.nt3)
(PRESENTATION = http://admin)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC4))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.111.11)(PORT = 1521))
)
(CONNECT_DATA =
(SRVR = DEDICATED)
(SERVICE_NAME = orcl.NT3)
)
)

NETORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.111.11)(PORT = 1521))
)
(CONNECT_DATA =
(SRVR = SHARED)
(SERVICE_NAME = orcl.NT3)
)
)

Try to change:

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.111.11)(PORT = 1521))
)
(CONNECT_DATA =
(SRVR = DEDICATED)
(SERVICE_NAME = orcl.NT3)
)
)

NETORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.111.11)(PORT = 1521))
)
(CONNECT_DATA =
(SRVR = SHARED)
(SID = orcl)
)
)

Remover the option of


SRVR=SHARED entry from your tnsnames.ora file and try again.
IF the database had been configured under shared server mode, then by default the connections would go for the shared server. If you want the dedicated option, then you would configure the SRVR to dedicated mode....

Let me know how it all goes...
Sam

No luck.

O.k lets first see whether your listener had registered any dispatchers....


do

lsnrctl services


Do you see the word DISPATCHER corresponding to the instance?

Sam

Could you provide me the OS and DB version of your server and the clients... Is your DB us SE/EE?

Code:

---

mts_dispatchers = "(protocol=TCP)(DISPATCHERS=2)"
mts_servers = 5
mts_max_servers = 10
mts_max_dispatchers = 10

---

Sam

[Edited by sambavan on 10-30-2001 at 03:55 PM]

Here is the result. I noticed the dispatcher host is NT3.MYCOMPANY.NET instead of just NT3. I think it is caused by the recent DNS configuration of the machine into the MYCOMPANY.NET domain, while before it was empty.

C:\>lsnrctl services

LSNRCTL for 32-bit Windows: Version 8.1.7.2.0 - Production on 30-OCT-2001 15:56:
44

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=111.111.111.11)(PORT=1521)))
Services Summary...
PLSExtProc has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
orcl has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
orcl has 2 service handler(s)
DEDICATED SERVER established:1 refused:0
LOCAL SERVER
DISPATCHER established:5 refused:0 current:0 max:1022 state:ready
D000
(ADDRESS=(PROTOCOL=tcp)(HOST=nt3.MYCOMPANY.NET)(PORT=1664))
The command completed successfully

What do you get when you do

Code:

---



select * from global_name;

---

This should be the service name in your tnsnames.ora file.

Could you check that please...

Sam

also please post your sqlnet.ora file specs


Sam

OS is NT4.0 Sp6; DB is Oracle8.1.7.2.1.

The global name was orcl.world. But after changed to orcl.nt3, the result is the same. The global_name does not affect the connection (as by definition, it affects dblinks), since the tnsname is using service_name defined as orcl.nt3.

SQLNET.ORA

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)

It just seems that the dispatcher constructed the host name from the DNS setup. How can I force it to be nt3 instead of nt3.mycompany.net?

*********
DISPATCHER established:5 refused:0 current:0 max:1022 state:ready
D000
(ADDRESS=(PROTOCOL=tcp)(HOST=nt3.MYCOMPANY.NET)(PORT=1664))
************

Now, could you comment out the

SQLNET.AUTHENTICATION_SERVICES= (NTS)

in your sqlnet.ora file and try the connection again.

On the other hand you can set the

local_listener = "(Address=(PROTOCOL=TCP)(HOST=...)(PORT=1521))"

in your initSID.ora file and restart the instance and then check that the dispatcher registers the correct server. Also make sure that things are configured as you want in the listener.ora file too...

Sam

Still no luck. I am going to contact Oracle support.

Did you configure your host name to the dispatcher host name and try?

Sam

Yes. Same result.

Ann,

I couldn't think of any thing more other than this

Quote:

---

MTS_DISPATCHERS = "(ADDRESS= (PROTOCOL=TCP)(HOST=chmweckerl1) ) (DISPATCHERS=4)"

Stop and start the instance

check listener services and try your connection again...

---

Extract from metalink

Quote:

---

You can fix the problem by adding the Oracle listener host name and IP to the
hosts file on the Microsoft client machine.

The file is located in the following directory:

C:\WINNT\system32\drivers\etc

The filename is "hosts"

Edit the file to include the IP address and the host name of the Oracle server
to which you wish to connect, thus:

126.34.10.244 hostname.domainname.com hostname othernames


Be careful not to add any extention to the file when saving it.

This is a workaround in the absence of a domain names server (DNS). The best
thing is to have DNS up and running and the client configured to use it.

---

Sam

Tried both, same result.

Are you have any firewalls with open 1521 port and close another?

Looks to me the problem is in the hostname identification...

First of all can you do

ping host_name
or
telnet host_name


Then try


tnsping host_name
tnsping service_name

Please also provide the results. "The one word answers doesn't help us". Give us the result output as it is....

Sam

It was actually a simple fix from Oracle support. In init.ora file, set the hostname with IP address instead of machine name for the local_listener and mts_dispatcher resolved the problem.

Thanks for all the effort. This is one of those occasions Oracle support had a quick and effective response. Closing this thread.