32-bit Oracle Server on 64-bit Solaris? 
Author Message
 32-bit Oracle Server on 64-bit Solaris?

My company is running a 64-bit version of Oracle 8.1.6.1 on 64-bit Solaris7.

Recently, we have run into a problem with our application and Oracle.
The application vendor informs us about an Oracle patch that might address
our problem, BUT: The vendor is running 32-bit Oracle and OracleSupport
informs us that the aforementioned patch is not available for our platform.

We have raised this as an issue with the vendor, but the system owner wants
to know if 'downgrading' the server to 32-bit just to be able to apply this
patch(.!.)  can be possible.

First: Can it be done? (I kinda hope it's not..)
I'm quite new to Oracle and this whole idea appears quite stupid. Wouldn't
it defeat the purpose and advantages of 64-bits OS+DB? Wouldn't it be sort
of like teaching a dog to walk on two legs--possible, but not terribly
efficient..(Dog trainers: pls don't shoot me for this analogy)

Any insights appreciated

Knut E. Meidal
(Wannabe Oracle DBA)



Fri, 28 Nov 2003 18:33:15 GMT
 32-bit Oracle Server on 64-bit Solaris?

Knut,

There is no problem in "downgrading" from 64 to 32 bit Oracle. All you need
to do is something like:

1) Install the 32-bit Oracle in a new ORACLE_HOME
2) Shutdown the database
3) Take a full backup! (Just in case something goes wrong)
4) Change ORACLE_HOME from the 64-bit Oracle to the 32-bit Oracle
5) Startup database
6) As internal run the script: $ORACLE_HOME/rdbms/admin/utlirp (which
invalidates and recompiles all PL/SQL)
7) You are up and running! (You might want to do a backup at this stage)

The main disadvantage with 32-bit Oracle compared to 64-bit Oracle is that
you cannot address as large amounts of memory, so unless you have a real
need for a large SGA nothing is wrong with using the 32-bit version (it is
definitely not slower!).

About the patch: If the bug mentioned cannot be backported to 8.1.6.1 (talk
to Oracle Support about this) then perhaps it is an option for you to
upgrade to 8.1.7 instead (assuming the bug is fixed here)?

HTH,
Gollum



Quote:
> My company is running a 64-bit version of Oracle 8.1.6.1 on 64-bit
Solaris7.

> Recently, we have run into a problem with our application and Oracle.
> The application vendor informs us about an Oracle patch that might address
> our problem, BUT: The vendor is running 32-bit Oracle and OracleSupport
> informs us that the aforementioned patch is not available for our
platform.

> We have raised this as an issue with the vendor, but the system owner
wants
> to know if 'downgrading' the server to 32-bit just to be able to apply
this
> patch(.!.)  can be possible.

> First: Can it be done? (I kinda hope it's not..)
> I'm quite new to Oracle and this whole idea appears quite stupid. Wouldn't
> it defeat the purpose and advantages of 64-bits OS+DB? Wouldn't it be sort
> of like teaching a dog to walk on two legs--possible, but not terribly
> efficient..(Dog trainers: pls don't shoot me for this analogy)

> Any insights appreciated

> Knut E. Meidal
> (Wannabe Oracle DBA)



Sat, 29 Nov 2003 02:46:01 GMT
 32-bit Oracle Server on 64-bit Solaris?
it is not at all unusual for releases and patches to be available first
in 32-bit, and for the port to 64-bit to lag behind.

the only reason i would have for migrating to a 64-bit release of oracle
would be to support an SGA of over 2GB  (the maximum allowed with
32-bit oracle).  following oracle's sizing recommendations, that would
require a minimum of 4GB of RAM on the database server.

there is no significant difference in performance between the 32-bit
and 64-bit oracle releases.  the difference is the maximum allowed size
of the SGA.

the two-legged dog analogy is comical, but way off target.

HTH



Quote:
> My company is running a 64-bit version of Oracle 8.1.6.1 on 64-bit
Solaris7.

> Recently, we have run into a problem with our application and Oracle.
> The application vendor informs us about an Oracle patch that might address
> our problem, BUT: The vendor is running 32-bit Oracle and OracleSupport
> informs us that the aforementioned patch is not available for our
platform.

> We have raised this as an issue with the vendor, but the system owner
wants
> to know if 'downgrading' the server to 32-bit just to be able to apply
this
> patch(.!.)  can be possible.

> First: Can it be done? (I kinda hope it's not..)
> I'm quite new to Oracle and this whole idea appears quite stupid. Wouldn't
> it defeat the purpose and advantages of 64-bits OS+DB? Wouldn't it be sort
> of like teaching a dog to walk on two legs--possible, but not terribly
> efficient..(Dog trainers: pls don't shoot me for this analogy)

> Any insights appreciated

> Knut E. Meidal
> (Wannabe Oracle DBA)



Sat, 29 Nov 2003 10:36:58 GMT
 32-bit Oracle Server on 64-bit Solaris?

Quote:

> there is no significant difference in performance between the 32-bit
> and 64-bit oracle releases.  the difference is the maximum allowed size
> of the SGA.

Thanks for your timely response. Seems like this is not as big an issue as I
feared.

Quote:

> the two-legged dog analogy is comical, but way off target.

Yeah, sorry about that.. Only I could think of to illustrate "possible, but
try another solution.." But I'm learning new Oracle stuff all the time.

K



Sat, 29 Nov 2003 15:26:51 GMT
 32-bit Oracle Server on 64-bit Solaris?
If had not done so, you want to change you /var/opt/oracle/oratab file
to the new ORACLE_HOME then do the shutdown startup


Quote:

> > there is no significant difference in performance between the 32-bit
> > and 64-bit oracle releases.  the difference is the maximum allowed size
> > of the SGA.

> Thanks for your timely response. Seems like this is not as big an issue as I
> feared.

> > the two-legged dog analogy is comical, but way off target.

> Yeah, sorry about that.. Only I could think of to illustrate "possible, but
> try another solution.." But I'm learning new Oracle stuff all the time.

> K



Sun, 30 Nov 2003 10:19:51 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Upper limit of total SGA for 32-bit Oracle8i Release 3 on 64-bit Solaris 8

2. Porting 32-bit to 64-bit on Sun Solaris

3. Ingres II 2.0 on Solaris 2.7 - 32 bit mode or 64 bit mode

4. 32-bit Clients to 64-bit Oracle Server

5. 64-bit SQL Server and 32-bit dlls question

6. 32-bit client to 64-bit server

7. 64 bit client accessing 32 bit server?

8. Interoperability of 32-bit and 64-bit client/server

9. 32-bit and 64-bit client/server interoperability

10. Join between 32-bit and 64-bit servers

11. Changes in 64 bit Oracle from 32 bit

12. How to tell if 64 or 32 bit version of Oracle 8.1.7 on Solaris


 
Powered by phpBB® Forum Software