Database Networking (MOSC)

MOSC Banner

db link between 11G and 10G not working

edited Jun 8, 2011 11:56AM in Database Networking (MOSC) 14 commentsAnswered
 Hi,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center