Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: problem getting rid of an undo tablespace

Re: problem getting rid of an undo tablespace

From: Juan Cachito Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Tue, 16 Mar 2004 16:59:12 -0400
Message-ID: <001b01c40b99$8d9c5070$2501a8c0@dazasoftware.com> 





About the paths, sorry but I only work on windows, you only have to
translate them,


I can't help you in t hat.



Bill Gates can't be destroyed, he really has still a long long
live, in several destops :), more than you think.
And still is going to give big big big headaches.
Even when you don't like it. And we understand who is him ;).







> Mladen,

> Tell us how you REALLLLY feel.

>  Get another cup of coffee... that should help keep you on top of

> things for a while.

> We have to get the GroupWise mail for Linux and then Bill Gates can no

> longer be on my desktop....

> RedHat AS 2.1 upgrade 3 has a KONQUERER browser also.. You can emulate

> ie4 - 5.5 if you care to.

> Ron

>

> >>> mladen_at_wangtrading.com 03/16/2004 3:15:43 PM >>>

> I know, I'm just being facetious. The point that was trying to

> make is about an OS and the quasi-OS, the latter having pathnames

> like described in the original post. To make it abundantly clear,

> I hate  @#$%! MS-Windows because I don't have nice things like

> crontab, I have problems with the perl DBI  and MIME::Lite

> and I have to be vewy, vewy careful, just like Elmer Fudd so

> that my PC doesn't catch a virus. Today I discovered that my

> IE 6 doesn't work with Java 1.4.2. The solution is called

> "Mozilla 1.6". So, at the moment, I'm a little bit peeved and

> annoyed with  MS-Windows. Give me an hour, it will pass.

> Where do you want to go today?

>

> On 03/16/2004 03:04:12 PM, david wendelken wrote:

> >

> > E\oraXXX\init\initXXX.ora is just a directory and file name, you need

> to substitute the correct filename and location for your installation.

> >

> > -----Original Message-----

> > From: Mladen Gogala <mladen_at_wangtrading.com>

> > Sent: Mar 16, 2004 11:36 AM

> > To: oracle-l_at_freelists.org

> > Subject: Re: problem getting rid of an undo tablespace

> >

> > It doesn't work.

> > [root_at_tux925 root]#

> > [root_at_tux925 root]# su - oracle

> > -bash-2.05b$

> > -bash-2.05b$ sqlplus "/ as sysdba"

> >

> > SQL*Plus: Release 9.2.0.4.0 - Production on Tue Mar 16 14:32:53 2004

> >

> > Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

> >

> > Connected to an idle instance.

> >

> > SQL> startup pfile=E:\oraXXX\init\initXXX.ora;

> > LRM-00109: could not open parameter file 'E:oraXXXinitinitXXX.ora'

> > ORA-01078: failure in processing system parameters

> > SQL>


> >

> > I have a slight suspicion that the "bash" thing is the problem. It

> doesn't recognize

> > anything like "E:\"? Should I get rid of my OS and switch to the

> quasi-OS that does

> > recognize it?

> >

> >

> > On 03/16/2004 01:59:29 PM, Juan Cachito Reyes Pacheco wrote:

> > > Here is the process to recreate a too bin undo tablespace, it will

> help to

> > > delete the one you have.

> > >

> > >

> > > connect SYS/SYS_at_XXX as SYSDBA;

> > > shutdown;

> > > connect SYS/SYS_at_XXX as SYSDBA;

> > > startup pfile=E:\oraXXX\init\initXXX.ora;

> > >

> > > CREATE UNDO TABLESPACE TBL_UNDOS  DATAFILE


> 'E:\oraXXX\datafiles\dfl_undoXXX'

> > > SIZE 50M


> > > REUSE AUTOEXTEND ON NEXT  5120K MAXSIZE UNLIMITED;


> > > ALTER SYSTEM SET UNDO_TABLESPACE = TBL_UNDOS;


> > > ALTER TABLESPACE "TBL_UNDO" OFFLINE NORMAL;


> > >

> > > DROP TABLESPACE TBL_UNDO


> > > INCLUDING CONTENTS AND DATAFILES;


> > >

> > > CREATE UNDO TABLESPACE TBL_UNDO  DATAFILE


> 'E:\oraXXX\datafiles\dfl_undo_XXX'

