RE: Creating account in Oracle 10g

["Alan J. Gagne" <alanjgagne gmail com>]

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 .