Ora-12545 Error Message
Contents |
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 Excel-DB Don Burleson Blog ora-12545 connect failed because target host
ORA-12545: Connect failedOra-12545 Sqlplus
because target host or object does not exist tips Oracle Error Tips by Burleson Consulting Question: I have ora-12545 network transport 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 ora-12454: connect failed because target host or object does not exist 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
Ora 12545 Connect Failed Toad
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 that your listener is running (lsnrctl stat) testing connectivity with ping, and then tnsping. verifying connectivity via the DNS (e.g. /etc/hosts) make sure to check your tnsnames.ora parms. Also see MOSC notes (http://support.oracle.com) on the ORA-12545 error: Note 284909.1 - Intermittent ORA-12545 When Trying To Connect To RAC Database Note 364855.1 - RAC Connection Redirected To Wrong Host/IP ORA-12545 Note 291175.1 - Clients Failing to Connect Due toSQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle ora-12545 connect failed because target host or object does not exist (dbd error ociserverattach) Books Oracle Scripts Ion Excel-DB Don Burleson Blog ora 12545 database link
ORA-12454: connect failed because target hostHow To Resolve Ora-12545 Error
or object does not exist tips Oracle Error Tips by Stephanie F The Oracle docs note this on the ora-12454 error: ORA-12545: Connect failed because target http://www.dba-oracle.com/t_ora_12545_connect_failed.htm 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 http://www.dba-oracle.com/t_ora_12454_connect_failed_because_target_host_or_object_does_not_exist.htm the protocol is TCP/IP, edit the TNSNAMES.ORA file to change 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 passwo
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 http://stackoverflow.com/questions/28847710/ora-12545-oracle-sid-suddenly-stopped-working 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 : connect failed 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 connect failed because 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, 2011, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production Start Date 04-MAR-2015 14:37:12 Uptime 0 days 0 hr. 12 min. 52 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /opt/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora Listener Log File /opt/u01/app/oracle/diag/tnslsnr/dbora112/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbora112)(PORT=1521))) Services Summary... Service "orcl" has 1 instance(s). Instance "orcl", sta