B. Kloppt 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.
>
>
> hi everyone,
>
> i just found out what the problem was.
> in the tnsnames.ora file on the clients, there was no equals sign
> after the service name ORCL.DOMAIN.LA (see example above).
> that seems to have caused all this.
>
> thanks very much to everyone who took the time to help.
>
> cheers,
> b.
That too... :-o
Frank
Received on Wed Feb 05 2003 - 12:11:42 CST