No Listener service created after running NETCA on Windows 2008 or later

Products

• Data Loss Prevention Enforce

Issue/Introduction

For a new install of Oracle, following successful creation of the DB using the DLP template, the following issues were found in the creation of the TNS Listener.

Net Configuration Assistant appears to complete successfully. However, services.msc shows that no Oracle Listener service has actually been created.

Cause

This is due to restrictions on running software on Windows 2008, and later.

Resolution

To correctly launch NETCA (Oracle's Network Configuration Assistant), even while logged in as Administrator, you would need to run the NETCA with elevated privileges. Only then will the service be created successfully.

Oracle has noted this in relation to newer Windows OS:

https://docs.oracle.com/database/121/NTCLI/install.htm#NTCLI1280

"On Windows, command prompts should be opened with Administrator privileges."

 

To launch as such, right-click the executable in default location, and choose "Run as Administrator":

%windir%\cmd.exe

 

Note that this issue can also occur in relation to an incorrect entry for the server in the Windows Hosts file (accompanied by "Listener supports no services" error, etc).