【Oracle 筆記 】The system has not been taken off maintenance mode completely.

現象

重新啟動 Oracle EBS 時候，系統無法連結，出現下列錯誤訊息:

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



事實上，在整個上 patch 的過程中，完全依照下列順序，為何還會有錯誤發生呢?

1. enable Maintenance mode
2. adstpall.sh
3. shut down database
4. apply patch
5. startup database
6. adstrtal.sh
7. disable Maintenance mode

檢查

1. 以 apps 帳號，由 DB 查詢 APPS_MAINTENANCE_MODE 的 status:


[dba@tw]$ sqlplus apps/xxxxxx

SQL*Plus: Release 11.2.0.2.0 Production on Wed Nov 12 10:59:12 2014

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;

FND_PROFILE.VALUE('APPS_MAINTENANCE_MODE')
--------------------------------------------------------------------------------
NORMAL


2. 採用 Bounce Apache Server 建議

首先，確認 Maintenance Mode 是 Disabled，之後依序下列順序操作:


$COMMON_TOP/admin/scripts/$TWO_TASK*/adapcctl.sh stop
wait for 30 seconds
$COMMON_TOP/admin/scripts/$TWO_TASK*/adapcctl.sh start

/u01/apps/PROD/inst/apps/PROD_xxxx-xxx-erp/admin/scripts/adapcctl.sh

or $INST_TOP/admin/scripts/adapcctl.sh


結論

事實上，在 Bounce Apache Server 之後，連結 Oracle EBS 仍有此錯誤訊息，但重新執行下列作業後，系統才恢復正常運作:

 1. enable Maintenance mode ( adadmin )
 2. shutdown AP server ( adstpall.sh apps/xxxxxx )
 3. startup AP server ( adstrtal.sh apps/xxxxxx )
 4. disable Maintenance mode ( adadmin )

參考

1. Oracle Applications Maintenance Procedures
http://download.oracle.com/docs/cd/B53825_03/current/acrobat/121admp.pdf

2. How to Stop and Start (Bounce) the Apache Server [ID 204218.1]

***Checked for relevance on 16-Apr-2013***


goal: How to stop and start (bounce) the apache server
fact: Oracle Application Object Library 11.5.10.2  and later
fact: Oracle HTTP Server Powered by Apache 1.3+
fact: Oracle Human Resources 11.5.10.2  and later
fact: Oracle Self Service Human Resources  11.5.10.2  and later



fix:

Log in to the httpd server
cd $SCRIPTS
type
adapcctl.sh stop
Wait 30 seconds
Type
adapcctl.sh start

Apache Server has been bounced.