db link between 11G and 10G not working
I create a db_link from 11G ( 11.2.0.2 test database) to a 10G ( 10.2.0.3) as sysdba, the databases are on physiccally seperate servers.
create public database link PROD using 'prod_server1';
And my tnsnames.ora is :
PROD_SERVER1 = 
	
  (DESCRIPTION = 
	
    (ADDRESS_LIST = 
	
      (ADDRESS = (PROTOCOL = TCP)(HOST =server1)(PORT = 1521)) 
	
    ) 
	
    (CONNECT_DATA = 
	
      (SERVER = DEDICATED) 
	
      (SERVICE_NAME = PROD) 
	
    ) 
	
  ) 
When I do a query on a small table using the db_link, the query hang there
select count(*) from tab1@prod;
And I don't see any db_link sessions on the PROD .
But I can connect to the PROD database from sqlplus
$sqlplus user1/pwd@prod_server1