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.

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

ERP技术讨论群: 288307890
技术交流,技术讨论,欢迎加入
Technology Blog Created By Oracle ERP - 鲍新建
相关文章
|
1月前
|
数据采集 监控 供应链
ERP系统在大型企业中的实施案例研究
ERP系统在大型企业中的实施案例研究
133 0
|
1月前
|
SQL Oracle 关系型数据库
WARNING: Too Many Parse Errors With error=911 When Running a JDBC Application Connected to an Oracle 19c database
WARNING: Too Many Parse Errors With error=911 When Running a JDBC Application Connected to an Oracle 19c database (
27 2
|
1月前
|
Oracle 关系型数据库
19c 开启Oracle Database Vault
19c 开启Oracle Database Vault
40 1
|
5天前
|
Oracle 关系型数据库 Linux
Requirements for Installing Oracle Database/Client 19c on OL8 or RHEL8 64-bit (x86-64) (Doc ID 2668780.1)
Requirements for Installing Oracle Database/Client 19c on OL8 or RHEL8 64-bit (x86-64) (Doc ID 2668780.1)
10 0
|
30天前
|
SQL Oracle 关系型数据库
Connect to Autonomous Database Using Oracle Database Tools
Connect to Autonomous Database Using Oracle Database Tools
25 1
|
29天前
|
弹性计算 监控 数据库
【阿里云弹性计算】企业级应用上云实战:基于阿里云 ECS 的 ERP 系统迁移案例
【5月更文挑战第25天】制造企业将面临资源不足、维护成本高和数据安全问题的ERP系统迁移到阿里云ECS,实现业务上云。通过数据迁移、应用部署、网络配置和性能优化等步骤,企业享受到弹性计算资源、高可靠性和数据安全优势,降低维护成本。阿里云提供24小时支持,助力企业数字化转型。此案例展示企业级应用上云的可行性,鼓励更多企业借助云计算实现创新发展。
41 0
|
1月前
|
人工智能 Oracle 关系型数据库
一篇文章弄懂Oracle和PostgreSQL的Database Link
一篇文章弄懂Oracle和PostgreSQL的Database Link
|
1月前
|
监控 供应链 数据挖掘
ERP系统在中小企业的实施案例分析
ERP系统在中小企业的实施案例分析
74 1
|
1月前
|
SQL Oracle 安全
Oracle Database Vault Access Control Components
Oracle Database Vault Access Control Components
18 0
|
1月前
|
Oracle 安全 关系型数据库
What Is Oracle Database Vault?
The Oracle Database Vault security controls protect application data from unauthorized access, and helps you to comply with privacy and regulatory requirements. You can deploy controls to block privileged account access to application data and control sensitive operations inside the database using
14 0

热门文章

最新文章

推荐镜像

更多