Home » RDBMS Server » Networking and Gateways » Can't Connect to Remote DB Listener (11g windows 2008 64-bit)
Can't Connect to Remote DB Listener [message #463717] Fri, 02 July 2010 13:46 Go to next message
THADC
Messages: 17
Registered: July 2010
Junior Member
Hello, I have a database up and running (including listener) on machine A. From that machine, everything seems fine. However, when I try to connect to it from another machine (say, machine B) on the network, the connection cannot be established (exact message: connection to database failed: The Network adapter cannot establish the connection).

I can successfully ping machine A from machine B. The machine A db is a default install (ORCL).

Is it possible the DB listener is not configured properly to connect to remote clients? On machine B, I have oracle tools such as SQLPLUS, Oracle Net Manager, and Net Configuration Assistant.

Any help diagnosing and fixing is greatly appreciated. Thanks!
Re: Can't Connect to Remote DB Listener [message #463718 is a reply to message #463717] Fri, 02 July 2010 13:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You need a listener (that is registered to a specif SID) up and running in Server A.
In server B, you need a tnsentry(tnsnames.ora file) or use JDBC/ODBC options to talk to the server A.
Post your configuration files.
Post how you are trying to connect.
Please copy and paste.
Re: Can't Connect to Remote DB Listener [message #463719 is a reply to message #463717] Fri, 02 July 2010 13:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

use COPY & PASTE so we can see what you do & exactly how Oracle responds

what is Operating System name & version of DB server?
Post results of
SELECT * from v$version
Re: Can't Connect to Remote DB Listener [message #463721 is a reply to message #463719] Fri, 02 July 2010 14:52 Go to previous messageGo to next message
THADC
Messages: 17
Registered: July 2010
Junior Member
Sorry for not following procedure. When I run "SELECT * from v$version" it returns "2". The OS is windows 2008 64-bit, and as I said, the DB is 11g.

Below are the contents of tnsnames.ora and listener.ora. For more background, on machine B, I was installing a product called WebSphere Lombardi Edition 7.1. As part of the install, it requires 2 Database connections (see attachment for screenshot). The "test connection" is where the failure occurs. NOTE: When i do this same "test connection" against an established database (that I am not allowed to use for my purposes), it connects fine. This is why I assume that is a connectivity issue with DB on machine A. Did I give you all that you asked for. Your help is greatly appreciated. Thanks!

# tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_WRHOUSE =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


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

WRHOUSE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = wrhouse.tysons.integratedsecure.com)
)
)


Here is listener.ora contents:


# listener.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_2\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_2)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_2\bin\oraclr11.dll")
)
)

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

ADR_BASE_LISTENER = C:\app\Administrator
Re: Can't Connect to Remote DB Listener [message #463722 is a reply to message #463721] Fri, 02 July 2010 14:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
When I run "SELECT * from v$version" it returns "2".

Not an Oracle answer.
Use SQL*Plus and copy and paste your session.

Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel
Re: Can't Connect to Remote DB Listener [message #463723 is a reply to message #463721] Fri, 02 July 2010 14:58 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
Above means DB Server can only talk to itself
We'll fix this by doing more below

On DB Server system open a command window & COPY the lines below

SET
lsnrctl stop
rename $ORACLE_HOME\network\admin\listener.ora $ORACLE_HOME\network\admin\listener.bck
lsnrctl start
lsnrctl status
lsnrctl service
DIR /Q $ORACLE_HOME\dbs

PASTE commands above into command window
COPY commands & results, then PASTE all back here
Re: Can't Connect to Remote DB Listener [message #463724 is a reply to message #463722] Fri, 02 July 2010 15:00 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>When I run "SELECT * from v$version" it returns "2".

in sqlplus SQL needs to be terminated by semicolon as below

SELECT * from v$version;
Re: Can't Connect to Remote DB Listener [message #463725 is a reply to message #463719] Fri, 02 July 2010 15:09 Go to previous messageGo to next message
THADC
Messages: 17
Registered: July 2010
Junior Member
Hope this is better:

 C:\Users\Administrator>SET
