Archive for June, 2022

ServiceAliasException: Could not initialize Service Alias: TNS-04404: no error

June 21st, 2022, posted in Oracle Queries
Share

I was getting this TNS error while creating Listner with “netca”, here is the screenshot for the same.

Listner,TNS-04404,ServiceAliasException,Service Alias

 

 

D:\app\db193\bin>netca

Oracle Net Services Configuration:
Configuring Listener:LISTENERCBT
ServiceAliasException: Could not initialize Service Alias: TNS-04404: no error
  caused by: oracle.net.config.ConfigException: TNS-04414: File error
  caused by: TNS-04605: Invalid syntax error: Unexpected char or LITERAL "IEPDB1" before or at  IEPDB1 = (
  Error in file D:\TNS_ADMIN\tnsnames.ora

This is my windows machine and creating new listner for my newly created CDB. DB version is 19.3

As above error shows that I have some issue with my tnsnames.ora with some of my TNS Entry with IEPDB1.

In my environment TNS_ADMIN environment variable is set and it is pointing to my D:\TNS_ADMIN\tnsnames.ora

Here I found some junk characters near IEPDB1 TNS entry, I removed it and save the file and ran netca again…
Now, all went good..
It solved my problem !!!

Share