I have a websphere application which runs under the user wsadmin
.
The application invokes the SQL bulk loader client ./sqlldr
The sqlldr needs some environment variables predefined in order to work such as
ORACLE_BASE=/usr/app/oracle
ORACLE_HOME=/usr/app/oracle/product/11.2.0.1/client_64
ORACLE_SID=VDO1018
Can you tell me what is the best place to put these variables. I have few options:
1) /etc/profile or /etc/environment
2) .bash_profile of wsadmin user
The reason I am asking this question is sqlldr is failing randomly for us and currently the variables are placed in .bash_profile. since .bash_profile is used for login shells, I am not sure if it would apply for JVM process.