database link problem

[arisk]

We have two databases in two different domains that connect via VPN. First domain is HLIOSNT with IP 192.168.100.x and

database name AIXSERV. The other domain is ATTIKOS with IP 192.168.1.x and (remote)database name ATTSERV. We want to

connect these two databases with a database link in oracle but the connection is fail.
We try the following steps:
We create a database link in a local database server with (oracle 8.1.7). The commands that we used is the following:

create database link remote_connect
connect to user1 identified by pass1 ussing ‘ATTSERV’.

The ‘attserv’ is the connection string of tnsnames.ora. We execute the above command
normally without any error.
However, if we execute the following command:

select * from table_name@remote _connect

oracle returns the following error:

ora-12154 TNS could not resolve the service name

When we change the statement (using 'ATTSERV') with statement
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=192.168.1.1)
(PORT=1521))
(CONNECT_DATA=
(SID=v734)
))

oracle returns the following error:

ora-12543 TNS destination host unreachable.

Which is the problem?. How could we connect these databases? Which are the statements or commands and the methods that we

must use to connect these databases ?

p.s: when we use the above strings to connect two databases in the same domain, that operation is succesfull.

Regards

 

[Turkbear]

Hi,
Try logging into the ATTSERV server from a local client using the

connect user@ATTSERV command..

If this works, the make sure the tnsnames.ora ON THE SERVER
is the same as on your client..Remember, it is the server's tnsnames.ora that is used in a db link..

 

[bgreen]

a. Set the DISTRIBUTED_TRANSACTIONS parameter to a number greater than
zero for both the target and the source databases in the
init.ora parameter file in the RDBMS server. NOTE: This parameter only
applies to database versions prior to 9i.

$ORACLE_HOME/dbs/init.ora

SQL> show parameter distributed

NAME TYPE VALUE
------------------------------------ ------- ------------------------------
distributed_transactions integer 46


b. Grant the APPS user account (GL in 10.7) in the RDBMS target server
the privilege to create database links.

grant create database link to <APPS account>
where <APPS account> is your APPS account name.

SQL> grant create database link to gl;

Grant succeeded.


c. Create the database link using the GL Super User responsibility by
navigating to the Define Database Links form (Setup/System/Database Links).
If you have already created the link manually, drop it first in SQL, before
trying to create the link from the form.

Note: You can only create a database link in the GUI version of Oracle Applications (10.7 SC or later release).

d. Verify you have included the domain name in the Connect String field.

e. Verify there are entries in the source and target database tnsnames.ora files for both the source and target databases.