Hi guys,
Something strange is really bugging my mind.
I created a database link to connect 2 database on 2 different machines. I know I did the right thing but it did not work. I used OEM(SCHEMA MANAGER) to test it and it told me "THE DATABASE LINK IS ACTIVE" but any time I tried to I issue an sql statment to select data from both databases on the different machines, it does not work. Does anybody no what the problem might be?
NOTE: I modified tnsnames file but I had the same problem.

I need some help, first of all.
Assuming I have two databases DATABASE A and DATABSE B.
DATABASE A is sitting on MACHINE A and DATABASE B is sitting on MACHINE B
I have TABLE A in DATABASE A and TABLE B in DATABASE B.

Can anyone create an example database link connecting these two databases on these 2 separate machines and modify the tnsnames files for me to see?

I know I am doing the right thing but I will be glad if somebody can go through the process systematically so that I can compare and see where I went wrong.

regards,
thedba