Maintaining System Configuration:Start,Stop database and tier process

Maintaining System Configuration This section describes how to apply latest AutoConfig patch and manage your Oracle Applications Release 11i if your Instance is AutoConfig enabled. In addition to re-configuring your system, AutoConfig can be used to review changes made to the configuration files, to start and stop Applications processes and to start and stop Database processes.

1. Commands to maintain System Configurations on the Database Tier
All scripts listed below are located in
RDBMS/appsutil/scripts/CONTEXT_NAME.
/oracle/iosadesadb/10.2.0/appsutil/scripts/IOSADESA_ioversondb2
Platform Functionality Command
UNIX
Start Database listener process addlnctl.sh start SID
Start Database process addbctl.sh start
Stop Database listener process addlnctl.sh stop SID
Stop Database process addbctl.sh stop immediate
Run AutoConfig adautocfg.sh
Windows
Start Database listener process addlnctl.cmd start SID
Start Database process addbctl.cmd start
Stop Database listener process addlnctl.cmd stop SID
Stop Database process addbctl.cmd stop
Run AutoConfig adautocfg.cmd
Note: Running AutoConfig might change your existing environment files. After running AutoConfig, you should always set the environment before you run any Applications utilities in order to apply the changed environment variables.
[oracle@ioversondb2 IOSADESA_ioversondb2]$ ./adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /oracle/iosadesadb/10.2.0/appsutil/log/IOSADESA_ioversondb2/09291835/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /oracle/iosadesadb/10.2.0
Classpath : /oracle/iosadesadb/10.2.0/jdk/jre/lib/rt.jar:/oracle/iosadesadb/10.2.0/jdk/lib/dt.jar:/oracle/iosadesadb/10.2.0/jdk/lib/tools.jar:/oracle/iosadesadb/10.2.0/jdbc/lib/ojdbc14.jar:/oracle/iosadesadb/10.2.0/appsutil/java/xmlparserv2.zip:/oracle/iosadesadb/10.2.0/appsutil/java:/oracle/iosadesadb/10.2.0/jlib/netcfg.jar:/oracle/iosadesadb/10.2.0/jlib/ldapjclnt10.jar
Using Context file : /oracle/iosadesadb/10.2.0/appsutil/IOSADESA_ioversondb2.xml
Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db102
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

3. Commands to maintain System Configurations on the Application Tier
All scripts listed below are located in
COMMON_TOP/admin/scripts/CONTEXT_NAME.
/u02/oracle/iosadesacomn/admin/scripts/IOSADESA_ioversonas2

Platform Functionality Command
UNIX
Start Applications processes adstrtal.sh APPSUSER
Stop Applications processes adstpall.sh APPSUSER
Run AutoConfig adautocfg.sh
Windows

Start Applications processes adstrtal.cmd APPSUSER
Stop Applications processes adstpall.cmd APPSUSER
Run AutoConfig adautocfg.cmd

Note: Running AutoConfig might change your existing environment files. After running AutoConfig, you should always set the environment before you run any Applications utilities in order to apply the changed environment variables.

[applmgr@ioversonas2 IOSADESA_ioversonas2]$ ./adautocfg.sh
Enter the APPS user password :

The log file for this session is located at: /u02/oracle/iosadesaappl/admin/IOSADESA_ioversonas2/log/09291811/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
Using APPL_TOP location : /u02/oracle/iosadesaappl
Classpath : /u02/oracle/iosadesacomn/util/java/1.4/j2sdk1.4.2_04/jre/lib/rt.jar:/u02/oracle/iosadesacomn/util/java/1.4/j2sdk1.4.2_04/lib/dt.jar:/u02/oracle/iosadesacomn/util/java/1.4/j2sdk1.4.2_04/lib/tools.jar:/u02/oracle/iosadesacomn/java/appsborg2.zip:/u02/oracle/iosadesacomn/java

Using Context file : /u02/oracle/iosadesaappl/admin/IOSADESA_ioversonas2.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring ABM_TOP.......COMPLETED
Configuring ECX_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring GL_TOP........COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring XNC_TOP.......COMPLETED
Configuring IGS_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring PA_TOP........COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring IMT_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.