Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1843
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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