Dear Folks,
Thanks for ur reply,
here is the environment variables , please go through it and get me the right solution for the script.
env variables(oracle)
$ env | grep ORACLE
ORACLE_BASE=/home/oracle/oracle
ORACLE_SID=mibast
ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1
$ env | grep oracle
PATH=/home/oracle/oracle/product/10.2.0/db_1/bin:/usr/bin:/opt/ansic/bin:/usr/cc
s/bin:/usr/contrib/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/upgrade/bin:/opt/
fcms/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/pd/bin:/opt/wbem/bin:/opt/wbem/s
bin:/opt/resmon/bin:/opt/firefox:/opt/gnome/bin:/opt/mozilla:/opt/graphics/commo
n/bin:/opt/hpsmh/bin:/opt/perl_32/bin:/opt/perl_64/bin:/usr/sbin/diag/contrib:/o
pt/sfm/bin:/opt/ssh/bin:/opt/thunderbird:/opt/gwlm/bin:/opt/aCC/bin:/opt/cadvise
/bin:/opt/langtools/bin:/opt/imake/bin:.
ORACLE_BASE=/home/oracle/oracle
LOGNAME=oracle
HOME=/home/oracle
LD_LIBRARY_PATH=/home/oracle/oracle/product/10.2.0/db_1/lib
ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1
$