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: ORA-01109 database not open.

Re: ORA-01109 database not open.

From: ktlee3 <kien_theng_at_yahoo.com>
Date: 8 Jun 2006 06:46:12 -0700
Message-ID: <1149774372.451485.55860@u72g2000cwu.googlegroups.com>


my bad, it is win 2k Advanced Server.

EdStevens wrote:
> ktlee3 wrote:
> > hi i am a newbie for oracle 9i, i was trying to create a db and
> > tablespace, and something happen when i was doing a compile, so i
> > dropped all the tablespace and users cascade. i think at the same time
> > delete the datafile as well.
> >
> > now when i try to recreate DB it gave me error like ORA-01109 database
> > not open.
> >
> > and when i start up at oracle it gave me media needs recovery and
> > ORA-1110 error.
> >
> > anyone knows how i can remove everything and redo everything? how can i
> > remove the whole database, if necessary...
> >
> > thanks
>
> What operating system?
Received on Thu Jun 08 2006 - 08:46:12 CDT

Original text of this message

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