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

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