10 Replies Latest reply: Oct 1, 2012 4:03 AM by orafad RSS

    showing idle instance on xe

    user2017273
      Hi,

      my database is running fine . But it is showing as idle instance while connection as sysdba. I am able to connect using tnsentry .
      how to fix this?


      DB version: 10.2.0.1 experess edition -- Linux
      Log

      $sqlplus "/as sysdba"

      SQL*Plus: Release 10.2.0.1.0 - Production on Sat Sep 29 06:11:22 2012

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

      Connected to an idle instance.

      SQL> exit
      Disconnected


      $ echo $ORACLE_SID
      XE


      $sqlplus system@xe

      SQL*Plus: Release 10.2.0.1.0 - Production on Sat Sep 29 06:11:45 2012

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

      Enter password:

      Connected to:
      Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

      SQL>