• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1886
  • Last Modified:

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?
0
bromley_college
Asked:
bromley_college
  • 5
  • 3
6 Solutions
 
actonwangCommented:
in both d'A' and p'B', do you use same exact statement to set them up?
0
 
actonwangCommented:
also, check to see if tns name you use in p'B' is valid.
0
 
bromley_collegeAuthor Commented:
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
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
actonwangCommented:
also, make sure you set up tns name  pB  correctly. You could set up a different tns name in pB. Then use it to create database link to how it goes.
0
 
vishal68Commented:
Try to test your link from SQL Plus. It will give a more meaningful error message. From EM, it always gives the same message link not active, which is a generic message rather than a specific message.

For testing from sql plus. Login to pB database and try the following command

select * from dual@dblink

HTH
Vishal
0
 
bromley_collegeAuthor Commented:
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.

0
 
actonwangCommented:
try to use different service names for each db to create db links.
0
 
bromley_collegeAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now