Originally Posted by CarlosinFL
As I finalize my Oracle 11g R2 (126.96.36.199) database installation on RHEL 6.3 Linux, I have some questions I wasn't able to find in the documentation:
1. The documentation advise you to configure the 'oracle' users home environment variables but I'm not 100% on exactly what MUST be present in .bash_profile in order to make sure Oracle is running as expected. Right now I only have:
Are there any other environment variables that are "required" for the 'oracle' user? The documentation do not instruct me to add or do so however I think I'm missing:
Do I need to manually set them and if so, how do I determine those variables and where are they expressed? I'm going to assume in .bash_profile with the other variables but I'm not making ANY assumptions.
2. Where the OUI, it prompts you for the local 'bin' directory and already suggests /usr/local/bin as the path but I'm not sure if Oracle is looking for $ORACLE_HOME/bin or the O.S. bin directory. Can someone please tell me which 'bin' folder Oracle database is expecting here? The documentation doesn't even discuss this little aspect of the installer and I'm confused. Assuming O.S. bin folder as it suggests but not 100%.
copy this and paste this in your .bash_profile....
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/; export ORACLE_HOME
ORACLE_SID=PROD; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
#LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
ulimit -u 16384 -n 65536
for more info go through http://www.appsdbatraining.com & http://www.fusionappsdba.com.....