Dblink Error Ora-12154
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn ora 12154 error in oracle 11g more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users database link ora 12154 Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping ora 12154 tns could not resolve connect identifier specified 11g each other. Join them; it only takes a minute: Sign up on using oracle database link theres an error “ORA-12154 TNS Could not resolve the connect identifier specified” up vote 0 down vote favorite I'm trying to define ora-02085 a database link on oracle 10.2 with connection identifier that throws the error in the question header. I have the connection identifier (service name) in my tnsnames.ora file. I can connect with sqlplus using this service name. no problem. This is the creation sql: create database link dev1.REGRESS.RDBMS.DEV.US.ORACLE.COM connect to user1 identified by pass1 using 'dev1'; select using the link: select * from t_users@dev1; I get: ORA-12154: TNS:could not resolve the connect identifier specified connecting to
Ora-02019: Connection Description For Remote Database Not Found
oracle with sqlplus to the 'unidentified' service (with no problem): sqlplus user1/pass1@dev1 I defined another link to the same database I'm woking in (loopback) - works OK. I read and tried anything I could find about the subject but did not solve this. Any suggestions? oracle database-link share|improve this question edited May 4 '12 at 0:57 BrettAdamsGA 60311122 asked May 2 '12 at 15:36 gold finger 11112 Did you configure SQLNET? If you're using Local naming you may have to add tnsnames to the NAMES.DIRECTORY_PATH in your Oracle Net Profile. You should post both your tnsnames and sqlnet files. –apesa May 2 '12 at 15:50 add a comment| 1 Answer 1 active oldest votes up vote 3 down vote Try: create database link dev1 connect to user1 identified by pass1 using 'dev1'; Also note that a tnsnames.ora entry for dev1 has to exist on the database server that you're linking from. share|improve this answer answered May 2 '12 at 15:39 Phil 1,6501014 thanks Phil. You nailed it with your second note. –gold finger May 3 '12 at 10:37 It's so obvious I'm quite ashamed I didn't think of it. The tnsnames I refered to was of course on my workstation. Thank you very much. –gold finger May 3 '12 at 10:40 add a comment| Your Answer draft saved draft discarded S
Marts and Cubes Data Visualization Training Higher Education Public Sector RFP & RFI Assistance ETL & Data Integration Data Planning & Design Enterprise Data
Create Database Link Oracle
Governance Master Data Management Data Solutions for DevOps Database Lifecycle Management Remote DBA Services Database Support Services Database Upgrades Database Monitoring Database Consulting Database Projects Database Staffing Database Assessment Database Tuning Database Development Database Documentation Complex Database Migrations Rapid Database Deployment Database Source Control Database Automation Data Replication Database Administration Database Lifecycle Management Remote DBA Services Database http://stackoverflow.com/questions/10417010/on-using-oracle-database-link-theres-an-error-ora-12154-tns-could-not-resolve-t Support Services Database Upgrades Database Monitoring Database Consulting Database Projects Database Staffing Database Assessment Database Tuning Database Development Database Documentation Complex Database Migrations Technologies MS SQL Oracle Oracle EBS MySQL mongoDB SharePoint DB2 Enterprise Support ITIL ProcessTiered DeliveryService ManagementOnsite & OffsiteOnshore & OffshoreScope & Service LevelsMonitoring & Ticketing24×7 Delivery Teams Resources Achieving Unified Commerce in the Data-Driven Retail https://www.datavail.com/blog/ora-12154-tnscould-not-resolve-the-connect-identifier-specified/ Industry We’ll discuss how to overcome these roadblocks by creating a robust database infrastructure that supports the new world of unified commerce and gives you a leg-up on the competition. Download TypeBlogs Case Studies Infographics Presentations Service Overviews Videos Webinars White Papers SolutionDatabase Assessments Data Consulting Database Monitoring Database Projects Database Security Database Staffing Database Support Database Upgrades Database Development Database Performance Tuning and Health Checks Remote DBA RoleCIO/CTO Database Manager Developer IT VP/Director Primary DBA TechnologyDB2 MongoDB MS SQL MySQL Oracle Oracle EBS SharePoint Select a resource category below for View All Resources >> Read the Blog About Datavail Leadership TeamNewsEventsCareersCulturePartnersContact Us Home>Blog>ORA-12154: TNS:could not resolve the connect identifier specified ORA-12154: TNS:could not resolve the connect identifier specified By Jeremiah Wilton | In Oracle The error also appears in some versions as: "ORA-12154: TNS:could not resolve service name." When a program needs to connect to an Oracle service via Oracle Networking (SQL*Net), it must look up the connect data for that service somewhere. When the lookup fails, the Orac
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this https://community.oracle.com/thread/2188088 page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 9 Replies Latest reply on Mar 7, 2011 5:58 PM by EdStevens Got error: ORA-12154 when to use a dblink 836048 Mar 4, 2011 7:52 PM ora 12154 Hi, I got an error when I use a dblink created in the database: dev_nap. *** login OSSP database (oracle 9i) in sqlplus SQL> select * from global_name; GLOBAL_NAME ------------------------------------- OSSP *** login dev_nap (oracle 10g 10.2) by sqlplus SQL> select * from global_name; GLOBAL_NAME -------------------------------- DEV_NAP.OPBU.XEROX.COM SQL> CREATE DATABASE LINK OSSP 2 CONNECT TO usog01001 IDENTIFIED BY database link ora jan25hc USING 'OSSP'; Database link created. SQL> select count(*) from TK_SERVICE_ACTIVITY@OSSP; Above info, I login with the same sqlplus. Thanks Helen I have the same question Show 0 Likes(0) 309Views Tags: none (add) databaseContent tagged with database, linkContent tagged with link, oracleContent tagged with oracle This content has been marked as final. Show 9 replies 1. Re: Got error: ORA-12154 when to use a dblink sb92075 Mar 4, 2011 7:55 PM (in response to 836048) post content of tnsnames.ora Like Show 0 Likes(0) Actions 2. Re: Got error: ORA-12154 when to use a dblink 836048 Mar 4, 2011 8:32 PM (in response to sb92075) DEV_NAP_TRIBBLE.CESA.OPBU.XEROX.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = tribble.cesa.opbu.xerox.com)(PORT = 1521)) ) (CONNECT_DATA = (SID = dev_nap) (SERVER = DEDICATED) ) ) OSSP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ossp_svr.wvdc.xerox.net)(PORT = 1527)) ) (CONNECT_DATA = (SID = ossp) (SERVICE_NAME = ossp) (DB_NAME = ossp) ) ) Like Show 0 Likes(0) Actions 3. Re: Got error: ORA-12154 when to use a dblin