Ora 12545 Error
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! ora-12545 connect failed because target host Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog ora-12545 sqlplus
ORA-12545: Connect failed becauseOra-12545 Network Transport
target host or object does not exist tips Oracle Error Tips by Burleson Consulting Question: I have Oracle 9i installed on my local Windows
Ora-12454: Connect Failed Because Target Host Or Object Does Not Exist
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 ora 12545 connect failed toad 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: 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 debuSQL 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
Ora-12545 Utl_http
Ion Excel-DB Don Burleson Blog
ora-12545 connect failed because target host or object does not exist (dbd error ociserverattach) ORA-12454: connect failed because target host or object does not exist ora-12545 toad tips Oracle 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: http://www.dba-oracle.com/t_ora_12545_connect_failed.htm 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 http://www.dba-oracle.com/t_ora_12454_connect_failed_because_target_host_or_object_does_not_exist.htm the host name to 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 twhere for a quick overview of the site Help Center Detailed answers to any questions you might have http://stackoverflow.com/questions/18252635/ora-12545-connect-failed-because-target-host-or-object-does-not-exist-no-erro Meta Discuss the workings and policies of this site About Us http://stackoverflow.com/questions/28847710/ora-12545-oracle-sid-suddenly-stopped-working 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 Overflow Community Stack Overflow is a community of 6.2 million programmers, just connect failed 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 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 connect failed because 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"} 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
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 more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack 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 : Oracle SID Suddenly Stopped working up vote 2 down vote favorite I have a baffling problem. I have an Oracle 11g set up on Linux that was working fine. I was able to connect remotely from other machines using a SID based connection string such as sqlplus myschema@192.168.184.102:1521:orcl then for some inexplicable reason it stopped working. I'm not sure what I or someone else jiggled loose. now i'm only able to connect remotely using a SERVICE_NAME or TNSNAME based methods sqlplus myschema@192.168.184.102:1521/orcl sqlplus myschema@ORCL Both work and this would be fine and well, but I have applications that rely on SID connection pattern that I can change. Could some kind soul help me figure out what I'm missing Below is my configuration: LISTENER.ORA: [oracle@dbora112 ~]$ cat /opt/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora # listener.ora Network Configuration File: /opt/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = dbora112)(PORT = 1521)) ) ) ADR_BASE_LISTENER = /opt/u01/app/oracle LISTENER STATUS: [oracle@dbora112 ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-MAR-2015 14:50:05 Copyright (c) 1991,