f



32 bit or 64 bit Oracle on 64 bit OS?

Hello,

Currently our environment is on 10g Release 2, OS windows 2000/2003
standard edition 32 bit. We use shared server to take advantage of
scalability and connecting maximum no of simultaneous connections to
the database. Now we take advantage of memory beyond 4GB we are
planning to check following.

64 bit Windows 2003 standard edition on AMD64/EM64T Servers.

Do we need to install 64 bit Oracle as well?

Do we need to reinstall Oracle clients with 64 bit installable if
Oracle Server is upgraded to 64 bit?

Is 32 bit Oracle is certified on 64 bit OS?

Do we need to take care of any other issues?

Kindly share your experiences and help me to get the answers of these
questions.

Thanks & Regards,

Shailesh

0
1/19/2007 8:34:49 AM
comp.databases.oracle.server 22978 articles. 1 followers. Post Follow

8 Replies
1571 Views

Similar Articles

[PageSpeed] 56

Can migrating to Linux will be better option than 64 bit Windows?

Please let me know your opinion on this as well.

Thanks & Regards,

Shailesh

0
1/19/2007 10:34:01 AM
Updated Subject.

0
1/19/2007 10:49:40 AM
Comments embedded.

Shailesh wrote:
> Hello,
>
> Currently our environment is on 10g Release 2, OS windows 2000/2003
> standard edition 32 bit. We use shared server to take advantage of
> scalability and connecting maximum no of simultaneous connections to
> the database. Now we take advantage of memory beyond 4GB we are
> planning to check following.
>
> 64 bit Windows 2003 standard edition on AMD64/EM64T Servers.
>
> Do we need to install 64 bit Oracle as well?

Yes, 64 bit Oracle is required on 64 bit Windows.  The 32 bit version
of Oracle may work, but is not supported.  The 64 bit Standard Edition
of Windows 2003 supports up to 32GB of memory.  By comparition, the 32
bit Standard Edition of Windows 2000/2003 limits each process to 2GB of
memory.

> Do we need to reinstall Oracle clients with 64 bit installable if
> Oracle Server is upgraded to 64 bit?

No, you do not need to change the Oracle clients.  I still have a
couple client computers running the Oracle 8.0.5 client that are
connecting to the 64 bit version of Oracle 10.2.0.2.

> Is 32 bit Oracle is certified on 64 bit OS?

No

> Do we need to take care of any other issues?

Take a look at large page support, and consider using it with Oracle.
Read the platform specific manuals provided by Oracle.

> Kindly share your experiences and help me to get the answers of these
> questions.
>
> Thanks & Regards,
>
> Shailesh

Regarding your other questions about switching to Linux, that decision
should depend on your familiarity with Linux.  If you have no
experience with Linux, it likely will be best to stay with the Windows
version of the database.  If you have extensive experience with Linux,
consider using an enterpise version of Linux - verify that the version
selected is a supported platform.

There have been two recent threads in this group that may help you
decide which platform is most appropriate for your needs.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.

0
hooperc2000 (791)
1/19/2007 12:15:36 PM

On Jan 19, 1:15 pm, "Charles Hooper" <hooperc2...@yahoo.com> wrote:
> Comments embedded.
>
> Shailesh wrote:
> > Hello,
>
> > Currently our environment is on 10g Release 2, OS windows 2000/2003
> > standard edition 32 bit. We use shared server to take advantage of
> > scalability and connecting maximum no of simultaneous connections to
> > the database. Now we take advantage of memory beyond 4GB we are
> > planning to check following.
>
> > 64 bit Windows 2003 standard edition on AMD64/EM64T Servers.
>
> > Do we need to install 64 bit Oracle as well?Yes, 64 bit Oracle is required on 64 bit Windows.  The 32 bit version
> of Oracle may work, but is not supported.  The 64 bit Standard Edition
> of Windows 2003 supports up to 32GB of memory.  By comparition, the 32
> bit Standard Edition of Windows 2000/2003 limits each process to 2GB of
> memory.
>
> > Do we need to reinstall Oracle clients with 64 bit installable if
> > Oracle Server is upgraded to 64 bit?No, you do not need to change the Oracle clients.  I still have a
> couple client computers running the Oracle 8.0.5 client that are
> connecting to the 64 bit version of Oracle 10.2.0.2.
>
> > Is 32 bit Oracle is certified on 64 bit OS?No
>
> > Do we need to take care of any other issues?Take a look at large page support, and consider using it with Oracle.
> Read the platform specific manuals provided by Oracle.
>
> > Kindly share your experiences and help me to get the answers of these
> > questions.
>
> > Thanks & Regards,
>
> > ShaileshRegarding your other questions about switching to Linux, that decision
> should depend on your familiarity with Linux.  If you have no
> experience with Linux, it likely will be best to stay with the Windows
> version of the database.  If you have extensive experience with Linux,
> consider using an enterpise version of Linux - verify that the version
> selected is a supported platform.
>
> There have been two recent threads in this group that may help you
> decide which platform is most appropriate for your needs.
>
> Charles Hooper
> PC Support Specialist
> K&M Machine-Fabricating, Inc.


Charles
Please refer to the certification matrix for win2003.
32-bit Oracle *is* certified, and there are several releases that will
work with several processors only in 32-bit mode.

