i have just started as DBA, i am working on solaris SPARC platform with Oracle 10g release 2
the problem is whenever i login as oracle user my sqlplus command not working and my ORACLE_HOME,ORACLE_SID are displaying blank. every time i have to execute $ . .profile command then its working. plz tell me the solution so that i connect to sqlplus directly without executing the bash profile.
and one more thing is when i login as root user and from there going to oracle everything is working fine.
plz tell me the solution.
thanks & regards,
Last edited by rajachallagulla; 12-12-09 at 10:02.