ORA-01033: ORACLE initialization or shutdown in progress" seen when launching an sqlplus session to help troubleshoot BMC Performance Manager Portal database issues

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BMC Performance Manager Portal


    APPLIES TO:

    BMC Performance Manager Portal



    PROBLEM:

     

      For example: 
      
       
       SQL*Plus: Release 10.2.0.2.0 - Production on Wed Nov 12 15:32:11 2008   
       
       Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.   
       
       Enter user-name: pe    
    Enter password:    
    ERROR:    
    ORA-01033: ORACLE initialization or shutdown in progress   
    BMC Performance Manager Portal (version 2.5.00)  
      BMC Datastore; 

     


    SOLUTION:

     

    Legacy ID:KA300707

      
       
       If the database has not been recently stopped or started, then the message indicates that there is a problem in starting the database.  
       
          
       
       Please do the following:  
       
       1) Stop the appserver (in the Windows Services GUI or '/etc/init.d/BMCPortalAppserver stop' on UNIX)  
       
          
       
       2) Open a shell session (e.g. DOS, telnet, ssh, etc.) and issue the following:  
       
       sqlplus /nolog  
       
       SQL> conn sys/manager as sysdba   
    SQL> shutdown   
    SQL> startup   
    SQL> shutdown immediate   
    SQL> startup mount  
       
          
       
       3) Send the following to BMC Support:  
       
       a) The output from step 2  
       
       b) The portal log:  
       
       ./BPM/BMCPortalKit/appserver/websdk/tools/jboss/server/all/log   
    c) The datastore logs:  
       
       ./BPM/Datastore/ora10g/db_1/admin/BMCPDS/bdump   
    (Include the *.log & the *.trc files)  
       
          
       
       Note that rebooting the datastore server will probably not resolve this.  
      
    Related Products:  
       
    1. BMC Performance Manager Portal

     


    Article Number:

    000078368


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles