RE: 64 bit Oracle (8.1.7) on a 32 bit AIX kernel (AIX 4.3.3)
Peter, I'll answer the 2nd question first as it's easier. - You will need to change the word size of your database from 64 bit to 32 bit. This involves running a few scripts and bouncing the database were required. The exact process is described in a Metalink note, sorry but I don't have the number to hand. - In answer to the 1st question I believe you can only run the Oracle 8.1.7 software in 32 bit mode on AIX 5L so Oracle 8.1.7 will be running as 32 bit software even after you apply the patch. See the end of the Metalink note: Oracle Releases for AIX 4.3.3 and AIX 5L: - The 64-bit ABI in AIX 4.3.3 is not supported under AIX 5L. Moving existing 64-bit applications from AIX 4.3.x to AIX 5L requires recompiling the application source code, and possibly changing application source code to ensure that data types are used correctly and consistently. Due to this restriction, starting from 9.2.0 version, Oracle ships different CDs for AIX 433 and AIX 5L. Customers should be careful not to use the wrong CDs, since these two releases are not compatible. This is also the reason why the 64-bit versions 9.0.1 and 8.1.7/64 do not run on AIX 5L. Cheers, Chris -Original Message- Sent: 12 September 2003 15:30 To: Multiple recipients of list ORACLE-L Thanks for the response. I have Metalink note 231901.1 which explains the options for installing 8.1.7 on AIX 5L, so I understand what I have to do (after reading it three times). Additional questions: - If we run the 64 bit kernel and put on the required patch for 8.1.7 will I be running Oracle in 64 bit or 32 bit mode? - If Oracle is running in 32 bit mode, what will happen if I restore a cold backup of my AIX 4.3.3 (64 bit) database onto the AIX 5L system? Thanks, Peter Schauss -Original Message- Sent: Friday, September 12, 2003 5:24 AM To: Multiple recipients of list ORACLE-L Peter, I know that this looks odd but as the hardware is 64 bit the AIX O/S has some sort of translation layer that allows it to run Oracle 64 bit even though the kernel is in 32 bit mode. I discovered this when investigating running Oracle 9.2 and Oracle 8.1.7 on AIX 5L. After raising a TAR with Oracle I received the response which basically stated: - Oracle 8.1.7 can only be run in 32 bit mode on AIX 5L. - To run Oracle 8.1.7 and Oracle 9.2 concurrently on AIX 5L you must run AIX in 32 bit mode on 64 bit hardware with 32 bit Oracle 8.1.7 and Oracle 9.2 64 bit (it only exists in 64 bit mode). Confusing I know but somehow true. As an aside I don't think this applies to the likes of HP-UX. I'm fairly sure that running 32bit HP-UX 11 on 64 bit hardware will not allow 64 bit Oracle to run. HTH Chris Dunscombe -Original Message- Sent: 11 September 2003 21:39 To: Multiple recipients of list ORACLE-L O/S is AIX 4.3.3 /usr/sbin/bootinfo -p returns "chrp" meaning that the hardware is capable of either 32 or 64 bit operation. /usr/sbin/bootinfo -K returns "32" meaning that the kernel is running in 32 bit mode. When I run sqlplus the server says: Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production How can I be running the 64 bit server on a system with a 32 bit kernel? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter 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: Dunscombe, Chris 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: Schauss, Peter 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
RE: 64 bit Oracle (8.1.7) on a 32 bit AIX kernel (AIX 4.3.3)
Thanks for the response. I have Metalink note 231901.1 which explains the options for installing 8.1.7 on AIX 5L, so I understand what I have to do (after reading it three times). Additional questions: - If we run the 64 bit kernel and put on the required patch for 8.1.7 will I be running Oracle in 64 bit or 32 bit mode? - If Oracle is running in 32 bit mode, what will happen if I restore a cold backup of my AIX 4.3.3 (64 bit) database onto the AIX 5L system? Thanks, Peter Schauss -Original Message- Sent: Friday, September 12, 2003 5:24 AM To: Multiple recipients of list ORACLE-L Peter, I know that this looks odd but as the hardware is 64 bit the AIX O/S has some sort of translation layer that allows it to run Oracle 64 bit even though the kernel is in 32 bit mode. I discovered this when investigating running Oracle 9.2 and Oracle 8.1.7 on AIX 5L. After raising a TAR with Oracle I received the response which basically stated: - Oracle 8.1.7 can only be run in 32 bit mode on AIX 5L. - To run Oracle 8.1.7 and Oracle 9.2 concurrently on AIX 5L you must run AIX in 32 bit mode on 64 bit hardware with 32 bit Oracle 8.1.7 and Oracle 9.2 64 bit (it only exists in 64 bit mode). Confusing I know but somehow true. As an aside I don't think this applies to the likes of HP-UX. I'm fairly sure that running 32bit HP-UX 11 on 64 bit hardware will not allow 64 bit Oracle to run. HTH Chris Dunscombe -Original Message- Sent: 11 September 2003 21:39 To: Multiple recipients of list ORACLE-L O/S is AIX 4.3.3 /usr/sbin/bootinfo -p returns "chrp" meaning that the hardware is capable of either 32 or 64 bit operation. /usr/sbin/bootinfo -K returns "32" meaning that the kernel is running in 32 bit mode. When I run sqlplus the server says: Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production How can I be running the 64 bit server on a system with a 32 bit kernel? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter 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: Dunscombe, Chris 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: Schauss, Peter 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).
RE: 64 bit Oracle (8.1.7) on a 32 bit AIX kernel (AIX 4.3.3)
Peter, I know that this looks odd but as the hardware is 64 bit the AIX O/S has some sort of translation layer that allows it to run Oracle 64 bit even though the kernel is in 32 bit mode. I discovered this when investigating running Oracle 9.2 and Oracle 8.1.7 on AIX 5L. After raising a TAR with Oracle I received the response which basically stated: - Oracle 8.1.7 can only be run in 32 bit mode on AIX 5L. - To run Oracle 8.1.7 and Oracle 9.2 concurrently on AIX 5L you must run AIX in 32 bit mode on 64 bit hardware with 32 bit Oracle 8.1.7 and Oracle 9.2 64 bit (it only exists in 64 bit mode). Confusing I know but somehow true. As an aside I don't think this applies to the likes of HP-UX. I'm fairly sure that running 32bit HP-UX 11 on 64 bit hardware will not allow 64 bit Oracle to run. HTH Chris Dunscombe -Original Message- Sent: 11 September 2003 21:39 To: Multiple recipients of list ORACLE-L O/S is AIX 4.3.3 /usr/sbin/bootinfo -p returns "chrp" meaning that the hardware is capable of either 32 or 64 bit operation. /usr/sbin/bootinfo -K returns "32" meaning that the kernel is running in 32 bit mode. When I run sqlplus the server says: Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production How can I be running the 64 bit server on a system with a 32 bit kernel? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter 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: Dunscombe, Chris 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).
