LD_LIBRARY_PATH blank problem
Hi all
My first post here
Actually have the same post in fedora/red hat but nobody is responding so im guessing wrong place
I am trying to run the cache database and oracle client on Red hat 5
Cache needs to use unixODBC to retrieve data from an external oracle db via the oracle client.
This requires me to have the LD_LIBRARY_PATH and JAVA_HOME set for the root user, which i have in root's .bash_profile
however when my cache service starts or i log into the GUI and open a terminal and i do an echo $LD_LIBRARY_PATH it comes up blank.
if i then do a su - root and then do a $LD_LIBRARY_PATH it comes back with the correct info
This now has me manually restarting the cache db every time the server restarts.
e.g.
[root@SK-DB-CA-P ~]# echo $LD_LIBRARY_PATH
[root@SK-DB-CA-P ~]# su - root
[root@SK-DB-CA-P ~]# echo $LD_LIBRARY_PATH
/cachedata/bin:/orabin/oracle/10.2_client/lib:/lib:/usr/lib:/cachedata/bin
[root@SK-DB-CA-P ~]#
I have added the $LD_LIBRARY_PATH to /etc/profile but to no effect
could anybody please help me or tell me what i must set where?
Thank you