-- 
Sybrand Bakker
Senior Oracle DBA

0
sybrandb1 (715)
1/19/2007 1:45:38 PM
Shailesh wrote:
> Can migrating to Linux will be better option than 64 bit Windows?
> 
> Please let me know your opinion on this as well.
> 
> Thanks & Regards,
> 
> Shailesh

Yes. I have a client just this week we are moving to 64 bit Oracle Linux
that reached a point where Windows, for all intents and purposes, fell
over due to their volume. It runs just fine with Linux.

I was discussing this with Microsoft yesterday and we agreed that it
might not have been Windows, per se, but rather the quality of Windows
Sys Admins. But either way ... the move solved the customer's problem.
-- 
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
0
damorgan3 (6326)
1/19/2007 3:09:40 PM
sybrandb wrote:
> On Jan 19, 1:15 pm, "Charles Hooper" <hooperc2...@yahoo.com> wrote:
> > Comments embedded.
> >
> > Shailesh wrote:
> > > Hello,
> >
> > > Do we need to install 64 bit Oracle as well?Yes, 64 bit Oracle is required on 64 bit Windows.  The 32 bit version
> > of Oracle may work, but is not supported.  The 64 bit Standard Edition
> > of Windows 2003 supports up to 32GB of memory.  By comparition, the 32
> > bit Standard Edition of Windows 2000/2003 limits each process to 2GB of
> > memory.
> >
> > > Do we need to reinstall Oracle clients with 64 bit installable if
> > > Oracle Server is upgraded to 64 bit?No, you do not need to change the Oracle clients.  I still have a
> > couple client computers running the Oracle 8.0.5 client that are
> > connecting to the 64 bit version of Oracle 10.2.0.2.
> >
> > > Is 32 bit Oracle is certified on 64 bit OS?No
> >
> > There have been two recent threads in this group that may help you
> > decide which platform is most appropriate for your needs.
> >
> > Charles Hooper
> > PC Support Specialist
> > K&M Machine-Fabricating, Inc.
>
>
> Charles
> Please refer to the certification matrix for win2003.
> 32-bit Oracle *is* certified, and there are several releases that will
> work with several processors only in 32-bit mode.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Sybrand,

Thanks for asking me to check the certification matrix - I dislike
giving out incorrect information, so it is good to check once in a
while to see what has changed.  On Metalink I found Note:343737.1, last
revised June 27, 2006.  From that document:

"Oracle Server Product Support - 32-Bit running on 64-Bit x64
============================================================
Oracle does not currently support running the 32-Bit versions of its
database
or client software on Windows XP 64-Bit Itanium / Windows 2003 64-Bit
Itanium
operating systems. Oracle has however certified the 32-Bit Client
software
from 9.2.0.x onwards to run on the Windows XP 64-Bit x64 / Windows 2003
64-Bit
x64 operating systems."

So, it looks like running a 32 bit client on a 64 bit operating system
is OK, but it is not supported to run the 32 bit version of the Oracle
database on a 64 bit version of Windows 2003.

There could very well be another document on Metalink that contradicts
the above quote.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.

0
hooperc2000 (791)
1/19/2007 4:38:57 PM
"Charles Hooper" <hooperc2000@yahoo.com> wrote in message
news:1169224737.654947.135890@a75g2000cwd.googlegroups.com...

> Thanks for asking me to check the certification matrix - I dislike
> giving out incorrect information, so it is good to check once in a
> while to see what has changed.  On Metalink I found Note:343737.1, last
> revised June 27, 2006.  From that document:
>
> "Oracle Server Product Support - 32-Bit running on 64-Bit x64
> ============================================================
> Oracle does not currently support running the 32-Bit versions of its
> database
> or client software on Windows XP 64-Bit Itanium / Windows 2003 64-Bit
> Itanium
> operating systems. Oracle has however certified the 32-Bit Client
> software
> from 9.2.0.x onwards to run on the Windows XP 64-Bit x64 / Windows 2003
> 64-Bit
> x64 operating systems."
>
> So, it looks like running a 32 bit client on a 64 bit operating system
> is OK, but it is not supported to run the 32 bit version of the Oracle
> database on a 64 bit version of Windows 2003.
>
> There could very well be another document on Metalink that contradicts
> the above quote.

 Charles,

Please note that there are two flavors of 64bit intel platforms, Itanium and
EM64T.  From the Metalink Certify tab:

      Certify - Certification Matrix: Oracle Database - Enterprise Edition
on Microsoft Windows 2003 (AMD64/EM64T)

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


      Server Certifications
            OS Product Certified With Version Status Addtl. Info. Components
Other Install Issue
            2003 R2 10gR2 64-bit N/A N/A Certified Yes None None None
            2003 10gR2 64-bit N/A N/A Certified Yes None None None
            2003 32-bit 10gR2 32-bit N/A N/A Certified Yes None None None


Sorry for the screwy formatting, but this says for EM64T, 32Bit 10gR2 is
certified on 64bit Win2003.




