Oracle Odbc Error 12545
Contents |
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 page. Please enter a title. You can not post a blank message. Please type your message and try again. ora-12545 connect failed because target host More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 1 2 ora 12545 error solution 3 Previous Next 43 Replies Latest reply on May 8, 2013 4:07 PM by user12069648 Oracle error ora-12545 Joseph Dec 28, 2012 6:13
Ora-12545 Network Transport
PM Hello i have a problem to connect my database error ora-12545 Connect failed because target host or object does not exist I checked on the forums for similar error tried all recommandation like check hosts file, ping
Ora-12545 Sqlplus
server ... but nothing My connection is like this i have one oracle db server on a RHEL 5.4 i have one oracle client on another RHEL 5.4 i tried to connect to the db via the client but it does not work i have configured my connect string (orcl) tnsping work : tnsping orcl Still i cannot connect to db server here is another thing when i type sqlplus the prompt comes for username after password and ora 12545 connect failed toad then i got error ora-12545 Connect failed because target host or object does not exist but when i connect like this : user/pass@orcl it brings me back to shell prompt without giving error** like it logs in and logs out just after Is there any log i should activate or check ? What should be done to correct this ? Any idea would be appreciate ? Thanks 28635Views Tags: none (add) 12545Content tagged with 12545, existContent tagged with exist, hostContent tagged with host, notContent tagged with not, oraContent tagged with ora, targetContent tagged with target This content has been marked as final. Show 43 replies 1. Re: Oracle error ora-12545 EdStevens Dec 28, 2012 6:20 PM (in response to Joseph) Joseph wrote: Hello i have a problem to connect my database error ora-12545 Connect failed because target host or object does not exist I checked on the forums for similar error tried all recommandation like check hosts file, ping server ... but nothing My connection is like this i have one oracle db server on a RHEL 5.4 i have one oracle client on another RHEL 5.4 i tried to connect to the db via the client but it does not work i have configured my connect string (orcl) tnsping work : tnsping orcl Still i cannot connect to db server here is another thing when i type sqlplus the
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion
Ora-12454: Connect Failed Because Target Host Or Object Does Not Exist
Excel-DB Don Burleson Blog
ora 12545 database link ORA-12454: connect failed because target host or object does not exist tips Oracle ora-12545: connect failed because target host or object does not exist (dbd error: ociserverattach) Error Tips by Stephanie F The Oracle docs note this on the ora-12454 error: ORA-12545: Connect failed because target host or object does not exist Cause: The address specified https://community.oracle.com/thread/2482773 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 http://www.dba-oracle.com/t_ora_12454_connect_failed_because_target_host_or_object_does_not_exist.htm a numeric IP address and try again. On Oracle DBA Forums, a user posts about having problems connecting on local workstation options to a new database. Below are the specifics of the question, as well as the original conflicts with ORA-12545: Question I have Oracle 9i installed on my local Windows XP workstation that 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 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: The replier advised two actions to begin resolving ORA-12545, starting by: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 http://stackoverflow.com/questions/18252635/ora-12545-connect-failed-because-target-host-or-object-does-not-exist-no-erro Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack https://bytes.com/topic/oracle/answers/704568-ora-12545-connect-failed-because-target-host-object-does-not-exist Overflow Community Stack Overflow is a community of 6.2 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 connect failed object does not exist - No 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 Connect failed because target host or object does not exist"} 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 a
+ Ask a Question Need help? Post your question and get tips & solutions from a community of 418,615 IT Pros & Developers. It's quick & easy. ORA-12545: Connect failed because target host or object does not exist P: 18 laconicamit HI!, Using SQL+, when i try to connect to a server giving RAC_srv as service name. It get connected, However sometimes it throws me following error. ORA-12545: Connect failed because target host or object does not exist But when I try to re-connect it get successfullt connected. My tns entries are fine and I am able to connect to the both of RAC nodes. Has anynody faced this type of problem? Does anybody had any solution for it. Thanks, Sep 7 '07 #1 Post Reply Share this Question 6 Replies Expert 100+ P: 2,368 amitpatel66 HI!, Using SQL+, when i try to connect to a server giving RAC_srv as service name. It get connected, However sometimes it throws me following error. ORA-12545: Connect failed because target host or object does not exist But when I try to re-connect it get successfullt connected. My tns entries are fine and I am able to connect to the both of RAC nodes. Has anynody faced this type of problem? Does anybody had any solution for it. Thanks, 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. Sep 7 '07 #2 reply Expert 5K+ P: 8,127 debasisdas it also might happen that the oracle service or the listener sevice in the service got hanged or the server was rebooted while u were connected. Sep 7 '07 #3 reply P: 18 laconicamit ORA-12545: Connect failed because target host or object does not e