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

Hi!

I have a suggestion as well:

Tempfiles are sparse files in unix, that is you can use alter tablespace command to add or resize the files even to 100G if you want, but they don't actually use much space on disk. When you start writing to this file, OS tries to allocate more real space to it and will fail if file system is full (depending on OS and your quota + rights you might actually see some free space, but it's unusable). You can see real size of a file in file system blocks using ls -ls (at least in Solaris & HP-UX it works...)

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Sunday, July 27, 2003 10:44 AM

> Check the block sizes. That part of the argument might still stand.
>
> On 2003.07.27 02:24, Saira Somani wrote:
> > We are using 32-bit on 5L. I don't think Oracle 8.1.7
> > is compatible with 64-bit AIX kernel.
> >
> > --- Mladen Gogala <mgogala_at_adelphia.net> wrote:
> > > 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).
> > > >
> > >
> > > --
> > > Mladen Gogala
> > > Oracle DBA
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.net
> > > --
> > > Author: Mladen Gogala
> > > INET: mgogala_at_adelphia.net
> > >
> > > 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).
> >
> > --
> > 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).
> >
>
> --
> Mladen Gogala
> Oracle DBA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: mgogala_at_adelphia.net
>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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).