All Things Oracle

Installing Oracle 11g Release 2 on OEL 5.3

Finally I downloaded Oracle 11g Release 2 from OTN, so I could start the installation and subsequent creation of a database. In this post I will show you what I found in the part corresponding to the installation of the software, note that I do not intend to replace the installation guide, whose reading is mandatory.

Step by step installation

This installation was done on OEL 5.3, although the usual is to configure it in such a way that it strictly complies with the prerequisites, in order to test the effectiveness of the installation fixup scripts and although I installed the required RPMs, I deliberately left out the kernel parameters.

1. After invoking Oracle Universal Installer, we are offered to register our My Oracle Support email and password in order to receive eventual notifications, but fortunately it is not a mandatory to complete this data.

Oracle 11.2 Installation - Step 1

2. By default we are suggested to install the software and create the database, but in this part I am exclusively interested in the first one.

3. Time to decide whether or not we want to use Real Application Clusters; to avoid complicating things we better start with a configuration that does not use it.

4. What language to use? The truth is that I prefer to use English for all the software I use, this goes from Windows, Office, and of course I extend it to Oracle Linux and Oracle Database Server.

5. To evaluate the full power of Oracle Database Server, the best way is to install Enterprise Edition, without any doubt.

6. The location of the software does not require much reasoning, the default values are the correct ones for this test.

7. Idem for the Inventory Directory.

8. The groups assigned to OSDBA and OSOPER are the expected.

9. Here begins the novelty: OUI checks the prerequisites, and as I did not configure the kernel parameters, I receive the alert that it is necessary to solve it before continuing.

The interesting thing is that OUI is able to provide me with a script that allows me to solve all those errors that appear as fixable, it’s a matter of pressing the button [Fix & Check Again].

Following the instructions I proceed to execute from a session in which I am logged in as root.

[root@talia ~]# /tmp/CVU_11.
Response file being used is :/tmp/CVU_11.
Enable file being used is :/tmp/CVU_11.
Log file location: /tmp/CVU_11.
Setting Kernel Parameters...
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
uid=502(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),506(asmdba)

Back to OUI, the check is repeated and the kernel configuration problems are gone! There are still the warnings about available memory and swap space allocation, but it is not really a problem for this test so I choose to ignore them and continue with the installation, of course you should not do that with a real installation.

10. We arrive at the installation summary screen.

11. And the action begins!

On this computer I have installed Oracle 9.2, 10.2 and 11.1 before, but this time I felt it took longer than those times.

12. The final step is to run some scripts, being careful to do it with the root user.

[root@talia ~]# /u01/app/oraInventory/
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.

[root@talia ~]# /u01/app/oracle/product/11.2.0/dbhome_1/
Running Oracle 11g script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/11.2.0/dbhome_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of script.
Now product-specific root actions will be performed.
Finished product-specific root actions.

13. After executing the scripts, the installation is finished.

As you may have noticed, the installation of the software is quite similar to what we have seen in previous versions, what is special and welcome, is the possibility of letting OUI help us to correct our errors or omissions when configuring the kernel, actually the list of things it can correct goes a little further, as you can check in the documentation.

In a next post I will show you how to create a database with DBCA, which also has some new features, stay tuned!

Did you find this article interesting, did you have any doubts, do you want to suggest a topic to cover, leave me your comments or contact me me right now!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Posts

First post of a series dedicated to the art of Oracle patching. We start with in-place patching, the most common and also the most dangerous way.
Learn how to download Oracle patches, both manually and automated, using the getMOSPatch utility.
Link to article published in Toad World, on how to apply an out-of-place patch to Grid Infrastructure, using a Golden Image.

Need Help?

Fill in these details and I will be in touch as soon as possible.