Solved

ORA-121514

Posted on 2009-04-11
2
1,403 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 250 total points
Comment Utility
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
Comment Utility
This problem was resolved when dba has to correct the tns entries on the server. thanks for your response..
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

743 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now