Oracle Odbc Error Ora-12545
Contents |
the node specified. For example: when the listener has not been started on the node, if the node address has been specified incorrectly, ora-12545 connect failed because target host or a firewall blocks access. How to fix it[edit] This message occurs
Ora 12545 Error Solution
when the listener on the remote node cannot be contacted. Did you add the host name and IP in ora-12545 sqlplus your DNS server? You can try tracing the path or the route a connection is taking from the client to the server. If it encounters an error, then it returns ora-12545 network transport the error stack which gives us more information when compared to an cryptic one line error. Execute the following: trcroute host_name This will help you find the problem and fix it. The problem may fall into one of the following areas: Check TNSNAMES.ORA: The TNSNAMES.ORA may contain a wrong address. Check the host and port have been specified correctly. Check
Ora-12454: Connect Failed Because Target Host Or Object Does Not Exist
the details against the LISTENER.ORA file. Check the remote node: Check if the listener has been started on the remote node. Check the status with the STATUS command of the listener control utility (lsnrctl): lsnrctl lsnrctl> status listener_name listener_name is the name of the listener defined in the listener.ora file. If you have not changed the listener name, then it would be called LISTENER. If the listener has not been started, start it with the command: lsnrctl> start listener_name You can check if the fix worked by executing tnsping. It should return an "OK" message if the TNSPING has been successful. Retrieved from "http://www.orafaq.com/wiki/index.php?title=ORA-12545&oldid=9517" Category: Errors Navigation menu Views Page Discussion Edit History Personal tools Log in / create account Site Navigation Wiki Home Forum Home Blogger Home Site highlights Blog Aggregator FAQ's Mailing Lists Usenet News RSS Feeds Wiki Navigation Categories Recent changes Random page Help Search Tools What links here Related changes Special pages Printable version Permanent link Page information This page was last modified on 23 June 2008, at 10:33. Privacy policy About Oracle Wiki Disclaimers
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 ora-12545 connect failed toad your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database ora-12545: connect failed because target host or object does not exist (dbd error: ociserverattach) Discussions This discussion is archived 1 2 3 Previous Next 43 Replies Latest reply on May 8, 2013 4:07 PM by user12069648
Ora 12545 Database Link
Oracle error ora-12545 Joseph Dec 28, 2012 6:13 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 http://www.orafaq.com/wiki/ORA-12545 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 https://community.oracle.com/thread/2482773 server here is another thing when i type sqlplus the prompt comes for username after password and 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 clie
+ 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+, https://bytes.com/topic/oracle/answers/704568-ora-12545-connect-failed-because-target-host-object-does-not-exist 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 http://oracledba.bigresource.com/Instant-Client-ORA-12545-Connect-failed-because-target-host-or-object-does-not-exist-BRp06cOKX.html 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 connect failed 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 connect failed because 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 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. TNSNAMES.ora is been perfectly entered and tnsping works fine. I tried it in both ways: entered IP address and Host name. It dosen't give me any problem in connecting to the Db. However, when I make frequent connections it fetche
want to use it on localhost because i just want to study and test it.but here, the some error appeared to me. so I was so screwed up. here is the error messages and the settings Command: ~ user$ sqlplus scott tiger ERROR: ORA-12545: Connect failed because target host or object does not exist env settings: $ORACLE_HOME=/usr/local/oracle $ORACLE_SID="Oracle 10g+ASM" // I don't know what ORACLE_SID means $ORACLE_LIBRARY=/usr/local/oracle/instantclient_10_2 $DYLD_LIBRARY_PATH=$DYLD_LIBRARY_PATH:$ORACLE_HOME/instantclient_10_2 $SQLPATH=$ORACLE_HOME/instantclient_10_2 $PATH=$PATH:$SQLPATH View 1 Replies Similar Messages: Cannot Connect To Database From Remote Computer (ORA-12545) Client Tools :: Unable To Connect Database / ORA-27101 / Shared Memory Realm Does Not Exist Client Tools :: ORA-12545 Error In PL/SQL Developer In Windows 7 Client Tools :: ODBC Instant Client Oracle 10g Enterprise Manager :: Grid - Populating Target In Host? Instant Client And ODBC Drivers Oracle 10g Instant Client For Window 7 Instant Client :: LD - Can't Link With (MH-BUNDLE)? Connecting To DB Remotely Through Toad Using Oracle Instant Client? Instant Client :: Using ODBC Without Running Odbc_install.exe (no Installation) C++ Call Interface :: Instant Client 11g OCCI In MSVC6++ Windows 7 32-bit Precompilers, OCI & OCCI :: Connecting To Oracle Database With Instant Client 11.01.06 Connect To Run +ASM Instance From A Different Host? SQL & PL/SQL :: Check If Object Exist Or Not While Creating Procedure? Backup & Recovery :: Connect To Target Database Replication :: ORA-23308 / Object BABU.EMP Does Not Exist Or Is Invalid Security :: DBA_AUDIT_SESSION Failed Login For Username That Does Not Exist Client Tools :: Able To Connect From SQL-Assistant BUT Unable To Connect From SQL Developer Client Tools :: Connect Oracle Developer 6i Without Connect String Forms :: Failed To Connect To Server Enterprise Manager :: Failed To Connect To Database Instance Client Tools :: Cannot Connect Using JDBC Oracle Thin Client With (New Method)? Client Tools :: How To Connect From Client To Oracle Database In Unix S