thanks a bunch davey23uk and zakriyamhd. bash# export ORACLE_SID=dbname worked just fine. i was just alittle pre-mature in making export all caps. thanks a bunch guys. sorry to get back to you so late