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

When the database is in ARCHIVELOG mode, you can probably recover it. But when not or you really want to drop the tablespace anyway then try this: connect as internal within srvrmgrl (the database is down) 1. startup mount pfile=[<dir>]init<SID>.ora

    where <dir> is the location of the file init<SID>.ora and     <SID> is the SID of the database.
2. alter database datafile '<file>' offline drop;

    where <file> is the name of the lost file. Use the keyword     'drop', when the database is in NOARCHIVELOG mode. 3. alter database open;
4. drop tablespace <tablespace>;

HTH
ali

Chris Hagmann wrote:

> 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 - 15:22:18 CDT