ALLUSERSPROFILE=C:\ProgramData
APPDATA=C:\Users\Administrator\AppData\Roaming
CommonProgramFiles=C:\Program Files\Common Files
CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files
COMPUTERNAME=WIN-7WSDUFVVLKX
ComSpec=C:\Windows\system32\cmd.exe
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Users\Administrator
LOCALAPPDATA=C:\Users\Administrator\AppData\Local
LOGONSERVER=\\WIN-7WSDUFVVLKX
NUMBER_OF_PROCESSORS=1
OS=Windows_NT
Path=C:\app\Administrator\product\11.2.0\dbhome_2\bin;C:\Windows\system32;C:\Win
dows;C:\Windows\System32\Wbem
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE=AMD64
PROCESSOR_IDENTIFIER=AMD64 Family 16 Model 4 Stepping 2, AuthenticAMD
PROCESSOR_LEVEL=16
PROCESSOR_REVISION=0402
ProgramData=C:\ProgramData
ProgramFiles=C:\Program Files
ProgramFiles(x86)=C:\Program Files (x86)
PROMPT=$P$G
PUBLIC=C:\Users\Public
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\Windows
TEMP=C:\Users\ADMINI~1\AppData\Local\Temp
TMP=C:\Users\ADMINI~1\AppData\Local\Temp
USERDOMAIN=WIN-7WSDUFVVLKX
USERNAME=Administrator
USERPROFILE=C:\Users\Administrator
windir=C:\Windows

C:\Users\Administrator>lsnrctl stop

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 02-JUL-2010 16:03
:16

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully

C:\Users\Administrator>rename $ORACLE_HOME\network\admin\listener.ora $ORACLE_HO
ME\network\admin\listener.bck
The system cannot find the path specified.

C:\Users\Administrator>lsnrctl start

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 02-JUL-2010 16:03
:18

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

Starting tnslsnr: please wait...

TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
System parameter file is C:\app\Administrator\product\11.2.0\dbhome_2\network\ad
min\listener.ora
Log messages written to c:\app\administrator\diag\tnslsnr\WIN-7WSDUFVVLKX\listen
er\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521
ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date                02-JUL-2010 16:03:22
Uptime                    0 days 0 hr. 0 min. 3 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\app\Administrator\product\11.2.0\dbhome_2\network\a
dmin\listener.ora
Listener Log File         c:\app\administrator\diag\tnslsnr\WIN-7WSDUFVVLKX\list
ener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

C:\Users\Administrator>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 02-JUL-2010 16:03
:23

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date                02-JUL-2010 16:03:22
Uptime                    0 days 0 hr. 0 min. 3 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\app\Administrator\product\11.2.0\dbhome_2\network\a
dmin\listener.ora
Listener Log File         c:\app\administrator\diag\tnslsnr\WIN-7WSDUFVVLKX\list
ener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

C:\Users\Administrator>lsnrctl service

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 02-JUL-2010 16:03
:23

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
The command completed successfully

C:\Users\Administrator>DIR /Q $ORACLE_HOME\dbs
The system cannot find the file specified.

C:\Users\Administrator>




Re: Can't Connect to Remote DB Listener [message #463726 is a reply to message #463725] Fri, 02 July 2010 15:18 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
What is ORACLE_SID?

On DB Server system open a command window & COPY the lines below

SET ORACLE_HOME=C:\app\Administrator\product\11.2.0\dbhome_2
lsnrctl status
lsnrctl stop
RENAME C:\app\Administrator\product\11.2.0\dbhome_2\network\admin\listener.ora C:\app\Administrator\product\11.2.0\dbhome_2\network\admin\listener.bck
lsnrctl start
lsnrctl status
DIR /Q $ORACLE_HOME\dbs


PASTE commands above into command window
COPY commands & results, then PASTE all back here
Re: Can't Connect to Remote DB Listener [message #463727 is a reply to message #463726] Fri, 02 July 2010 15:23 Go to previous messageGo to next message
THADC
Messages: 17
Registered: July 2010
Junior Member
 C:\Users\Administrator>SET ORACLE_HOME=C:\app\Administrator\product\11.2.0\dbhom
e_2

C:\Users\Administrator>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 02-JUL-2010 16:19
:11

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date                02-JUL-2010 16:03:22
Uptime                    0 days 0 hr. 15 min. 51 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\app\Administrator\product\11.2.0\dbhome_2\network\a
dmin\listener.ora
Listener Log File         c:\app\administrator\diag\tnslsnr\WIN-7WSDUFVVLKX\list
ener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl.tysons.integratedsecure.com" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB.tysons.integratedsecure.com" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "wrhouse.tysons.integratedsecure.com" has 1 instance(s).
  Instance "wrhouse", status READY, has 1 handler(s) for this service...
