Oracle Error 12545 Encountered
Contents |
exist If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. ora-12545 connect failed because target host To start viewing messages, select the forum that you want to visit from the ora 12545 error selection below. Results 1 to 9 of 9 Thread: ORA-12545: Connect failed because target host or object does not exist Tweet Thread ora-12545 network transport Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 01-13-04,01:33 #1 preetikate View Profile View Forum Posts Registered User Join
Ora-12545 Sqlplus
Date Jan 2004 Posts 84 Unanswered: ORA-12545: Connect failed because target host or object does not exist Hi, I am getting error while trying to run exp from database A to database B using exp user/pwd@tns using a script. However , when I run the export at prompt as below it runs well $exp user/pwd@tns but I wish to do the export using script exp_tab.ksh and exp_tab.par. When trying to ora 12545 connect failed toad do the same thing from script it fails with the error given below. I am unable to get the cause. The ksh and par files follow. Export: Release 8.1.7.0.0 - Production on Tue Jan 13 11:57:41 2004 (c) Copyright 2000 Oracle Corporation. All rights reserved. EXP-00056: ORACLE error 12545 encountered ORA-12545: Connect failed because target host or object does not exist EXP-00000: Export terminated unsuccessfully exp_tab.ksh --------------- mknod exp_tab.dmp p compress < exp_tab.dmp > exp_tab.dmp.Z & exp parfile=exp_tab.par exp_tab.par -------------- userid=user/pwd@tns file=exp_tab.dmp rows=y buffer=10240000 Compress=n INDEXES=y GRANTS=n tables=(owner.TABLE_NAME) CONSISTENT=N log=exp_tab.log Reply With Quote 01-13-04,06:42 #2 satish_ct View Profile View Forum Posts Visit Homepage Registered User Join Date Nov 2003 Location Bangalore, INDIA Posts 333 HI, 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 . SATHISH . Reply With Quote 01-13-04,07:07 #3 preetikate View Profile View Forum Posts Registered User Join Date Jan 2004 Posts 84 No the problem got resolved when I removed the userid parameter from the parameter file and ran the script as below $exp_tab.ksh and supplied user/pwd@tns when it asked... The parameter file was not taking the tns entry for the remote database.. not sure why... Reply With Quote 01-1
the node specified. For example: when the listener has not been started on the node, if the node address has been specified incorrectly, how to resolve ora-12545 error or a firewall blocks access. How to fix it[edit] This message occurs
Ora 12545 Database Link
when the listener on the remote node cannot be contacted. Did you add the host name and IP in
Ora-12454: Connect Failed Because Target Host Or Object Does Not Exist
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 http://www.dbforums.com/showthread.php?977769-ORA-12545-Connect-failed-because-target-host-or-object-does-not-exist 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 http://www.orafaq.com/wiki/ORA-12545 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 https://community.oracle.com/community/developer/search.jspa?q=ORA-12545 JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it http://searchoracle.techtarget.com/answer/Resolving-error-ORA-12545 enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle connect failed VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace connect failed because depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x
Topic Database design Database Admin View All Cloud infrastructure Availability Backup and recovery Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Applications View All Enterprise and business performance management Implementing and upgrading Oracle apps E-Business Suite Fusion applications Hyperion JD Edwards (JDE) PeopleSoft Siebel and Oracle CRM Data Mgmt View All BI (business intelligence) Data quality Data warehousing Metadata Database Admin View All Cloud infrastructure Availability Backup and recovery Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Development View All BPEL in Oracle Open Source SQL Java / J2EE Stored procedures XML PL/SQL Fusion View All Oracle and BEA Application Server Data and application integration SOA (service-oriented architecture) Infrastructure View All Cloud computing infrastructure Exadata and Exalogic Grid computing Oracle on Linux Operating system Oracle hardware decisions Virtual machine Oracle management View All certification Oracle acquisitions Business process management Market analysis DBA jobs training and certification Small businesses Regulatory compliance Outsourcing Oracle on demand and SaaS Oracle strategy and product roadmap Oracle support services Oracle vs. SAP Oracle Web 2.0 Sun-Oracle infrastructure View All Oracle cloud computing Oracle OS Oracle virtualization Topics Archive View All Oracle DBA jobs Oracle Resources Training and certification Tutorials, tips and FAQs Please select a category Applications Data Mgmt Database Admin Development Fus