Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h1SIFAn29592 for ; Fri, 28 Feb 2003 12:15:10 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h1SIF9G29587 for ; Fri, 28 Feb 2003 12:15:09 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id GAA01482; Fri, 28 Feb 2003 06:56:45 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0055CC93; Fri, 28 Feb 2003 06:03:53 -0800 Message-ID: Date: Fri, 28 Feb 2003 06:03:53 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Gene Sais" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Gene Sais" Subject: RE: Upgrade to AIX 5.2 Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=_56093A33.A2C3D26B" --=_56093A33.A2C3D26B Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit So it appears that Oracle 8.1.7 databases and 9.2 databases can not co-exist on the same server, i.e. AIX 4.3.3 32 bit. If this is the case, then all databases on the server must be upgraded at the same time? Current Env: AIX 4.3.3 32 bit Oracle 8.1.7 Proposed Env: AIX 5.2 64 bit Oracle 9.2 Plan to get there: - Boot AIX 4.3.3 server to 64 bit - Install Oracle 9.2 64 bit & Patch for AIX 4.3.3 - Change env scripts to point to Oracle 9.2 - Migrate/upgrade all databases from 8.1.7 to 9.2 - Upgrade AIX to 5.2 - Install Oracle 9.2 64 bit binaries Then there is the alternate plan: - Free up a server - Upgrade AIX 4.3.3 to 5.2 64 bit on this new server - Install Oracle 9.2 64 bit - Export 8.1.7 database and import to new 9.2 database - Continue this process on a per database basis, no rush to do all databases on server Any thoughts, experiences, opinions are appreciated. Thanks, Gene >>> kirti.deshpande@verizon.com 02/27/03 03:19PM >>> Tracy, We are still debating this issue with our preferred App Vendor... Since there is no 64-bit 8.1.7.4 on AIX 5L, upgrading to 9i is what we will pursue. Testing the Vendor App on 9i/AIX 4.3.3 should not take considerable amount of time, as *none* of the new features of 9i would be used by the Vendor. Sad but true. There will be more testing time allocated to 9i/AIX 5L update, as several other software pieces would be tested for the first time with that combination. We will need to install 9i for AIX 5L after the OS upgrade. We may choose to install it in the same ORACLE_HOME as before. These are just my initial thoughts, no concrete plans, yet. If Oracle would have supported 64-bit 8.1.7.4 on AIX 5L, this would have been a bit simpler... Regards, - Kirti -----Original Message----- Sent: Thursday, February 27, 2003 1:36 PM To: Multiple recipients of list ORACLE-L John/Kirti, We are in the same boat with you. However, we were looking to first upgrade to AIX 5L first and leave our existing 8.1.7 32-bit databases (booting the server in 32 bit mode). In a subsequent phase we would upgrade 8.1.7 32-bit to 9.2 64-bit. The downside to this is that it will affect all databases on the server. We would need to test the complexity/timing/risk to determine if this is the appropriate choice. Kirti, with the option that you are leaning towards, as I see it, you need to upgrade to 5L and then install 9.2 for 5L (there is also a 9.2 for 4.3.3) and then migrate the databases from 9.2/4.3.3 to 9.2/5L. Do you know what effort is involved in that transition? Is it complex/time consuming or just pointing to a new oracle_home? Thanks 02/27/2003 05:43 AM PST Please respond to ORACLE-L@fatcity.com Sent by: root@fatcity.com To: "Multiple recipients of list ORACLE-L" cc: It appears that way. We are also pondering on this upgrade as well. But if one takes this route, that is, running 5L in 32-bit mode, one can not install 9i on the same server. And Oracle has not certified 8.1.7 64-bit on AIX 5L. It is not planned to be available, either. So, we are leaning towards upgrading to 9i first on AIX 4.3.3. Next upgrade OS to AIX 5L 5.1 and then 5.2 (some of the apps will become available on 5.2 later this year).. - Kirti -----Original Message----- Sent: Thursday, February 27, 2003 7:09 AM To: Multiple recipients of list ORACLE-L So 8.1.7 is supported on AIX 5L provided AIX is booted in 32 bit mode??? John -----Original Message----- Sent: 27 February 2003 12:24 To: Multiple recipients of list ORACLE-L Certify - Additional Info Oracle Server - Enterprise Edition Version 8.1.7 (8i) On IBM AIX -Based Systems ---------------------------------------------------------------------------- ---- Operating System: IBM AIX -Based Systems Version 5.2 (5L) Oracle Server - Enterprise Edition Version 8.1.7 (8i) N/A Version N/A Status: Certified Product Version Note: Terminal Oracle8i release To obtain Patch Sets from MetaLink, click the "Patches" button to the left. Certification Note: Existing patch sets: 8.1.7.1.0 (without JDBC), 8.1.7.1.0b (includes JAVAVM, Context and JDBC), 8.1.7.2.0 8.1.7.3.0 8.1.7.4.0 Oracle 8i 32-bit on AIX 5L (5.1 & 5.2) Kernel modes AIX 5L introduces the option to run the AIX kernel in 64-bit mode. This mode is not supported, as Oracle 8i uses at least one 32-bit kernel extension. AIX-based systems must be booted with kernels in 32-bit mode. Warning about missing "crash" during installation of Oracle 8i. The error message "crash: not found" may appear during execution of rootpre.sh on AIX 5L. This warning may be ignored. Alternatively, the warning can be avoided by creating the following script and renaming it to "/usr/sbin/crash": #!/bin/ksh read input if [ X"$input" = Xle ]; then echo lke | /usr/sbin/kdb | \ /usr/bin/awk '/^ *[0-9]+/ {printf("LoadList entry at 0x%s\n Name: %s\n\n",$2,$6)} fi April Wells Oracle DBA Great spirits have always encountered violent opposition from mediocre minds -- Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tracy Rahmlow INET: tracy.rahmlow@aexp.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@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: Deshpande, Kirti INET: kirti.deshpande@verizon.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@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). --=_56093A33.A2C3D26B Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Content-Description: HTML
So it appears that Oracle 8.1.7 databases and 9.2 databases can not co-exist on the same server, i.e. AIX 4.3.3 32 bit.  If this is the case, then all databases on the server must be upgraded at the same time?
 
