Home » Server Options » Replication » DATABASE LINK -- WHERE IS MY MISTAKE
DATABASE LINK -- WHERE IS MY MISTAKE [message #208924] Tue, 12 December 2006 10:49 Go to next message
prince973
Messages: 37
Registered: November 2006
Member
Dear all ,
i created two databases
the name of the first is : one.oracle
the second :two.oracle

i connected to one
create o_user identified by o_user;
grant dba to o_user;
--------------------------------------------------
and on the database two
i created a user t_user identified by t_user;


on the one database i wrote
CREATE DATABASE LINK MY_LINK CONNECT TO T_USER IDENTIFIED BY T_USER USING 'TWO';

my tnsnames.ora is :

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

TWO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = one)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TWO.ORACLE.one)
)
)

ONE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = user)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ONE.ORACLE)
)
)


i cant use the link i have changed tnsnames many times but now i am desperate
i need ur help
i think i have to change the tnsnames but how
can u please advise ..................
Re: DATABASE LINK -- WHERE IS MY MISTAKE [message #210257 is a reply to message #208924] Wed, 20 December 2006 01:14 Go to previous message
stirandas
Messages: 4
Registered: December 2006
Junior Member
Please mention what you mean by "I can't use the link".
Was there an error while creating the link, or was there some error while trying to use it?

Please note if the parameter global_names = true in init.ora,
then you will have to create the DB link with the same name as of the target instance.

If you want give a different name to the DB link than that of the target database, you will have to set GLOBAL_NAMES to FALSE.

Regards
Srikanth
Previous Topic: How to do replication of table from oralce to MSSQL?
Next Topic: session blocked after network failure
Goto Forum:
  


Current Time: Mon Sep 01 17:16:39 CDT 2014

Total time taken to generate the page: 0.10964 seconds