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...