Cannot create Listener on Oracle

Products

• Data Loss Prevention Core Package

Issue/Introduction

• You have  upgraded the  Oracle DB  from 12c to 19c using the steps in the Symantec Data Loss Prevention Oracle 19c Implementation Guide
• Whilst creating the Listener using the netca.bat you receive the error below:

ServiceAliasException: Could not save Service Alias: TNS-04406 Object already exists

Default local naming configuration complete.

ListenerException: Could not save listener: TNS-04414: File error caused by: TNS-04605: Invalid syntax error: Unexpected char or LITERAL "(" before or at ( PROGRAM =

Listener configuration complete.

• The OracleOraDB19Home1TNSListener is not created as a service in the services.msc control panel and the listener.ora file is not present in the <Drive>:\oracle\product\19.3.0.0\db_1\network\admin folder.

Environment

Release : 15.7

Component : Oracle 19c Standard Edition, Single Tenant, Windows 2016

Cause

Unclear

Resolution

• After checking the ORACLE_HOME and PATH environment variables for correct paths, and checking the original 12c version of the listener.ora file, no problems could be found.
• The installation was rolled back to a pre-upgraded state from a back up and the upgrade was repeated.
• This time the listener service was successfully created and the upgrade completed successfully