Below are some of the important Operating system level environment variables related to R12.2.
$ echo $FILE_EDITION
<shows which file edition you are using, run or patch>
$ echo $RUN_BASE
<shows absolute path to run file system>
$ echo $PATCH_BASE
<shows absolute path to patch file system>
$ echo $NE_BASE
<shows absolute path to non-edition file system>
$ echo $APPL_TOP_NE
<non-editioned appl_top path. Equivalent to $NE_BASE/EBSapps/appl>
$ echo $LOG_HOME
<Application Instance Specific Log Directory>
$ echo $ADOP_LOG_HOME
<Online patching Specific Log Directory. Equivalent to $NE_BASE/EBSapps/log/adop>
$ echo $IAS_ORACLE_HOME
<FMW Web Tier Home Directory>
$ echo $ORACLE_HOME
< 10.1.2 ORACLE_HOME>
$ echo $CONTEXT_FILE
<Source for information populating template files (autoconfig)>
$ echo $EBS_DOMAIN_HOME
<WLS Deployment of Oracle E-Business Suite 12.2 Domain (instance specific)>
$ echo $ADMIN_SCRIPTS_HOME
<Shell scripts to control processes associated to the Applications Instance>
$ echo $EBS_ORACLE_HOME
<Oracle E-Business Suite 12.2 FMW Deployment directory>
$ echo $RW
<10.1.2 reports directory>
$ echo $HOSTNAME
<hostname without domain name>
$ echo $APPS_VERSION
<to get the EBS version>
And the most important part is for setting up the right environment don’t directly hard code the RUN environemnt .env file in the .profile of OS user as online patching switches the filesystem from RUN to PATCH and vice versa and it can really create confusion.
Instead use EBSapps.env environment file (created under BASE directory) with ‘RUN’ as argument. It will automatically find which file system (fs1 or fs2) is currently RUN file system. it will then serach the correct ENV file under $APPL_TOP of RUN/PATCH (whatever you asked for) and lay out the correct environment.
So EBSapps.env is third ENV file besides the ENV files under PATCH and RUN APPL_TOPs. EBSapps.env file internally will point to the correct ENV file based on your needs.
For example, in our case base directory is ‘/u01/oracle/dba’
. /u01/oracle/dba/EBSapps.env RUN
It will set environemnt and display below information on screen. E-Business Suite Environment Information —————————————- RUN File System : /u01/oracle/dba/fs2/EBSapps/appl PATCH File System : /u01/oracle/dba/fs1/EBSapps/appl Non-Editioned File System : /u01/oracle/dba/fs_ne DB Host: dbhost.hertz.com Service/SID: dba Sourcing the RUN File System …
- Oracle Multitenant DB 4 : Parameters/SGA/PGA management in CDB-PDB - July 18, 2020
- Details of running concurrent requests in Oracle EBS - May 26, 2020
- Oracle Multitenant DB 3 : Data Dictionary Architecture in CDB-PDB - March 20, 2020
Nice Article
Its very useful
Cool
Much useful for starters
Hi, guys!
In this post, there is a PL/SQL script that generates the current database environment file.
Also, it contains a good example of an environment file you’d better use for your database.
http://dbpilot.net/2018/01/30/generating-an-enviroment-file-from-pl-sql/
Thank you! Saved my time.