Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> instance stuck in initialization

instance stuck in initialization

From: <pjohns23_at_my-deja.com>
Date: Tue, 29 Aug 2000 21:09:04 GMT
Message-ID: <8oh8ot$860$1@nnrp1.deja.com>

I have a new installation of 8.1.5 on Solaris 7 that seems to be getting hung up in an initialization mode.

When I bring up the instance this happens:

   SVRMGR> connect internal
   Connected
   SVRMGR> startup open dev1
   ORACLE instance started.

   Total System Global Area                         37182864 bytes
   Fixed Size                                          64912 bytes
   Variable Size                                    10723328 bytes
   Database Buffers                                 26214400 bytes
   Redo Buffers                                       180224 bytes
   Database mounted.
   ORA-01403: no data found
   SVRMGR> As long as I remain connected as internal, I can do whatever I want (create a database, create/drop tablespaces, create/drop tables, ...). However, when I try to connect as another user, this happens:

   SVRMGR> connect dbauser/xxxxxxx
   ORA-01033: ORACLE initialization or shutdown in progress    SVRMGR> This same ORA-01033 error occurs in sqlplus, imp, and every utility I've tried, as well.

Any ideas are greatly appreciated.

--
Thanks,
Peggy D. Johnson


Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Aug 29 2000 - 16:09:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US