Showing Idle Instance xe

Issue Description :

  XE database is running fine but while login to database it is showing idle instance.

$sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 12 18:32:49 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to Idle Instance.

SQL>   Workaround:   LIB path is caused for this issue. you have run to oracle_env.sh script from ORACLE_HOME/bin location.   add  script on .bash_profile   $ cat .bash_profile

. /opt/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh

$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 12 18:32:49 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:

Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL>