Home » RDBMS Server » Networking and Gateways » ORA-12541 and ORA 12560 (Oracle DB 11.1.0.6.0, Windows 2003, VMware)
ORA-12541 and ORA 12560 [message #507156] Thu, 12 May 2011 14:37 Go to next message
Kamal22
Messages: 11
Registered: May 2011
Location: Chicago
Junior Member
Hi everyone,

I have read so many resolutions on this topic, but I am still unable to resolve mine....very reluctantly I am posting in the hope that someone will HELP me!

I have a Server (Dell), and installed Windows 2003, R2 SP2.

Also, I installed VM Workstation 7, and configured two VM machines

1. On one of the machine, VMAdminHypdb, I installed Oracle database 11g
2. On the other machine, hypappad-4eadec, I installed Oracle client 11.

I also configured a Microsoft loop-back adapter for the Oracle Database, with static address, for Local Area Connection 2.

Overall, I am able to log into the Database from "Vmadminhypdb" machine, with System user_name. Everything works fine.

But, I am not able to connect to the database from the "Hypappad-4eadec" machine. Error code keep toggling between "Protocol Adapter Error" and "No Listener"

I am able to ping the Database server from the client successfully...but get the errors above when I do a tnsping


The Server machine settings are:

tnsnames.ora file ...


ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vmadminhypdb.localhost.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

listener.ora file ...

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = vmadminhypdb.localhost.com)(PORT = 1521))
)
)

sqlnet.ora file ...

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

I appreciate anyone's time to help!

Thanks.
Re: ORA-12541 and ORA 12560 [message #507157 is a reply to message #507156] Thu, 12 May 2011 14:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Since Networking is involved, the basic assumption is that two distinct systems are involved.

For System1 post hostname, IP#, Operating System name & version & Oracle s/w version to 4 decimal places.
For System2 post hostname, IP#, Operating System name & version & Oracle s/w version to 4 decimal places.
Clarify which hostname is associated with DataBase (DB) Server system & which hostname with SQL Client.

From DB Server post content of listener.ora & sqlnet.ora (if either exist)
From DB Server post results from following commands
lsnrtcl status
lsnrctl service
sqlplus scott/tiger

From SQL Client post content of tnsnames.ora & sqlnet.ora (if either exist)
From SQL Client post results from following commands
tnsping <DB_alias>
ping <DBhostname>
sqlplus scott/tiger@<DB_alias>

12541, 00000, "TNS:no listener"
// *Cause: The connection request could not be completed because the listener
// is not running.
// *Action: Ensure that the supplied destination address matches one of
// the addresses used by the listener - compare the TNSNAMES.ORA entry with
// the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to
// go by way of an Interchange). Start the listener on the remote machine.
This error can result when listener has not been started or Firewall exists between client & DB server.

ORA-12560 occurs much more often on Window OS than other OS.
Most common cause is when 1 or more OS Services for either Listener or DB have not been started.

[Updated on: Thu, 12 May 2011 15:14]

Report message to a moderator

Re: ORA-12541 and ORA 12560 [message #507165 is a reply to message #507157] Thu, 12 May 2011 15:49 Go to previous messageGo to next message
Kamal22
Messages: 11
Registered: May 2011
Location: Chicago
Junior Member
Thanks Blackswan... here are the information:

System1 (Database Server)
Hostname: Vmhypadmin
IP: 192.168.86.128
OS: Windows 2003 R2 SP 2
Oracle Database: 11.1.0.6.0

System2 (SQL Client Machine)
Hostname: Hypappad-4eadec
IP: 192.168.86.129
OS: Windows 2003 R2 SP 2
Oracle Client: 11.1.0

DB Server - listener.ora

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = vmadminhypdb.localhost.com)(PORT = 1521))
)
)

DB Server - sqlnet.ora

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


From DB Server lsnrtcl status, lsnrctl service, sqlplus scott/tiger

C:\Documents and Settings\Administrator>lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 12-MAY-2011 15:11
:50

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.1.0.6.0 - Produ
ction
Start Date 12-MAY-2011 13:29:42
Uptime 0 days 1 hr. 42 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\Administrator\product\11.1.0\db_1\network\admin
\listener.ora
Listener Log File c:\app\administrator\diag\tnslsnr\vmadminhypdb\listene
r\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vmadminhypdb.localhost.com)(PORT=152
1)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully



C:\Documents and Settings\Administrator>lsnrctl service

LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 12-MAY-2011 15:16
:22

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:48 refused:0 state:ready
LOCAL SERVER
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: VMADMINHYPDB, pid: 604>
(ADDRESS=(PROTOCOL=tcp)(HOST=vmadminhypdb.localhost.com)(PORT=2079))
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:48 refused:0 state:ready
LOCAL SERVER
The command completed successfully


C:\Documents and Settings\Administrator>sqlplus scott/tiger@orcl

SQL*Plus: Release 11.1.0.6.0 - Production on Thu May 12 15:18:43 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL Client tnsnames.ora

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vmadminhypdb.localhost.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)


SQL Client sqlnet.ora

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


SQL Client tnsping <DB_alias>, ping <DBhostname>, sqlplus scott/tiger@<DB_alias>


Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\Administrator>tnsping orcl

TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 12-MAY-2
011 15:24:45

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:
C:\app\Administrator\product\11.1.0\client_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = vmadminh
ypdb.localhost.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_
NAME = orcl)))
TNS-12535: TNS:operation timed out

C:\Documents and Settings\Administrator>ping vmadminhypdb

Pinging vmadminhypdb [192.168.86.128] with 32 bytes of data:

Reply from 192.168.86.128: bytes=32 time=2ms TTL=128
Reply from 192.168.86.128: bytes=32 time<1ms TTL=128
Reply from 192.168.86.128: bytes=32 time<1ms TTL=128
Reply from 192.168.86.128: bytes=32 time<1ms TTL=128

Ping statistics for 192.168.86.128:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 2ms, Average = 0ms

C:\Documents and Settings\Administrator>sqlplus scott/tiger@orcl

SQL*Plus: Release 11.1.0.6.0 - Production on Thu May 12 15:26:32 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

ERROR:
ORA-12541: TNS:no listener


Enter user-name:scott
Enter password:tiger
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:scott
Enter password:tiger
ERROR:
ORA-12560: TNS:protocol adapter error


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

C:\Documents and Settings\Administrator>

Again, many thanks... K
Re: ORA-12541 and ORA 12560 [message #507167 is a reply to message #507165] Thu, 12 May 2011 17:16 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
DB Server is all OK!

>Hostname: Vmhypadmin
>(HOST = vmadminhypdb.localhost.com)
OK, which is correct?

I suspect FireWall between client & DB Server
Re: ORA-12541 and ORA 12560 [message #507168 is a reply to message #507167] Thu, 12 May 2011 18:08 Go to previous messageGo to next message
Kamal22
Messages: 11
Registered: May 2011
Location: Chicago
Junior Member
The host name is VmAdminHypdb.

Also, I turned off the firewall btw on the machines, both Server and Client, before running the connectivity.

What should I look for to resolve?

Re: ORA-12541 and ORA 12560 [message #507169 is a reply to message #507168] Thu, 12 May 2011 18:16 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
*SOMETHING* is preventing client from communicating with Listener.
Oracle is victim; not culprit.
The fact that both "systems" are virtual adds another layer for mis-configuration to exist.
I don't have any additional ideas what might be wrong.
Re: ORA-12541 and ORA 12560 [message #507180 is a reply to message #507169] Thu, 12 May 2011 22:53 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I don't know if this can be done in your virtual world.
My advice to folks in the real world would be to run WireShark or similar packet sniffer to determine where the disconnect existed.
Packets originate with client s/w (sqlplus, tnsping, etc) & packet exchange fails due to some unknown mystery.
The failure could be within client system, network problem between the 2 systems, or coming into DB Server.
Without knowing where root cause exists, the odds to fix it are slim and none.
Re: ORA-12541 and ORA 12560 [message #507183 is a reply to message #507180] Thu, 12 May 2011 23:58 Go to previous messageGo to next message
Kamal22
Messages: 11
Registered: May 2011
Location: Chicago
Junior Member
Hi Blackswan,

I ran a trace on tnsping from the client to the Database...it returned a timeout error.

Below is the trace result... are you able to determine what could be the problem..


TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 12-MAY-2011 23:38:50

Copyright (c) 1997, 2007, Oracle. All rights reserved.

--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is c:\trace\trace\tnsping.trc
New trace level is 6
--- TRACE CONFIGURATION INFORMATION ENDS ---
--- PARAMETER SOURCE INFORMATION FOLLOWS ---
Attempted load of system pfile source C:\app\Administrator\product\11.1.0\client_1\network\admin\sqlnet.ora
Parameter source loaded successfully

-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
trace_fileno_client = 2
trace_filelen_client = 100
trace_level_client = 16
log_file_client = cli
log_directory_client = c:\trace\log
tnsping.trace_level = admin
NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)
tnsping.trace_directory = c:\trace\trace
trace_directory_client = c:\trace
SQLNET.AUTHENTICATION_SERVICES = (NTS)
trace_timestamp_client = on
trace_file_client = cli
trace_unique_client = on
--- PARAMETER SOURCE INFORMATION ENDS ---
--- LOG CONFIGURATION INFORMATION FOLLOWS ---
Log stream will be "standard output"
Log stream validation not requested
--- LOG CONFIGURATION INFORMATION ENDS ---

nlstdipi: entry
nlstdipi: exit
nnfun2awanm: entry
nnfgiinit: entry
nncpcin_maybe_init: first request sent to name server will have ID 0
nncpcin_maybe_init: initial retry timeout for all name servers is 1500 csecs
nncpcin_maybe_init: max request retries per name server is 1
nngsini_init_streams: initializing stream subsystem, cache size is 10
nngtini_init_msg: initializing PDU subsystem, initial pool size is 2
nncpcin_maybe_init: default name server domain is [root]
nnfgiinit: Installing read path
nnfgsrsp: entry
nnfgsrsp: Obtaining path parameter from names.directory_path or native_names.directory_path
nnfgsrdp: entry
nnfgsrdp: Setting path:
nnfgsrdp: checking element TNSNAMES
nnfgsrdp: checking element EZCONNECT
nnfgsrdp: Path set
nnfun2a: entry
nlolgobj: entry
nnfgrne: entry
nnfgrne: Going though read path adapters
nnfgrne: Switching to TNSNAMES adapter
nnftboot: entry
nlpaxini: entry
nlpaxini: exit
nnftmlf_make_local_addrfile: entry
nnftmlf_make_local_addrfile: construction of local names file failed
nnftmlf_make_local_addrfile: exit
nlpaxini: entry
nlpaxini: exit
nnftmlf_make_system_addrfile: entry
nnftmlf_make_system_addrfile: system names file is C:\app\Administrator\product\11.1.0\client_1\network\admin\tnsnames.ora
nnftmlf_make_system_addrfile: exit
nnftboot: exit
nnftrne: entry
nnftrne: Original name: orcl.vmadminhypdb.localhost.com
nnfttran: entry
nnfgrne: Query unsuccessful, skipping to next adapter
nnfgrne: Switching to EZCONNECT adapter
nnfhboot: entry
nnfhboot: exit
snlinGetAddrInfo: entry
snlinGetAddrInfo: exit
snlinGetNameInfo: entry
snlinGetNameInfo: exit
snlinFreeAddrInfo: entry
snlinFreeAddrInfo: exit
nnfhrne: Using hostname address (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=64.99.64.32)(PORT=1521))) for name orcl.vmadminhypdb.localhost.com
nnfgrne: exit
nlolgserv: entry
nnfggav: entry
nnfhgav: exit
nnfgfrm: entry
nnfhfrm: exit
nnfgfrm: exit
nlolgserv: exit
nlolgobj: exit
nlolfmem: entry
nlolfmem: exit
nnfun2awanm: Getting the path of sqlnet.ora
nnfun2awanm: Getting the adapter name
nnfun2awanm: exit
nsmal: 212 bytes at 0x1f7fae8
nscall: connecting...
nladini: entry
nladini: exit
nladget: entry
nladget: exit
nsc2addr: (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=64.99.64.32)(PORT=1521)))
nttbnd2addr: entry
snlinGetAddrInfo: entry
snlinGetAddrInfo: exit
nttbnd2addr: using host IP address: 64.99.64.32
snlinFreeAddrInfo: entry
snlinFreeAddrInfo: exit
nttbnd2addr: exit
nsmal: 996 bytes at 0x1fca908
nsmal: 2096 bytes at 0x1fcacf8
nsmal: 84 bytes at 0x1fcb668
nsopen: opening transport...
nttcon: entry
nttcon: toc = 1
nttcnp: entry
nttcnp: exit
nttcni: entry
nttcni: Tcp conn timeout = 0 (ms)
nttcni: trying to connect to socket 1712.
ntt2err: entry
ntt2err: soc 1712 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0
ntt2err: exit
nttcni: exit
nttcon: exit
nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[0]=505, nt[1]=60, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nsopen: unable to open transport
nsvntx_dei: entry
nsvntx_dei: exit
nsmfr: 2096 bytes at 0x1fcacf8
nsmfr: 996 bytes at 0x1fca908
nscall: connecting...
nladget: entry
nladget: exit
nsmfr: 212 bytes at 0x1f7fae8
nladtrm: entry
nladtrm: exit
nlse_term_audit: entry
nlse_term_audit: exit