Current Env:    AIX 4.3.3 32 bit Oracle 8.1.7
Proposed Env: AIX 5.2 64 bit Oracle 9.2
 
Plan to get there:
- Boot AIX 4.3.3 server to 64 bit
- Install Oracle 9.2 64 bit & Patch for AIX 4.3.3
- Change env scripts to point to Oracle 9.2
- Migrate/upgrade all databases from 8.1.7 to 9.2
- Upgrade AIX to 5.2
- Install Oracle 9.2 64 bit binaries
 
Then there is the alternate plan:
- Free up a server
- Upgrade AIX 4.3.3 to 5.2 64 bit on this new server
- Install Oracle 9.2 64 bit
- Export 8.1.7 database and import to new 9.2 database
- Continue this process on a per database basis, no rush to do all databases on server
 
Any thoughts, experiences, opinions are appreciated.  Thanks,
Gene

>>> kirti.deshpande@verizon.com 02/27/03 03:19PM >>>
Tracy,
We are still debating this issue with our preferred App Vendor...

Since there is no 64-bit 8.1.7.4 on AIX 5L, upgrading to 9i is what we will pursue.

Testing the Vendor App on 9i/AIX 4.3.3 should not take considerable amount of time, as *none* of the new features of 9i would be used by the Vendor. Sad but true. There will be more testing time allocated to 9i/AIX 5L update, as several other software pieces would be tested for the first time with that combination. We will need to install 9i for AIX 5L after the OS upgrade. We may choose to install it in the same ORACLE_HOME as before. These are just my initial thoughts, no concrete plans, yet.

If Oracle would have supported 64-bit 8.1.7.4 on AIX 5L,  this would have been a bit simpler...

Regards,

- Kirti


-----Original Message-----
Sent: Thursday, February 27, 2003 1:36 PM
To: Multiple recipients of list ORACLE-L



John/Kirti,
We are in the same boat with you.  However, we were looking to first upgrade to
AIX 5L first and leave our existing 8.1.7 32-bit databases (booting the server
in 32 bit mode).  In a subsequent phase we would upgrade 8.1.7 32-bit to 9.2
64-bit.  The downside to this is that it will affect all databases on the
server.  We would need to test the complexity/timing/risk to determine if this
is the appropriate choice.  Kirti, with the option that you are leaning
towards, as I see it, you need to upgrade to 5L and then install 9.2 for 5L
(there is also a 9.2 for 4.3.3) and then migrate the databases from 9.2/4.3.3
to 9.2/5L.  Do you know what effort is involved in that transition?  Is it
complex/time consuming or just pointing to a new oracle_home? Thanks





       02/27/2003 05:43 AM PST

Please respond to ORACLE-L@fatcity.com

Sent by:    root@fatcity.com


To:    "Multiple recipients of list ORACLE-L" <ORACLE-L@fatcity.com>
cc:


It appears that way. We are also pondering on this upgrade as well.

But if one takes this route, that is, running 5L in 32-bit mode, one can not
install 9i on the same server. And Oracle has not certified 8.1.7 64-bit on AIX
5L. It is not planned to be available, either.

So, we are leaning towards upgrading to 9i first on AIX 4.3.3. Next upgrade OS
to AIX 5L 5.1 and then 5.2 (some of the apps will become available on 5.2 later
this year)..

- Kirti

-----Original Message-----
Sent: Thursday, February 27, 2003 7:09 AM
To: Multiple recipients of list ORACLE-L


So 8.1.7 is supported on AIX 5L provided AIX is booted in 32 bit mode???

John




-----Original Message-----
Sent: 27 February 2003 12:24
To: Multiple recipients of list ORACLE-L



Certify - Additional Info Oracle Server - Enterprise Edition Version 8.1.7
(8i) On IBM AIX -Based Systems

----------------------------------------------------------------------------
----

Operating System: IBM AIX -Based Systems Version 5.2 (5L)
Oracle Server - Enterprise Edition Version 8.1.7 (8i)
N/A Version N/A
Status: Certified

Product Version Note:


Terminal Oracle8i release
To obtain Patch Sets from MetaLink, click the "Patches" button to the left.
Certification Note:


Existing patch sets:
     8.1.7.1.0  (without JDBC),
     8.1.7.1.0b (includes JAVAVM, Context and JDBC),
     8.1.7.2.0
     8.1.7.3.0
     8.1.7.4.0


Oracle 8i 32-bit on AIX 5L (5.1 & 5.2)
Kernel modes AIX 5L introduces the option to run the AIX kernel in 64-bit
mode. This mode is not supported, as Oracle 8i uses at least one 32-bit
kernel extension. AIX-based systems must be booted with kernels in 32-bit
mode.

Warning about missing "crash" during installation of Oracle 8i.
The error message "crash: not found" may appear during execution of
rootpre.sh on AIX 5L. This warning may be ignored. Alternatively, the
warning can be avoided by creating the following script and renaming it to
"/usr/sbin/crash":
#!/bin/ksh
read input
if [ X"$input" = Xle ]; then
echo lke | /usr/sbin/kdb | \
/usr/bin/awk '/^ *[0-9]+/ {printf("LoadList entry at 0x%s\n  Name:
%s\n\n",$2,$6)}
fi

April Wells
Oracle DBA
Great spirits have always encountered violent opposition from mediocre minds
-- Albert Einstein







--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tracy Rahmlow
  INET: tracy.rahmlow@aexp.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@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: Deshpande, Kirti
  INET: kirti.deshpande@verizon.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@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).

--=_56093A33.A2C3D26B-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Sais INET: Gsais@co.palm-beach.fl.us 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@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).