首页 / ORACLE / OracleAppsDBA常用命令

OracleAppsDBA常用命令

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了OracleAppsDBA常用命令，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含11637字，纯文字阅读大概需要17分钟。

内容图文

数据库启动监听 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:

==================================================

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 /appsutil/scripts/)

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 /appsutil/install/)

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 /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 Utility Name	Executable or Script	Description
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

EBS-r12.1.1安装
http://ebshome.blogspot.jp/2012/06/ebs-r1211.html

http://blog.csdn.net/pan_tian/article/details/7612517

内容总结

以上是互联网集市为您收集整理的OracleAppsDBA常用命令全部内容，希望文章能够帮你解决OracleAppsDBA常用命令所遇到的程序开发问题。如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/535443.html

来源：【匿名】

【上一篇】Oracle11gR2新特性：DeferredSegmentGeneration 【下一篇】Oracle Faq(Oracle TAF的配置)

更多 ►

【OracleAppsDBA常用命令】教程文章相关的互联网学习教程文章

oracle常用命令

--登录：sys/ken@orcl as sysdba1、建立表空间、授予权限/*分为四步 *//*第1步：创建临时表空间 */create temporary tablespace user_temp tempfile ‘D:\oracle\oradata\Oracle9i\user_temp.dbf‘ size 50m autoextend on next 50m maxsize 20480m extent management local; /*第2步：创建数据表空间 */create tablespace user_data logging datafile ‘D:\oracle\oradata\Oracle9i\user_data.dbf‘ size 50m autoexten...

Oracle 常用命令大全

查看当前用户的角色 select * from user_role_privs; 查看当前用户的系统权限和表级权限 select * from user_sys_privs; select * from user_tab_privs; 查看用户下所有的表 select * from user_tables; 查看用户下所有的视图 select view_name from user_views; 查看某表的约束条件 select constraint_name, constraint_type,search_condition, r_constraint_name from user_constraints where table_name = upper...

Oracle-01-数据库分类/oracle sql*plus常用命令

一、数据库分类一、数据库分类1、小型数据库：access、foxbase2、中型数据库：informix、sql server、mysql3、大型数据库：sybase、db2、oracle 二、项目中如何合理地使用数据库，可以依据如下三个方面入手1、项目的规模a、负载量有多大，即用户数有多大b、成本c、安全性 eg、小型数据库1、负载量小，用户大概100人之内比如：留言板、信息管理系统2、成本在千元之内3、对安全性要求不高 ...

ORACLE常用命令

一、ORACLE的启动和关闭 1、在单机环境下要想启动或关闭ORACLE系统必须首先切换到ORACLE用户，如下 su-oracle a、启动ORACLE系统 oracle>svrmgrl SVRMGR>connectinternal SVRMGR>startup SVRMGR>quit b、关闭ORACLE系统 oracle>svrmgrl SVRMGR>connectinternal SVRMGR>shutdown SVRMGR>quit 启动oracle9i数据库命令： $sqlplus/nolog SQL*Plus:Release9.2.0.1.0-ProductiononFriOct3113:53:532003 Copyright(c)1982,2002,OracleCo...

20170411oracle常用命令【代码】

--1新建用户create user shopping identified by 123456;--分配权限 grant connect,resource,dba to shopping;--切换用户 conn shopping/123456 --切换到管理员 conn /as sysdba 原文：http://www.cnblogs.com/super-admin/p/6696623.html

二、oracle sql*plus常用命令【代码】

一、sys用户和system用户 Oracle安装会自动的生成sys用户和system用户 (1)、sys用户是超级用户，具有最高权限，具有sysdba角色，有create database的权限，该用户默认的密码是change_on_install (2)、system用户是管理操作员，权限也很大。具有sysoper角色，没有create database的权限，默认的密码是manager (3)、一般讲，对数据库维护，使用system用户登录就可以拉注意：也就是说sys和system这两个用户最大的区别是在于有没有cre...

Oracle数据库基本常用命令汇总

1、得到数据库名和创建日期SELECT name, created, log_mode, open_mode FROM v$database;2、ORACLE数据库的计算机的主机名，ORACLE数据库的实例名及ORACLE数据库管理系统的版本信息SELECT host_name, instance_name, version FROM v$instance;3、为了知道oracle数据库版本的一些特殊信息select * from v$version;4、获取控制文件名字select * from v$controlfile;5、得到Oracle数据库的重做日志配置信息SELECT group#, members, by...

oracle的归档模式ORACLE数据库归档日志常用命令

Oracle数据库有联机重做日志，这个日志是记录对数据库所做的修改，比如插入，删除，更新数据等，对这些操作都会记录在联机重做日志里--连接恢复管理器 C:\Documents and Settings\mengzhaoliang>rman target/ --归档日志列表 RMAN> list archivelog all; --删除物理文件不存在的归档日志 RMAN> delete expired archivelog all; --删除7天前的归档日志 RMAN> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7'; oracle的归档模式...

【ORACLE-学习笔记】常用命令

