Wednesday, July 24, 2013

Oracle Database Preinstallation – Part 3

Dear Readers,

My name is Franz Devantier, creator of this blog.  I am an Oracle Certified Professional (OCP DBA 11g) Security DBA.  I will be sharing with you the basic duties of an Oracle DBA, and also some of the undocumented, and not so well known tasks. 


I will make a deal with you:  If you refer me to a company that needs database support, from a few hours per week to full time, and I am able to sign a contract with them.
Then I will give you 10% of the monthly contract or deal price every month.  When the contract ends, and we re-sign the contract, I will again give you 10% of the monthly contract price.  This will go on until the company no longer employs or contracts me or my agents to look after their databases.
I can do this, because that 10% is my marketing budget.  When we re-sign the contract, in the future, it may depend on you giving the thumbs up again, and that is worth 10% of the monthly contract price, to be given to you as commission.

Oracle Database Preinstallation – Part 3
Checking the Software Requirements
Depending on whether you are going to install, enterprise or standard edition, but really the other things that go with them.  Are you going to install grid control, ASM etc.  What add-ins are you going to install.  So this task is highly dependent on exactly what you will install, but the basic concepts are fairly generic as well.  We will need to look at the Operating system requirements, Kernel requirements, Package requirements, Compiler requirements, and additional Software requirements.

Oracle Universal Installer(OUI) will also perform a series of checks to make sure that you meet the minimal requirements.  It is better practice to first verify that your configuration has all the needed requirements, rather than allowing OUI to abend when it tries to install the Oracle software.

Operating System Requirements
We are installing the Oracle Linux OS by default, to run on x86-64.  This means that we can choose from Oracle Linux 4,5 or 6.  If your specific version of Linux is not on the list, then you will probably have great difficulty installing Oracle on the box, if you get it right at all.  You need to make sure that you have the correct update, and in addition you need to match your OS to your hardware.  Sometimes the issue may be because the specific version of Linux is not compatible on a specific hard platform.  Of course Linux versions like Ubuntu are unsupported at this point in time.  Although it may be possible with quite a bit of effort and research to get the Oracle database server to work on an unsupported version of Linux, it is strongly discouraged, especially in a production environment.

For Oracle database server 11.2 the following minimal operating systems are compatible.  Note that sometimes a more advanced Operating system is also not compatible.  This exercise where you verify or select you Operating System, is very important, if you want a successful Oracle database installation.

On Linux x86
Asianux Server 3 SP2
Oracle Linux 4 Update 7
Oracle Linux 5 Update 2
Red Hat Enterprise Linux 4 Update 7
Red Hat Enterprise Linux 5 Update 2
SUSE Linux Enterprise Server 10 SP2
SUSE Linux Enterprise Server 11
On Linux x86-64
Asianux Server 3 SP2
Oracle Linux 4 Update 7
Oracle Linux 5 Update 2 (with Red Hat Compatible Kernel)
Oracle Linux 5 Update 5
Oracle Linux 6
Oracle Linux 6 (with Red Hat Compatible Kernel)
Red Hat Enterprise Linux 4 Update 7
Red Hat Enterprise Linux 5 Update 2
Red Hat Enterprise Linux 5 Update 5 (with the Oracle Unbreakable Enterprise Kernel for Linux)
Red Hat Enterprise Linux 6
Red Hat Enterprise Linux 6 (with the Oracle Unbreakable Enterprise Kernel for Linux)
SUSE Linux Enterprise Server 10 SP2
SUSE Linux Enterprise Server 11
On IBM: Linux on System z
Red Hat Enterprise Linux 4 Update 8
Red Hat Enterprise Linux 5 Update 4
SUSE Linux Enterprise Server 10 SP3
SUSE Linux Enterprise Server 11 SP1






From Oracle database Server 11.2 onwards, the Security Enhanced Linux feature (SELinux), is supported for Oracle Linux 4, Oracle Linux 5, Oracle Linux 6, Red Hat Enterprise Linux 4, red Hat Enterprise Linux 5, red Hat Enterprise Linux 6

When you are looking at the system requirements, by Kernel version, then the following notes will prove useful.
Oracle Linux 4 and red Hat Enterprise Linux 4, have the same requirements with regards to the kernel version.

Asianux Server 3, Oracle Linux 5, and Red Hat Enterprise Linux 5.  They all have the same Update 2 requirements.

Oracle Unbreakable Enterprise Kernel for x86-64 systems, for Linux 5 Update 5 (2.6.32) and above, contain several additional features and performance enhancements.  These features are not available with Oracle Linux or with other supported Linux distributions.  You can install this Oracle Unbreakable Enterprise kernel in certain situations.  Firstly you must be running on a x86-64 server.  Then it can be installed on the following Operating Systems: Oracle Linux 5 update 5, Oracle Linux 6, Red Hat Enterprise Linux 5 Update 5, or Red Hat Enterprise Linux 6.

If you are using Oracle Linux 6, then the Oracle Unbreakable Enterprise Kernel for Linux is installed by default.

You will need to determine the exact distribution and version of installed Linux, to make sure that you have a compatible operating system for the Oracle installation.
$ cat /proc/version

You may also be able to execute:
$ lsb_release -id

If your version of Linux is not listed in the above list, then you don’t have a certified version of Linux installed.  You will have to get a certified version installed on the server, before you install the Oracle database server.  Please don’t try to install on uncertified Linux versions, because it may or may not install, but you are likely to sit with problems, that you may not be able to resolve.  One of the first questions that Oracle support will ask you, when you develop serious problems is; what version of Linux you are running the Oracle software on.  To have to change your version of Linux down the line, will be quite an exercise, as compared to doing it before you install the Oracle database.  Don’t be fooled by articles that you will find on Google with claims that they have installed Oracle on Ubuntu etc, and are running production systems with no side effects.  Be very careful of these scenarios, because potentially the only remedy may be a rebuild.

Franz Devantier,
Need a database health check?

Classifieds


No comments:

Post a Comment