Amazon books

Thursday, July 18, 2013

netca got error ServiceAliasException: Could not initialize Service Alias: TNS-04404: no error caused by: oracle.net.config.ConfigException: TNS-04414: File error caused by: TNS-04612: Null RHS for "BWWLPR"

O got this error below while trying to create a listener using netca in a RAC 10g.

############################################################################

ServiceAliasException: Could not initialize Service Alias: TNS-04404: no error
  caused by: oracle.net.config.ConfigException: TNS-04414: File error
  caused by: TNS-04612: Null RHS for "BWWLPR"
############################################################################

The problem was that netca is not recognising my service name BWWLPR as below:

############################################################################

BWWLPR =
(DESCRIPTION =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx1.b2w)(PORT = 1525))
    (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx2.b2w)(PORT = 1525))
    (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx3.b2w)(PORT = 1525))

    (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx4.b2w)(PORT = 1525))
  )
  (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = BWWLPR)
    (FAILOVER_MODE =

 (TYPE = SELECT)
      (METHOD = BASIC)
      (RETRIES = 180)
      (DELAY = 5)
    )
  )



############################################################################


To fix this issue I added the line "(DESCRIPTION = " to the first line like below:

"BWWLPR = (DESCRIPTION ="

It works for me.

Best Regards,
Paulo Portugal

No comments:

Post a Comment