Looks like you need to get your environment sourced correctly to gain access to your database. What do these commands return. #ps -ef | grep pmon #cat /etc/oratab #env | grep -i ora Alan PS For this kind of database help you may be better served trying one of the database forums on otn.oracle.com .