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@xxxxxxxxxxxxxxx 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@xxxxxxxxxxxxxxx> > Sent: Mar 16, 2004 11:36 AM > To: oracle-l@xxxxxxxxxxxxx > Subject: Re: problem getting rid of an undo tablespace > > It doesn't work. > [root@tux925 root]# > [root@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@XXX as SYSDBA; > > shutdown; > > connect SYS/SYS@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@xxxxxxxxxxxxx> > > To: <oracle-l@xxxxxxxxxxxxx> > > 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@xxxxxxxxxxxxx > > > put 'unsubscribe' in the subject line. > > > -- > > > Archives are at //www.freelists.org/archives/oracle-l/ > > > FAQ is at //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@xxxxxxxxxxxxx > > put 'unsubscribe' in the subject line. > > -- > > Archives are at //www.freelists.org/archives/oracle-l/ > > FAQ is at //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@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //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@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------