Oracle Error Number 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 object does not exist sqlplus or a firewall blocks access. How to fix it[edit] This message occurs
Ora-12545 Sqlplus
when the listener on the remote node cannot be contacted. Did you add the host name and IP in ora-12545 network transport 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 connect failed toad 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
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 ora-12545: connect failed because target host or object does not exist (dbd error: ociserverattach) Excel-DB Don Burleson Blog
how to resolve ora-12545 error ORA-12454: connect failed because target host or object does not exist tips OracleOra 12545 Database Link
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: The address http://www.orafaq.com/wiki/ORA-12545 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 http://www.dba-oracle.com/t_ora_12454_connect_failed_because_target_host_or_object_does_not_exist.htm 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 two actions to begin resolving ORA-12545, starting b
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 https://community.oracle.com/thread/2482773 type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 1 2 3 Previous Next 43 Replies Latest reply on May 8, 2013 4:07 PM by user12069648 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 connect failed 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 client but it does not work i have configured my connect string (orcl) tnsping work : tnsping orcl Still i cannot connect failed because connect to db 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 28632Views 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