Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Configuring Listeners error while converting single instance db to RAC +ASM

BrunieNov 14 2009 — edited Nov 15 2009
Every 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,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 12 2009
Added on Nov 14 2009
2 comments
1,459 views