Home > Crystal Reports > Crystal Reports Error Ora-12154

Crystal Reports Error Ora-12154


Can Anybody Suggest ?? C:\ > type tnsnames.ora CtxSumry = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ...C:\ > type sqlnet.ora # SQLNET.ORA Network Configuration File: NAMES.DEFAULT_DOMAIN = Europe.DelphiAuto.netThis default domain implies Re: ORA-12154: TNS:could not resolve the connect identifier specified 604134 Oct 30, 2007 11:58 PM (in response to 604134) Thanks anyway, I fixed it in the meantime. Reply Saeed says: June 11, 2014 at 8:35 am Very simple solution find below, solutions-ever.blogspot.com/…/ora-06413.html Reply Jeremy Thompson says: October 7, 2015 at 11:13 pm Just start Visual Studio with short http://ogdomains.com/crystal-reports/crystal-reports-515.php

Service "Oracle10gR2XDB" has 1 instance(s). Then only the CR Jobserver shouod suffice._________________Berend - SAP Business Objects Platform consultant and trainer Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 YearOldest You can not post a blank message. Is a world with two different types of air possible?

Sap Kb 0001198150

Check that the net service name used as the connect identifier exists in the TNSNAMES.ORA file. All rights reserved. The thing I finally found was that if I did a sqlplus fred/[email protected] from dos command line in the actual network\admin directory, then it worked, but anywhere else, it did not. Such as "c:\program files (x86)\crystal reports"?

it's not the database server. Service "Oracle10gR2_XPT" has 1 instance(s). Skip to Content Open navigation Account Settings Notifications Followed Activities Logout Search Your browser does not support JavaScript. And click HERE to dicsover more about how to troubleshoot Oracle connectivity issues in general.

Skip navigationOracle Community DirectoryOracle Community FAQLog inRegisterMy Oracle Support Community (MOSC)SearchSearchCancelGo Directly To Oracle Technology Network CommunityMy Oracle Support CommunityOPN Cloud ConnectionOracle Employee CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: Ora-12154: Tns:could Not Resolve The Connect Identifier Specified This added some registry keys under HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE. SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) C:\>type C:\Oracle\Network\Admin\tnsnames.ora # tnsnames.ora Network Configuration File: C:\Oracle\network\admin\tnsnames.ora # Generated by Oracle configuration tools. a fantastic read If it is absolutely necessary to stick to the 10G version of the client (it shouldn't be), refer to the following:

For 32-BIT Oracle Client:


Re: ORA-12154: TNS:could not resolve the connect identifier specified 509395 Aug 4, 2006 2:33 PM (in response to orafad) That's an answer, but not a good one. How to typeset a system of linear equations in LaTeX? EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) ORA92 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS AS I am new to this I have absolutely no idea how check it.

Ora-12154: Tns:could Not Resolve The Connect Identifier Specified

Are you using the same login/password that you use when you start SQL*PLUS? The System DNS definition for Oracle is named: bbpdwhp.2. Sap Kb 0001198150 Re: ORA-12154: TNS:could not resolve the connect identifier specified 522964 Jul 13, 2006 8:45 AM (in response to 429733) Hello! Re: ORA-12154: TNS:could not resolve the connect identifier specified orafad Jul 13, 2006 9:34 AM (in response to 522964) One thing sticks out here, maybe one of the common configuration mistakes.

What are the servers we need to add in that server group? http://ogdomains.com/crystal-reports/crystal-reports-error-91.php Get the Complete Oracle SQL Tuning Information The landmark book "Advanced Oracle SQL Tuning The Definitive Reference" is filled with valuable information on Oracle SQL Tuning. Like Show 0 Likes(0) Actions 1 2 3 4 5 6 Previous Next Go to original post Actions About Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS I too have a similar problem.

We run lots of crystal reports(1000's) that pull data from an oracle back end. Re: ORA-12154: TNS:could not resolve the connect identifier specified 531112 Aug 31, 2006 3:42 PM (in response to 495468) Hi, Were you able to solve this problem? I installed Oracle Client 10.2.04 64bit, then tried 10.2.01 32bit and although the Oracle-Connect- and ODBC-Test were successful (32+64bit), I couldn't connect via ODBC from MS Excel to the database. http://ogdomains.com/crystal-reports/crystal-reports-error-229.php Refer SAP KB 0001198150 on how to change the environment variables.Thank you,Sri 1 Likes 1 View this answer in context 5 replies Share & Follow Privacy Terms of Use Legal Disclosure

My back end is Oracle 10g and VB.NET as front end. Install 64bit 10.2.03 upgrade - Select the correct Oracle Home.

However, It is strongly recommended to upgrade to Oracle 11G Release 1 version of Client tools (Build: we are using BI 4.0 sp2 .

All rights reserved.

I create a project and add a crystal report, then I go to database and click database expert. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed I have no doubt many will agree. asked 1 year ago viewed 211 times Upcoming Events 2016 Community Moderator Election ends in 3 days Linked 11 Oracle ORA-12154: TNS: Could not resolve service name Error? 3 VS2010 +

Animate finding the middle How to concentrate during conference talks where the quality of the presentation is poor? Then I tried the Oracle Client 11.2 32bit and then was successful installing it, testing the connection and establishing a ODBC-connection from MS Excel. Thanks for your help Report message to a moderator Re: Oracle + Crystal Reports on Windows 7 64 Bit Machine [message #600832 is a reply to message #492689] More about the author The following bug has been filed to correct this behavior: Bug 3807408

We installed both 32 Bit and 64 bit Oracle Clients on the server and checked the TNS Names. Re: ORA-12154: TNS:could not resolve the connect identifier specified 540384 Apr 23, 2007 8:27 AM (in response to 523988) I can confirm this. But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be able to connect to the database on NT. I did this with both versions9 and 2008.

Re: ORA-12154 error plz help me 458726 Apr 26, 2006 12:50 PM (in response to 508936) Triple post? There is a bug in regarding 64 bit connections that is solved in patch set (The server also needs to be at least Report message to a moderator says: October 7, 2013 at 11:56 pm I was facing the same issue onto server… We installed oracle 11g Client into the C:/ drive. Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog

Failed to open the connection.

Does its directory contain brackets? A frequent cause is missing/wrong entry in tnsnames.ora file. Basically, If error says that tns name cant be found, this is what you should look into. Details: Database Vendor Code: 12154, refers to the TNS error ORA-12154: TNS-12154 TNS: Could not resolve service nameCause: The service name specified is not defined correctly in the TNSNAMES.ORA file.