Service "wrhouseXDB.tysons.integratedsecure.com" has 1 instance(s).
  Instance "wrhouse", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\Users\Administrator>lsnrctl stop

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 02-JUL-2010 16:19
:11

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully

C:\Users\Administrator>RENAME C:\app\Administrator\product\11.2.0\dbhome_2\netwo
rk\admin\listener.ora C:\app\Administrator\product\11.2.0\dbhome_2\network\admin
\listener.bck
The syntax of the command is incorrect.

C:\Users\Administrator>lsnrctl start

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 02-JUL-2010 16:19
:13

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

Starting tnslsnr: please wait...

TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
System parameter file is C:\app\Administrator\product\11.2.0\dbhome_2\network\ad
min\listener.ora
Log messages written to c:\app\administrator\diag\tnslsnr\WIN-7WSDUFVVLKX\listen
er\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521
ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date                02-JUL-2010 16:19:16
Uptime                    0 days 0 hr. 0 min. 3 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\app\Administrator\product\11.2.0\dbhome_2\network\a
dmin\listener.ora
Listener Log File         c:\app\administrator\diag\tnslsnr\WIN-7WSDUFVVLKX\list
ener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

C:\Users\Administrator>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 02-JUL-2010 16:19
:17

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date                02-JUL-2010 16:19:16
Uptime                    0 days 0 hr. 0 min. 3 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\app\Administrator\product\11.2.0\dbhome_2\network\a
dmin\listener.ora
Listener Log File         c:\app\administrator\diag\tnslsnr\WIN-7WSDUFVVLKX\list
ener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

C:\Users\Administrator>DIR /Q $ORACLE_HOME\dbs
The system cannot find the file specified.

Re: Can't Connect to Remote DB Listener [message #463728 is a reply to message #463727] Fri, 02 July 2010 15:38 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
manually do

lsnrctl stop

then C:\Users\Administrator>RENAME C:\app\Administrator\product\11.2.0\dbhome_2\netwo
rk\admin\listener.ora C:\app\Administrator\product\11.2.0\dbhome_2\network\admin
\listener.bck
The syntax of the command is incorrect.

RENAME listener.ora to a new name - WINDOZE does not like my syntax for some reason

then do LSNRCTL START

wait 1 - 2 minutes then issue LSNRCTL STATUS

post the results back here.
I need to go take care of real business & will return in about 90 minutes
Re: Can't Connect to Remote DB Listener [message #463729 is a reply to message #463728] Fri, 02 July 2010 15:54 Go to previous messageGo to next message
THADC
Messages: 17
Registered: July 2010
Junior Member

C:\Users\Administrator>LSNRCTL STATUS

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 02-JUL-2010 16:48
:49

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date                02-JUL-2010 16:45:26
Uptime                    0 days 0 hr. 3 min. 25 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         c:\app\administrator\diag\tnslsnr\WIN-7WSDUFVVLKX\list
ener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WIN-7WSDUFVVLKX)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "orcl.tysons.integratedsecure.com" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB.tysons.integratedsecure.com" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "wrhouse.tysons.integratedsecure.com" has 1 instance(s).
  Instance "wrhouse", status READY, has 1 handler(s) for this service...
Service "wrhouseXDB.tysons.integratedsecure.com" has 1 instance(s).
  Instance "wrhouse", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\Users\Administrator> 
Re: Can't Connect to Remote DB Listener [message #463737 is a reply to message #463729] Fri, 02 July 2010 17:17 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WIN-7WSDUFVVLKX)(PORT=1521)))
above is VERY encouraging!

both from DB Server & remote client system what results from following OS command

ping HOST=WIN-7WSDUFVVLKX
Re: Can't Connect to Remote DB Listener [message #463800 is a reply to message #463724] Sat, 03 July 2010 18:59 Go to previous messageGo to next message
THADC
Messages: 17
Registered: July 2010
Junior Member
Here you go:

From DB Machine

Microsoft Windows [Version 6.0.6001]
Copyright (c) 2006 Microsoft Corporation.  All rights reserved.

C:\Users\Administrator>ping HOST=WIN-7WSDUFVVLKX
Ping request could not find host HOST=WIN-7WSDUFVVLKX. Please check the name and
 try again.

C:\Users\Administrator>


From Client Machine

