Archive

Archive for November, 2009

Oracle database and operating support matrix

November 2nd, 2009 8 comments

The following matrix shows a matrix of operating systems, database version and certification status. All information is taken from the database documentation and information freely available on the internet (e.g. oracle forums, blogs). The information is structured first into operating systems (Windows, Linux, Other) and further divided into version numbers and architecture (32-bit or 64-bit).

Table annotations

  • n/a: “not supported or certified”; for this there might be several reasons, for instance:
    • operating system too old
    • mixing 32-bit operating system with 64-bit database or vice versa
    • database for this platform not available
  • Projected: will be certified in the future; at this point of time this also counts as “not supported”

Windows

9i R2
32 bit
10g R1
32-bit
10g R2
32-bit
11g R1
32-bit
11g R2
32-bit
9i R2
64-bit
10g R1
64-bit
10g R2
64-bit
11g R1
64-bit
11g R2
64-bit
Windows 2000
32-bit
CertifiedCertifiedCertifiedCertifiedn/an/an/an/an/an/a
Windows 2003
32-bit
CertifiedCertifiedCertifiedCertifiedCertified
(Single Instance only)
n/an/an/an/an/a
Windows 2003 R2
32-bit
CertifiedCertifiedCertifiedCertifiedCertified
(Single Instance only)
n/an/an/an/an/a
Windows 2003
64-bit
n/an/an/an/an/an/an/aCertifiedCertifiedCertified
Windows 2003 (Itanium)
64-bit
n/an/an/an/an/aCerti-
fied
Certi-
fied
Certifiedn/an/a
Windows 2003 R2
64-bit
n/an/an/an/an/an/an/aCertifiedCertifiedCertified
Windows 2003 R2 (Itanium) 64-bitn/an/an/an/an/an/an/aCertifiedn/an/a
Windows 2008
32-bit
n/an/aCerti-
fied
Certi-
fied
Certified
(Single Instance only)
n/an/an/an/an/a
Windows 2008 R2
32-bit
n/an/an/an/aCertified
(Single Instance only)
n/an/an/an/an/a
Windows 2008
64-bit
n/an/an/an/an/an/an/aCertifiedCertifiedCertified
Windows 2008 R2
64-bit
n/an/an/an/an/an/an/an/an/aCertified

Linux

9i R2
32 bit
10g R1
32-bit
10g R2
32-bit
11g R1
32-bit
11g R2
32-bit
9i R2
64-bit
10g R1
64-bit
10g R2
64-bit
11g R1
64-bit
11g R2
64-bit
SLES 8
32-bit
Certi-
fied
Certi-
fied
n/an/an/an/an/an/an/an/a
SLES 9
32-bit
Certi-
fied
Certi-
fied
Certifiedn/an/an/an/an/an/an/a
SLES 10
32-bit
n/an/aCertifiedCertifiedCertifiedn/an/an/an/an/a
SLES 11
32-bit
n/an/aCertifiedCertifiedCertifiedn/an/an/an/an/a
SLES 8
64-bit
n/an/an/an/an/aCerti-
fied
Certi-
fied
n/an/an/a
SLES 9
64-bit
n/an/an/an/an/aCerti-
fied
Certi-
fied
Certifiedn/an/a
SLES 10
64-bit
n/an/an/an/an/an/an/aCertifiedCertifiedCertified
SLES 11
64-bit
n/an/an/an/an/an/an/aCertifiedCertifiedCertified
Red Hat AS/ES 3
32-bit
Certi-
fied
Certi-
fied
Certifiedn/an/an/an/an/an/an/a
Red Hat AS/ES 4
32-bit
Certi-
fied
Certi-
fied
CertifiedCertifiedCertifiedn/an/an/an/an/a
Red Hat AS/ES 5
32-bit
n/an/aCertifiedCertifiedCertifiedn/an/an/an/an/a
Red Hat AS/ES 3
64-bit
n/an/an/an/an/aCerti-
fied
Certi-
fied
Certifiedn/an/a
Red Hat AS/ES 4
64-bit
n/an/an/an/an/aCerti-
fied
Certi-
fied
CertifiedCertifiedCertified
Red Hat AS/ES 5
64-bit
n/an/an/an/an/an/an/aCertifiedCertifiedCertified
Oracle Enterprise Linux 4
32-bit
Certi-
fied
Certi-
fied
CertifiedCertifiedCertifiedn/an/an/an/an/a
Oracle Enterprise Linux 5
32-bit
n/an/aCertifiedCertifiedCertifiedn/an/an/an/an/a
Oracle Enterprise Linux 4
64-bit
n/an/an/an/an/aCerti-
fied
Certi-
fied
CertifiedCertifiedCertified
Oracle Enterprise Linux 5
64-bit
n/an/an/an/an/an/an/aCertifiedCertifiedCertified
Oracle Enterprise Linux 6
64-bit
n/an/an/an/an/an/an/an/an/aCertified (11.2.0.3.0 and later)

Solaris, HP-UX, AIX

Read more…

Categories: Oracle in general Tags:

Using data pump to export and import data using the network mode feature

November 2nd, 2009 2 comments

Data Pump is a great improvement of the old fashioned export and import utility. Data Pump is available since 10g Release 2 and offers some nice new features, for instance a API to be used to start exports and imports from within the database. Beside these features there is one major feature using data pump: SPEED. Data pump is by factors faster that traditional export/import.

A more comprehensive description about data pump can be found here or here. Documentation for version 11g Release 2 is available here.

One of the downsides of data pump – especially for unix dbas – is that data pump in oracle 10g is unable to compress the data (however it does compress metadata but savings are negligible) and is also unable to use pipes (which can be used to compress data if the software does not support this).Starting with 11g Release 1 the ability to compress data was added but required the expensive “Advanced Compression” license.

Another useful new data pump feature is the so called “network mode” which transfers the data to be imported over a database link instead of exporting the data into a file, transferring the file(s) to the destination server and importing the the export file(s).

This article is a short documentation about how to use data pumps network mode feature for importing data to remote (source and destination database are different) or local (source and destination database are the same) database instances. For general information how to use data pump or an introduction refer to the oracle documentation.

Read more…

Categories: Oracle in general Tags: