12545 Oracle Error
Contents |
the node specified. For example: when the listener has not been started on the node, if the node address has been specified incorrectly, oracle error 12545 encountered or a firewall blocks access. How to fix it[edit] This message occurs
Oracle Error 12154
when the listener on the remote node cannot be contacted. Did you add the host name and IP in
Oracle Error 12162
your DNS server? You can try tracing the path or the route a connection is taking from the client to the server. If it encounters an error, then it returns
Oracle 12545 Connect Failed
the error stack which gives us more information when compared to an cryptic one line error. Execute the following: trcroute host_name This will help you find the problem and fix it. The problem may fall into one of the following areas: Check TNSNAMES.ORA: The TNSNAMES.ORA may contain a wrong address. Check the host and port have been specified correctly. Check oracle ora 12545 the details against the LISTENER.ORA file. Check the remote node: Check if the listener has been started on the remote node. Check the status with the STATUS command of the listener control utility (lsnrctl): lsnrctl lsnrctl> status listener_name listener_name is the name of the listener defined in the listener.ora file. If you have not changed the listener name, then it would be called LISTENER. If the listener has not been started, start it with the command: lsnrctl> start listener_name You can check if the fix worked by executing tnsping. It should return an "OK" message if the TNSPING has been successful. Retrieved from "http://www.orafaq.com/wiki/index.php?title=ORA-12545&oldid=9517" Category: Errors Navigation menu Views Page Discussion Edit History Personal tools Log in / create account Site Navigation Wiki Home Forum Home Blogger Home Site highlights Blog Aggregator FAQ's Mailing Lists Usenet News RSS Feeds Wiki Navigation Categories Recent changes Random page Help Search Tools What links here Related changes Special pages Printable version Permanent link Page information This page was last modified on 23 June 2008, at 10:33. Privacy policy About Oracle Wiki Disclaimers
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle oracle tns 12545 Books Oracle Scripts Ion Excel-DB Don Burleson Blog ora-12545 connect failed because target host
ORA-12545: Connect failed because target host ora-12545 sqlplus or object does not exist tips Oracle Error Tips by Burleson Consulting Question: I have Oracle 9i installed on my local Windows XP workstation that http://www.orafaq.com/wiki/ORA-12545 will be used for local development only. Now I am trying to create a database and using OEM Database Configuration Assistant. I put in FirstDB for the Global Database Name and put in FirstDB for the SID. I completed the wizard and set up my tnsnames.ora file with the SID and hostname. Then I tried http://www.dba-oracle.com/t_ora_12545_connect_failed.htm to connect using OEM with the Sys login and it says: ORA-12545:Connect failed because target host or object does not exist. Should I put in localhost or 127.0.0.1 for my Global Database Name? I assume I connect as Sys or System and the password I created right after creating the database. Please advise on how I can get this to work? Answer: Use oerr to look up the ORA-12545 error: ORA-12545: Connect failed because target host or object does not exist Cause: The address specified is not valid, or the program being connected to does not exist. Action: Ensure the ADDRESS parameters have been entered correctly; the most likely incorrect parameter is the node name. Ensure that the executable for the server exists (perhaps "oracle" is missing.) If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the host name to a numeric IP address and try again. I would start to debug a ORA-12545 error with these steps: making sure there 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 http://stackoverflow.com/questions/18252635/ora-12545-connect-failed-because-target-host-or-object-does-not-exist-no-erro Stack Overflow the company Business Learn more about hiring developers or posting ads with http://www.oracledistilled.com/oracle-database/oracle-net/ora-12545-connect-failed-because-target-host-or-object-does-not-exist/ us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA-12545: Connect failed because target host or object does not exist - No oracle error error on System.Data.OracleClient up vote 6 down vote favorite 1 Can't believe I am having to ask this question, but I cannot for the life of me connect to an Oracle 11g database. The following works while using System.Data.OracleClient - but obviously this is depreciated. When using the exact same code but using Oracle.DataAccess.OracleClient I get the following error {"ORA-12545: Connect failed because target host or object does not exist"} 12545 connect failed Here is my code using (OracleConnection con = new OracleConnection("Data Source=orac;User Id=SYSTEM; Password=Pass;")) { con.Open(); Console.WriteLine("Connection opened"); OracleCommand cmd2 = new OracleCommand("SELECT * FROM SYSTEM.TABLE", con); OracleDataReader oracleDataReader = cmd2.ExecuteReader(); while (oracleDataReader.Read()) { Console.WriteLine(oracleDataReader[0]); } } Could anyone help me out with what I am doing wrong? I had to change the program to be 32 bit for the Oracle.DataAccess.dll to load. Is this even the correct library to be using??? Thanks EDIT tnsnames.ora file as follows: # tnsnames.ora Network Configuration File: C:\app\UserName\product\11.2.0\dbhome_3\network\admin\tnsnames.ora # Generated by Oracle configuration tools. ORAC = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orac.example.com) ) ) LISTENER_ORAC = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522)) UPDATE I have tried connecting using Oracle Sql developer. This works so long as I use the TNS connection type, but doesn't work if I use the Basic connection type. Also I've noticed that in my services there are 2 called OracleOraDb11g_home1TNSListener OracleOraDb11g_home2TNSListener The orac dbhome is home3 I believe, could this be the issue?? If so does anyone know how I would go about fixing it? Thanks UPDATE In HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ there are two properties (Default) and inst_loc. There are a few folders two of
(13) Performance (2) SecureFiles and Large Objects (1) Security (1) Utilities (1) OCI/OCCI (1) Internals (1) Grid Control (19) TimesTen (14) Linux (9) Java (13) JDBC (8) JavaFX (4) Windows (5) VirtualBox (4) Grid Infrastructure (4) NetBeans (2) Berkeley DB (2) JDeveloper (2) Golden Gate (2) Oracle Fusion Middleware (1) Weblogic (1) Video (1) MySQL (1) Cloud Control (1) announcements (1) ORA-12545: Connect failed because target host or object does not exist by Eric Jenkinson on July 14, 2010 Categories: Errors,Network Tagged: Error, ORA-12545, trace Connectivity errors are common questions on Oracle related forums and in many cases they are highly misunderstood by the poster of the questions and some responders. This aim of this document is to show a method for diagnosis and resolution to a scenario in which an ORA-12545 is raised during the connection to a database. Problem You attempt a connection to database through SQL*Plus and you receive the following error. [oracle@ora2 ]$ sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 30 10:29:27 2010 Copyright (c) 1982, 2009, Oracle. All rights reserved. SQL> connect hr@proddb Enter password: ERROR: ORA-12545: Connect failed because target host or object does not exist SQL> Diagnosis process If you are unfamiliar with the error use the oerr utility to get more information on the error. [oracle@ora2 ]$ oerr ora 12545 12545, 00000, "Connect failed because target host or object does not exist" // *Cause: The address specified is not valid, or the program being // connected to does not exist. // *Action: Ensure the ADDRESS parameters have been entered correctly; the // most likely incorrect parameter is the node name. Ensure that the // executable for the server exists (perhaps "oracle" is missing.) // If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the // host name to a numeric IP address and try again. [oracle@ora2 ]$ Nowhere in the error description above is any mention of this problem being related to the listener. This error is due to the inability of TNS to contact the host in th