C:\Users\Administrator>ping HOST=WIN-7WSDUFVVLKX
Ping request could not find host HOST=WIN-7WSDUFVVLKX. Please check the name and
 try again.

C:\Users\Administrator>
Re: Can't Connect to Remote DB Listener [message #463802 is a reply to message #463800] Sat, 03 July 2010 22:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I need to pay closer attention to details

do as below on both systems

ping WIN-7WSDUFVVLKX
Re: Can't Connect to Remote DB Listener [message #463820 is a reply to message #463802] Sun, 04 July 2010 09:36 Go to previous messageGo to next message
THADC
Messages: 17
Registered: July 2010
Junior Member
me too..

Funny, I can ping from both now (couldn't ping by hostname from client machine before..). However, same problem. Installation of Lombardi still cannot connect to DB (i.e., same original problem). thanks!

From DB Machine:

C:\Users\Administrator>
C:\Users\Administrator>ping WIN-7WSDUFVVLKX

Pinging WIN-7WSDUFVVLKX [fe80::784d:ee76:1e35:1139%10] from fe80::784d:ee76:1e35
:1139%10 with 32 bytes of data:
Reply from fe80::784d:ee76:1e35:1139%10: time<1ms
Reply from fe80::784d:ee76:1e35:1139%10: time<1ms
Reply from fe80::784d:ee76:1e35:1139%10: time<1ms
Reply from fe80::784d:ee76:1e35:1139%10: time<1ms

Ping statistics for fe80::784d:ee76:1e35:1139%10:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Users\Administrator>


From Client Machine:

C:\Users\Administrator>ping WIN-7WSDUFVVLKX


Pinging WIN-7WSDUFVVLKX.tysons.integratedsecure.com [192.168.25.180] with 32 byt
es of data:
Reply from 192.168.25.180: bytes=32 time<1ms TTL=128
Reply from 192.168.25.180: bytes=32 time=3ms TTL=128
Reply from 192.168.25.180: bytes=32 time<1ms TTL=128
Reply from 192.168.25.180: bytes=32 time=3ms TTL=128

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

C:\Users\Administrator>
Re: Can't Connect to Remote DB Listener [message #463823 is a reply to message #463820] Sun, 04 July 2010 09:44 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
progress is being made
on the client system rename TNSNAMES.ORA out of the way to a new/different name
create a new tnsnames.ora file containing the single line below
ORCL=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-7WSDUFVVLKX)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)))

After it is in place issue following command
tnsping ORCL
COPY results from command above then PASTE all back here
Re: Can't Connect to Remote DB Listener [message #463824 is a reply to message #463823] Sun, 04 July 2010 09:57 Go to previous messageGo to next message
THADC
Messages: 17
Registered: July 2010
Junior Member
Hmm.. The client machine does not have a tnsnames.ora file. Well, it has the default sample one (in the C:\app\Administrator\product\11.2.0\client_2\NETWORK\ADMIN\SAMPLE) directory..

Also, just for kicks, I ran the command anyway. I expected it to say it cannot connect. I didn't expect to say it didn't recognize the command:

C:\Users\Administrator>tnsping ORCL
'tnsping' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Administrator>
Re: Can't Connect to Remote DB Listener [message #463827 is a reply to message #463824] Sun, 04 July 2010 10:02 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It almost appears Windows OS does not think that Oracle client s/w was successfully/properly installed on this system.
on client system post results from following command

SET

You need to convinced Windows that Oracle client software is available & to use it upon demand/request
Re: Can't Connect to Remote DB Listener [message #463829 is a reply to message #463827] Sun, 04 July 2010 10:05 Go to previous messageGo to next message
THADC
Messages: 17
Registered: July 2010
Junior Member

C:\Users\Administrator>set
ALLUSERSPROFILE=C:\ProgramData
APPDATA=C:\Users\Administrator\AppData\Roaming
CommonProgramFiles=C:\Program Files\Common Files
CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files
COMPUTERNAME=WIN-J19SIYA8CEL
ComSpec=C:\Windows\system32\cmd.exe
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Users\Administrator
LOCALAPPDATA=C:\Users\Administrator\AppData\Local
LOGONSERVER=\\WIN-J19SIYA8CEL
NUMBER_OF_PROCESSORS=1
OS=Windows_NT
Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE=AMD64
PROCESSOR_IDENTIFIER=AMD64 Family 16 Model 4 Stepping 2, AuthenticAMD
PROCESSOR_LEVEL=16
PROCESSOR_REVISION=0402
ProgramData=C:\ProgramData
ProgramFiles=C:\Program Files
ProgramFiles(x86)=C:\Program Files (x86)
PROMPT=$P$G
PUBLIC=C:\Users\Public
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\Windows
TEMP=C:\Users\ADMINI~1\AppData\Local\Temp
TMP=C:\Users\ADMINI~1\AppData\Local\Temp
USERDOMAIN=WIN-J19SIYA8CEL
USERNAME=Administrator
USERPROFILE=C:\Users\Administrator
windir=C:\Windows

