Adding Nodes

Posted by latifa on Apr 26, 2017; 12:24pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Adding-Nodes-tp2595.html

Hi Erman,

When adding nodes to the master one (with : perl adcfgclone.pl appsTier dualfs), I have the following WARNING message and always the same (in the second part of cloning I mean while cloning the patch fs):

Running:
perl adaddnode.pl -appsuser=APPS -promptmsg=hide

WARNING: Whole add node operation is completed, only setting of APPL_TOP_ID has failed.
Please check the error log in adaddnode_<timeStamp> and try to run it manually if required.

I check that log file, it says:
ERROR at line 1:
ORA-00001: unique constraint (APPLSYS.AD_APPL_TOPS_U2) violated
ORA-06512: at line 16
Error configuring snapshot information for the source node...cannot proceed with setting the appl top name for the node.

I did something on some servers: I deleted the node in AD_APPL_TOPS and rerun perl adaddnode.pl -appsuser=APPS. The error message changed as following:

ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 159
Error configuring snapshot information for the targer node...cannot proceed with setting the appl top name for the node.

What do you think about that error ? how can I avoid it ?

Thank you in adavance for your reply.

Regards,
Latifa