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

Chris

"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