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 -> Re: 7.3.4 on Solaris 2.6 -- can't open database

Re: 7.3.4 on Solaris 2.6 -- can't open database

From: Steve Phelan <stevep_at_XXnospamXX.toneline.demon.co.uk>
Date: Mon, 20 Apr 1998 08:53:39 +0100
Message-ID: <893058802.2023.0.nnrp-08.c2de712e@news.demon.co.uk>


You'll probably have to do a 'shutdown abort' (in Server Manager) on the = instance to close it down (also check that all the background processes = have died afterwards at the OS level). Once you've done that, either = 'recover' the database or take the test tablespace 'offline' (and maybe = drop it if you don't want it anymore - which it sounds like you don't) = before 'open'ing the database. Check the Oracle Database Admin. manual = or the Oracle backup and recovery handbook for more details.

Steve Phelan.

Chris Hagmann wrote in message <3539D240.C6003AA4_at_bluewin.ch>...

    I encountered a messy problem with Oracle 7.3.4 on Solaris 2.6:     I created a tablespace for testing. Somewhen a shellscript deleted = the datafile belonging to this tablespace on the running database (on = filesystem layer, not SQL). Since then I was not able to delete this = tablespace or work with it. I always got I/O error when I tried to = access this tablespace through SQL). Alright, was not that bad, but it = even got worse. Somewhen I had to restart the database and since then I = can't access the database anymore through sql. Every time I try to log = into the database (sqlplus system/xxx_at_yyy) I get the following error:     

    Enter user-name: system
    Enter password:
    ERROR: ORA-01033: ORACLE initialization or shutdown in progress     

    I waited for hours -- no change, always this error message = (restarting didn't help either, but when I shut down the database I get = the message that the DB was not open -- and during start up it complains = about the missing datafile)     

    I'm not sure what I should think about that -- I'm sure that there = is a way to log into this messy database and delete the trouble causing = tablespace -- but who can tell me how?            

    Please also forward the response to my email -- thanx            

    "Who needs horror movies when we have Microsoft?!"


    
    Christian Hagmann              email: chagmann_at_bluewin.ch 
    dipl. El.-Ing. ETH             http://www.commercemaker.ch 

--

    Swisscom -- the blue window tel: +41 1 317 20 10     Applications Division fax: +41 1 317 20 11     Stadelhoferstr. 22
    Postfach                       http://bluewindow.com 
    8032 Zurich
            Received on Mon Apr 20 1998 - 02:53:39 CDT

Original text of this message

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