asked on

Oracle error 'The Database link is not active'

I have two databases (development 'A' and production 'B') on one server and another database 'C' on another server

I have created identical database links in each of A and B pointing at C

The one from the development database A works fine however I get a 'The Database link is not active' error on B

I checked the :global_names parameter and its FALSE on both databases

Any other ideas?

SOLUTION

Acton Wang

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Acton Wang

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

bromley_college

ASKER

I used the SQL created by Enterprise Manager on A and ran this on B

both links use the same tns name.

Also I have found the same problem connecting to another database C where the link in A works but the same link from B will not.

I am suspecting something in the setup of A

SOLUTION

Acton Wang

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Acton Wang

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

vishal68

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

bromley_college

ASKER

It seems that we may have more problems than just this as the database has now lost connection to its standby.

We are going to bounce the database this evening and see what happens!

Thanks for your help and advise so far, I'll report back tomorrow.

ASKER CERTIFIED SOLUTION

Acton Wang

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

bromley_college

ASKER

Rebooting the server has now restored the production server links with out making any other changes.

I wish I knew why this works, however the IT team has several issues with network connectivity at the moment and it is possible it was due to this.

Thanks for your helpful comments. As no difinitive answer has been found for this question I'll split the points between all contributers.