Configuring Listeners error while converting single instance db to RAC +ASM
BrunieNov 14 2009 — edited Nov 15 2009Every time when I refresh the db with production db and try to convert to cluster db using rconfig I get this error.
Verified xml file and every thing is correct in it.
rconfig convertTOrac.xml
Converting Database LABDB. to Cluster Database. Target Oracle Home : /u01/app/oracle/product/10.2.0.4/db_1.
Setting Data Files and Control Files
Adding Database Instances
Adding Redo Logs
Enabling threads for all Database Instances
Setting TEMP tablespace
Adding UNDO tablespaces
Adding Trace files
Setting Flash Recovery Area
Updating Oratab
Creating Password file(s)
Configuring Listeners
<?xml version="1.0" ?>
<RConfig version="1.1" >
<ConvertToRAC>
<Convert>
<Response>
<Result code="1" >
Got Exception
</Result>
<ErrorDetails>
oracle.sysman.assistants.rconfig.engine.ListenerCreationException: oracle.sysman.assistants.util.NetAPIException: TNS-04404: no error
caused by: oracle.net.config.ConfigException: TNS-04414: File error
caused by: TNS-04610: No literals left, reached end of NV pair
Operation Failed. Refer logs at /u01/app/oracle/product/10.2.0.4/db_1/cfgtoollogs/rconfig/rconfig.log for more details.
</ErrorDetails>
</Response>
</Convert>
</ConvertToRAC></RConfig>
You have new mail in /var/spool/mail/oracle
I know its a problem with TNS but still i could not figure out where I am going wrong. Here is the TNS.
Parameter:
*.local_listener=LISTENERS_LABDB
*.remote_listener=''
TNS: Same has been updated in all the 3 nodes but still no luck.
LABDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = melrhrac2lab1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = melrhrac2lab2-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = melrhrac2lab3-vip)(PORT = 1521))
(ENABLE = BROKEN)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = LABDB_APPSVR)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
LISTENERS_LABDB =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = melrhrac2lab1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = melrhrac2lab2-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = melrhrac2lab3-vip)(PORT = 1521))
)
Regards,