C:\Users\Administrator>
Re: Can't Connect to Remote DB Listener [message #463830 is a reply to message #463829] Sun, 04 July 2010 10:08 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SET Path=C:\app\Administrator\product\11.2.0\dbhome_2\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem

Or wherever the Oracle client s/w is installed
Re: Can't Connect to Remote DB Listener [message #463831 is a reply to message #463830] Sun, 04 July 2010 10:12 Go to previous messageGo to next message
THADC
Messages: 17
Registered: July 2010
Junior Member
did that just now. Still does not recognize the command:


C:\Users\Administrator>SET Path=C:\app\Administrator\product\11.2.0\dbhome_2\bin
;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem

C:\Users\Administrator>tnsping ORCL
'tnsping' is not recognized as an internal or external command,
operable program or batch file.

C:\Users\Administrator>
Re: Can't Connect to Remote DB Listener [message #463833 is a reply to message #463831] Sun, 04 July 2010 12:01 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
you need to FIND/SEARCH local disk to learn in which folder tnsping, sqlplus & other Oracle utilities reside;
then add that fully qualified pathname to PATH environmental variable
Re: Can't Connect to Remote DB Listener [message #463844 is a reply to message #463833] Sun, 04 July 2010 14:39 Go to previous messageGo to next message
THADC
Messages: 17
Registered: July 2010
Junior Member
got it. It should have been client_2, rather than dbhome_2.. In any case, when I run ping util now, I get:


C:\Users\Administrator>tnsping

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 04-JUL-2
010 15:32:46

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

TNS-03502: Insufficient arguments.  Usage:  tnsping <address> [<count>]

C:\Users\Administrator>tnsping orcl

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 04-JUL-2
010 15:33:31

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

Used parameter files:
C:\app\Administrator\product\11.2.0\client_2\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name

C:\Users\Administrator>



Also, we never found the appropriate tnsnames.ora on the client machine. Is that because if you only have oracle client, you use another config file or something?? Anyway, Here we are..
Re: Can't Connect to Remote DB Listener [message #463845 is a reply to message #463844] Sun, 04 July 2010 14:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
create C:\app\Administrator\product\11.2.0\client_2\NETWORK\ADMIN\tnsnames.ora containing line below

ORCL=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-7WSDUFVVLKX)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)))

then post results from

TNSPING ORCL
Re: Can't Connect to Remote DB Listener [message #463846 is a reply to message #463845] Sun, 04 July 2010 14:53 Go to previous messageGo to next message
THADC
Messages: 17
Registered: July 2010
Junior Member
ok. Did all that. Different response now!

C:\Users\Administrator>TNSPING ORCL

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 04-JUL-2
010 15:50:20

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

Used parameter files:
C:\app\Administrator\product\11.2.0\client_2\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-7WSDUFVVLKX)
(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)))
TNS-12535: TNS:operation timed out

C:\Users\Administrator>
Re: Can't Connect to Remote DB Listener [message #463848 is a reply to message #463846] Sun, 04 July 2010 14:55 Go to previous messageGo to next message
THADC
Messages: 17
Registered: July 2010
Junior Member
and from the DB machine, validated that the ping works (below):

C:\Users\Administrator>tnsping ORCL

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 04-JUL-2
010 15:53:16

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

Used parameter files:
C:\app\Administrator\product\11.2.0\dbhome_2\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhos
t)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.tyson
s.integratedsecure.com)))
OK (600 msec)

C:\Users\Administrator>
Re: Can't Connect to Remote DB Listener [message #463849 is a reply to message #463846] Sun, 04 July 2010 14:59 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I suspect this might be due to Windoze FireWall issue
On DB Server review following file
c:\app\administrator\diag\tnslsnr\WIN-7WSDUFVVLKX\listener\alert\log.xml
Ideally near the end of this file will be 1 or more records indicating client got the attention of the listener on DB server.
COPY & PASTE those lines back here.
Since I don't do Windoze, I have no direct advice on FireWall other than to shut it off/down!
Re: Can't Connect to Remote DB Listener [message #463850 is a reply to message #463849] Sun, 04 July 2010 15:21 Go to previous messageGo to next message
THADC
Messages: 17
Registered: July 2010
Junior Member
Hmm.. It was huge so I it was hard to read.. I wiped it out, then went and tried to ping again from client. The log was recreated, but I can't tell whether any of the content is related to the attempted ping. Here is the content after and started from a clean file and pinged:

<msg time='2010-07-04T16:17:03.383-04:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='WIN-7WSDUFVVLKX'
 host_addr='fe80::784d:ee76:1e35:1139%10' version='1'>
 <txt>04-JUL-2010 16:17:03 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=WIN-7WSDUFVVLKX$))(SERVICE_NAME=orcl.tysons.integratedsecure.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50166)) * establish * orcl.tysons.integratedsecure.com * 0
 </txt>
</msg>
<msg time='2010-07-04T16:17:08.886-04:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='WIN-7WSDUFVVLKX'
 host_addr='fe80::784d:ee76:1e35:1139%10'>
 <txt>04-JUL-2010 16:17:08 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=WIN-7WSDUFVVLKX$))(SERVICE_NAME=orcl.tysons.integratedsecure.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50168)) * establish * orcl.tysons.integratedsecure.com * 0
 </txt>
</msg>
<msg time='2010-07-04T16:17:14.052-04:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='WIN-7WSDUFVVLKX'
 host_addr='fe80::784d:ee76:1e35:1139%10'>
 <txt>04-JUL-2010 16:17:13 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=WIN-7WSDUFVVLKX$))(SERVICE_NAME=orcl.tysons.integratedsecure.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50170)) * establish * orcl.tysons.integratedsecure.com * 0
 </txt>
</msg>
<msg time='2010-07-04T16:17:14.136-04:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='WIN-7WSDUFVVLKX'
 host_addr='fe80::784d:ee76:1e35:1139%10'>
 <txt>04-JUL-2010 16:17:14 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=WIN-7WSDUFVVLKX$))(SERVICE_NAME=orcl.tysons.integratedsecure.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50171)) * establish * orcl.tysons.integratedsecure.com * 0
 </txt>
</msg>
<msg time='2010-07-04T16:17:14.164-04:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='WIN-7WSDUFVVLKX'
 host_addr='fe80::784d:ee76:1e35:1139%10'>
 <txt>04-JUL-2010 16:17:14 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=WIN-7WSDUFVVLKX$))(SERVICE_NAME=orcl.tysons.integratedsecure.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50173)) * establish * orcl.tysons.integratedsecure.com * 0
 </txt>
</msg>
<msg time='2010-07-04T16:17:14.185-04:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='WIN-7WSDUFVVLKX'
 host_addr='fe80::784d:ee76:1e35:1139%10'>
 <txt>04-JUL-2010 16:17:14 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=WIN-7WSDUFVVLKX$))(SERVICE_NAME=orcl.tysons.integratedsecure.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50174)) * establish * orcl.tysons.integratedsecure.com * 0
 </txt>
</msg>
<msg time='2010-07-04T16:17:34.350-04:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='WIN-7WSDUFVVLKX'
 host_addr='fe80::784d:ee76:1e35:1139%10'>
 <txt>04-JUL-2010 16:17:34 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=WIN-7WSDUFVVLKX$))(SERVICE_NAME=orcl.tysons.integratedsecure.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50176)) * establish * orcl.tysons.integratedsecure.com * 0
 </txt>
</msg>
<msg time='2010-07-04T16:17:37.836-04:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='WIN-7WSDUFVVLKX'
 host_addr='fe80::784d:ee76:1e35:1139%10'>
 <txt>04-JUL-2010 16:17:37 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=WIN-7WSDUFVVLKX$))(SERVICE_NAME=orcl.tysons.integratedsecure.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50179)) * establish * orcl.tysons.integratedsecure.com * 0
 </txt>
</msg>
<msg time='2010-07-04T16:17:38.044-04:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='WIN-7WSDUFVVLKX'
 host_addr='fe80::784d:ee76:1e35:1139%10'>
 <txt>04-JUL-2010 16:17:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=WIN-7WSDUFVVLKX$))(SERVICE_NAME=orcl.tysons.integratedsecure.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50180)) * establish * orcl.tysons.integratedsecure.com * 0
 </txt>
