Ora-12545 Error Rac
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 ora-12545 connect failed because target host Scripts Ion Excel-DB Don Burleson Blog
ora 12545 error solution ORA-12454: connect failed because target host or object does not ora-12545 sqlplus exist 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 ora-12454: 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 fileOra-12545 Network Transport
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 password I created right after creating the database.Please advise on how I can get this to work? Ans
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
Ora-12545 Connect Failed Because Target Host Or Object Does Not Exist (dbd Error Ociserverattach)
can not post a blank message. Please type your message and try again. ora 12545 connect failed toad More discussions in Real Application Clusters All PlacesDatabasePerformance & AvailabilityReal Application Clusters This discussion is archived 3 Replies Latest how to resolve ora-12545 error reply on May 15, 2008 6:22 AM by Billy~Verreynne ORA-12545 While connecting to RAC nodes 569701 May 14, 2008 2:59 AM Hi all, Env: 10gR2 on Solaris 10 I have new rac http://www.dba-oracle.com/t_ora_12454_connect_failed_because_target_host_or_object_does_not_exist.htm with 2 nodes. I have created a service 'testing' on both nodes [SHCL1DR1]srvctl status service -d SHCL1DR -s testing [SHCL1DR1]Service testing is running on instance(s) SHCL1DR1, SHCL1DR2 The database is in shared server mode When i try to connect from the client machine at times i get ORA-12545 and i get connected sometimes. C:\WINNT>sqlplus system@rac_dev SQL*Plus: Release 9.2.0.1.0 - Production on Wed May https://community.oracle.com/thread/657348 14 11:28:01 2008 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Enter password: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options SQL> select sysdate from dual; SYSDATE --------- 14-MAY-08 SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options C:\WINNT>sqlplus system@rac_dev SQL*Plus: Release 9.2.0.1.0 - Production on Wed May 14 11:43:51 2008 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Enter password: ERROR: ORA-12545: Connect failed because target host or object does not exist Enter user-name: system Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: C:\WINNT> C:\WINNT>sqlplus system@rac_dev SQL*Plus: Release 9.2.0.1.0 - Production on Wed May 14 11:47:20 2008 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Enter password: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options SQL> select instance_name from v$instance; INSTANCE_NAME ---------------- SHCL1DR1 SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production With the Partiti
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 http://it.toolbox.com/blogs/david/intermittent-ora12545-when-trying-to-connect-to-rac-database-26152 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 connect failed because 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, 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 "orc
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich Locutus Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk Adrian_Grigoriu bluesguyAZ59 numbersguyPA COMPANIES EdgeWave Sophos Pivotal CRM Wave Direct View All Topics View All Members View All Companies Toolbox for IT Topics Database Blogs Intermittent ORA-12545 When Trying To Connect To RAC Database David Yahalom Jul 23, 2008 | Comments (2) Tweet 0 Please Sign In or Register to like this blog. Well, got another RAC tidbit for you today. I've been doing some very interesting RAC installations in the past few weeks and came across several "bugs" (or "random features" in Oracle-tongue :) I felt like sharing. So, you have a brand new 10g RAC cluster installed and when you try to connect using OCI (probably JDBC thin as well) only to recieve intermittent ORA-12545 errors. The client will connect fine every other attempt or so. This error happens when you enable server side load balancing but the client does not have domain address / DNS search function setup (or valid /etc/hosts file) so it cannot translate a hostname to a proper IP address. The solution is simple, make sure that the client from which you are trying to connect is able to resolve all the hostnames in your RAC installation. Either via registering the nodes in a DNS server or by updateding the /etc/hosts file (remember, Windows also has an /etc/hosts file under \system32\drivers\etc\hosts). I've seen many DBAs forget that for server-side LOB you need to be able to resolve each cluster node hostname from the client EVEN when you only use IPs in your TNSNAMES.ORA entries. Even without server-side LOB, it's good practice to be able to resolve RAC hostnames from the client. This isn't actually a bug, it's by-design and if you understand they way server-side LOB works in RAC you'll see why the client has to be able to resolve RAC hostnames to IP addresses. David YahalomSenior Project Manager, CTOMy personal website Read 2 comments Popular White Paper On This Topic The Impact and Value of HCM MoreWhitePapers 2 Comments USER_2397782 Mar