Sybrand Bakker wrote:
> b_kloppt_at_my-deja.com (B. Kloppt) wrote in message news:<3717b54f.0302030301.5d0c5343_at_posting.google.com>...
>
>>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.
>
>
>
> Please do not cross- or multipost.
>
> Regards
>
> Sybrand Bakker
> Senior Oracle DBA
In addition to that, why use a default domain of world,
when you domains are called domain.la and domain.ny?!?
Which is a weird naming schema, but that is not the scope of
this ng...
Remove the line, and get used to orcl.domain.ny and orcl.domain.la.
Received on Mon Feb 03 2003 - 14:51:16 CST
