database connectivity/tnsping problem

Hi everyone,

i've got a problem which i haven't been able to solve.

my company has two domains, which are connected using a vpn router. my domain (domain.ny) has the ip range 192.168.1.x and the second domain (domain.la) has the ip range 192.168.2.x in both domains we've got an oracle server running under linux. in both domains workstations can connect to databases in their own domain with sqlplus.

we cannot, however, cross-domain connect. not even a tnsping works correctly.
this is the output of tnsping when pinging from a station in the first domain (domain.ny):

---8<-----------------------------------------------------------------------------
[oracle_at_dbserver:~]$ tnsping orcl.domain.la

TNS Ping Utility for Linux: Version 9.2.0.1.0 - Production on 02-FEB-2003 20:53:53 Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
/opt/oracle/product/9.2.0/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name
---8<-----------------------------------------------------------------------------

a tnsping to the ip-address brings me the desired results, however:

---8<-----------------------------------------------------------------------------
[oracle_at_dbserver:~]$ tnsping 192.168.2.25

TNS Ping Utility for Linux: Version 9.2.0.1.0 - Production on 02-FEB-2003 20:54:37 Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
/opt/oracle/product/9.2.0/network/admin/sqlnet.ora

Used HOSTNAME adapter to resolve the alias Attempting to contact
(DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=192.168.2.25))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.25)(PORT=1521))) OK (490 msec)
---8<-----------------------------------------------------------------------------

trying to connect to our server from a workstation in the second domain brings the same results.
i have double-checked my tnsname.ora file, which has the following section defined:

ORCL.DOMAIN.LA
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.25)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL)
    )
  )

i have even set NAMES.DEFAULT_DOMAIN = world in the sqlnet.ora file as well.

i must be missing something else.
can anyone help me?

thanks in advance. Received on Mon Feb 03 2003 - 05:01:23 CST