Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

ORA-121514

Posted on 2009-04-11
2
Medium Priority
?
1,482 Views
Last Modified: 2012-05-06
Hi

I am trying to connect to remote oracle database from windows (using sqlplus and TOAD) that had a cname change, the oracle that remote database was installed has changed from one unix machine to another and nothing else changed - after this change both database and listener was up and the remote team was saying no issues connecting to their database, but when I try to connect using database link I get - ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. I asked them to stop and restart the listener many times and also I could tnsping from windows and also can connect direcly in sqlplus or toad using the user id and password that I used in database link, but the database link alone does not work - any clues?
0
Comment
Question by:mahjag
2 Comments
 
LVL 25

Accepted Solution

by:
lwadwell earned 750 total points
ID: 24123709
Hi mahjag,

Did you change your TNSNAMES to be able to connect to where the new database is?  If so, was the TNSNAMES for the database where the dblink is from also changed?

lwadwell
0
 

Author Comment

by:mahjag
ID: 24124400
This problem was resolved when dba has to correct the tns entries on the server. thanks for your response..
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question