Oracle EBS R12 打中文Patch報錯

最近安裝了一套 Oracle EBS R12,在打中文Patch時，報如下錯誤。

FAILED: file FNDNLINS.sql on worker 1.

FAILED: file JTFNLINS.sql on worker 3.

退出ADADMIN後，無法進入ERP,報如下錯誤。

 

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

 

重新啟動AP，無效。折騰了一上午，仍然未搞定。

在網上搜了很久，未找到合適的方法，都說是要進ADADMIN關掉維護模式，可是根本就進不了ADADMIN。

無意中發現一篇文章是說可以用adctrl進入AD Controller查看Worker啟動並執行狀態，在輸入ADCTRL之後，進入如下畫面：

 

                    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

 

選擇【1】

 

 

Enter your choice [1] :

 

 

        Control

Worker Code      Context            Filename                    Status

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

     1 Run      Generic R120       FNDNLINS.sql                Restarted    

     2 Run       Generic R120                                   Wait         

     3 Run       Generic R120       PERNLINS.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.

 

忘記是在那裡看到是說資料表空間不做，趕快將所有資料表空間改為自動擴充後，再在 AD Controller中選[2],發現ADADMIN在跑了，哈哈，看到希望啦！

 

                    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