Re: ORA-12541 and ORA 12560 [message #507185 is a reply to message #507183] Fri, 13 May 2011 00:02 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>nnfhrne: Using hostname address (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=64.99.64.32)(PORT=1521)))
IP# is not as expected nor desired.
Re: ORA-12541 and ORA 12560 [message #507287 is a reply to message #507185] Fri, 13 May 2011 08:06 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
>Hostname: Vmhypadmin
>(HOST = vmadminhypdb.localhost.com)
OK, which is correct?

I think this is your problem. The fqdn vmadminhypdb.localhost.com doesn't resolve on your client.
Re: ORA-12541 and ORA 12560 [message #507292 is a reply to message #507185] Fri, 13 May 2011 08:36 Go to previous messageGo to next message
Kamal22
Messages: 11
Registered: May 2011
Location: Chicago
Junior Member
Thanks Blackswan..

I observed that too but do not know why and what the IP address "64.99.64.32" came about... This may be the major issue for me to get the desired result... I continue to work on this and hopefully get this problem resolved...

I sure can use any help/suggestion..

Re: ORA-12541 and ORA 12560 [message #507293 is a reply to message #507287] Fri, 13 May 2011 08:37 Go to previous messageGo to next message
Kamal22
Messages: 11
Registered: May 2011
Location: Chicago
Junior Member
Hi John,

That was a typo error when I was posting the case...the host name was not written correctly, in the post.. Please see my response to Blackswan.

K
Re: ORA-12541 and ORA 12560 [message #507294 is a reply to message #507292] Fri, 13 May 2011 08:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I sure can use any help/suggestion..
solution involves hostname to IP number resolution.
One possible work around is to modify tnsnames.ora on client to contain IP# of DB Server;
but this fights only the symptom not root cause.
Re: ORA-12541 and ORA 12560 [message #507295 is a reply to message #507292] Fri, 13 May 2011 08:40 Go to previous messageGo to next message
Kamal22
Messages: 11
Registered: May 2011
Location: Chicago
Junior Member
Hey Blackswan...I should also mention that the ping result of the IP address "64.99.64.32" was unsuccessful (timed out) on the SQL client machine (VM).

However, it replied on the Server machine (VM) as well as on the host (physical) machine....

Re: ORA-12541 and ORA 12560 [message #507296 is a reply to message #507295] Fri, 13 May 2011 08:42 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Hey Blackswan...I should also mention that the ping result of the IP address "64.99.64.32"
Any idea what system is associated with this IP#?
Re: ORA-12541 and ORA 12560 [message #507298 is a reply to message #507296] Fri, 13 May 2011 08:53 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Look, you have put this hostname in your client tnsnames.ora file:

HOST = vmadminhypdb.localhost.com

but what you pinged successfully was this:

ping vmadminhypdb

That's your problem.
Re: ORA-12541 and ORA 12560 [message #507300 is a reply to message #507298] Fri, 13 May 2011 09:02 Go to previous messageGo to next message
Kamal22
Messages: 11
Registered: May 2011
Location: Chicago
Junior Member
Thanks John.

Vmadminhypdb is the host (VM 1) machine name.
Vmadminhypdb.localhost.com (VM 1, also) is the full machine name, including the domain name.

I successfully pinged both names from the client machine (VM 2).

When I log into the Database on VM1, (Database Server), the full host name is shown as "Vmadminhypdb.localhost.com"

However, please let me know if I still do not get your point...appreciate your help!

K
Re: ORA-12541 and ORA 12560 [message #507301 is a reply to message #507300] Fri, 13 May 2011 09:05 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
just for drill, post content of "hosts" file from SQL Client system
Re: ORA-12541 and ORA 12560 [message #507305 is a reply to message #507301] Fri, 13 May 2011 09:21 Go to previous messageGo to next message
Kamal22
Messages: 11
Registered: May 2011
Location: Chicago
Junior Member
here Blackswan..


Database server (VM 1 - Vmadminhypdb)

127.0.0.1 localhost
10.10.10.10 vmadminhypdb.localhost.com vmadminhypdb

Connectivity set-up:

Local Area connection - TCP/IP - Obtain automatically
Local Area connection 2- TCP/IP Static - 10.10.10.10 (Microsoft adapter for loop-back)


Client Server (VM1 - hypappad-4eadec.)

127.0.0.1 localhost

Connectivity set-up:

Local Area connection - TCP/IP - Obtain automatically


Physical Machine (svctag-bfr0fq1.Kamal.local)

127.0.0.1 localhost

I appreciate your time...
Re: ORA-12541 and ORA 12560 [message #507306 is a reply to message #507305] Fri, 13 May 2011 09:25 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>System1 (Database Server)
>Hostname: Vmhypadmin
>IP: 192.168.86.128
>OS: Windows 2003 R2 SP 2
>Oracle Database: 11.1.0.6.0
>
>System2 (SQL Client Machine)
>Hostname: Hypappad-4eadec
>IP: 192.168.86.129
>OS: Windows 2003 R2 SP 2
>Oracle Client: 11.1.0

if above is true the why have below?
>10.10.10.10 vmadminhypdb.localhost.com vmadminhypdb
Re: ORA-12541 and ORA 12560 [message #507309 is a reply to message #507306] Fri, 13 May 2011 09:41 Go to previous messageGo to next message
Kamal22
Messages: 11
Registered: May 2011
Location: Chicago
Junior Member
10.10.10.10 vmadminhypdb.localhost.com vmadminhypdb

This line is required for the Microsoft adapter loopback settings from the Oracle documentation below:

"Add a line to the SYSTEM_DRIVE:\WINNT\system32\drivers\etc\hosts file with the following format, right after the localhost line:

IP_address hostname.domainname hostname"

Re: ORA-12541 and ORA 12560 [message #507324 is a reply to message #507294] Fri, 13 May 2011 11:07 Go to previous messageGo to next message
Kamal22
Messages: 11
Registered: May 2011
Location: Chicago
Junior Member
Blackswan...

The suggestion below worked for the connection, but like you said, I need to resolve the root cause for the IP number/name resolution between the two machines..

solution involves hostname to IP number resolution.
One possible work around is to modify tnsnames.ora on client to contain IP# of DB Server;
but this fights only the symptom not root cause.


But many thanks for your help (and John's) so far... I am still hopeful of a through resolution....will surely appreciate any other suggestion(s)
Re: ORA-12541 and ORA 12560 [message #507325 is a reply to message #507324] Fri, 13 May 2011 11:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
While I am marginally Windows conversant, I am a hard core *nix aficionado.
I simply don't know how to "trace" hostname translation on Windows.
I don't know Windows internals to know how or where the translation occurs.

what system is associated with 64.99.64.32?
SQL*Net did NOT automagically generate the IP# above.
It asked Windows what IP# was associated with hostname & this was the answer.
Now how & why was 64.99.64.32 provided as the translation?

[Updated on: Fri, 13 May 2011 11:36]

Report message to a moderator

Re: ORA-12541 and ORA 12560 [message #507328 is a reply to message #507325] Fri, 13 May 2011 11:41 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
One more try.
It is all in the name resolution, which is a mess. Your listener is listening on vmadminhypdb.localhost.com, which on the server resolves to 10.10.10.10. This is in your server side hosts file, and your listener.ora file.
Your client tnsnames file specifies vmadminhypdb.localhost.com, which (according to the results of your ping) your client resolves to 192.168.86.128.
So that's the problem: your client is going to an address where nothing is listening. Either you need to add 192.168.86.128 as a listening address in listener.ora file, or you need to adjust your client tnsnames.ora file to go to 10.10.10.10.

I've no idea where those addresses come from, or if there is in fact any possibility of communication between the machines. I've never worked with vmware (and, from what I've read of it on this forum, I never intend to).

Over to you.
Previous Topic: ora-12514
Next Topic: Listener configured at Non-Default Port
Goto Forum:
  


Current Time: Thu Mar 28 12:07:15 CDT 2024