Oracle 64-bit Windows Error 61 Unknown Error
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development tns-12560: tns:protocol adapter error tns-00530: protocol adapter error Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle how to start tns listener in oracle 11g in windows Books Oracle Scripts Ion Excel-DB Don Burleson Blog
Oracle Listener Not Starting Windows
Oracle Windows TNS error: No Listener found Oracle Database Tips by Burleson Consulting May 9, 2015
Tns-12541: Tns:no Listener Tns-12560: Tns:protocol Adapter Error Tns-00511: No Listener
Question: I'm getting a TNS "no listener" error on my Windows Oracle database when trying to connect: LSNRCTL> status Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and
Tns-00530 Protocol Adapter Error Windows 7
much of it will not work correctly without 64-bit windows error: 2: no such file or directory it enabled. Please turn JavaScript back on and reload this page. Please tns-00511 no listener windows enter a title. You can not post a blank message. Please type your message and try again. More discussions in http://www.dba-oracle.com/t_windows_tns_no_listener_error.htm General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 1 2 Previous Next 27 Replies Latest reply on Feb 3, 2013 2:23 PM by 985927 Go to original post This content has been marked as final. Show 27 replies https://community.oracle.com/thread/2490394?start=15&tstart=0 15. Re: ORA-12514: TNS:listener does not currently know of service 985927 Feb 1, 2013 11:47 PM (in response to sb92075) Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Users\Eyad>lsnrctl status LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 02-FEB-2013 02:45:22 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 2: No such file or directory Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 61: Unknown error -------------------------------------------------------------------------------------------------------------------------------------- C:\Users\Eyad>lsnrctl service LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 02-FEB-2013 02:46:02 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))
error [message #481338] Tue, 02 November 2010 10:38 patdev Messages: 56Registered: August 2008 Member Hi all, I have install 10.2.0.4 64 bit on windows 2008 http://www.orafaq.com/forum/t/162996/ 64 bit. But i am running in to problem with listener: Please http://sapnw-professional.blogspot.com/2013/06/oracle-listener-can-start-tns-12541.html help: my listener.ora fiel: LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = servername)(PORT = 1521)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ETEST) (ORACLE_HOME = D:\oracle\product\10.2.0\db_1\) (SID_NAME = ETEST) ) ) Tnsnames.ora: ETEST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL adapter error = TCP)(HOST = servername)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ETEST) ) ) error 1) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server1.NTS.rethi.com)(P ORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 61: Unknown error 2) and for tnsping from my computer: TNS12535 TNS: operation timeout. Report message to a moderator protocol adapter error Re: 64-bit Windows Error: 61: Unknown error [message #481341 is a reply to message #481338] Tue, 02 November 2010 10:47 BlackSwan Messages: 24958Registered: January 2009 Location: SoCal Senior Member is the listener OS Service running? post results from following commands set lsnrctl status lsnrctl service Report message to a moderator Previous Topic: install oracle 10g in windows 7 Next Topic: OUI-10133 : Invalid staging area ????????? Goto Forum: - SQL & PL/SQLSQL & PL/SQLClient Tools- RDBMS ServerServer AdministrationBackup & RecoveryPerformance TuningSecurityNetworking and GatewaysEnterprise ManagerServer Utilities- Server OptionsRAC & FailsafeData GuardReplicationStreams & AQSpatialText & interMedia- Developer & ProgrammerApplication Express, ORDS & MOD_PLSQLFormsReports & DiscovererDesignerJDeveloper, Java & XMLWarehouse BuilderPrecompilers, OCI & OCCI- Fusion Middleware & Colab SuiteWeblogic & Application ServerBusiness IntelligenceWebCenter Suite & PortalCollaboration & Content ManagementSOA Suite, BPEL and OWSM- ApplicationsOracle Fusion Apps & E-Business SuitePeopleSoft, JD Edwards & SiebelPrimaveraOther Application Suites- InfrastructureHardwareUnixLinuxWindowsOther Operating Systems- Open SourceProgramming InterfacesMySQL- OtherGeneralTraining & CertificationMarketplaceCommunity HangoutSuggestions & FeedbackTest- Non-English ForumsArabicDutchFrenchGermanJapanesePortugueseRussianSpanish -=] Back to Top [=- [ Syndicate this f
0 comments Error : Oracle listener cannot start and gives error return code1. Environment: OS : Windows Server 2008, DB : Oracle 11g, SAP ECC 6 .0 EHP6 Investigations : Look into logs C:\Program Files\sapinst_instdir\ERPEhP6\AS-ABAP\ORA\CENTRAL\lsnrctl.log LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 24-JUN-2013 18:33:56 Copyright (c) 1991, 2011, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 2: No such file or directory Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SIDHOST.local)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 61: Unknown error Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=GDI.WORLD))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 2: No such file or directory Resolution: Look into the usage of port . i.e Other application may using the same port. To know port usage at windows command prompt execute netstat -ano | findstr 1521 > This command gives if the port is free or its been using by any other application. If output is ESTABLISHED it means this port is used by some application and command gives process id using this port. C:\Users\Administrator>netstat -ano | findstr 1521 TCP 192.168.8.115:1521 192.168.8.115:56157 ESTABLISHED 9682 TCP 192.168.8.115:1521 192.168.8.115:56158 ESTABLISHED 9682 tasklist /SVC /FI "PID eq 9682" > This command will give you application name holding this process id. Alternatively you can see in windows task manager. C:\Users\Administrator>tasklist /SVC /FI "PID eq 9682" Image Name PID Services ========================= ======== ==================== java.exe 9892 N/A Now we have two options left. Either change port for listener or change other applications port which is using this port 1521. In my scenario I have gone for changing port for oracle listener in file listener.ora at path C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora. Changed default port 1521 to free port 1527. Start oracle listener from services.msc or command prompt. This solved my issue and installatio