Oracle Application Maintenance Procedure

  • Overview :-

This document will take you through the basic administration of the application that an APPS DBA should know. We have tried

to cover all the best possible tasks used on daily basis to monitor and maintain the application.

  • Table on Contents :-

✔ Ad Administration

✔ Starting and Stopping application services

✔ Autoconfig

✔ Other Activities

Using adadmin ( Application database administration)

➔ Application administration can be done using Ad Administration (adadmin).
Login to the application as the appl user and source the environment file

./APPS_host.env
$ adadmin --- Requires system and apps user password
It will prompt for system and apps password.
AD code level : [ A. 6]
AD Administration Main Menu
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
1. Generate Applications Files menu
2. Maintain Applications Files menu
3. Compile/Reload Applications Data base Entities menu
4. Maintain Applications Database Entities menu
5. Change Maintenance Mode
6. Exit AD Adminisitration
Enter your choice [ 6] :

➔ General Applications File menu – This options helps you to generates forms,reports,message and JAR files.

a) Generate message files
b) Generate form files
c) Generate report files
d) Generate product JAR files

➔ Maintain Applications Files – This options helps you to execute the following

a) Relink Oracle applications – Relinks oracle applications executable programs with ORACLE server libraries
b) Copy files to destination
c) Convert characterset
d) Maintain snapshot information
e) Check for missing files

➔ Compile/Reload Applications Database Entities menu – Helps in compiling or reloading database entities

a) Compile APPS schema
b) Compile menu information
c) Compile flexfields
d) Reload JAR files to data base

➔ Maintain Applications Database Entities menu – Helps in verifying the intergrity of the APPS schema and also recreate permissions for APPS schema

a) Validate APPS schema
b) Re - create grants and synonyms for APPS schema
c) Maintain multi - lingual tables
d) Check DUAL table

➔ Change Maintenance Mode – Controls the system downtime period by managing user logons

a) Enable Maintenance Mode
b) Disable Maintenance Mode

Stopping and Starting Application and Database services

Stop/Start all the application services

Login to Application as application user (for e.g applprod,applmgr)

UNIX ENVIRONMENT

su – applmgr
cd $INST_TOP/admin/scripts/
sh adstpall.sh apps/----- To Stop all the application services
sh adstrtal.sh apps/----- To Start all the application services

WINDOWS ENVIRONMENT

cd %INST_TOP%\admin\scripts
adstpall.cmd apps/-------- To Stop all the application services
adstrtal.cmd apps/------- To Start all the application services

➔ Stop/Start single application services

  • Stop the Apache service
 cd admin/scripts
 UNIX – adapcctl.sh stop/start
 WIN – adapcctl.cmd stop/start
  • Startup/Stop “HTTP”
Log file Location - $LOG_HOME/ora/10.1.3/Apache directory:
 ssl_engine_log
 access_log.999999999
 error_log.999999999
 Stop the Forms Service
 cd/admin/scripts
 UNIX – adformsctl.sh stop/start
 WIN – adformsctl.cmd stop/start
  • Startup/Stop “forms” OC4J
Logile Location same as OACORECTL.SH
UNIX – adoafmctl.sh stop/start
WIN – adoafmctl.cmd stop/start
  • Startup/Stop “oafm” OC4J – Oracle Application Fusion Middleware
Logile Location same as OACORECTL.SH
UNIX – adoacorectl.sh stop/start
WIN – adoacorectl.cmd stop/start
  • Startup/Stop “oacore” OC4J
Log file Location - $LOG_HOME/ora/10.1.3 directory:-
opmn/OC4J~oacore~default_group~1
opmn/oacore_default_group_1/oacorestd.err
opmn/oacore_default_group_1/oacorestd.out
j2ee/oacore/oacore_default_group_1/jms.log
j2ee/oacore/oacore_default_group_1/application.log
j2ee/oacore/oacore_default_group_1/rmi.log
j2ee/oacore/oacore_default_group_1/server.log
j2ee/oacore/oacore_default_group_1/global-application.log
j2ee/oacore/oacore_default_group_1/log.xml
j2ee/oacore/oacore_default_group_1/system-application.log
UNIX – adopmnctl.sh stop/start
WIN – adopmnctl.cmd stop/start
  • Startup/Stops just the OPMN service
