Hello; Thanks for reading.
A browser based application is run off of a web server that connects to our database server (Both running Windows Server 2012). When attempting to login the the browser based app, called AA, an error was posted Logon Failed. Server Later Message ORA-12170: TNS:Connection timeout occurred.
After some research on this error, most people pointed to a firewall issue. The firewall had not been changed but ultimately, I brought the firewalls on both machines down. When the Firewall was brought down on the Database machine, the login error changed to ORA-12541: TNS: no listener.
I have attempted to connect to SQL Developer and an error code is thrown when trying to login with with the users: The Network Adapter could not establish the connection Vendor code 20.
Both the services and the servers have been restarted. I forwarded the Listener.ora, sqlnet.ora, and tnsnames.ora files to the company that set the system up and created AA and the files seemed to check out. Both servers can see their physical memory. Both machines can be pinged and can be remoted to via TNSPing lists no listener. LSNRCTL status and I receive the response:
PS C:\Users\administrator.HANOVER> lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 05-NOV-2015 09:26:42
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DELL-DB-SERVER.HANOVER.NET)(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=EXTPROC1521)))
TNS-01153: Failed to process string: ╨▼╥♣
PS C:\Users\administrator.HANOVER> lsnrctl start
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 05-NOV-2015 09:31:36
Copyright (c) 1991, 2010, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started
PS C:\Users\administrator.HANOVER>
*Edited to include lsnrctl status and start*
The only change to the network around this time was the addition of a server running ESXI which Hotconverted a workstation attached to this network. Ths server as been disconnected, servers, restarted, and still the issue persists.
This is by far the most I have had to interact with and troubleshoot SQL, oracle, and this database so if you have any suggestions or requests for additional information, I would greatly appreciate a step by step walkthrough.
Thanks in advance for you time, consideration, and expertise.