Dear Experts,
I have a database link on DEV pointing to TEST database. All I'm trying to do is run a select stmt as below, my session is hung, (no errors). I'm unable to run the select stmt. I do not see any issues with DB Link user password, owner password or anything else. This link has been working fine. No password changes from last 1 year. Anyone faced similar issue before? or have any suggestions? Appreciate your thoughts.
DB Link owner - LINK_OWNER
DB Link user - LINK_USER
select * from dual@TEST.WORLD;
DBLINK DDL:
CREATE DATABASE LINK "TEST.WORLD"
CONNECT TO LINK_USER
IDENTIFIED BY <PWD>
USING 'TEST.WORLD';
Something I've just noticed, when I do a tnsping TEST.WORLD from DEV machine, I get the result but don't get UNIX prompt back, instead it appears like its hung after returning tnsping result. Seems like related..
Edited by: Ora DBA on Nov 5, 2012 4:05 AM