Re: 8.1.7 instance on upgraded AIX machine - ORA-1652 all the time

Your 1652 error means the following:

01652, 00000, "unable to extend temp segment by %s in tablespace %s"

// *Cause:  Failed to allocate an extent for temp segment in tablespace.
// *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
//         files to the tablespace indicated.

If everything else is the same, I would say that the new OS is using a different OS filesystem block size. That would mess up all your file sizes, allocations and alike. You are probably using 64 bit JFS on 5L, straight up from 32-bit 4.3.3?

On 2003.07.27 00:39, Saira Somani wrote:
> Hi Gurus,
>
> After upgrading the OS from AIX 4.3.3 to 5.1, our
> Oracle 8i instance is dishing out plenty of ORA-1652
> which means that our application cannot commit any
> transactions (or so I am finding in my tests).
>
> Help. The warehouse needs to be in production
> tomorrow 8AM!
>
> Thanks,
> Saira
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Saira Somani
> INET: saira_somani_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Sat Jul 26 2003 - 22:51:34 CDT