> > > SIZE 50M


> > > REUSE AUTOEXTEND ON NEXT  5120K MAXSIZE UNLIMITED;


> > > ALTER SYSTEM SET UNDO_TABLESPACE = TBL_UNDO;


> > >

> > > DROP TABLESPACE TBL_UNDOS


> > > INCLUDING CONTENTS AND DATAFILES;


> > >

> > > ALTER DATABASE   DATAFILE 'E:\ORAXXX\DATAFILES\DFL_UNDO_XXX'


> AUTOEXTEND   ON


> > > MAXSIZE UNLIMITED;


> > >

> > >

> > >

> > > ----- Original Message ----- 

> > > From: "david wendelken" <davewendelken_at_earthlink.net>

> > > To: <oracle-l_at_freelists.org>

> > > Sent: Tuesday, March 16, 2004 2:30 PM

> > > Subject: Re: problem getting rid of an undo tablespace

> > >

> > >

> > > >

> > > > I have a problem with one of the files in my undo tablepace.

> > > >

> > > > Given that there are not any transactions to undo, it seemed

> simplest to

> > > just drop the file.

> > > > But I haven't been able to get the database to let me do that.

> > > >

> > > > So, I created a 2nd undo tablespace with the intention of taking

> the first

> > > off line and then dropping it.

> > > > But I haven't been able to get the database to let me take it off

> line.

> > > >

> > > > I found a parameter in my spfile called "undo_tablespace" which

> was set to

> > > the old tablespace.

> > > > I shut down the database, changed the entry to point to the new

> > > tablespace, but the database would not open up.

> > > >

> > > > Any ideas on how to clear out the corrupted undo tablespace

> file?

> > > >

> > > > Thanks in advance!

> > > >

> > > > ----------------------------------------------------------------

> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com

> > > > ----------------------------------------------------------------

> > > > To unsubscribe send email to:  oracle-l-request_at_freelists.org

> > > > put 'unsubscribe' in the subject line.

> > > > --

> > > > Archives are at http://www.freelists.org/archives/oracle-l/

> > > > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

> > > >

> -----------------------------------------------------------------

> > > >

> > >

> > >

> > > ----------------------------------------------------------------

> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com

> > > ----------------------------------------------------------------

> > > To unsubscribe send email to:  oracle-l-request_at_freelists.org

> > > put 'unsubscribe' in the subject line.

> > > --

> > > Archives are at http://www.freelists.org/archives/oracle-l/

> > > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

> > > -----------------------------------------------------------------

> > >

> > ----------------------------------------------------------------

> > Please see the official ORACLE-L FAQ: http://www.orafaq.com

> > ----------------------------------------------------------------

> > To unsubscribe send email to:  oracle-l-request_at_freelists.org

> > put 'unsubscribe' in the subject line.

> > --

> > Archives are at http://www.freelists.org/archives/oracle-l/

> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

> > -----------------------------------------------------------------

> >

> > ----------------------------------------------------------------

> > Please see the official ORACLE-L FAQ: http://www.orafaq.com

> > ----------------------------------------------------------------

> > To unsubscribe send email to:  oracle-l-request_at_freelists.org

> > put 'unsubscribe' in the subject line.

> > --

> > Archives are at http://www.freelists.org/archives/oracle-l/

> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

> > -----------------------------------------------------------------

> >

> ----------------------------------------------------------------

> Please see the official ORACLE-L FAQ: http://www.orafaq.com

> ----------------------------------------------------------------

> To unsubscribe send email to:  oracle-l-request_at_freelists.org

> put 'unsubscribe' in the subject line.

> --

> Archives are at http://www.freelists.org/archives/oracle-l/

> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

> -----------------------------------------------------------------

> ----------------------------------------------------------------

> Please see the official ORACLE-L FAQ: http://www.orafaq.com

> ----------------------------------------------------------------

> To unsubscribe send email to:  oracle-l-request_at_freelists.org

> put 'unsubscribe' in the subject line.

> --

> Archives are at http://www.freelists.org/archives/oracle-l/

> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

> -----------------------------------------------------------------







Please see the official ORACLE-L FAQ: http://www.orafaq.com




To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


Received on Tue Mar 16 2004 - 14:58:55 CST












Original text of this message













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