Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Posts
    18

    Unanswered: ORA:01033 - Oracle Initialisation or shutdown in progress

    hello

    I am getting the following error while connecting to oracle..

    ORA:01033 - Oracle Initialisation or shutdown in progress

    Why this is coming and how to handle...please let me know...if anybody know...

    This is very urgent..

    thanx in advance.
    kishan

  2. #2
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118

    sysdba

    Hi

    It's just what is says, you database is either startiin gup or shutting down:

    Please login as DBA asn post the contents of v$instance and v$database.

    Login to your RDBMS server box with your OS account:

    set the oracle_sid login as sysdba :



    C:\>set ORACLE_SID=DB1

    C:\>sqlplus "sys as sysdba"

    SQL*Plus: Release 9.0.1.0.1 - Production on Fri Mar 21 10:29:16 2003

    (c) Copyright 2001 Oracle Corporation. All rights reserved.

    Enter password:

    Connected to:
    Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
    With the Partitioning option
    JServer Release 9.0.1.1.1 - Production

    [SYS@DB1.ORA-0000.COM] $ select * from v$database;

    DBID NAME CREATED RESETLOG
    S_CHANGE# RESETLOGS PRIOR_RESETLOGS_CHANGE# PRIOR_RES LOG_MODE CHECKPOINT_CH
    ANGE# ARCHIVE_CHANGE# CONTROL CONTROLFI CONTROLFILE_SEQUENCE# CONTROLFILE_CHANGE
    # CONTROLFI OPEN_RESETL VERSION_T OPEN_MODE STANDBY_MOD REMOTE_ARCH ACTIVATION#
    DATABASE_ROLE ARCHIVELOG_CHANGE# SWITCHOVER_STATUS
    ---------- -------------------------------------------------- --------- --------
    --------- --------- ----------------------- --------- ------------ -------------
    ----- --------------- ------- --------- --------------------- ------------------
    - --------- ----------- --------- ---------- ----------- ----------- -----------
    ---------------- ------------------ ------------------
    1050444063 DB1 15-MAR-02
    1 15-MAR-02 0 NOARCHIVELOG ########
    ##### 2.2014E+12 CURRENT 15-MAR-02 5016 2.2014E+1
    2 20-MAR-03 NOT ALLOWED 15-MAR-02 READ WRITE UNPROTECTED ENABLED 1050443295
    PRIMARY 0 SESSIONS ACTIVE

    [SYS@DB1.ORA-0000.COM] $ select * from v$instance;

    INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION STARTUP_
    T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_ LOGINS SHU DATABASE_STATUS INSTA
    NCE_ROLE ACTIVE_ST
    --------------- ---------------- -------------------- ----------------- --------
    - ------- --- ------- ------- ----------- ---------- --- ----------------- -----
    ------------- ---------
    1 db1 PCHQ-1093 9.0.1.1.1 20-MAR-0
    3 OPEN NO 1 STOPPED ALLOWED NO ACTIVE PRIMA
    RY_INSTANCE NORMAL



    Remi
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

Posting Permissions

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