Leave a Comment:
6 comments
[…] » Add new Application Tier/Node to Oracle Apps/E-Business Suite … […]
Reply[…] » Add new Application Tier/Node to Oracle Apps/E-Business Suite … […]
Reply@ Bala,
Option 1
———
1. Just shutdown node and delete file system
Option 2 (Clean Method)
———–
1. Shutdown node which you wish to remove
2. Remove all nodes from fnd_nodes
Connect as apps
SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;
EXIT;
3. Run autoconfig on all existing nodes to repopulate fnd_nodes and corresponding nodes
first on Database then Concurrent Manager followed by Middle Tiers
ReplyUseful option. I bet that one would work.
ReplyDon’t go for RAC or LB setup. Because MRP in EBS 11i/R12 won’t support these setups.
Ref: Note 279156.1 – RAC Configuration Setup For Running MRP Planning, APS Planning, and Data Collection Processes
Extract of this Doc:
“MRP does NOT support RAC for the MRP processes. MRP uses DBMS_PIPES. DBMS_PIPES cannot communicate across nodes. In MRP you can’t do load balancing on the DB and CM node which handles the MRP requests that’s why you have to disable load balancing on those and pin the concurrent manager running the MRP request to that node two_task needs to point to the entry in the tnsnames which does not have load balancing .Two_task needs to point to the entry in the tnsnames which does not have load balancing this is clearly mentioned in the note, section III, point 7
Key Point: The TWO_TASK of the node where these processes will run, must point to the TNSNAMES.ora entry that is for a single instance of the RAC and cannot have LOAD BALANCE setup. ”
Don’t become a prey to this trap.
If anybody facing/fixed this issue, kindly post your experience.
Reply