Monday, July 4, 2011

How to change the VIP for RAC apps database tier and VIP for the Apps tier

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:

How to change the VIP for RAC apps database tier and VIP for the Apps tier

Symptoms:

Database -- RAC instance (Two Instances).
Application -- Two node with shared APPL_TOP.


Solution:

- on the Database tier update the Auto Config Context variable s_virtual_hostname with the new vip hostname
- deregister the host or purge the Net Services Topology Data Model as per Note 218089.1 so the new virtual host to get reflected in tnsnames.ora in 8.0.6 ORACLE_HOME
backup FND_Nodes table.
deregister the current database tier from the Net Services Topology Data Model using

            perl <RDBMS ORACLE_HOME>/appsutil/bin/adgentns.pl appspass=<APPSpwd> \
contextfile=<CONTEXT> -removeserver

- run Auto Config on the Database tier
- run Auto Config on the Applications tier

References:

You might have to deregister the host or purge the Net Services Topology Data Model? as per Note 218089.1: "Autoconfig FAQ"


    

Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: