Intermittent Ora-12545 Error
Contents |
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 <
Ora-12545 Connect Failed Because Target Host
Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design ora 12545 error solution MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Ramnath.Awate JoeTorre Andrew.S.Baker bracke Locutus Dennis Stevenson Craig
Ora-12545 Sqlplus
Borysowich Richard DukeGanote mircea_luca iudithm Clinton Jones Nikki Klein AbhaiTripathi Iqbalyk bluesguyAZ59 blrvenkat jakarman COMPANIES GeoTrust Juniper Networks HP, Voltage Security and ... Wave Direct View All Topics View All Members View All Companies Toolbox for IT how to resolve ora-12545 error 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 ora-12454: connect failed because target host or object does not exist 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 Thi
:: Show Polls :: Message Navigator E-mail to friend ORA-12545: Connect failed because target host or object does not exist [message #294931] Sun, 20 January 2008 23:06 jkirankumar_307@yahoo.com Messages: 12Registered: April 2007 Junior Member Hi All, I created a database link
Ora-12545 Network Transport
as follows create database link WEBDB_LIVE connect to SEI using '(DESCRIPTION = (ADDRESS_LIST = (FAILOVER ora 12545 connect failed toad = ON) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.3.201)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.3.200)(PORT = 1521)) ) (CONNECT_DATA
Ora-12545: Connect Failed Because Target Host Or Object Does Not Exist (dbd Error: Ociserverattach)
= (SERVICE_NAME = WHPROD) ) )'; I am getting this error, but finally it getting succedded after sevaral attempts. how to avoid this error.. My database are in RAC environment. ORA-12012: error on auto execute of job http://it.toolbox.com/blogs/david/intermittent-ora12545-when-trying-to-connect-to-rac-database-26152 142 ORA-12545: Connect failed because target host or object does not exist ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2254 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2460 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 My database version is : 10.2.0.3 OS : IBM AIX 5.3 ML 05 even i am getting this error from my client machine. I am sending the tns entries . WHPROD = (DESCRIPTION = (LOAD_BALANCE = ON) (FAILOVER http://www.orafaq.com/forum/t/95924/0/ = ON) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.3.201)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.3.200)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME =WHPROD) (FAILOVER_MODE= (TYPE=select) (METHOD=basic) (RETRIES=20) (DELAY=15) ) ) ) Any body can help me.... Regards, Kiran Report message to a moderator Re: ORA-12545: Connect failed because target host or object does not exist [message #294942 is a reply to message #294931] Sun, 20 January 2008 23:35 Michel Cadot Messages: 63892Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator Quote: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. Regards Michel Report message to a moderator Re: ORA-12545: Connect failed because target host or object does not exist [message #294959 is a reply to message #294931] Mon, 21 January 2008 00:49 jkirankumar_307@yahoo.com Messages: 12Registered: April 2007 Junior Member Hi Michel, I am able to connect some times. The connection establishment is intermit
Tasks with Jobs and Alerts 8 Transferring Data with SSIS 9 Monitoring Tools 10 Maintenance http://andrewfraserdba.com/2011/05/09/intermittent-ora-12545-with-oracle-rac-database/ Plans 11 Replication 12 High Availability Appendix List of Differences between http://stackoverflow.com/questions/38715453/getting-intermittent-ora-12545-error SQL Server and Oracle Introduction to PL/SQL by Example Performance Tuning training notes and code Andrew on LinkedIn Home › RAC › Intermittent ORA-12545 with oracle RAC database Intermittent ORA-12545 with oracle RAC database Posted on 9 May 2011 by Andrew Fraser — No connect failed Comments ↓ Problem: Client suffers intermittent ORA-12545 "Connect failed because target host or object does not exist" trying to connect to oracle RAC database. Solution: Edit server side (not client side) listener.ora and tnsnames.ora files to have fully qualified hostnames. Thanks to David Yahalom for flagging this - it doesn't appear to be covered connect failed because in metalink/my oracle support. RAC servers were configured to resolve each others host names with - so ‘racserver1' resolved to the same IP address as did the fully qualified name ‘racserver1.admin.mycompany.com'. Client machine (web servers in my case) were not configured in that way. So they could resolve ‘racserver1.admin.mycompany.com' ok, but could not resolve ‘racserver1'. You might think that simply specifying the fully qualified hostnames in the client connect string (only) would be enough to resolve this. But no. Server side load balancing will every so often redirect the client to a new hostname. The client has to be able to resolve that new hostname, or it will report an ORA-12545. And that new hostname is supplied by the server, based on what is in the server listener and tnsnames settings. This behaviour is the default (at least in Oracle 11gR1). This is especially likely with web servers, where security considerations might mean they don't see exactly the same DNS as other
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 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up getting intermittent ORA-12545 error up vote 0 down vote favorite I am running a monitoring site developed in yii framework using xampp on a windows server machine to check the health of databases. Normally everything works fine but sometimes it gives me the following error: Code: 12545|Message: CDbConnection failed to open the DB connection: SQLSTATE[HY000]: pdo_oci_handle_factory: ORA-12545: Connect failed because target host or object does not exist (ext\pdo_oci\oci_driver.c:635) I check ping and everything is fine, tns_ping is working, other users can logon to database and use it. but i get the above error. PHP Version 5.5.28 Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production Oracle Instant Client - 11.2.0.1.0 Windows Server 2012 R2 Standard PDO Driver for OCI 8 and later enabled Query used to check if we can connect to database and query it select count(*) from dual any help will be appreciated php oracle pdo yii share|improve this question asked Aug 2 at 8:31 Sarwar 162 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote I assume you are using yii 1 but nevertheless you should try those steps in fixing the error: In most cases defining the database in your main.php fixes the problem, so try adding: 'connectionString'=>'oci:dbname=mydb', Disable those extensions: php_pdo_oci8.dll and php_oci8.dll in your php.ini file and leave only the needed one for your environment: php_pdo_oci.dll. Definitely update your Oracle to 10 or above because according to my experience and some internet forums Oracle client 9 can make some troubles with php 5.1 or above. Not in every scenario but I think it's worth the update. share|improve this answer answered Aug 2 at 8:41 g9m29 261114 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using