Monday 7 April 2014

TNS-04605: Invalid syntax error: Unexpected char or LITERAL

When trying to configure listener or net services of oracle database below error is received 



C:\Documents and Settings\Administrator>netca
Oracle Net Services Configuration:
ServiceAliasException: Could not enum Net Service Names: 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 "PROD"
before or at  PROD = (
Oracle Net Services configuration terminated by user.  The exit code is -1


Same time i'm unable to access in oracle net Manager unable to add or modify in Name serving.



Solution for this Error is:

Reason : Entry in tnsnames.ora syntax is incorrect or missing some parameters.

Solution : 

Check the below syntax is matching according to your SID(TEST) , IP Address(192.168.75.131) and Port (1521)

otherwise copy this below syntax and paste in your $ORACLE_HOME/network/tnsnames.ora
and change these SID,IP and Port according to your Env.


TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.75.131)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = TEST)
    )
  )

 After doing this you can verify it whether this is ping or not using tnsping 

C:\Users> tnsping TEST



No comments:

Post a Comment