 | | | problem getting rid of an undo tablespace | problem getting rid of an undo tablespace 2004-03-16 - By Ron Rogers
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@(protected) 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@(protected) >
> Sent: Mar 16, 2004 11:36 AM
> To: oracle-l@(protected)
> Subject: Re: problem getting rid of an undo tablespace
>
> It doesn 't work.
> [root@(protected) root]#
> [root@(protected) 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 (See ORA-01078.ora-code.com): 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@(protected) as SYSDBA;
> > shutdown;
> > connect SYS/SYS@(protected) 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@(protected) >
> > To: <oracle-l@(protected) >
> > 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@(protected)
> > > 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@(protected)
> > 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@(protected)
> 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@(protected)
> 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@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
|