Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2015

    Angry Unanswered: XE Idle Instance

    Can anyone help resolve an "idle Instance" of a Oracle XE database upon entry of 'sqlplus / as sysdba'? Oracle are perplexed.

    Click image for larger version. 

Name:	sysdba error.PNG 
Views:	2 
Size:	13.4 KB 
ID:	16308

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    [oracle@localhost ~]$ sqlplus / as sysdba
    SQL*Plus: Release Production on Wed Apr 22 07:23:28 2015
    Copyright (c) 1982, 2010, Oracle.  All rights reserved.
    Connected to an idle instance.
    SQL> startup
    ORACLE instance started.
    Total System Global Area  456146944 bytes
    Fixed Size                  1344840 bytes
    Variable Size             339741368 bytes
    Database Buffers          109051904 bytes
    Redo Buffers                6008832 bytes
    Database mounted.
    Database opened.
    SQL> select count(*) from user_objects;
    SQL> exit
    Disconnected from Oracle Database 11g Enterprise Edition Release - Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    [oracle@localhost ~]$
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts