Cannot log in due to Oracle-1 error on Empower Workstation - WKB302312

Article number: 302312

SYMPTOMS

Cannot log in to Empower Workstation due to Oracle-1 error
ORA-12541: TNS:no listener
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

TNSListener services not getting communication to Oracle Service.
TNSListener Service not started.

1. Add the loop back adapter and assign an IP (10.10.10.1).
2. My Computer >
3. Add Legacy Hardware >

4. Add Driver for Network >
5. Finish Installation >

6. Add IP in Loop back Adaptor Properties IPv4 >
7. Run Notepad as Administrator and open the Host file (select All files in Notepad).

9. Add IP in host file (10.10.10.1 <space> Device Name) and save. Device name is Computer name.

10. Open the sqlnet.ora file again from Notepad, and add # in front of all TCP lines.

11. Both services (Oracle Service and TNSListener) should be set to automatic.

12. Restart the workstation.