Crystal Reports Tns Protocol Adapter Error
Contents |
SAP Crystal Reports - Data ConnectivityWhere is this place located?All Places SAP Crystal Reports SAP Crystal Reports - Data Connectivity 8 Replies Latest reply: Sep 23, 2009 8:04 PM by Tuan Huynh Tweet Cannot connect to Oracle 9 (after 10g Client install) Jonathan Muir crystal report ora 12560 Sep 9, 2009 1:44 PM Currently Being Moderated I have Crystal Report XI (11.0.0.895 tns protocol adapter error sqlplus Developer Version).I have only been connecting to SQL and Oracle 9 databases, however one of our Oracle servers has been upgraded to ora-12560 tns protocol adapter error 11g 10g:- I can now access all my SQL databases, and the Oracle 10g databases without any problems however I can no longer connect to the Oracle 9 databases.I have check my ODBC connections & settings and tns protocol adapter error in oracle 11g I tested all my connections and they all worked correctly, I have even deleted and created new settings for the Oracle 9 and 10g ODBC settings. (I have 10g and 9 client installed on my pc)I get the following errors:-When trying to open a report that I had previously created:-Failed to open the connection.Details: ORA-12154: TNS:could not resolve the connection identifier specified[Database Vendor Code: 12154 ]When I try and setup a new
Tns Protocol Adapter Error Oracle 12c
connection with my ODBC connectionLogon failed.Details: S1000:[Oracle][ODBC][Ora]ORA-12560: TNS:protocol adapter error[Database Vendor Code: 12560 ]..............did manage to get it to work once, I unistalled Crystal Reports and then reinstalled it - it worked for the afternoonm but I do not want to uninstall and reinstall Crystal Reports everytime I want ot make a change to a report or I reboot. 4601Views Re: Cannot connect to Oracle 9 (after 10g Client install) Don Williams Sep 9, 2009 4:31 PM (in response to Jonathan Muir) Currently Being Moderated Hi Jonathan,This is not a CR issue. When I try and setup a new connection with my ODBC connectionLogon failed.Details: S1000:OracleODBCOraORA-12560: TNS:protocol adapter errorDatabase Vendor Code: 12560 You are having issues with the Oracle client if ODBC won't work. I believe what is happening is you are mixing Oracle runtime versions and accessing the correct location of the client. I suggest you search Oracles site on how to do this and what is required to make it work and it's limitations.And for your info Crystal Reports uses the PATH statement to find the various DB clients. So the first one in the PATH is the one CR will use. You may have to create a btach file to change this but not sure if Oracle will work without re-booting.
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development
Tns Protocol Adapter Error Windows 7
Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle ora-12560 tns protocol adapter error sqlplus instant client Scripts Ion Excel-DB Don Burleson Blog
ora-12560 tns protocol adapter error during installation ORA-12560: TNS: protocol adapter error Oracle Tips by Burleson Question: I installed Oracle 10g on my http://scn.sap.com/thread/1470447 server but there is a problem with error "ORA-12560:TNS:protocol adapter error". When I sign on I get the error "ORA-12560:TNS:protocol adapter error"... Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter password: ERROR: ORA-12560: TNS:protocol http://www.dba-oracle.com/t_ora_12560_tns_protocol_adapter_error.htm adapter error Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter password: ERROR: ORA-12560: TNS:protocol adapter error Answer by Edward Stoever: Is there a listener running? Have you run the netca program to configure and start the listener? The Oracle docs note that you should troubleshoot the ORA-12560 by tracing the connection: ORA-12560: TNS: protocol adapter error Cause: A generic protocol adapter error occurred. Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors. For further details, turn on tracing and re-execute the operation. Turn off tracing when the operation is complete. If you are running Oracle on Windows, you may fi the ORA-12560 by running the oradim utility to create a service for the listener. MOSC Note: 117976.1 offers tips for diagnosing the TNS-12560 error notCommunityOracle 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 https://community.oracle.com/thread/269600?start=45&tstart=0 JavaScript back on and reload this 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 1 2 3 4 5 6 Previous Next 84 Replies Latest reply on tns protocol Aug 4, 2010 1:51 PM by rajeysh Go to original post This content has been marked as final. Show 84 replies 45. Re: ORA-12154 error plz help me 458726 Apr 26, 2006 12:50 PM (in response to 508936) Triple post? Try: C:> sqlplus u2/u2@mat Like Show 0 Likes(0) Actions 46. Re: ORA-12154: tns protocol adapter TNS:could not resolve the connect identifier specified 509395 Jun 26, 2006 12:37 PM (in response to 452882) You may want to check out this tutorial. http://www.devshed.com/c/a/Oracle/Experience-the-Possibilities-with-Oracle-10g-Express-Edition/ For other tutorials on Oracle check out this link: http://www.angelfire.com/vt2/hodentek/ It's a shame so many people have to spend so much time trouble shooting this ORA-12154 error. Oracle guys should come out with a definitive answer. Like Show 0 Likes(0) Actions 47. Re: ORA-12154: TNS:could not resolve the connect identifier specified orafad Jun 26, 2006 2:37 PM (in response to 509395) It's a shame so many people have to spend so much time trouble shooting this ORA-12154 error.Agreed. Oracle guys should come out with a definitive answer.Dont think they can give you one. It depends on your specific installation(s) and configuration. It could be some multi-home issue or Oracle Net domain name related.... To start with, you should check which Oracle home you are using really (registry, PATH etc