数据库启动监听
addlnctl.sh start instance
启动数据库
addbctl.sh start
启动应用服务器
adstrtal.sh
停止应用服务器
adstpall.sh
查看HTTP/OC4J Status
adopmnctl.sh status
sample output:
Processes in Instance: mc3yd213_bej301441.bej301441.cn.oracle.com
---------------------------------+--------------------+---------+---------
ias-component | process-type | pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group | OC4J:oafm | 16924 | Alive
OC4JGroup:default_group | OC4J:forms | 16851 | Alive
OC4JGroup:default_group | OC4J:oacore | 16767 | Alive
HTTP_Server | HTTP_Server | 16710 | Alive
==================================================
Order of Startup Shutdown
————————————–
As in Oracle Apps 11i order for startup is
A) Start Database Tier Services
–Start Database Listener
–Start Database
Then
B) Start Application/Middle Tier Services
– adstrtal.sh
Order for shutdown in Oracle Apps R12 is
A) Stop Application/Middle Tier Services
– adstpall.sh
Then
B) Stop Database Tier Services
–Stop Database
–Stop Database Listener
Database Tier Scripts in R12
————————————–
For Database tier you need to start database and database listener. Scripts are located inDatabase_Install_Dir/db/tech_st/10.2.0/appsutil/scripts/$CONTEXT_NAME- For Database
Use script addbctl.sh
- For Database Listener
Use script addlnctl.sh
or alternatively you can use
lsnrctl startstop listener_name (For Database Listener)
sqlplus “/as sysdba”
SQL> startup shutdownimmediate
Middle/Application Tier Scripts in R12
————————————————-
Scripts for Application Tier services in R12 are located in “Install_base/inst/apps/$CONTEXT_NAME/admin/scripts“
where CONTEXT_NAME is of format SID_HOSTNAME
i) adstrtal.sh
Master script to start all components/services of middle tier or application tier. This script will use Service ControlAPI to start all services which are enabled after checking them in context file (SID_HOSTNAME.xml or CONTEXT_NAME.xml)
ii) adstpall.sh
Master script to stop all components/services of middle tier or application tier.
iii) adalnctl.sh
Script to start / stop apps listener (FNDFS andFNDFS). This listener will file will be in 10.1.2 ORACLE_HOME (i.e. Forms & Reports Home)
listener.ora file will be in $INST_TOP/apps/$CONTEXT_NAME/ora/10.1.2/network/admin directory
(Mostly similar to one in 11i with only change in ORACLE_HOME i.e. from 8.0.6 to 10.1.2)
iv) adapcctl.sh
Script to start/stop Web Server or Oracle HTTP Server. This script uses opmn (Oracle Process Manager and Notification Server) with syntax similar toopmnctl[startstop]proc ohs
like opmnctlstopproc ohs.
(In 11i this script directly used to callapachectl executable but now callsopmnctl whichin turn calls apachectl. In 11i web server oracle home was 1.0.2.2.2 but in R12 its 10.1.3)
v) adcmctl.sh
Script to start / stop concurrent manager, Similar to one in 11i. (This script in turn calls startmgr.sh )
vi) adformsctl.sh
Script to start / stop Forms OC4J from 10.1.3 Oracle_Home. This script will also use opmnctl to start/stop Forms OC4J like
opmnctl stopproc type=oc4jinstancename=forms
vii) adformsrvctl.sh
This script is used only if you wish to start forms in socket mode. Default forms connect method in R12 isservlet.
If started this will start frmsrv executable from 10.1.2 Oracle_Home in Apps R12
viii) adoacorectl.sh
This script will start/stop oacoreOC4J in 10.1.3 Oracle_Home. This scripts will also useopmnctl (similar toadapcctl &adformsctl) to startoacore instance ofOC4J like
opmnctlstartproc type=oc4jinstancename=oacore
ix) adoafmctl.sh
This script will start/stop oafmOC4J in 10.1.3 Oracle_Home. This scripts will also useopmnctl (similar to above) to startoacore instance ofOC4J like
opmnctlstartproc type=oc4jinstancename=oafm
x) adopmnctl.sh
This script will start/stop opmn service in 10.1.3 Oracle_Home. opmn will control all services in 10.1.3 Oracle_Home like web server or variousoc4j instances. If any services are stopped abnormallyopmn will/should start them automatically.
xi) jtffmctl.sh
This script will be used to start/stop one to one fulfilment server.
xii) mwactl.sh
To start / stop mwa telnet server wheremwa is mobile application.
Log File Location for Startup Shutdown Services in R12
———————————————————————-
Log files for startup/shutdown scripts for application/mid tier in R12 are in$INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log
(adalnctl.txt,adapcctl.txt,adcmctl.txt,adformsctl.txt,adoacorectl.txt,adoafmctl.txt,adopmnctl.txt,adstrtal.log,jtffmctl.txt )
==================================================
RDBMS ORACLE_HOME Control scripts (located under <RDBMS ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>)
Control Script
|
Functionality
|
addbctl.sh |
Control database server |
addlnctl.sh |
Control Oracle Net listener for the database server |
RDBMS ORACLE_HOME Install scripts (located under <RDBMS ORACLE_HOME>/appsutil/install/<CONTEXT_NAME>)
Install Script
|
Functionality
|
adsvdlsn.sh |
Start Oracle Net listener during installation |
adcrdb.sh |
Start database and create database control files |
addbprf.sh |
Set profile option values |
adsvdcnv.sh |
Perform character set conversion and licensing tasks |
adsvdb.sh |
Start database during installation |
Application Service Control scripts (located under <INST_TOP>/admin/scripts)
Control Script
|
Functionality
|
Node
|
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 |
adcmctl.sh |
Control Concurrent managers |
Concurrent processing server node |
adapcctl.sh |
Control Apache processes |
HTTP server node |
adopmnctl.sh |
Controls Oracle Process Manager |
HTTP server node |
adoacorectl.sh |
Controls Oacore Oc4j Instance |
HTTP server node |
adformsctl.sh |
Controls Forms Oc4j Instance |
HTTP server node |
adoafmctl.sh |
Controls Oafm Oc4j Instance |
HTTP server node |
jtffmctl.sh |
Control Oracle fulfillment server |
HTTP server node |
==================================================
Instance Home($INST_TOP) Directory Structure
Instance Home contains all the config files, log files, SSL certificates etc.
$INST_TOP/admin/scripts ($ADMIN_SCRIPTS_HOME): All AD scripts are located here
$INST_TOP/appl ($APPL_CONFIG_HOME) : For standalone envs, this is set to $APPL_TOP
$INST_TOP/appl/fnd/12.0.0/secure FND_SECURE: The dbc file is located here
$INST_TOP/appl/admin All the env config files are located here
$INST_TOP/certs SSL Certificates go here
$INST_TOP/logs LOG_HOME: Central log file location. All log files are placed here (except adconfig)
$INST_TOP/logs/ora ($ORA_CONFIG_HOME)
$INST_TOP/logs/ora/10.1.2 ‘C’ Oracle home config, Contains tnsnames and forms listener servlet config files
$INST_TOP/logs/ora/10.1.3 Apache & OC4J config home, Apache, OC4J and opmn. This is the ‘Java’ oracle home configuration for OPMN, Apache and OC4J
$INST_TOP/pids Apache/Forms server PID files are located here
$INST_TOP/portal Apache’s DocumentRoot folder
==================================================
AD Command Line Utilities
AD Administration
|
adadmin
|
Performs maintenance tasks for Oracle E-Business Suite. |
AD Check Digest
|
adchkdig
|
Checks the integrity of Oracle E-Business Suite patches downloaded from My Oracle Support. |
AD Configuration
|
adutconf.sql
|
Reports standard information about the installed configuration of Oracle E-Business Suite. |
AD Controller
|
adctrl
|
Manages parallel workers in AD Administration and AutoPatch. |
AD File Identification
|
adident
|
Reports the version and translation level of an Oracle E-Business Suite file. |
AD File Character Set Converter
|
adncnv
|
Converts a file from one character set to another. |
AD Merge Patch*
|
admrgpch
|
Merges multiple patches into a single merged patch. |
AD Relink
|
adrelink.sh
|
Relinks Oracle E-Business Suite executable programs with the Oracle server product libraries. |
AD Splicer
|
adsplice
|
Adds off-cycle products. |
AD Job Timing Report
|
|
Reports a summary of the timing for jobs run by parallel workers. |
AutoPatch*
|
adpatch
|
Applies patches and other system updates. |
Patch Application Assistant*
|
admsi.pl
|
Generates customized installation instructions for a patch. |
Rapid Install**
|
rapidwiz
|
Provides a wizard for entering parameters that are specific to a new installation or an upgrade of an Oracle E-Business Suite system. |
Reference:
Oracle Applications(Apps) R12 (12.1.1) Installation on Linux
http://www.freeoraclehelp.com/2011/11/oracle-applicationsapps-r12-1211.html
R12 Instance Home Overview
http://onlineappsdba.com/index.php/2007/10/19/r12-instance-home-overview/
Start-up Shutdown Scripts in Oracle Apps R12
http://onlineappsdba.com/index.php/2007/06/10/start-up-shutdown-scripts-in-oracle-apps-r12/
Oracle E-Business Suite Maintenance Utilities
http://docs.oracle.com/cd/E18727_01/doc.121/e13676/T530334T530337.htm
分享到:
相关推荐
ORACLE DBA 常用命令
Oracle DBA常用运维命令大全
oracle数据管理员常用命令: 1)显示所有参数极其设置值 2)显示所有NLS参数可设置的值 ……
Oracle DBA常用命令总结 , 包含 复杂权限控制等等
本人珍藏oracle的常用命令,都是本人在日常运维中需要使用的命令,分享给大家。互相学习。
dba常用命令…………………………………………………………
DBA常用的命令集锦 DBA常用命令269条
ORACLE DBA 常用命令 这个描述很详细了吧
ORACLE_DBA常用脚本,有时间可以看一看。
Oracle DBA 常用脚本(外国网站上下载)
natstat,oracle常用命令常用命令natstat,oracle常用命令常用命令natstat,oracle常用命令常用命令natstat,oracle常用命令常用命令natstat,oracle常用命令常用命令
ORACLE 数据库性能设置于问题分析常用脚本
oracle_DBA常用指令
oracle dba 常用命令 1 运行 SQLPLUS 工具 sqlplus 2 以 OS 的默认身份连接 / as sysdba 3 显示当前用户名 show user 4 直接进入 SQLPLUS 命令提示符 sqlplus /nolog 5 在命令提示符以 OS 身份连接 connect / as ...
ORACLE_DBA常用脚本
Oracle的DBA培训资料(ppt) Oracle之DBA培训资料(ppt)
Oracle dba常用操作,很基础很详细。
Oracle DBA常用的UNIX命令,docx格式的,office 2007以及以上版本,本来想用txt的,同事发给我的,同事整理的,有颜色的,txt的就没颜色效果了,还是照搬过来吧,给大家共享下
oracle_dba常用sql脚本分类文档
oracle 常用命令_oracle 命令大全_oracle命令集合_oracle基本命令 非常方便,带查询功能,能很方便的查询你要找的oracle命令写法