EBS R12系统的正常关闭和启动:
①
Shutdown:
先关闭应用系统所有应用服务,然后关闭数据库监听,最后关闭数据库:
# su - applmgr
$ cd /u01/oracle/PROD/apps/apps_st/appl/
$ . ./APPSPROD_ebsr12.env
$ echo $APPL_TOP
/u01/oracle/PROD/apps/apps_st/appl
$ cd $ADMIN_SCRIPTS_HOME
$ pwd
/u01/oracle/PROD/inst/apps/PROD_ebsr12/admin/scripts
$
$ ./adstpall.sh apps/apps
$ ps -ef |grep httpd
$ ps -ef |grep FNDLIBR
$ ps -ef |grep java
$ ps -ef |grep frmweb
$ ps -ef |grep tns
# su - oracle
$ cd /u01/oracle/PROD/db/tech_st/11.1.0/
$ . ./PROD_ebsr12.env
$ lsnrctl stop
$ sqlplus /nolog
SQL> conn /as sysdba
SQL> shutdown immediate
SQL> exit
----------------------------------
使用自带脚本(偶还是喜欢上面的命令去关闭数据库和监听,可能之前的习惯,看着都舒服!注\db实例名为:PROD):
$ pwd
/u01/oracle/PROD/db/tech_st/11.1.0
$ cd appsutil/scripts/PROD_ebsr12/
$ . ./addlnctl.sh stop PROD
$ . ./addbctl.sh stop immediate
--------------------------------
②
Startup:
启动ERP时一定要先启动数据库监听和数据库,然后再启动应用系统:
# su - oracle
$ cd /u01/oracle/PROD/db/tech_st/11.1.0/
$ . ./PROD_ebsr12.env
$ lsnrctl start
$ sqlplus /nolog
SQL*Plus: Release 11.1.0.7.0 - Production on Sun Jul 15 18:20:14 2012
Copyright (c) 1982, 2008, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected to an idle instance.
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2166536 bytes
Variable Size 427819256 bytes
Database Buffers 624951296 bytes
Redo Buffers 14000128 bytes
Database mounted.
Database opened.
SQL>
# su - applmgr
$ cd /u01/oracle/PROD/apps/apps_st/appl/
$ . ./APPSPROD_ebsr12.env
$ echo $APPL_TOP
/u01/oracle/PROD/apps/apps_st/appl
$ cd $ADMIN_SCRIPTS_HOME
$ . ./adstrtal.sh apps/apps