Hi When my desktop system starts up,I usually login as root in my KDE environment. After that I do a su - oracle to login to my Oracle user and start my database. However I notice that when I run su - oracle the .bash_profile of oracle user does not get executed. None of my essential env variables like ORACLE_HOME, LD_LIBRARY_PATH etc get set. Even explicitly running . .bash_profile does not help. The only way I can set them is when I logout as root and login as oracle user. This can be painful sometimes,since I can connect to internet only as root user. Is there anyway I can set my env variables by running my .bash_profile for oracle user when in su - oracle. Thanks Anand

A) DONT LOG INTO KDE AS ROOT B) what does your .bash_profile look like? are u using export? are you talking about the .bash_profile in oracle's homedir? C) edit /etc/profile and add something like . ~/.bash_profile. that should do the trick. D) youre running kde on an oracle server? E) youre running kde on an oracle server? :)

Hmmm....If you set up your environment variables as root (ie add your oracle stuff to root profile) and then: # su -m oracle it should keep your values intact. But maybe you should sort out why you can only access the net as root instead and then log on to KDE as oracle.

To read the .profile of the assumed user you need to use the '-l' flag to su su -l user Don't loging as root Running kde chews up tons of resources that oracle would gladly use.