Home » Server Options » Replication » links are not properly working!
links are not properly working! [message #206935] Sat, 02 December 2006 09:19 Go to next message
doc1
Messages: 18
Registered: December 2005
Junior Member

Hi!!

i am trying to replicate data between two instances, iiui and iiu, on the same system but the problem is that iiu site is not accessing iiui where as the other site iiui is accessing iiu..what might be the problem. any sugession

Thanx
Re: links are not properly working! [message #206947 is a reply to message #206935] Sat, 02 December 2006 11:21 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It seems that you've already answered the question in topic subject: link does not work properly. Recreate it, but make sure it is done correctly.
Re: links are not properly working! [message #207134 is a reply to message #206947] Mon, 04 December 2006 04:30 Go to previous messageGo to next message
doc1
Messages: 18
Registered: December 2005
Junior Member

thanx for your answer.. but i have already done what you are refferring to do and now the condition is both links are not accessing each other. my question is can it be becuase of any other reason as i am working on two instance at one pc .. may be installation problem or any other technical issue..any idea

thanx
Re: links are not properly working! [message #207145 is a reply to message #207134] Mon, 04 December 2006 05:26 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How do TNSNAMES.ORA aliases for both 'iiu' and 'iiui' (really meaningful names, BTW) and both CREATE DATABASE LINK statements look like?
Re: links are not properly working! [message #207323 is a reply to message #207145] Tue, 05 December 2006 02:08 Go to previous messageGo to next message
doc1
Messages: 18
Registered: December 2005
Junior Member

Aliases are iiui for iiui and iiu for iiu. I am uploading tnsnames.ora too. The statement for the link is

1.create public database link iiui.world using ‘iiui’;
2.create public database link iiu.world using ‘iiu’;


  • Attachment: tnsnames.ora
    (Size: 0.97KB, Downloaded 1807 times)
Re: links are not properly working! [message #207401 is a reply to message #206935] Tue, 05 December 2006 06:59 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

create public database link MYDBLINK connect to "username" identified by "mypassword" USING 'iiui'

[Updated on: Tue, 05 December 2006 07:20]

Report message to a moderator

Re: links are not properly working! [message #207698 is a reply to message #207401] Wed, 06 December 2006 12:12 Go to previous messageGo to next message
doc1
Messages: 18
Registered: December 2005
Junior Member

thanx but this is also not working... neither site is accessing other....

Re: links are not properly working! [message #207718 is a reply to message #207698] Wed, 06 December 2006 14:41 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

You didnt forget the " "

?

And you still have the same error ?
Re: links are not properly working! [message #207726 is a reply to message #207718] Wed, 06 December 2006 15:23 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If everything is fine, you should be able to reproduce something like this live example (both schemas being in the same database, just like yours):
SQL> create database link dbl_scott
  2  connect to "scott" identified by "tiger"
  3  using 'ora10';

Database link created.

SQL> select 'x' from dual@dbl_scott;

'
-
x

SQL>

If SELECT statement fails, database link isn't properly created.
Re: links are not properly working! [message #208961 is a reply to message #206935] Tue, 12 December 2006 13:59 Go to previous message
doc1
Messages: 18
Registered: December 2005
Junior Member
Thanx for your concern and helping out. It's solved now.
Previous Topic: Unable to create materialized view over db link
Next Topic: How to do replication of table from oralce to MSSQL?
Goto Forum:
  


Current Time: Thu Mar 28 05:35:17 CDT 2024