Error Code 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, oracle error 12545 or a firewall blocks access. How to fix it[edit] This message occurs
Ora 12545 Error
when the listener on the remote node cannot be contacted. Did you add the host name and IP in ora 12545 connect failed because target host 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 ora-12545 sqlplus 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-12545 Connect Failed Toad
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
here for a quick overview of the site Help Center Detailed answers ora-12545 network transport to any questions you might have Meta Discuss the workings ora-12454: connect failed because target host or object does not exist and policies of this site About Us Learn more about Stack Overflow the company Business
Error While Trying To Retrieve Text For Error Ora-12545
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 http://www.orafaq.com/wiki/ORA-12545 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 ORA-12545: Connect failed because target host or object does not exist - No error on System.Data.OracleClient up vote 6 down vote favorite 1 Can't http://stackoverflow.com/questions/18252635/ora-12545-connect-failed-because-target-host-or-object-does-not-exist-no-erro believe I am having to ask this question, but I cannot for the life of me connect to an Oracle 11g database. The following works while using System.Data.OracleClient - but obviously this is depreciated. When using the exact same code but using Oracle.DataAccess.OracleClient I get the following error {"ORA-12545: Connect failed because target host or object does not exist"} Here is my code using (OracleConnection con = new OracleConnection("Data Source=orac;User Id=SYSTEM; Password=Pass;")) { con.Open(); Console.WriteLine("Connection opened"); OracleCommand cmd2 = new OracleCommand("SELECT * FROM SYSTEM.TABLE", con); OracleDataReader oracleDataReader = cmd2.ExecuteReader(); while (oracleDataReader.Read()) { Console.WriteLine(oracleDataReader[0]); } } Could anyone help me out with what I am doing wrong? I had to change the program to be 32 bit for the Oracle.DataAccess.dll to load. Is this even the correct library to be using??? Thanks EDIT tnsnames.ora file as follows: # tnsnames.ora Network Configuration File: C:\app\UserName\product\11.2.0\dbhome_3\network\admin\tnsnames.ora # Generated by Oracle configuration tools.
and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing http://scn.sap.com/thread/3622022 and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive connect failed ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect 12545 connect failed ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and InfrastructureOverviewApplication PlatformContent and CollaborationInterface ManagementProcess Management and IntegrationData ManagementOverviewBig Data on HadoopData WarehousingDatabase ManagementEnterprise Information ManagementIT ManagementOverviewApplication Lifecycle ManagementIT Infrastructure ManagementSecurity SoftwareOverviewApplication and IT Infrastructure SecurityIdentity, Access and Authentication ManagementBrowse by ProductAnalyticsContent and CollaborationCustomer Relationship ManagementData Ma
be down. Please try the request again. Your cache administrator is webmaster. Generated Mon, 10 Oct 2016 20:32:21 GMT by s_wx1131 (squid/3.5.20)