DBA_Oracle Erp重新启动database/application/concurrent/apache（案例）
2014-12-27 Created By BaoXinjian
一、重启数据库 - Database
Step1. 进入Script目录
[oravis@paleonode1 PROD_paleonode1]$ su - oravis
[oravis@paleonode1 PROD_paleonode1]$ pwd
/u1/VIS/visora/db/tech_st/11.1.0/appsutil/scripts/PROD_paleonode1
Step2. 启动应用
./addbctl.sh start
Step3. 启动监听
./addlnctl.sh start PROD
Step3. 检查进程
分别检查进程 ps -ef|grep oravis
二、重启应用 - Application
Step1. 进入Script目录
[applvis@paleonode1 ~]$ su - applvis
[applvis@paleonode1 ~]$ cd $ADMIN_SCRIPTS_HOME [applvis@paleonode1 ~]$ pwd /u2/VIS/visappl/inst/apps/PROD_paleonode1/admin/scripts
Step2. 启动应用 ./adstrtal.sh apps/apps
Step3. 查看进程
分别检查进程 ps -ef|grep applvis
三、重启并发管理器 - Concurrent Manager
Step1. 进入Script目录
[applvis@paleonode1 ~]$ cd $ADMIN_SCRIPTS_HOME
[applvis@paleonode1 ~]$ pwd
/u2/VIS/visappl/inst/apps/PROD_paleonode1/admin/scripts
Step2. 关闭并发管理 adcmctl.sh stop apps/apps
[applvis@paleonode1 scripts]$ ./adcmctl.sh stop apps/apps
You are running adcmctl.sh version 120.17.12010000.3
Shutting down concurrent managers for PROD ...
ORACLE Password:
oracle
Submitted request 5813385 for CONCURRENT FND SHUTDOWN
adcmctl.sh: exiting with status 0
adcmctl.sh: check the logfile /u2/VIS/visappl/inst/apps/PROD_paleonode1/logs/appl/admin/log/adcmctl.txt for more information ...
Step3. 查看进程
[applvis@paleonode1 scripts]$ ps -ef |grep FNDLIB
applvis 10984 10064 0 11:49 pts/2 00:00:00 grep FNDLIB
Step4. 重启并发管理后进程数量
[applvis@paleonode1 scripts]$ ./adcmctl.sh start apps/apps
[applvis@paleonode1 scripts]$ ps -ef |grep FNDLIB
applvis 11157 11152 0 11:51 pts/2 00:00:00 FNDLIBR
applvis 11164 10064 0 11:51 pts/2 00:00:00 grep FNDLIB
Step5. 并管理器异常时，process数为0，需进行重启
四、OAF重编重启 - Apache
Step1. 进入Script目录 $INST_TOP/admin/scripts
[applvis@paleonode1 ~]$ cd $ADMIN_SCRIPTS_HOME
[applvis@paleonode1 ~]$ pwd
/u2/VIS/visappl/inst/apps/PROD_paleonode1/admin/scripts
Step2. 重启Apache: adapcctl.sh stop / start
[applvis@paleonode1 scripts]$ ./adapcctl.sh stop
You are running adapcctl.sh version 120.7.12010000.2
Stopping OPMN managed Oracle HTTP Server (OHS) instance ...
opmnctl: stopping opmn managed processes...
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile /u2/VIS/visappl/inst/apps/PROD_paleonode1/logs/appl/admin/log/adapcctl.txt for more information ...
[applvis@paleonode1 scripts]$ ./adapcctl.sh start
You are running adapcctl.sh version 120.7.12010000.2
Starting OPMN managed Oracle HTTP Server (OHS) instance ...
opmnctl: opmn is already running.
opmnctl: starting opmn managed processes...
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile /u2/VIS/visappl/inst/apps/PROD_paleonode1/logs/appl/admin/log/adapcctl.txt for more information ...
Step3. 重启OC4J（只在R12系统存在）: adoacorectl.sh stop / start
[applvis@paleonode1 scripts]$ ./adoacorectl.sh stop
You are running adoacorectl.sh version 120.13
Stopping OPMN managed OACORE OC4J instance ...
adoacorectl.sh: exiting with status 0
adoacorectl.sh: check the logfile /u2/VIS/visappl/inst/apps/PROD_paleonode1/logs/appl/admin/log/adoacorectl.txt for more information ...
[applvis@paleonode1 scripts]$ ./adoacorectl.sh start
You are running adoacorectl.sh version 120.13
Starting OPMN managed OACORE OC4J instance ...
adoacorectl.sh: exiting with status 0
adoacorectl.sh: check the logfile /u2/VIS/visappl/inst/apps/PROD_paleonode1/logs/appl/admin/log/adoacorectl.txt for more information ...
五、数据库中脚本分析 - Scripts
1. 停止应用(stopAPP.sh)文件中的内容如下：
/u2/VIS/visappl/inst/apps/PROD_paleonode1/admin/scripts/adalnctl.sh stop
/u2/VIS/visappl/inst/apps/PROD_paleonode1/admin/scripts/adcmctl.sh stop apps/apps
/u2/VIS/visappl/inst/apps/PROD_paleonode1/admin/scripts/adfrmctl.sh stop
/u2/VIS/visappl/inst/apps/PROD_paleonode1/admin/scripts/adrepctl.sh stop
/u2/VIS/visappl/inst/apps/PROD_paleonode1/admin/scripts/adapcctl.sh stop
2. 停止数据库(stopDB.sh) 文件中的内容如下：
/u1/VIS/visora/db/tech_st/11.1.0/appsutil/scripts/PROD_paleonode1/addlnctl.sh stop PROD
/u1/VIS/visora/db/tech_st/11.1.0/appsutil/scripts/PROD_paleonode1/addbctl.sh stop immediate
3. 启动数据库(startDB.sh) 文件中的内容如下：
/u1/VIS/visora/db/tech_st/11.1.0/appsutil/scripts/PROD_paleonode1/addbctl.sh start
/u1/VIS/visora/db/tech_st/11.1.0/appsutil/scripts/PROD_paleonode1/addlnctl.sh start PROD
4. 启动应用(startAPP.sh) 文件中的内容如下：
/u2/VIS/visappl/inst/apps/PROD_paleonode1/admin/scripts/adalnctl.sh start
/u2/VIS/visappl/inst/apps/PROD_paleonode1/admin/scripts/adcmctl.sh start apps/apps
/u2/VIS/visappl/inst/apps/PROD_paleonode1/admin/scripts/adfrmctl.sh start
/u2/VIS/visappl/inst/apps/PROD_paleonode1/admin/scripts/adrepctl.sh start
/u2/VIS/visappl/inst/apps/PROD_paleonode1/admin/scripts/adapcctl.sh start
5. 上述命令所代表的含义如下表所示：
adalnctl.sh Control Oracle Net8 listener for Applications services All application tier server nodes
adstrtal.sh Start all Applications server processes All application tier server nodes
adstpall.sh Stop all Applications server processes All application tier server nodes
adfrmctl.sh Control Forms server Forms server node
adfmcctl.sh Control Forms Metrics Client Forms server node
adfmsctl.sh Control Forms Metrics Server HTTP server node
adtcfctl.sh Control TCF SocketServer Concurrent processing server node
adcmctl.sh Control Concurrent managers Concurrent processing server node
adrepctl.sh Control Reports server Concurrent processing server node
adapcctl.sh Control Apache processes HTTP server node
jtffmctl.sh Control Oracle fulfillment server HTTP server node
Thanks and Regards