0
Nospam5480 (15)
1/19/2007 7:33:17 PM
Dave wrote:
> "Charles Hooper" <hooperc2000@yahoo.com> wrote in message
> news:1169224737.654947.135890@a75g2000cwd.googlegroups.com...
>
> > Thanks for asking me to check the certification matrix - I dislike
> > giving out incorrect information, so it is good to check once in a
> > while to see what has changed.  On Metalink I found Note:343737.1, last
> > revised June 27, 2006.  From that document:
> >
> > "Oracle Server Product Support - 32-Bit running on 64-Bit x64
> > ============================================================
> > Oracle does not currently support running the 32-Bit versions of its
> > database
> > or client software on Windows XP 64-Bit Itanium / Windows 2003 64-Bit
> > Itanium
> > operating systems. Oracle has however certified the 32-Bit Client
> > software
> > from 9.2.0.x onwards to run on the Windows XP 64-Bit x64 / Windows 2003
> > 64-Bit
> > x64 operating systems."
> >
> > So, it looks like running a 32 bit client on a 64 bit operating system
> > is OK, but it is not supported to run the 32 bit version of the Oracle
> > database on a 64 bit version of Windows 2003.
> >
> > There could very well be another document on Metalink that contradicts
> > the above quote.
>
>  Charles,
>
> Please note that there are two flavors of 64bit intel platforms, Itanium and
> EM64T.  From the Metalink Certify tab:
>
>       Certify - Certification Matrix: Oracle Database - Enterprise Edition
> on Microsoft Windows 2003 (AMD64/EM64T)
>
> --------------------------------------------------------------------------
>
>
>       Server Certifications
>             OS Product Certified With Version Status Addtl. Info. Components
> Other Install Issue
>             2003 R2 10gR2 64-bit N/A N/A Certified Yes None None None
>             2003 10gR2 64-bit N/A N/A Certified Yes None None None
>             2003 32-bit 10gR2 32-bit N/A N/A Certified Yes None None None
>
>
> Sorry for the screwy formatting, but this says for EM64T, 32Bit 10gR2 is
> certified on 64bit Win2003.

We seem to have found an inconsistency between the two Metalink
documents.

The certify section does show what you indicate above.  Metalink note
343737.1, that I referenced in my previous post, is titled "Oracle
Database Server support Matrix for Windows XP / 2003 64-Bit (x64)".
The AMD64/EM64T CPU lines, if running a 64 bit version of Windows 2003,
require the x64 Edition of Windows 2003.  I can't determine why the
document would include a heading of "Oracle Server Product Support -
32-Bit running on 64-Bit x64" and then directly below that heading
discussed Itanium processors - Note 236183.1 deals with the Itanium
processor.

If one were to run the 32 bit version of Oracle 10.2 on the x64 Edition
of Windows 2003, what would be gained? The per process limit is raised
from 2GB to 4GB.  If support is needed for the 32 bit version of Oracle
on 64 bit Windows 2003, would Oracle support state that this is an
invalid configuration?  I guess that the answer might depend on which
document support references when troubleshooting the problem.

This has been an interesting discussion.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.

0
hooperc2000 (791)
1/19/2007 8:30:54 PM
Reply:

Similar Artilces:

32 bit Oracle RDBMS on 64 bit OS?
I see from the Oracle certification matrix that they do not certify running a 32-bit installation of Oracle database against a 64 bit operating system. But does anyone know whether this can be done, would it/could it work? I was thinking about running 32 bit 10g standard edition on a 64 bit Windows OS (Windows8). Does anyone have any knowledge on this? Thanks, Dan On Sep 8, 3:00=A0pm, Dan <daniel.oster...@visaer.com> wrote: > I see from the Oracle certification matrix that they do not certify > running a 32-bit installation of Oracle database against a 64 bit > operating system. =A0 But does anyone know whether this can be done, > would it/could it work? =A0I was thinking about running 32 bit 10g > standard edition on a 64 bit Windows OS (Windows8). > > Does anyone have any knowledge on this? > > Thanks, > Dan I currently have 10g XE 32-bit running on 64-bit Windows7 without issue. It appears that 10g XE isn't available in 64-bit, and 11g XE isn't available in 64-bit for "Winders". David Fitzjarrell On Thu, 08 Sep 2011 15:00:23 -0700, Dan wrote: > I see from the Oracle certification matrix that they do not certify > running a 32-bit installation of Oracle database against a 64 bit > operating system. But does anyone know whether this can be done, would > it/could it work? I was thinking about running 32 bit 10g standard > edition on a 64 bit Windows OS (Windows8). > > Does anyone have a...

Oracle 64 bits and 32 bits oracle applications mix on same machine ?
We used to run solaris 2.6 (32 bits) and oracle 32 bits on older machines. I'm new in the 64 bits world on solaris. I just bought a new sun server (SPARC III) and I plan to run solaris 9 on it, in 64 bits mode, which I think is the default (Can anyone confirm this ?) Does anyone know if it is possible on the same server, which is running in solaris 64 bits mode, and oracle 64 bits version, to run other oracle apps in 32 bits mode ? For example, suppose I have an oracle 64 bits instance running on the server and I have some "legacy" oracle applications that were compiled in 32 bit mode running (Ex: webforms server, old OCI apps) and I don't have the source and I cannot recompile them. Would those 32 bits application run OK ? Also, I've heard that unless you REALLY NEED it (For HUGE SGA for example) you better stick with oracle 32 bits because it performs better. Is that true ? Thanks Without going into too much detail: 1. Install 64-bit Solaris. 2. You can run 32-bit Oracle on 64-bit Solaris...this is very very common. 3. There is no "32-bit" mode as far as Oracle is concerned. Just stick in the 32-bit version of the software, install, and do your work normally. Hope this helps. norwoodthree@my-deja.com (NorwoodThree) wrote in message news:<ba03e2c.0310311021.7c21ae21@posting.google.com>... > Without going into too much detail: > > 1. Install 64-bit Solaris. > 2. You can run 32-bit Oracle on 64-bit Solaris...t...

