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.

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

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

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

·  .env => $APPL_TOP => Oracle Applications

·  APPS.env => $APPL_TOP =>Consolidated Environment file


Here CONTEXT_NAME is referred to _.CONTEXT_NAME.env is called environment setup file. Whereas APPS.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.env

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

Here you go to know the description of these parameters.

·  APPLFENV - This parameter refers to name of the.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 (".,").

·  _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