Oracle Enviroment Variables in unix

Submitted by code_admin on Thu, 07/12/2018 - 15:42

Oracle supplies some environment variables that point to specific directories in the file system. This page explains how to setup individual users so that these environment variables are always available.
Once this is done you can test the environment is set up by using the env command or typing echo $APPL_TOP at the bash prompt.

Redhat Linux - including Oracle Enterprise Linux

In the users home directory there is a file called .bash_profile (It starts with a leading dot) Put something like the following in it:

  1. source /d01/oracle/VIS/apps/apps_st/appl/APPSVIS_oracle.env

IBM Aix systems
In the users home directory is a file called .profile
Add a line like the following to the bottom of the file

' 11i:
. /apps11i/prod/prodappl/APPSPROD_gchrprddb.env

R12 VISION database

Db Enviroment
. /d01/oracle/VIS/db/tech_st/11.1.0/VIS_localhost.env

' Apps Enviroment
. /d01/oracle/VIS/apps/apps_st/appl/APPSVIS_localhost.env

Search Terms
env

RJM Article Type
Quick Reference