64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit
64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - new ! Windows Liberty 64bit 8403 Windows Limited Edition 64 Bit Edition 8764 Microsoft SQL Server 2000 Developer Edition 64 Bit 12 000 IBM DB2 UNIVERSAL CONNECT ENTERPRISE EDITION V8.1.2 64BIT 12 211 IBM DB2 Administration Client V8.1.2 64bit W3KSERVER 12 266 IBM DB2 UDB Enterprise Server Edition V8.1.2 64Bit W3KSERVER 12 284 IBM DB2 Connect Applic Server Edition V8.1.2 64bit W3KSERVER 12 392 IBM DB2 Spatial Extender v8.1 64Bit Multilanguage 12 610 If you have Googled your butt off, and haven't come up with anything ...., and for 14,000 more reasons, please send e-mail, tel4@ath.forthnet.gr, tel2003@pathfinder.gr, astra35@pathfinder.gr, TEL wrote: > 64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, > Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - > new ! > > Windows Liberty 64bit 8403 > > Windows Limited Edition 64 Bit Edition 8764 > > Microsoft SQL Server 2000 Developer Edition 64 Bit 12 000 > > IBM DB2 UNIVERSAL CONNECT ENTERPRISE EDITION V8.1.2 64BIT 12 211 > > IBM DB2 Administration Client V8.1.2 64bit W3KSERVER 12 266 > > IBM DB2 UD...

64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit
64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - new ! Windows Liberty 64bit 8403 Windows Limited Edition 64 Bit Edition 8764 Microsoft SQL Server 2000 Developer Edition 64 Bit 12 000 IBM DB2 UNIVERSAL CONNECT ENTERPRISE EDITION V8.1.2 64BIT 12 211 IBM DB2 Administration Client V8.1.2 64bit W3KSERVER 12 266 IBM DB2 UDB Enterprise Server Edition V8.1.2 64Bit W3KSERVER 12 284 IBM DB2 Connect Ap...

64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit
64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - new ! Windows Liberty 64bit 8403 Windows Limited Edition 64 Bit Edition 8764 Microsoft SQL Server 2000 Developer Edition 64 Bit 12 000 ----------------------------------------------------------------------- IBM DB2 UNIVERSAL CONNECT ENTERPRISE EDITION V8.1.2 64BIT 12 211 IBM DB2 Administration Client V8.1.2 64bit W3KSERVER 12 266 IBM DB2 UDB Enterprise Server Edition V8.1.2 64Bit W3KSERVER 12 284 IBM DB2 UDB Enterprise Server Edition V8.1.2 64Bit Linux IBM DB2 Connect Applic Server Edition V8.1.2 64bit W3KSERVER 12 392 IBM DB2 Spatial Extender v8.1 64Bit Multilanguage 12 610 ---------------------------------------------------------------------- Windows Liberty 64bit No.Of.Disk:1 Format:Cue/Bin Rar Files:9 Type:OS Protection:None Notes:Just another OS but you must have Windows XP to install install it and run it ----------------------------------------------------------------------- Windows Limited Edition 64 Bit Edition Format......: BIN/CUE RAR count........: 47 X 15mb Protection.......: None Date........: May 01, 2002 This is the Windows Limited Edition 64 Bit Edition operating system that will only run on 64 bit processors. It will not work on any others. To I...

64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit
64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - new ! Windows Liberty 64bit 8403 Windows Limited Edition 64 Bit Edition 8764 Microsoft SQL Server 2000 Developer Edition 64 Bit 12 000 ----------------------------------------------------------------------- IBM DB2 UNIVERSAL CONNECT ENTERPRISE EDITION V8.1.2 64BIT 12 211 IBM DB2 Administration Client V8.1.2 64bit W3KSERVER 12 266 IBM DB2 UDB Enter...

64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit
64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - new ! Windows Liberty 64bit 8403 Windows Limited Edition 64 Bit Edition 8764 Microsoft SQL Server 2000 Developer Edition 64 Bit 12 000 ----------------------------------------------------------------------- IBM DB2 UNIVERSAL CONNECT ENTERPRISE EDITION V8.1.2 64BIT 12 211 IBM DB2 Administration Client V8.1.2 64bit W3KSERVER 12 266 IBM DB2 UDB Enterprise Server Edition V8.1.2 64Bit W3KSERVER 12 284 IBM DB2 UDB Enterprise Server Edition V8.1.2 64Bit Linux IBM DB2 Connect Applic Server Edition V8.1.2 64bit W3KSERVER 12 392 IBM DB2 Spatial Extender v8.1 64Bit Multilanguage 12 610 ---------------------------------------------------------------------- Windows Liberty 64bit No.Of.Disk:1 Format:Cue/Bin Rar Files:9 Type:OS Protection:None Notes:Just another OS but you must have Windows XP to install install it and run it ----------------------------------------------------------------------- Windows Limited Edition 64 Bit Edition Format......: BIN/CUE RAR count........: 47 X 15mb Protection.......: None Date........: May 01, 2002 This is the Windows Limited Edition 64 Bit Edition operating system that will only run on 64 bit processors. It will not work on any others. To Install: No Serial or Crack is Needed for this rele...

