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

There is a 64 bit version of Oracle 8.1.7 for AIX available. Check your $ORACLE_HOME/lib directory. If you have a lib64 or lib32 directory, then you have the 64bit version.

RWB

Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) reginald.w.bailey_at_jpmorgan.com
baileyre_at_us.ibm.com

                                                                                                                 
                    saira_somani_at_y                                                                               
                    ahoo.com             To:     ORACLE-L_at_fatcity.com                                            
                    Sent by:             cc:                                                                     
                    ml-errors_at_fatc       Subject:     Re: 8.1.7 instance on upgraded AIX machine - ORA-1652 all  
                    ity.com               the time                                                               
                                                                                                                 
                                                                                                                 
                    07/27/2003                                                                                   
                    01:24 AM                                                                                     
                    Please respond                                                                               
                    to ORACLE-L                                                                                  
                                                                                                                 
                                                                                                                 

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




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Reginald.W.Bailey_at_jpmorgan.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).