Hi

I hope you have given proper access for the oracle database user

The changes you have to make to ur .profile for the new unix user are the following

for example

export ORACLE_HOME=/oracle

export PATH=$PATH:/ORACLE_HOME/bin:

export LD_LIBARY_PATH=/ORACLE_HOME/lib

export ORACLE_SID=ORACLESID

Change the above accoring to ur environment

Or


the best thing is try to copy the .profile of Oracle user that is the unix user to the new user's home directory

Regards