The table FND_INSTALL_PROCESSES created by AD Administration already exists.

 Issue:

During adop phase I faced the below error.

The table FND_INSTALL_PROCESSES created by AD Administration already exists.

Cause:

adadmin session was open to compile apps schema objects but it was stuck.

Solution:

1. Now take the backup of the FND_INSTALL_PROCESSES table

Connect as applsys because FND_INSTALL_PROCESS is owned by applsys schema.

Sqlplus applsys/<password>

create table fnd_Install_processes_23Feb22 as select * from fnd_Install_processes;

2. Check the both tables should have the same number of rows

SQL> select count(*) from fnd_Install_processes_23Feb22;

SQL> select count(*) from fnd_Install_processes;

3.. In same way take the backup of the AD_DEFERRED_JOBS table from applsys schema

sqlplus applsys/<password>

SQL>create table AD_DEFERRED_JOBS_23Feb22 as select * from AD_DEFERRED_JOBS;

4. Now backup the .rf9 files located at below path directory

$APPL_TOP/admin/$TWO_TASK/restart directory

Here adpatch session must be ended and the cursor should be back at the UNIX prompt.

$echo $ORACLE_SID or $TWO_TASK

cd $APPL_TOP/admin/$TWO_TASK

cp restart restart_23FEB

5. DROP the FND_INSTALL_PROCESSES table and the AD_DEFERRED_JOBS table.

sqlplus applsys/<password>

drop table FND_INSTALL_PROCESSES;

drop table AD_DEFERRED_JOBS;

6. Restart adop patch

Oracle cloud infrastructure 2021 architect associate 1z0-1072 dumps free

All Real Exam Questions with Answers (highlighted in RED)

Q1:

Q2:

Q3:

Q4:

Q5:

Q6:

Q7:

Q8:

Q9:

Q10:

Q11:

Q12:

Q13:

Q14:

Q15:

Q16:

Q17:

Q18:

Q19:

Q20:

Q21:

Q22:

Q23:

Q24:

Q25:

Q26:

Q27:

Q28:

Q29:

Q30:

Q31:

Q32:

Q33:

Q34:

Q35:

Q36:

Q37:

Q38:

Q39:

Q40:

Q41:

Q42:

Q43:

Q44:

Q45:

Q46:

Q47:

Q48:

Q49:

Q50:

Q51:

Q52:

Q53:

Q54: