Oracle EBS R12 Chinese patch Error

A set of Oracle EBS R12 has been installed recently. The following error is reported when a Chinese patch is used.

Failed: file fndnworkflow. SQL on worker 1.

Failed: file jtfnworkflow. SQL on worker 3.

After exiting adadmin, you cannot access ERP and the following error is reported.

 

The system has not been taken off maintenance mode completely. Please contact your system administrator.

 

An error occurred while restarting the AP. After a long morning of hard work, it was still not completed.

I searched the internet for a long time and did not find a proper method. I said that I had to go to adadmin to turn off the maintenance mode, but I simply couldn't enter adadmin.

I accidentally found an article about how to use adctrl to enter the ad controller to view the running status of the worker. After Entering adctrl, the following screen is displayed:

 

Ad controller menu

---------------------------------------------------

 

1. Show worker status

 

2. Tell worker to restart a failed job

 

3. Tell worker to quit

 

4. Tell manager that a worker failed its job

 

5. Tell manager that a worker acknowledges quit

 

6. restart a worker on the Current Machine

 

7. Exit

 

Select [1]

 

 

Enter your choice [1]:

 

 

Control

Worker code context filename status

-----------------------------------------------------------------------

1 run generic r120 fndntasks. SQL restarted

2 run generic r120 wait

3 run generic r120 perntasks. SQL restarted

4 run generic r120 wait

5 run generic r120 wait

6 run generic r120 wait

7 run generic r120 wait

8 run generic r120 wait

 

Review the messages above, then press [Return] to continue.

 

If you forget to see it there, it means that the tablespace is not done. change all the tablespaces to auto scaling. Then select [2] in the ad controller and find that adadmin is running. Haha, see hope!

 

Ad controller menu

---------------------------------------------------

 

1. Show worker status

 

2. Tell worker to restart a failed job

 

3. Tell worker to quit

 

4. Tell manager that a worker failed its job

 

5. Tell manager that a worker acknowledges quit

 

6. restart a worker on the Current Machine

 

7. Exit