</msg>
<msg time='2010-07-04T16:17:39.141-04:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='WIN-7WSDUFVVLKX'
 host_addr='fe80::784d:ee76:1e35:1139%10'>
 <txt>04-JUL-2010 16:17:39 * service_update * orcl * 0
 </txt>
</msg>
<msg time='2010-07-04T16:17:39.899-04:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='WIN-7WSDUFVVLKX'
 host_addr='fe80::784d:ee76:1e35:1139%10'>
 <txt>04-JUL-2010 16:17:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=WIN-7WSDUFVVLKX$))(SERVICE_NAME=orcl.tysons.integratedsecure.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50181)) * establish * orcl.tysons.integratedsecure.com * 0
 </txt>
</msg>
<msg time='2010-07-04T16:17:44.233-04:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='WIN-7WSDUFVVLKX'
 host_addr='fe80::784d:ee76:1e35:1139%10'>
 <txt>04-JUL-2010 16:17:44 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=WIN-7WSDUFVVLKX$))(SERVICE_NAME=orcl.tysons.integratedsecure.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50183)) * establish * orcl.tysons.integratedsecure.com * 0
 </txt>
</msg>
<msg time='2010-07-04T16:17:44.253-04:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='WIN-7WSDUFVVLKX'
 host_addr='fe80::784d:ee76:1e35:1139%10'>
 <txt>04-JUL-2010 16:17:44 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=WIN-7WSDUFVVLKX$))(SERVICE_NAME=orcl.tysons.integratedsecure.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50184)) * establish * orcl.tysons.integratedsecure.com * 0
 </txt>
</msg>
<msg time='2010-07-04T16:17:44.280-04:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='WIN-7WSDUFVVLKX'
 host_addr='fe80::784d:ee76:1e35:1139%10'>
 <txt>04-JUL-2010 16:17:44 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=WIN-7WSDUFVVLKX$))(SERVICE_NAME=orcl.tysons.integratedsecure.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50186)) * establish * orcl.tysons.integratedsecure.com * 0
 </txt>
</msg>
<msg time='2010-07-04T16:17:44.303-04:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='WIN-7WSDUFVVLKX'
 host_addr='fe80::784d:ee76:1e35:1139%10'>
 <txt>04-JUL-2010 16:17:44 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=WIN-7WSDUFVVLKX$))(SERVICE_NAME=orcl.tysons.integratedsecure.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50187)) * establish * orcl.tysons.integratedsecure.com * 0
 </txt>
</msg>
<msg time='2010-07-04T16:17:45.144-04:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='WIN-7WSDUFVVLKX'
 host_addr='fe80::784d:ee76:1e35:1139%10'>
 <txt>04-JUL-2010 16:17:45 * service_update * orcl * 0
 </txt>
</msg>

Re: Can't Connect to Remote DB Listener [message #463851 is a reply to message #463850] Sun, 04 July 2010 15:27 Go to previous messageGo to next message
THADC
Messages: 17
Registered: July 2010
Junior Member
hey, anyway, I just turned off the firewall and the problem seems to be fixed! I can both ping and connect from the test thing on the install! Thanks!

By the way, what should I put for the entry for my 2nd db (the lobardi platform needs 2 DBs) in the tnsnames.ora file on the client? The second DB is called WRHOUSE.
Re: Can't Connect to Remote DB Listener [message #463852 is a reply to message #463851] Sun, 04 July 2010 15:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
create C:\app\Administrator\product\11.2.0\client_2\NETWORK\ADMIN\tnsnames.ora containing lines below

ORCL=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-7WSDUFVVLKX)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)))
WRHOUSE=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-7WSDUFVVLKX)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=WRHOUSE)) )

Any line in listsener.log containing "(HOST=127.0.0.1)" is DB Server talking to itself.
It appear some JAVA s/w is accessing the ORCL DB
Re: Can't Connect to Remote DB Listener [message #463855 is a reply to message #463851] Sun, 04 July 2010 17:59 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Incase firewall is involved,
the standard workaround for that is make the registry settting use_shared_socket=TRUE
Previous Topic: Issues with the package execution
Next Topic: Listener
Goto Forum:
  


Current Time: Thu Mar 28 09:29:27 CDT 2024