OraFAQ Forum: Networking and Gateways » Can't Connect to Remote DB Listener

Home » RDBMS Server » Networking and Gateways » Can't Connect to Remote DB Listener (11g windows 2008 64-bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can't Connect to Remote DB Listener [message #463717]

Fri, 02 July 2010 13:46

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!

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463718 is a reply to message #463717]

Fri, 02 July 2010 13:51

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463719 is a reply to message #463717]

Fri, 02 July 2010 13:52

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

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463721 is a reply to message #463719]

Fri, 02 July 2010 14:52

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

Attachment: ScreenShotOfLombardi.jpg
(Size: 95.28KB, Downloaded 1967 times)

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463722 is a reply to message #463721]

Fri, 02 July 2010 14:58

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463723 is a reply to message #463721]

Fri, 02 July 2010 14:58

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

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463724 is a reply to message #463722]

Fri, 02 July 2010 15:00

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;

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463725 is a reply to message #463719]

Fri, 02 July 2010 15:09

THADC
Messages: 17
Registered: July 2010

Junior Member

Hope this is better:

Code: [Select all] [Show/ hide]

 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>

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463726 is a reply to message #463725]

Fri, 02 July 2010 15:18

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

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463727 is a reply to message #463726]

Fri, 02 July 2010 15:23

THADC
Messages: 17
Registered: July 2010

Junior Member

Code: [Select all] [Show/ hide]

 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.

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463728 is a reply to message #463727]

Fri, 02 July 2010 15:38

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

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463729 is a reply to message #463728]

Fri, 02 July 2010 15:54

THADC
Messages: 17
Registered: July 2010

Junior Member

Code: [Select all] [Show/ hide]

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>

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463737 is a reply to message #463729]

Fri, 02 July 2010 17:17

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

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463800 is a reply to message #463724]

Sat, 03 July 2010 18:59

THADC
Messages: 17
Registered: July 2010

Junior Member

Here you go:

From DB Machine

Code: [Select all] [Show/ hide]

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

Code: [Select all] [Show/ hide]

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>

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463802 is a reply to message #463800]

Sat, 03 July 2010 22:31

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

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463820 is a reply to message #463802]

Sun, 04 July 2010 09:36

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:

Code: [Select all] [Show/ hide]

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

Code: [Select all] [Show/ hide]

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>

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463823 is a reply to message #463820]

Sun, 04 July 2010 09:44

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

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463824 is a reply to message #463823]

Sun, 04 July 2010 09:57

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:

Code: [Select all] [Show/ hide]

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

C:\Users\Administrator>

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463827 is a reply to message #463824]

Sun, 04 July 2010 10:02

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

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463829 is a reply to message #463827]

Sun, 04 July 2010 10:05

THADC
Messages: 17
Registered: July 2010

Junior Member

Code: [Select all] [Show/ hide]

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>

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463830 is a reply to message #463829]

Sun, 04 July 2010 10:08

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

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463831 is a reply to message #463830]

Sun, 04 July 2010 10:12

THADC
Messages: 17
Registered: July 2010

Junior Member

did that just now. Still does not recognize the command:

Code: [Select all] [Show/ hide]

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>

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463833 is a reply to message #463831]

Sun, 04 July 2010 12:01

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

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463844 is a reply to message #463833]

Sun, 04 July 2010 14:39

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:

Code: [Select all] [Show/ hide]

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..

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463845 is a reply to message #463844]

Sun, 04 July 2010 14:41

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

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463846 is a reply to message #463845]

Sun, 04 July 2010 14:53

THADC
Messages: 17
Registered: July 2010

Junior Member

ok. Did all that. Different response now!

Code: [Select all] [Show/ hide]

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>

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463848 is a reply to message #463846]

Sun, 04 July 2010 14:55

THADC
Messages: 17
Registered: July 2010

Junior Member

and from the DB machine, validated that the ping works (below):

Code: [Select all] [Show/ hide]

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>

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463849 is a reply to message #463846]

Sun, 04 July 2010 14:59

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!

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463850 is a reply to message #463849]

Sun, 04 July 2010 15:21

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:

Code: [Select all] [Show/ hide]

<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>

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463851 is a reply to message #463850]

Sun, 04 July 2010 15:27

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.

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463852 is a reply to message #463851]

Sun, 04 July 2010 15:40

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

Report message to a moderator

Re: Can't Connect to Remote DB Listener [message #463855 is a reply to message #463851]

Sun, 04 July 2010 17:59

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Previous Topic:	Issues with the package execution
Next Topic:	Listener

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 17:06:22 CDT 2025