Date: Thu, 6 Nov 2008 08:30:03 -0800 (PST)
On Nov 6, 11:10 am, sybrandb <sybra..._at_gmail.com> wrote:
> On 6 nov, 17:02, markg22..._at_yahoo.com wrote:
> > ORACLE 8i (we are in process of upgrading to 10g).
> > UNIX solaris 5.8 (we are moving to new box).
> > We recovered our production database in our current environment with
> > RMAN.
> > We started getting ORA-25153.
> > We added the old tempfile to the temporary tablespace and resized it
> > at the same time. (don't know if this makes a difference).
> > We are now getting ORA-03232 on random queries. These are
> > queries that have always run even when the tempfile was only 2GB.
> > It is now 10GB.
> > We have not bounced the database since the recover, as this is a
> > production database.
> > Could anyone please help ?
> > Thank you.
> Please make sure for every error you post, you include the error text.
> You can get the error text from the online documentation.
> Please do not expect everyone knows all errors from memory and/or is
> going to look the error up on your behalf.
> This is a forum of volunteers.
> Sybrand Bakker
> Senior Oracle DBA- Hide quoted text -
> - Show quoted text -
I am sorry.
We first got ORA-25153 - Temporary Tablespace is Empty
Cause: An attempt was made to use space in a temporary tablespace with
Action: Add files to the tablespace using ADD TEMPFILE command.
This was not unusual, because RMAN doesn't restore temp tablespaces.
Now we are getting
ORA-03232: unable to allocate an extent of 119 blocks from tablespace 2
tablespace 2 is our temporary tablespace.
There is over 9GB of free space. Received on Thu Nov 06 2008 - 10:30:03 CST