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)
[EMAIL PROTECTED]
[EMAIL PROTECTED]
============================================================================================================
[EMAIL PROTECTED]
ahoo.com To: [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