SQLPLUS - > user和password 查看当看的用户： SHOW USER; 查看数据库里面的数据库表： SELECT table_name FROM user_tables; 修改自身的密码： PASSW 退出/断开： EXIT/DISC 切换用户： CONN user/password// 用户管理创建用户： CREATE USER user IDENTIFIED BY password; 修改用户密码： PASSWORD user; 修改用户： ALTER USER user IDENTIFIED BY newpassword 删除用户： DROP USER user [CASCADE]// 权限管理（系统权限、对...

oracle 常用命令【代码】

创建/删除表空间创建： create tablespace USERS datafile ‘/oracle/oradata/mytest/tsuser.dbf‘ size 500M autoextend on next 10M maxsize unlimited extent management local; 删除： DROP TABLESPACE USERS INCLUDING CONTENTS AND DATAFILES; 2. 创建/删除用户 Create User ERIC Identified by Password Default TableSpace USERS; // 这里也可以不指定表空间，可以在后面的时候一起授权 drop user ERIC cascade Grant Con...

大小中型数据库和Oracle的常用命令【代码】

@ d:\a.sql 或是 sql>start d:a.sql 2、edit 说明：该命令可以编辑指定的sql脚本案例：sql>edit d:\a.sql，这样会把d:\a.sql这个文件打开 3、spool 说明：该命令可以将sql*plus屏幕上的内容输出到指定的文件中去案例：sql>spool d:\b.sql 并输入 sql>spool off 交互式命令 1、& 说明：可以替代变量，而该变量在执行时，需要用户输入。Select *form emp where job=‘&job‘; 显示和设置环境变量概述：可以用来控制输出的各种...

Oracle常用命令

1.连接racle: sqlplus username/password@sid [as sysdba] SQL>startup force [nomount/mount/open/force/restrict] SQL>shutdown [normal/transactional/immediate/abort] 2.启动控制台: mysqld-nt –install(压缩的安装成服务) mysqld-nt –remove(卸载服务) net start(stop) mysql DE>mysql -v或者mysql -u root -pDE> set oracle_sid=**emctl start dbconsolehttp://hnjk-oh:1158/emisqlpuls starthttp://hnjk-oh:5560/isq...

oracle创建用户及常用命令【代码】

--首先创建临时表空间 create temporary tablespace test_temp tempfile ‘路径‘ size 32M autoextend on next 32M maxsize 2048M extend management local; --创建表空间 create tablespace test_data logging data ‘路径‘ size 32M autoextend on next 32M maxsize 2048M extend management local;--创建用户，分配表空间 create tuser test identified by ‘123456‘ default tablespace test_data temporary table tablespa...

Oracle教程-常用命令（二）

一、sys用户和system用户Oracle安装会自动的生成sys用户和system用户(1)、sys用户是超级用户，具有最高权限，具有sysdba角色，有create database的权限，该用户默认的密码是change_on_install(2)、system用户是管理操作员，权限也很大。具有sysoper角色，没有create database的权限，默认的密码是manager(3)、一般讲，对数据库维护，使用system用户登录就可以拉注意：也就是说sys和system这两个用户最大的区别是在于有没有create d...

二、oracle sqlplus常用命令

一、sys用户和system用户　　Oracle安装会自动的生成sys用户和system用户　　(1)、sys用户是超级用户，具有最高权限，具有sysdba角色，有create database的权限，该用户默认的密码是change_on_install　　(2)、system用户是管理操作员，权限也很大。具有sysoper角色，没有create database的权限，默认的密码是manager　　(3)、一般讲，对数据库维护，使用system用户登录就可以拉　　注意：也就是说sys和system这两个用户最大的区别...

ORACLE - 最热教程

Oracle11g 创建数据库中问题处理（必须...Oracle 查看索引表空间 Navicat报错-ORA-28547：connection to...oracle 查看最大连接数 Oracle中合并数据集(多行变一行)Navicat如何添加oracle的oci.dll插件，...oracle如何将am,pm时间字符串改为时间格...for update造成的Oracle锁表与解锁 phppdooracle中文乱码的快速解决方法_P...Oracle分区表新增主分区及子分区语句

首页 / ORACLE / OracleAppsDBA常用命令

OracleAppsDBA常用命令

内容导读

内容图文

内容总结

内容备注

内容手机端

【OracleAppsDBA常用命令】教程文章相关的互联网学习教程文章

oracle常用命令

Oracle 常用命令大全

Oracle-01-数据库分类/oracle sql*plus常用命令

ORACLE常用命令

20170411oracle常用命令【代码】

二、oracle sql*plus常用命令【代码】

Oracle数据库基本常用命令汇总

oracle的归档模式ORACLE数据库归档日志常用命令

【ORACLE-学习笔记】常用命令

oracle 常用命令【代码】

大小中型数据库和Oracle的常用命令【代码】

Oracle常用命令

oracle创建用户及常用命令【代码】

Oracle教程-常用命令（二）

二、oracle sqlplus常用命令

ORACLE - 相关标签

ORACLE - 最新教程

ORACLE - 最热教程