Step by Step Information on Oracle Applications R12 Control Scripts

In this post you will come to know about Oracle Applications Control Scripts. It is very important for an APPS DBA to know the location and its usage while handling APPS DBA duties.

The application Tier server process control scripts are used to start and stop server processes on the applications tier like adcmctl.sh (Concurrent manager start/stop control script) and adapcctl.sh (HTTP Server start/stop control script).

The following question can be arise in your mind regarding control scripts on Application Tier.

Now you will think where this control scripts are located in Application Tier

How these control scripts are created.

Is it possible to recreate these control scripts.

Here you go...The answer to the above queries are...

Control scripts are located in the $ADMIN_SCRIPTS_HOME (i.e, $INST_TOP/admin/scripts) directory. It is created by Rapid Install during the installation and you can recreate using AutoConfig (i.e,adautocfg.sh control script) as and when required.

The syntax of the control scripts is [stop or start]

$./adalnctl.sh stop (To stop the Apps Listener)
$./adalnctl.sh start (To start the Apps Listener)

You can use other Application Tier server process control scripts for all server processes to stop and start at the same time.

$./adstrtal.sh (Apps username/password)
$./adstpall.sh (Apps username/password)

To stop or start Forms server in socket mode.

$./adfrmsrvctl.sh

To stop or start Forms OC4J instance in servlet mode.

$./adfrmctl.sh

To stop or start Application Listener.

$./adalnctl.sh

To stop or start concurrent managers.
(This control script required the APPS username and password).

$./adcmctl.sh

To stop or start the HTTP server.

$./adapcctl.sh

Hope you like this post. Please let me know what Topic you would like to see on my blog. Based on request I will start including other stuff too. I am taking my family time to write these articles so I will be on / off from the blogs. You inputs are highly appreciated to improve my blog.

Step by Step Information on Oracle Application R12 Environment files - Part 2

I started in my last post about environment files..

In todays post I am going to discuss some more environment files which an APPS DBA should know.

adovars.env file

adovars.env file which is located under $APPL_TOP/admin, and called from <CONTEXT_NAME.env>. This files specifies various types of file location using various environment variables like

JAVA_TOP -> All java files are copied here and it is the top-level directory

CLASSPATH -> It lists the directories and zip file for java class files needed at runtime.

OA_JRE_TOP -> JRE installation location.

OAD_TOP -> Context-sensitive documentation files are copied at this location.

LD_LIBRARY_PATH -> To list the directories for dyanmic library files needed at runtime.

OAH_TOP -> HTML files are copied at this location.

fndenv.env File

This default values should not be modified of this file. This file is located under $FND_TOP direcotry. It sets additional environment varialbes used by Oracle AOL (i.e, Applcation Object Library).

devenv.env file

This file is located under $FND_TOP and is called by fndenv.env for the purpose of compile and link custom Oracle Forms user exits and concurrent program with Oracle Applications. It sets variable that help you link third-party software and your own custom applications with Oracle Applications.

adconfig.txt File

This file is located under $APPL_TOP/admin directory and AD utility perform a variety of database and file management task for which they require acces to specific configuration information. This information is specified when Oracle Application is installed. It is stored in the adconfig.txt file.

Hope this helps to my blog reader community.

Step by Step Information on Oracle Application R12 Environment files - Part 1

Received numerous emails from my blog readers to start working on blog. Thanks for all of your appreciation ,support and encouragement to start again. My todays post will be based on Oracle Application R12. As I received request from my blog reader to continue with the series of R12. I will continue with R12 articles also going to cover other areas like Database 11g, Oracle Application server, SOA suites etc in my future posts. In this post I am going to discuss about R12 Oracle Environment files.

Environment Files and Control scripts:

Environment files are in place to manage the setup and configuration within the Oracle Application R12 system.Rapid install generates/create number of different environment files.

<CONTEXT_NAME>.env => $ORACLE_HOME (10.2.0.2) => Oracle Server Ent. Edition

<CONTEXT_NAME>.env => $ORACLE_HOME (AS 10.1.2)=> Oracle Tools Tech Stack

<CONTEXT_NAME>.env=> $ORACLE_HOME (AS 10.1.3)=> Java Tech Stack

<CONTEXT_NAME>.env => $APPL_TOP => Oracle Applications

APPS<CONTEXT_NAME>.env => $APPL_TOP =>Consolidated Environment file

Here CONTEXT_NAME is referred to _.CONTEXT_NAME.env is called environment setup file. Whereas APPS<CONTEXT_NAME>.env.env is called a consolidated environment file which reside under APPL_TOP directory.

Now question must be arise in your mind what is in CONTEXT_NAME.env environment file.

As pre R12 DBA must be aware of and fresher might be thinking what it consist of.

So here comes the answer....

CONTEXT_NAME.env consist of :

Product Directories and Subdirectories

Product Directories Paths

Other environment information

Oracle application have important and core environment file is <CONTEXT_NAME>.env

Also you should know what parameters are part of <CONTEXT_NAME>.env environment file.

Here you go to know the description of these parameters.

APPLFENV - This parameter refers to name of the <CONTEXT_NAME>.env environment file.

APPL_TOP - This parameter refers to top-level directory for this installation of Oracle applications.

INST_TOP - This parameter refers to top-level directory for this instance.

FND_TOP - This parameter refers to path to AOL directory. For e.g /d01/oracle/apps/apps_st/appl/fnd/12.0.0

AU_TOP - This parameter refers to path to the applications utilities directory. For e.g /d01/oracle/apps/apps_st/appl/au/12.0.0.

NLS_LANG - This parameter refers to territory,language and character set installed in the database. For e.g AMERICAN_AMERICA.UTF8

NLS_DATE_FORMAT - This parameter refers to National language support date format.For e.g The default is "DD-MON-RR", e.g 16-JUL-08.

NLS_NUMERIC_CHARACTERS - This parameter refers to National language support numberic separators. The defulat is period and comman (".,").

<PROD>_TOP - This parameter refers to path to a product's top directory

GWYUID - This parameter refers to the user name/password that give access to the initial sign on.

APPLDCP - This parameter refers to whether PCP is being used. This should be set to OFF if not using PCP.

APPLTMP - This parameter refers to directory for temp file in Oracle Applications.

APPLPTMP - This parameter refers to directory for temp PL/SQL output files.

APPLCNAM - This parameter refers to 8.3 file name convention for concurrent manager log and output files format.

APPLLOG - This parameter refers to concurrent manager log subdirectory.

APPLOUT - This parameter refers to concurrent manager output files subdirectory.

APPLCSF - This parameter refers to the top-level directory for concurrent manager log and output files if they are consolidated into single direcotry for all products.

PATH - This parameter refers to sets directory search path

FNDNAM - This parameter refers to the name of the schema to which the system
administration responsibility connects.

ADMIN_SCRIPTS_HOME - This parameter refers to directory under $INST_TOP that identifies the location of control scripts.

PLATFORM - This parameter refers to the O/S currently in use. The value of this parameter should match with $APPL_TOP/admin/adpltfrom.txt

I will continue with other environment files in my next post..coming soon...