64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit
64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - new ! Windows Liberty 64bit 8403 Windows Limited Edition 64 Bit Edition 8764 Microsoft SQL Server 2000 Developer Edition 64 Bit 12 000 IBM DB2 UNIVERSAL CONNECT ENTERPRISE EDITION V8.1.2 64BIT 12 211 IBM DB2 Administration Client V8.1.2 64bit W3KSERVER 12 266 IBM DB2 UDB Enterprise Server Edition V8.1.2 64Bit W3KSERVER 12 284 IBM DB2 Connect Applic Server Edition V8.1.2 64bit W3KSERVER 12 392 IBM DB2 Spatial Extender v8.1 64Bit Multilanguage 12 610 If you have Googled your butt off, and haven't come up with anything ...., and for 14,000 more reasons, please send e-mail, tel4@ath.forthnet.gr, tel2003@pathfinder.gr, astra35@pathfinder.gr, ...

64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit
64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - new ! Windows Liberty 64bit 8403 Windows Limited Edition 64 Bit Edition 8764 Microsoft SQL Server 2000 Developer Edition 64 Bit 12 000 ----------------------------------------------------------------------- IBM DB2 UNIVERSAL CONNECT ENTERPRISE EDITION V8.1.2 64BIT 12 211 IBM DB2 Administration Client V8.1.2 64bit W3KSERVER 12 266 IBM DB2 UDB Enter...

64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit
64 bit - Windows Liberty 64bit, Windows Limited Edition 64 Bit, Microsoft SQL Server 2000 Developer Edition 64 Bit, IBM DB2 64 bit - new ! Windows Liberty 64bit 8403 Windows Limited Edition 64 Bit Edition 8764 Microsoft SQL Server 2000 Developer Edition 64 Bit 12 000 IBM DB2 UNIVERSAL CONNECT ENTERPRISE EDITION V8.1.2 64BIT 12 211 IBM DB2 Administration Client V8.1.2 64bit W3KSERVER 12 266 IBM DB2 UDB Enterprise Server Edition V8.1.2 64Bit W3KSERVER 12 284 IBM DB2 Connect Applic Server Edit...

Installing 32-bit and 64-bit oracle client on windows 2003 Server
Hi, I am wondering if we could install 32-bit client of 10g release2 and 64-bit client of the same (allowing delphi 32-bit apps and some .net Windows services to connect to the oracle database server hosted on HP- UX running 64-bit mode. has anyone done this before? If so, can you please provide me some documentation of how to configure the same. Thanks in advance. Deepak. ...

Installing 32-bit and 64-bit oracle client on windows 2003 Server
Hi, I am wondering if we could install 32-bit client of 10g release2 and 64-bit client of the same (allowing delphi 32-bit apps and some .net Windows services to connect to the oracle database server hosted on HP- UX running 64-bit mode. has anyone done this before? If so, can you please provide me some documentation of how to configure the same. Thanks in advance. Deepak. ...

Oracle 8.1.7 32-Bit to Oracle 8.1.7 64-Bit
Hi I would much appreciate help We have a 150-200GB database on Oracle 8.1.7 which resides on a HP-UX 32-bit machine. We are upgrading the HP-UX machine to 64-Bit. Is the only way of extracting/inmporting the data via the exp/imp utitlity due to the change in bits? Is there any other way? Thanks Bob Bob wrote: > Hi I would much appreciate help > > We have a 150-200GB database on Oracle 8.1.7 which resides on a HP-UX > 32-bit machine. We are upgrading the HP-UX machine to 64-Bit. Hi, a) Do you want to upgrade Oracle-Software from 32bit to 64bit? On Solaris, I know 32bit Oracle-Software runs also on 64bit Solaris, but I don't know about HP-UX. b) If you want or have to switch to Oracle 64 bit, then use can use the new 64bit oracle software on the "old" database, but you have to recompile all PL/SQL-procedures, no more. No exp/imp is necessary. - install 64bit Oracle-Software in a new $ORACLE_HOME - switch all environments to 64bit oracle and use it now - sqlplus "/ as sysdba" sql> startup restrict sql> @?/rdbms/admin/utlirp; sql> shutdown immediate sql> startup sql> @?/rdbms/admin/utlrp; sql> exit; --> ready! Eberhard Eberhard Niendorf <eberhard.niendorf_schrott@t-online.de> wrote in message news:<cnt89j$uor$05$1@news.t-online.com>... > Bob wrote: > > > Hi I would much appreciate help > > > > We have a 150-200GB database on Oracle 8.1.7 which resid...

upgrade oracle 32-bit 9204 apps database to 64-bit 9207
I'am in the process of upgrading my 32-bit 9204 apps database to 64-bit 9207. Just wanted to make sure i covered everything. 1) Install 9201 64-bit 2) apply 64bit 9207 on it. 3) Copy init.ora and orapwd file to new Oracle home 4) startup migrate (with _system_trig_enabled = FALSE) 5) run @utlip.sql 6) download patch 1994933 and run rmsro.sql, call rmsro.run(); & invalidate.sql 7) create or replace java system; 8) @catpatch.sql 9) utlrp.sql 10) shutdown and restart (after removing setting _system_trig_enabled = TRUE) 10) copy appsutil from 32-bit 9204 to 64-bit 9207 home and run perl adcfgclone.pl dbTechStack Did i miss any steps ? Any redundant steps in there ? Thanks & regards srivenu srivenu@hotmail.com wrote: > I'am in the process of upgrading my 32-bit 9204 apps database to 64-bit > 9207. > > Just wanted to make sure i covered everything. > > 1) Install 9201 64-bit > 2) apply 64bit 9207 on it. > 3) Copy init.ora and orapwd file to new Oracle home > 4) startup migrate (with _system_trig_enabled = FALSE) > 5) run @utlip.sql > 6) download patch 1994933 and run rmsro.sql, call rmsro.run(); & > invalidate.sql > 7) create or replace java system; > 8) @catpatch.sql > 9) utlrp.sql > 10) shutdown and restart (after removing setting _system_trig_enabled > = TRUE) > 10) copy appsutil from 32-bit 9204 to 64-bit 9207 home and run perl > adcfgclone.pl dbTechStack > > Did i miss any steps ? &g...