Log file Location - $LOG_HOME/ora/10.1.3/opmn directory

opmn.dbg
opmn.out
opmn.log
UNIX – adcmctl.sh stop/start apps/appspasswd – Requires apps password
WIN – adcmctl.cmd stop/start apps/appspasswd – Requires apps password

  • Startup/Stop “Concurrent Programs”
UNIX – adalnctl.sh stop/start
WIN – adalnctl.cmd stop/start
  • Startup/Stop “APPS LISTENER”
  • Login to Database as dba user (for e.g oraprod,oracle)
UNIX ENVIRONEMNT
su – oracle
cd $ORACLE_HOME/appsutil/scripts/SID_HOSTNAME
sh addbctl.sh stop immediate ----- To Stop the database
sh addlnctl.sh stop– To stop the listener
sh addbctl.sh start --- To start the database
sh addlnctl.sh start– To start the listener
WINDOWS ENVIRONEMNT
cd %ORACLE_HOME%\appsutil\scripts\SID_HOSTNAME
addbctl.cmd stop immediate ---- To stop the database
addlnctl.cmd stop– To stop the listener
addbctl.cmd start ---- To start the database
addlnctl.cmd start– To start the listener

P.N : While starting the services you should first start the database and database listener and then start the application services.

Using Autoconfig to update the Application and Database

  • AutoConfig is a configuration tool that automates the configuration of an Oracle Applications system
  • Information required to configure the application is stored in a repository called Application CONTEXT(SID_HOST.xml)
  • One context file exists for application tier and one for database tier.
  • Autconfig uses information from this context file to configure all the files across the application and database system.
  • R12 is by default Autoconfig enabled
  • To verify if 11i system is Autoconfig enabled go to $AD_TOP/bin and execute adcfginfo.sh contextfile=

Running Autconfig on Database Tier

Login as database user ( for.eg oraprod,oracle)

UNIX ENVIRONMENT
su – oracle
./SID_HOSTNAME.env
cd $ORACLE_HOME/appsutil/scripts/SID_HOSTNAME
adautocfg.sh ---- Requires apps password
WINDOWS ENVIROMENT
cd\appsutil\scripts\SID_HOSTNAME
adautocfg.cmd – Requires apps password

Running Autoconfig on Application Tier

Login as application user (for e.g : applprod,applmgr)

UNIX ENVIROMENT
su – applmgr
./APPS_HOST.env
cd/admin/scripts
adautoconfig.sh ---- Requires apps password
WINDOWS ENVIROMENT
cd %INST_TOP%\admin\scripts
adautocfg.cmd ---- Requires apps password

Review the Autconfig logfile for errors

Application
/admin/log/
Database
/appsutil/log/SID_HOSTNAME/

Rollback Autoconfig

Application
/admin/out/
UNIX – restore.sh
WIN -- restore.cmd
Database
/appsutil/out/SID_HOSTNAME/
UNIX -- restore.sh
WIN – restore.cmd

OTHER ACTIVITIES

➔ To check the file version

strings -a| grep '$Header'

➔ Compile single Report or Forms

#UNIX Forms Compile
#compile_forms.sh
for i in `ls *.fmb`
do
echo Compiling Form $i ....
frmcmp_batch.sh userid=apps/appspass@SID batch=yes module=$i module_type=form compile_all=yes
window_state=minimize
done
#UNIX COMPILE REPORTS
#compile_rep.sh
for i in `ls *.rdf`
do
echo Compiling Report $i ...
rwconverter.sh userid=apps/appspasswd@SID batch=yes source=$i stype=rdffile dtype=repfile overwrite=yes
compile_all=yes
done
#WINDOWS COMPILE FORMS
#compile_forms.bat
cls
Echo compiling Forms....
for %%f IN (*.fmb) do frmcmp userid=scott/tiger@v11G module=%%f batch=yes module_type=form
compile_all=yes window_state=minimize
ECHO FINISHED COMPILING
#WINDOWS COMPILE REPORT
#compile_report.bat
cls
Echo compiling Report .....
for %%f IN (*.rdf) do rwconverter userid=scott/tiger@v11G batch=yes source=% %f stype=rdffile
DTYPE=REPFILE compile_all=yes OVERWRITE=yes logfile=log.txt
ECHO FINISHED COMPILING
Share →
Skip to toolbar