Failed To Open Service Tns Listener Error 1060
and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing 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 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 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 An
start. [message #557883] Sat, 16 June 2012 23:30 dsnaveen Messages: 3Registered: June 2012 Junior Member Hello huys, Please need your help in resolving the error C:\Documents and Settings\naveen>lsnrctl start PLSExtProc LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 17-JUN-2012 11:41 :02 Copyright (c) 1991, 2006, Oracle. All rights reserved. Starting tnslsnr: please wait... Failed to open service
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle http://www.dba-oracle.com/t_windows_install_tips.htm Books Oracle Scripts Ion Excel-DB Don Burleson Blog http://dbaforums.org/oracle/index.php?showtopic=18108
Install Oracle on Windows Tips Oracle Database Tips by Burleson Consulting July 30, 2015 The surest way to avoid issues during Oracle installs, patches, and upgrades is to carefully read the release notes and failed to installation guides. There are several things to look for when installing and patching Oracle on Windows. Some of these tips and instructions are in the Oracle documentation (perhaps buried, but there!), and some are not. The main tips for installing Oracle on Windows includes: - Stop the Oracle services first before any upgrade or patch.- failed to open Stop the Distributed Transaction Process service before any upgrade or patch.- Stop all antivirus before any upgrade or patch.- Stop backup agents (Backup Exec, DataProtector, etc) before any upgrade or patch.- Use tasklist /m filename.dll to find process IDs for open DLLs. - The ORACLE_HOME environment variable setting can cause TNS Protocol Adapter errors, etc. Oracle says don't set this at all. - The last product you install will be first in the PATH. - You must manually start listener with LSNRCTL to create the new Listener Service after an install or upgrade.- If the Installer or OPatch still complains about an open DLL, even after you have killed the related process, try logging off and logging back on. - If all else fails when the Installer complains about an open DLL, set the Oracle Services to Manual and reboot the server! Now we will take the list and review each item in a bit more detail.Stop all Oracle Related Services FirsPost #1 Member Group: Members Posts: 13 Joined: 26-May 09 Member No.: 40,769 Hi, I have successfully installed ORACLE 10.2(SID= ANK) and uninstalled 10.1(SID= ANB) on same machine(Hostname INLD50057853A port 1521) .but I am not able see listener services in windows service box for ANK I only see previous one, though I have uninstalled 10.1 with proper steps.Below are only services I can see in my windows box1) OracleANB101TNSListener (not able to start this service...it gives some error)2) OracleANK102iSQL*Plus (not able to start this service also)3) OracleOraDb10g_home1TNSListener (not able to start this also) Could you please let me know what can I do in such case now.If I do command lsnrctl it gives me successfull messageC:\>lsnrctlLSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 01-JUN-2009 11:53:10Copyright © 1991, 2005, Oracle. All rights reserved.Welcome to LSNRCTL, type "help" for information.If I do command tnsping ANK.WORLD it give me error messageC:\>tnsping ANK.WORLDTNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 01-JUN-2009 11:52:03Copyright © 1997, 2005, Oracle. All rights reserved.Used parameter files:c:\oracle\ANK\102\network\admin\sqlnet.oraTNS-03505: Failed to resolve nameIf I do commant sqlplus /nolog it saysC:\>sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 1 11:55:06 2009Copyright © 1982, 2005, Oracle. All rights reserved.SQL> conn sys/your_pass@ank.world as sysdbaERROR:ORA-12154: TNS:could not resolve the connect identifier specifiedmy lsnrctl.log saysLSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 01-JUN-2009 11:59:44Copyright © 1991, 2005, Oracle. All rights reserved.Starting tnslsnr: please wait...TNS-12560: TNS:protocol adapter errorsending you listener.ora , namespace.ora and sqlnet.oraC:\oracle\Network\adminlistener.ora################# Filename......: listener.ora# Created.......: created by SAP AG, R/3 Rel. >= 6.10# Name..........:# Date..........:# @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#3 $################ADMIN_RESTRICTIONS_LISTENER = onLISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC) (KEY = ANK.WORLD) ) (ADDRESS= (PROTOCOL = IPC) (KEY = ANK) ) (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = INLD50057853A) (PORT = 1521) ) )STARTUP_WAIT_TIME_LISTENER = 0CONNECT_TIMEOUT_LISTENER = 10TRACE_LEVEL_LISTENER = OFFSID_LIST_LISTENER = (SID_LIST = (