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
############################################################################
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