search cancel

Cannot create Listener on Oracle

book

Article ID: 242950

calendar_today

Updated On:

Products

Data Loss Prevention Core Package

Issue/Introduction

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.

Cause

Unclear

Environment

Release : 15.7

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

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

Attachments