Oracle has emerged as a major competitor in the enterprise Linux market after a major Linux migration effort in 2004. Offering support contracts for certain Linux distributions in the past year and putting the finishing touches on their own Linux distribution, Oracle Enterprise Linux, Oracle has demonstrated that it is serious about Linux and would like to muscle in on RHEL's market share.
Red Hat is clearly the leader in today's enterprise Linux market and Oracle is clearly the leader in the database market. Put them both together, and you have two very powerful systems that work well together. This article shows how to install and configure Oracle10 in a RHEL5 environment.
We'll be working with RHEL5 x64, server release 5.1 (Tikanga) and Oracle 10gR2 64 bit; on an Intel Xeon HS20 for BladeCenter , Intel(R) Xeon(TM) CPU 3.60GHz environment.
Installing Oracle on RHEL
Let's start out with the basics and make sure that the hosts file has the fully qualified domain name. Oracle likes this.
Before you download Oracle, please confirm the kernel mode:
This command prints the hardware platform and machine name. It also validates that we need to download the 64 bit x86 version, which we can get directly from Oracle. After unzipping it to the box and imploding it with cpio, follow the instructions which are listed in the download section. When the directories are finished imploding, we are ready to move on.
Let's make sure SELinux is disabled:
We can then create our users and groups:
Make sure the following packages are installed prior to the install. Not all of them are required, but Oracle recomm...
To continue reading for free, register below or login
To read more you must become a member of SearchEnterpriseLinux.com
ends you do this prior to installation on RHEL5.
Now we are ready for the installation. If you are not going to do the install from a GUI console, you will need to have X installed on your PC. I've found that one of the better open source (and free) X servers is Cygwin/X. If you choose to install X, you can start it up this way: Start > freeXer> XWin Xserver.
You also need to enable X11 forwarding from your SSH client. I used PuTTY (another free download) for this exercise. To use PuTTY, go to:
SSH > Tunnels, then highlight the box that says enable X11 forwarding. If your display is not set properly, you will never be able to install Oracle, as the character based option disappeared about a decade ago.
Log in as oracle (the installer will not run as root.)
[IMAGE]
At the first screen, you have the option of creating a database or performing an advanced installation. We will chose the default and let Oracle create a database for us. Enter a password (remember it, we'll need it later) and then keep going.
[IMAGE]
As we move forward with the install, we will need to specify an inventory director and the credentials. Doing this automatically sets up subdirectories for each product, which contains inventory information.
[IMAGE]
When this is completed, the installer will verify that the kernel parameters are configured appropriately. In our case, there are several parameters which have not yet been changed, and we are warned of them.
[IMAGE]
Here are the parameters that you need to change:
Just append them to the end of /etc/sysctl and run sysctl –p to make the changes to the /etc/sysctl.conf file available in the active kernel memory.
The install notifies us that the system is lacking in swap space.
[IMAGE]
I tried to add some more. You can partition your disk for adding filesystems by using either fdisk or parted. I prefer parted.
Unfortunately, I did not have any more space in which to add swap. My rule of thumb is to give swap ½ the amount of RAM, that is if you have it to give. I ignored the this warning and moved forward. After your system is running and being utilized, I would monitor the system to determine if you really do need additional swap. This part of the install can take awhile, but the progress tracker is very helpful.
[IMAGE]
After this complete, the install wants you to run several scripts.
[IMAGE]
You must run these scripts as root. The first script is orainstRoot.sh
The second script is root.sh:
That's pretty much it. On the GUI, click next and it will continue until finished.
[IMAGE]
Configuration of Oracle on RHEL
Now, we use the Database Configuration Assistant (DBCA), a graphical user interface that interacts with the Oracle Universal Installer, to configure our Oracle software on RHEL 5.
[IMAGE]
From here, you can create and delete databases, configure your options, manage templates and configure automatic storage management.
[IMAGE]
I chose the configure option, because I wanted to put the database in shared server mode. The default is dedicated server mode, which is better for a DB with a small amount of users.
[IMAGE]
After changing the default, click finish.
[IMAGE]
Another GUI to work with in Oracle is the Oracle Enterprise Manager (OEM). I highly recommend that you get this working in your environment. To set this up properly, follow these steps:
- First login in as the oracle user
Make sure that you set the correct ORACLE_SID reflects the database that you think you're setting it to. If not, then export the correct ORACLE_SID.
- Start up OEM
- Bring up your browser
- Type in the correct url
You must use the url template below; substituting your fully qualified hostname for yourhostname below. If there is a typo, you'll get the infamous "page cannot be displayed" message.
At this point, we're almost in.
[IMAGE]
After logging in as SYS as SYSDBA (I hope you remembered the password that you set up during your install for the database, you'll see this screen:
[IMAGE]
Let's take a quick look at the performance section, which drills down into the Database.
[IMAGE]
If you're more of a DBA than a systems administrator, you'll probably spend more time with sqlplus. To enter that utility, just type in sqlplus as the oracle user.
When installing and configuring Oracle, use the documentation that is readily available to you. The release notes for installations on Linux contain the most pertinent information. I strongly recommend that you read. Please also be certain that you satisfy the prerequistes prior to installation, so that you won't run into issues like I did during the install. Don't forget to start up X if you plan on doing an installation and configuration of Oracle anywhere else but the console. Finally, use the tools that are available to you, such as the Oracle Database Creation Assistant and Oracle Enterprise Manager. Even experienced DBAs use OEM because of the options it makes available. You may also want to look into some open source tools (licensed under the GPL), such as the TOra Toolkit for Oracle.
About the author: Ken Milberg is a systems consultant with two decades of experience working with Unix and Linux systems. He is a SearchEnterpriseLinux.com Ask the Experts advisor and columnist.
