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 Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle tns-00511 no listener 64-bit windows error 61 unknown error PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
64 Bit Windows Error 54 Unknown Error
Oracle Windows TNS error: No Listener found
64 Bit Windows Error 203 Unknown Error
Oracle tips by Burleson May 9, 2015 Question: I'm getting a TNS "no listener" error on my Windows Oracle database when trying to connect: LSNRCTL> status
64 Bit Windows Error 1004 Unknown Error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=
Member No.: 33,355 Hello AllBelow is tns-12541: tns:no listener tns-12560: tns:protocol adapter error tns-00511: no listener the error which i got .... I have attached the necessary docs also, Any tns-12560 protocol adapter error help will be appreciated.**********************************C:\Documents and Settings\USER>LSNRCTLLSNRCTL for 64-bit Windows: Version 10.2.0.4.0 - Production on 15-OCT-2010 12:02:24Copyright © 1991, 2007, Oracle. All rights reserved.Welcome http://www.dba-oracle.com/t_windows_tns_no_listener_error.htm to LSNRCTL, type "help" for information.LSNRCTL> STATUS STBY1Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.62.16.20)(PORT=1553))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=STBY1.DEV.COM)))TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 61: Unknown errorConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.62.16.20)(PORT=1528))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=STBY1.DEV.COM)))TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 61: Unknown errorConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.62.16.20)(PORT=1527))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=STBY1.DEV.COM)))TNS-12541: TNS:no listener http://dbaforums.org/oracle/index.php?showtopic=20125 TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 61: Unknown errorLSNRCTL> START STBY1Starting tnslsnr: please wait...TNSLSNR for 64-bit Windows: Version 10.2.0.4.0 - ProductionSystem parameter file is D:\ORACLE\ORA10G\network\admin\listener.oraLog messages written to D:\ORACLE\ORA10G\network\log\stby1.logTNS-01151: Missing listener name, STBY1, in LISTENER.ORA**********************************Below is the listener log file :**********************************Listener failed to start. See the error message(s) above...TNSLSNR for 64-bit Windows: Version 10.2.0.4.0 - Production on 15-OCT-2010 11:49:03Copyright © 1991, 2007, Oracle. All rights reserved.System parameter file is D:\ORACLE\ORA10G\network\admin\listener.oraLog messages written to D:\ORACLE\ORA10G\network\log\stby1.logTrace information written to D:\ORACLE\ORA10G\network\trace\stby1.trcTrace level is currently 0Started with pid=4104TNS-01151: Missing listener name, STBY1, in LISTENER.ORA**********************************Below is the listener.ora file configuration :**********************************TCP_3 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dbsc.DEV.COM)(PORT = 1527)) )TCP_2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dbsc.DEV.COM)(PORT = 1528)) )TCP_1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dbsc.DEV.COM)(PORT = 1553))
14 I never had so much trouble installing an Oracle version on a Windows OS as I had with installation of Oracle 11R2 on Windows 7 (64-bit). The issues I faced were twofold: First I https://toinevanbeckhoven.wordpress.com/2011/03/18/installation-of-oracle-11-release-2-on-windows-7-64-bit/ got messages (during installation of the software) that files could not be found in http://dandar3.blogspot.com/2012/07/the-case-of-oracle-11g-listener-not.html the target oracle folder Second, after finding the solution for the first annoyance, I spent two hours finding out why everything installed correctly, I could create a database, but could not start a Listener. I am an Administrator on my laptop. The errors I got at starting a listener were ORA-12560 and ORA-12541. Regarding 1: It appeared windows error to be very simple: when you download Oracle 11 R2, there are two zip files. Make sure to extract both zip files into the same folder and not into two separate folders (like a Disk1 and Disk2 folder). After extracting both zip files into the same folder, the installation went smooth without errors. Regarding 2: After a fresh installation and creation of a database, I am used to open a Command bit windows error prompt, start LSNRCTL, and execute a START to start the default listener. If a Windows Service does not exist yet, LSNRCTL throws some errors around that but as part of this it creates the Windows Service. But not this time. I kept on getting the result: C:\>lsnrctl start LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-MRT-2011 21:48:56 Copyright (c) 1991, 2010, Oracle. All rights reserved. Starten van tnslsnr: Even geduld a.u.b. TNS-12560: TNS: fout bij protocoladapter.  TNS-00530: Fout in protocoladapter. and a LSNRCTL status gave me: C:\>lsnrctl status LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-MRT-2011 21:52:02 Copyright (c) 1991, 2010, Oracle. All rights reserved. Verbinding wordt gemaakt met (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=1.1.1.1)(PORT=1521))). TNS-12541: TNS: geen listener.  TNS-12560: TNS: fout bij protocoladapter.  TNS-00511: Geen listener   64-bit Windows Error: 61: Unknown error C:\> But no listener got created. The Oracle support site, nor any forum or blog pointed me in the correct direction. The only thought I had was: I know Windows requires the Listener to be present as a Service, so as long as that is not the case, it will not start. So here is what I tried: I created the service myself using the Windows "sc" command. Now a first attempt gave an Access Denied, but afte
starting up and when eventually did start listening on port 1521, it wasn't taking client connections! The odd part is that as far as I know nothing was changed, either software or network configuration, so why all this?! lsnctrl status was showing this error: C:\oracle\product\11.1.0\db_1\BIN>LSNRCTL.EXE status LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 27-JUL-2012 02:51:26 Copyright (c) 1991, 2007, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server.domain.com)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 32-bit Windows Error: 61: Unknown errorFocusing with Process Monitor (procmon) on TNSLSNR.exe showed that it was trying to write to the listener.log file. Right-click the file and choose Jump To… brought the file in Explorer, wow, the log file is 4 GB?! Stopping the listener service, removing the log file and restarting the listener service, services are back to normal now! C:\oracle\product\11.1.0\db_1\BIN>LSNRCTL.EXE status LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 27-JUL-2012 02:52:49 Copyright (c) 1991, 2007, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server.domain.com)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 11.1.0.6.0 - Production Start Date 27-JUL-2012 02:52:27 Uptime 0 days 0 hr. 0 min. 22 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File C:\oracle\product\11.1.0\db_1\network\admin\listener.ora Listener Log File c:\oracle\diag\tnslsnr\SERVER\listener\alert\log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SERVER.domain.com)(PORT=1521))) Servic