oracle调用apps,OracleAppsDBA常用命令

数据库启动监听 addlnctl.sh start instance 启动数据库 addbctl.sh start 启动应用服务器 adstrtal.sh 停止应用服务器 adstpall.sh ------------------------------- 系统启动/关闭相关的脚本 数据库层 名称: addbctl.sh 说明: Start/Stop database 路径: $

数据库启动监听

addlnctl.sh start instance

启动数据库

addbctl.sh start

启动应用服务器

adstrtal.sh

停止应用服务器

adstpall.sh

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

系统启动/关闭相关的脚本数据库层名称:addbctl.sh

说明:Start/Stop database

路径:${ORACLE_HOME}/appsutil/scripts/VIS_ebs121/addbctl.sh

应用层名称:adalnctl.sh

说明:Start / Stop Applications RPC Listener process

路径:${INST_TOP}/admin/scripts/adalnctl.sh

名称:adapcctl.sh

说明:start, stop and check the status of Oracle HTTP Server.

路径:${INST_TOP}/admin/scripts/adapcctl.sh

名称:adoacorectl.sh

说明:start, stop and check the status of the oacore oc4j instance

路径:${INST_TOP}/admin/scripts/adoacorectl.sh

名称:adformsctl.sh

说明:start, stop and check the status of the forms oc4j instance.

路径:${INST_TOP}/admin/scripts/adformsctl.sh

名称:adcmctl.sh

说明:Start / Stop Concurrent Manager for VIS

路径:${INST_TOP}/admin/scripts/adcmctl.sh

AllInOne名称:adstrtal.sh

说明:start Oracle E-Business Suite Services

路径:${INST_TOP}/admin/scripts/adstrtal.sh

名称:adstpall.sh

说明:stop Oracle E-Business Suite Services

路径:${INST_TOP}/admin/scripts/adstpall.sh

可以讲这些脚本整合到root用户下, 实现EBS服务的启动与关闭. 以笔者为例:/root/scripts/start.sh

su - oracle -c "${ORACLE_HOME}/appsutil/scripts/VIS_ebs121/addbctl.sh start"

su - oracle -c "${ORACLE_HOME}/bin/lsnrctl start"

su - applmgr -c "/d01/oracle/VIS/inst/apps/VIS_ebs121/admin/scripts/adalnctl.sh start"

su - applmgr -c "/d01/oracle/VIS/inst/apps/VIS_ebs121/admin/scripts/adapcctl.sh start"

su - applmgr -c "/d01/oracle/VIS/inst/apps/VIS_ebs121/admin/scripts/adoacorectl.sh start"

su - applmgr -c "/d01/oracle/VIS/inst/apps/VIS_ebs121/admin/scripts/adformsctl.sh start"

su - applmgr -c "/d01/oracle/VIS/inst/apps/VIS_ebs121/admin/scripts/adcmctl.sh start apps/apps"/root/scripts/stop.sh

su - applmgr -c "/d01/oracle/VIS/inst/apps/VIS_ebs121/admin/scripts/adcmctl.sh stop apps/apps"

su - applmgr -c "/d01/oracle/VIS/inst/apps/VIS_ebs121/admin/scripts/adformsctl.sh stop"

su - applmgr -c "/d01/oracle/VIS/inst/apps/VIS_ebs121/admin/scripts/adoacorectl.sh stop"

su - applmgr -c "/d01/oracle/VIS/inst/apps/VIS_ebs121/admin/scripts/adapcctl.sh stop"

su - applmgr -c "/d01/oracle/VIS/inst/apps/VIS_ebs121/admin/scripts/adalnctl.sh stop"

su - oracle -c "${ORACLE_HOME}/appsutil/scripts/VIS_ebs121/addbctl.sh stop immediate"以上就是一些与EBS启动/关闭相关的脚本介绍, 最后如果不希望打开VBox的窗体而通过ssh进行操作的

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

查看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.shScript 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 ohslike 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.shThis 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 /appsutil/scripts/)Control ScriptFunctionality

addbctl.shControl database server

addlnctl.shControl Oracle Net listener for the database server

RDBMS ORACLE_HOME Install scripts

(located under /appsutil/install/)Install ScriptFunctionality

adsvdlsn.shStart Oracle Net listener during installation

adcrdb.shStart database and create database control files

addbprf.shSet profile option values

adsvdcnv.shPerform character set conversion and licensing tasks

adsvdb.shStart database during installation

Application Service Control scripts

(located under /admin/scripts)Control ScriptFunctionalityNode

adalnctl.shControl Oracle Net8 listener for Applications servicesAll application tier server nodes

adstrtal.shStart all Applications server processesAll application tier server nodes

adstpall.shStop all Applications server processesAll application tier server nodes

adcmctl.shControl Concurrent managersConcurrent processing server node

adapcctl.shControl Apache processesHTTP server node

adopmnctl.shControls Oracle Process ManagerHTTP server node

adoacorectl.shControls Oacore Oc4j InstanceHTTP server node

adformsctl.shControls Forms Oc4j InstanceHTTP server node

adoafmctl.shControls Oafm Oc4j InstanceHTTP server node

jtffmctl.shControl Oracle fulfillment serverHTTP 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 UtilitiesAD Utility NameExecutable or ScriptDescription

AD AdministrationadadminPerforms maintenance tasks for Oracle E-Business Suite.

AD Check DigestadchkdigChecks the integrity of Oracle E-Business Suite patches downloaded from My Oracle Support.

AD Configurationadutconf.sqlReports standard information about the installed configuration of Oracle E-Business Suite.

AD ControlleradctrlManages parallel workers in AD Administration and AutoPatch.

AD File IdentificationadidentReports the version and translation level of an Oracle E-Business Suite file.

AD File Character Set ConverteradncnvConverts a file from one character set to another.

AD Merge Patch*admrgpchMerges multiple patches into a single merged patch.

AD Relinkadrelink.shRelinks Oracle E-Business Suite executable programs with the Oracle server product libraries.

AD SpliceradspliceAdds off-cycle products.

AD Job Timing ReportReports a summary of the timing for jobs run by parallel workers.

AutoPatch*adpatchApplies patches and other system updates.

Patch Application Assistant*admsi.plGenerates customized installation instructions for a patch.

Rapid Install**rapidwizProvides 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

EBS-r12.1.1安装

http://ebshome.blogspot.jp/2012/06/ebs-r1211.html

http://blog.csdn.net/pan_tian/article/details/7612517 本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源：php中文网