Monday, May 24, 2010

Setting Enviroment Variables For Oracle R12

Setting Environment Variables For Oracle R12

Open .bas_profile at following path

Computer ---> Home ---> Oracle ---> .bas_profile

(where oracle is the OS user name.)

Now add these two lines in it.

export ORA_dbENV=’/d01/oracle/prod1/db/tech_st/10.2.0/PROD1_prod1.env’

export ORA_appsENV=’/d01/oracle/prod1/apps/apps_st/app1/APPSPROD1_prod1.env’


The above lines will create two environment variables as ORA_dbENV and ORA_appsENV


(I have used the paths according to our environment. You can change it according to yours, After prod1 the path will be same.)


Navigate to both the files PROD1_prod1.env and APPSPROD1_prod1.env and give all the permissions on them so that it can be executed.


Logout the system and login again so that the bash_profile will be loaded to memory.


sources the files so the all the environment variables will set using (. $ORA_dbENV and . $ORA_appsENV).


Now all the variables are set .


Note: You can source one variable at a time. Sourcing both will overwrite the value of the previous one.


No comments:

Post a Comment