Re: database connectivity/tnsping problem

B. Kloppt wrote:
> 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.

try that:

SQLNET.ORA:
   names.directory_path = (TNSNAMES)
   #NAMES.DEFAULT_DOMAIN = world

TNSNAMES.ORA:
  ORCL
   (DESCRIPTION =

     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.25)(PORT = 1521))
     )
     (CONNECT_DATA =
       (SERVICE_NAME = ORCL)
     )

tnsping orcl

   or/and
tnsping orcl.world Received on Mon Feb 03 2003 - 18:33:47 CST