Installing 32-bit and 64-bit oracle client on windows 2003 Server
Hi, I am wondering if we could install 32-bit client of 10g release2 and 64-bit client of the same (allowing delphi 32-bit apps and some .net Windows services to connect to the oracle database server hosted on HP- UX running 64-bit mode. has anyone done this before? If so, can you please provide me some documentation of how to configure the same. Thanks in advance. Deepak. On 13 Apr 2007 10:00:52 -0700, deepak.kollipara@gmail.com wrote: >Hi, > >I am wondering if we could install 32-bit client of 10g release2 and >64-bit client of the same (allowing delphi 32-bit apps and some .net >Windows services to connect to the oracle database server hosted on HP- >UX running 64-bit mode. has anyone done this before? > >If so, can you please provide me some documentation of how to >configure the same. > >Thanks in advance. >Deepak. Fact: 32-bit client can communicate with 64-bit server without problem. Fact: if you want to install 2 different clients you need to install them in 2 different Oracle homes Fact: your question is redundant, as this is all outlined in the installation documentation on http://otn.oracle.com or http://tahiti.oracle.com both reachable from http://www.oracle.com Fact: you were even too lazy to type www.oracle.com in your browser and hit the documentation button. -- Sybrand Bakker Senior Oracle DBA On Apr 13, 11:12 am, sybra...@hccnet.nl wrote: > On 13 Apr 2007 10:00:52 -0700, deepak.kollip...@gmail.com wrote: >...

32 bits vs. 64 bits Oracle
I am about to update Oracle from 8.1.7 to 9.2.0 on a Sun E3500 running Solaris 7. If I have the chance to choose, should I prefer the 64 bit version instead of the 32 bit version? Would anyone explain the difference in general, and perhaps in the particular case of Oracle? The machine has 2 GB and won't ever get more. By the way, if if booting kernel/unix (32 bit Kernel), will any 64 bit software still run? We have had a case the other way around: A special software won't run properly if booting the 64 bit Kernel. Thanks in advance Rick Denoire In article <7kc9uvop07odr9k0heb...

Clone a 10gR2 database running on 64 bit server to 32 bit server
I Have to clone a 10gR2 database running on 64 bit server to 32 bit server. Details: we have HOT backup of last night. Database running on Red hat Linux 4. DB version : 10.2.0.2. Any suggestions are appreciated. is the oracle binary 32-bit or 64-bit ? regards srivenu On Sep 9, 11:27=A0am, sriv...@hotmail.com wrote: > is the oracle binary 32-bit or 64-bit ? > regards > srivenu The server has 32 bit binaries. On Sep 9, 12:32=A0pm, amr <maheshn...@gmail.com> wrote: > On Sep 9, 11:27=A0am, sriv...@hotmail.com wrote: > > > is the oracle binary 32-bit or 64-bit ? > > regards > > srivenu > > The server has 32 bit binaries. This is on the 64-bit machine? David Fitzjarrell On Sep 9, 10:32=A0am, amr <maheshn...@gmail.com> wrote: > On Sep 9, 11:27=A0am, sriv...@hotmail.com wrote: > > > is the oracle binary 32-bit or 64-bit ? > > regards > > srivenu > > The server has 32 bit binaries. Well, it could be out of date, but see metalink Note:62290.1 & 467676.1. I think the part about 32-bit not being supported on 64-bit might be right, judging from the certification matrix. But with linux, who knows what evil lurks in the machinations of men? And I could be wrong, not actually using linux now. Platforms that support both will say 64-bit only if 64-bit, but platforms that only support 64-bit won't say it, AFAIK (Note:119707.1). So, be explicit in how you know it is 32-bit, we might all learn ...

Run 32-bit and 64-bit listener at the same time on W3K 64-bit
I have Oracle 10.2.0.4-64 bit running on W3K-64-bit. Now I need to run a 32-bit 9.2.0.5 (yes I know, ouch) on this box. I cannot get the listener to work. I use batch file to specifically point to the 9.2 environment, but for some reason it points to the 64-bit version. Any clues? E:\dbscripts>rem set oracle 9.2 environment E:\dbscripts>set ORACLE_HOME=C:\oracle\ora92 E:\dbscripts>set path=C:\oracle\ora92\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;\\CFOLDC1\fopublic\ E:\dbscripts>set TNS_ADMIN=C:\oracle\ora92\network\admin E:\dbscripts>c: C:\...

compiling on 32-bit vs. 64-bit (gcc fails on 64-bit)
On a 64-bit Scientific Linux 5.4 machine, I get the following when I try to compile the basic "Hello world" program: [root]# g++ -Wall hello.cc -o hello /tmp/ccglIDXK.s: Assembler messages: /tmp/ccglIDXK.s:10: Error: suffix or operands invalid for `push' /tmp/ccglIDXK.s:38: Error: suffix or operands invalid for `push' /tmp/ccglIDXK.s:55: Error: suffix or operands invalid for `push' /tmp/ccglIDXK.s:79: Error: suffix or operands invalid for `push' /tmp/ccglIDXK.s:81: Error: suffix or operands invalid for `push' /tmp/ccglIDXK.s:85: Error: suffix or operand...

64-bit instance on Aix 32 bit kernel / 64 bit hardware
Hi, Is it worth to use 64-bit DB2 instances on a 32-bit kernel, in terms of: - performance - configuration (go beyond the 256 Mb segment for private mem, 1.75 Gb for Bufferpools) - other ? I've seen NIS is not supported, downlevel (64 to 32 bit ?) is not supported .... The "Should I be using DB2 64-bit?" tech note seems confusing: http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&q1=64-bit&uid=swg21188114&loc=en_US&cs=utf-8&lang=en It states some restrictions - You can install 64-bit DB2 UDB Version 8 on 32-bit operating systems only on AIX, HP-UX and Solaris Operating Environments. ==>You will not be able to create or run 64-bit instances. You can only create and run 32-bit instances. <== Really ? The db2setup (8.2 / Aix) asked for 32-bit or 64-bit instance creation. It seems db2iupdt -w 64 works fine, and the instance is functionning, but is it worth ? Thanks for your help, Jean-Marc Jean-Marc, I believe what the technote is trying to say is you can install the 64-bit version of DB2 (i.e. the DB2 binaries) under a 32-bit OS, but once you install the DB2 binaries, you must create DB2 instances in order to operate a DB2 database. I believe it is saying that you cannot create 64-bit instances under a 32-bit OS. If you didn't receive an error in attempting to do so, I guess you are in uncharted territory, and risk not being able to get support from IBM. I'm not ...

Oracle 10g on W2k3
I'm looking at speccing out new server hardware. We want to move to 10.2. Any reason not to use the 64 bit OS instead of the 32 bit version? Anybody here using 10.2 on Windows 64 bit? Comments? Observations? Smallish to mediumish database. Our network administrators are mostly Windows, so hosting on Linux or U*ix is probably a non starter. The advantages of sticking with the 32 bit version is that it's not "new" - we have a base of W2k3 32 bit boxen, so from an OS care and feeding perspective it's just another box in the rack just like the others. The advantage of 64 bit is the larger addressable memory space which *may* improve performance. As a shop we'll be going to 64 bit for many servers before long anyway (MS Exchange, for instance), so might as well do it now. But I'm not sure that Oracle is the best candidate to be the guinnea pig.... (current version 9.2 on W2k3 32 bit) //Walt Walt wrote: > I'm looking at speccing out new server hardware. We want to move to 10.2. > > Any reason not to use the 64 bit OS instead of the 32 bit version? > Anybody here using 10.2 on Windows 64 bit? Comments? Observations? > > Smallish to mediumish database. Our network administrators are mostly > Windows, so hosting on Linux or U*ix is probably a non starter. The > advantages of sticking with the 32 bit version is that it's not "new" - > we have a base of W2k3 32 bit boxen, so from an OS ca...

Linking 32-bit and 64 bit oracle library
Hi , I am creating two libraries using Pro*c , one which uses Oracle client 8.0.5 and the other uses Oracle 10.2.0.1.0(In their own environment) . The 8.0.5 library is a 32 bit , and 10g's library is 64 bit library(uses -xarch=v9 flag while compiling) when I include these libraries as USRLIBS I get errors like : ld: fatal: file pro_10.o: wrong ELF class: ELFCLASS64 Is there any way to convery the 32 bit library to 64 or vice versa ? Thanks ! abhi147@gmail.com wrote: > I am creating two libraries using Pro*c , one which uses Oracle > client 8.0.5 and the other uses Oracle 10.2.0.1.0(In their own > environment) . The 8.0.5 library is a 32 bit , and 10g's library is 64 > bit library(uses -xarch=v9 flag while compiling) > > when I include these libraries as USRLIBS I get errors like : > > ld: fatal: file pro_10.o: wrong ELF class: ELFCLASS64 > > Is there any way to convery the 32 bit library to 64 or vice versa ? Let me get that right: You're writing a C program that should run against an 8 and a 10g server? And you want to encapsule the Oracle stuff in a shared library, and depending on which database you want to access you're repacing the shared library? Yours, Laurenz Albe abhi147@gmail.com wrote: > Hi , > > I am creating two libraries using Pro*c , one which uses Oracle > client 8.0.5 and the other uses Oracle 10.2.0.1.0(In their own > environment) . The 8.0.5 library is a 32 bit , and 10g&...

32 bit oracle on Solaris 9 64 bits ?
I just bought a new sun server (280R) and I plan to run solaris 9 on it in 64 bits mode, which I think is the default when you install (Can anyone confirm this ?) Should I run oracle 64 bits edition on it, or would oracle 32 bits edition run just fine ? I heard that the 64 bit edition was slower and I don't need a HUGE SGA, and I will probably have older 32 bit oracle OCI apps running that I cannot recompile. Is there a HUGE performance penalty in running 32 bits apps on solaris 64 bits ? Thanks Comments inline. > I just bought a new sun server (280R) and I plan to run solaris 9 on it in > 64 bits mode, > which I think is the default when you install (Can anyone confirm this ?) Yes, 64-bit is the default. You should never change to 32 bit OS > > Should I run oracle 64 bits edition on it, or would oracle 32 bits edition > run just fine ? We run an Oracle DB of 32 bits in 64-bits Solaris (8 ,9) for more than 2 years now. Performace is good, also very stable. > I heard that the 64 bit edition was slower and I don't need a HUGE SGA, and > I will probably > have older 32 bit oracle OCI apps running that I cannot recompile. > > Is there a HUGE performance penalty in running 32 bits apps on solaris 64 > bits ?> Don't know that becuase I have no comparisons. sean chang -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 1...

RHEL AS 4 + Oracle 10g : 32-bit or 64-bit ?
Both RHEL AS 4 and Oracle 10g for Linux exist in 32-bit and 64-bit versions. Suppose we have 64-bit x86 compatible hardware, what would be the advantages of choosing 64-bit OS and Oracle instead of 32-bit ? We don't need a bigger than 1GB SGA, so are there any other advantages regarding performance ? Any online tests/benchmarks somewhere ? Matthias Matthias Hoys wrote: > of choosing 64-bit OS and Oracle instead of 32-bit ? We don't need a bigger > than 1GB SGA, so are there any other advantages regarding performance ? Any > online tests/benchmarks somewhere ? maybe https://www.redhat.com/rhel/details/benchmarks/ has some comparable benchmark results. QUEST offers a TPC test AFAIK, HAMMERORA is another one. regards, -ap > Both RHEL AS 4 and Oracle 10g for Linux exist in 32-bit and 64-bit > versions. > Suppose we have 64-bit x86 compatible hardware, what would be the > advantages of choosing 64-bit OS and Oracle instead of 32-bit ? We don't > need a bigger than 1GB SGA, so are there any other advantages regarding > performance ? Not really. Even larger SGA doesn't guarantee better performance. Matthias Hoys wrote: > Both RHEL AS 4 and Oracle 10g for Linux exist in 32-bit and 64-bit versions. > Suppose we have 64-bit x86 compatible hardware, what would be the advantages > of choosing 64-bit OS and Oracle instead of 32-bit ? We don't need a bigger > than 1GB SGA, so are there any other advantages r...

Web resources about - 32 bit or 64 bit Oracle on 64 bit OS? - comp.databases.oracle.server

Oracle - Wikipedia, the free encyclopedia
This article is about the classical medium. For the software company, see Oracle Corporation . For other uses, see Oracle (disambiguation) . ...

Oracle - Wikipedia, the free encyclopedia
This article is about the classical medium. For the software company, see Oracle Corporation . For other uses, see Oracle (disambiguation) . ...

News Oracle
The News Oracle is an online news outlet. The Oracle covers the most relevant stories from around the globe.

Oracle Acquires Facebook Data Partner Datalogix
One of Facebook’s data partners has a new owner, as Datalogix was acquired by Oracle , the two companies announced Tuesday. (more…) New Career ...

Google, Oracle setting up jurors to fail in API copyright retrial, judge says
(credit: Seabamirum ) One of the tech sector's biggest upcoming trials— Oracle v. Google —careened Tuesday away from the hot-button topic of ...

Oracle Rising: Past the Trough in Cloud Transition, Say Bulls
Shares of database giant Oracle ( ORCL ) are up $1.26, over 3%, at $40, in early trading, continuing last night’s gains, after the company yesterday ...

Larry Ellison shrugs off Amazon, Microsoft play for Oracle database business
Businesses that aren't worried when Amazon starts gunning for their customers need only give Borders Books and Music a call. That said, Oracle's ...

Riley Curry Made a Special Appearance on the Dance Cam at Oracle Arena - Bleacher Report
Riley Curry...back at it again with the heart-stealing. The young phenom gave her dad, Golden State Warriors star Stephen Curry , a run for his ...

Here's the email Larry Ellison just sent to employees about a big change at Oracle
Oracle CEO Safra Catz made some interesting and cryptic comments about big changes coming to the company when talking to analysts after reporting ...

Oracle earnings beat estimates
Analysts had expected Oracle to report earnings of about 62 cents a share on $9.12 billion in revenue.

Resources last updated: 3/20/2016 12:31:25 AM