Further question: Oracle 32bit / 64bit

OK help me out here...................................

We are contemplating moving up to the new Sun/Solaris "sunfire" architecture,
which is a 64-bit platform.
We would be moving from multiple Solaris 32-bit machines.

What are my options as far as running Oracle 8.1.6.x?

Upgrade?
Re-install and move data?
Run Oracle 32-bit on the 64-bit platform?

Thanks.

• Forwarded by Dan Hubler/DS/MICORP on 07/17/2001 03:33 PM ---------------------------

"Rao, Maheswara" <Maheswara.Rao_at_Sungardp3.com>@fatcity.com on 07/17/2001 04:10:46 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Mitchell,

We have both 32 bit and 64 bit Oracle 817 running on Solaris 7.

The easiest way is --- When you log onto SQL, then you would get a message similar to following:

Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64 bit production

Now, if you are running 32 bit version, you get the following message

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production

Please observe that the above message is not telling whether it is 32 or 64.
But for 64 bit, the message specifically tells you.

Thanks,

Rao

-----Original Message-----
Sent: Tuesday, July 17, 2001 3:38 PM
To: Multiple recipients of list ORACLE-L

Dear DBAs

How can I know my Oracle running on 32 or 64bit ? I am considering change configuration of SGA. Currently OS is updated to 8g memory on aix 4.3.3.
The limit is 2gb for 32bit ?

I only know if you switch from 32bit to 64bit or vice-a-versa, then you also need to run UTLIRP.SQL script which recompiles all PL/SQL modules and alters certain dictionary tables.

Mitchell

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rao, Maheswara
  INET: Maheswara.Rao_at_Sungardp3.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
-- 
Author: 
  INET: Dan.Hubler_at_Metavante.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).