Apps R12 ORA-00001: unique constraint (APPLSYS.AD_APPL_TOPS_U2) violated

Another personal note just in case this issue recurs in PROD instance while creating additional oracle application node and while
executing perl adaddnode.pl.

Instances are running in Oracle Enterprise Linux 5.6 x86_64.

ORA-00001: unique constraint (APPLSYS.AD_TIMESTAMPS_U1) violated (Doc ID 727990.1)

create table ad_appl_tops_joey as select * from  ad_appl_tops;
delete from ad_appl_tops where appl_top_id = 195 and name  = ‘tabak’;
commit;

create table  AD_TIMESTAMPS_joey as select * from AD_TIMESTAMPS;
select * from AD_TIMESTAMPS where type like ‘%_CURRENT_VIEW_SNAPSHOT’;
select * from AD_TIMESTAMPS where attribute like ‘PROD%tabak%’;

–returns null

[applprod@tabak bin]$ perl adaddnode.pl
Enter the APPS username: apps

Enter the APPS user password:
        Using CONTEXT_FILE : /fin_app/PROD/inst/apps/PROD_tabak/appl/admin/PROD_tabak.xml
        Using      CTXORIG : /fin_app/PROD/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml
APPL_TOP name of the source system (old APPL_TOP name) : finora
APPL_TOP name of the target system (new APPL_TOP name) : tabak

Configuring snapshot information for the original (clone source) node…
Executing command:
sqlplus /nolog @/fin_app/PROD/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adadmrat.sql APPS appspw PROD PROD tabak finora /fin_app/PROD/inst/apps/PROD_tabak/temp/adadmat_sql.spool

SQL*Plus: Release 10.1.0.5.0 – Production on Thu Nov 17 21:25:00 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected.

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Current data
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

APPL_TOP Names in AD_APPL_TOPS:

*PRESEEDED*
GLOBAL
ap6002bld
ap6003bld
finora
rws60051app
rws60052app
tabak

8 rows selected.

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Updating tables…
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

declare
*
ERROR at line 1:
ORA-00001: unique constraint (APPLSYS.AD_APPL_TOPS_U2) violated
ORA-06512: at line 16


Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Error configuring snapshot information for the source node…cannot proceed with adding the node.

————————–
references:

Please read http://oracle-magic.blogspot.com/2008/02/add-new-node-to-apps.html before reading the steps below,

After finishing configuring the clone instance by running adcfgclone.pl I had
to run the adaddnode.pl script according to note 464018.1.
While running adaddnode.pl I faced the following error
ERROR at line 1:
ORA-00001: unique constraint (APPLSYS.AD_APPL_TOPS_U2) violated
ORA-06512: at line 16

Ifollowed note 394615.1 to solve it and after I did the steps in the
note I run adaddnode.pl again and I faced error related to
AD_TIMESTAMPS_U1 I checked on metalink but I could not find anything
then I search on google and found post by dave
http://newappsdba.blogspot.com/2006/09/dont-hit-ctrl-c-while-running.html
from his post I took a backup the ad_timestamps and then truncate it
after that I run adaddnode.pl and it completed successfully.
Then I
updated the xml file to have only the forms and web servers running on
this new node following the same note 464018.1 I run autoconfig the
start the service on both nodes a now able to access both nodes.

What
I want to do now is to configure web cache as load balancer also I want
to implement Step 2.4.1.2. Implement Forms Listener Servlet Support
from note (Advanced Configurations and Topologies for Enterprise
Deployments of E-Business Suite 11i) Note:217368.1 in order to have
Forms Server Load Balancing, so when one form server go down in one node
users will be connect to the other forms node.Because the current
configuration if I am connect to webnode1 and forms on that node is down
I will not be able to connect to forms and I will receive an error but
if load balancing is implemented it will take me to the other working
forms server node.

Advertisements

About this entry