Running Oracle on RHEL 5
 

Hi all.


We're probably going to migrate some Oracle servers from HP-UX to RHEL 5. I'm a linux sysadmin, but have never had Oracle running on our Linux boxes before. Therefore I could really use some advice on what to do and what not to do. I'm sure the Oracle admins will be resonsible for tuning the application, but if there are any linux-specific things such as partitioning or whatever I need to know about please let me know.

Regards,
kenneho

It will run fine on a simple partitioning scheme. You may want to part off /var/log and a few others, but more for to avoid any denial of service than anything else.

Lots of memory and a 64bit OS would be my first recommendation.

yes its a very good idea. I have similar setup too i have oracle in linux boxes.
Its working very good. Linux and oracle are the best combination now a days.

So my advice is go for it.

vap16oct1984,

I wonder if you might be trying to click the 'Quote' button in your replies, but by mistake are clicking the 'Report' button? You have 'reported' this thread and another thread several times, but there doesn't appear to be anything wrong with the content.

The Report button is for reporting a post in the case that you feel it is unsuitable or offensive. Please verify that you click the 'Quote' button, farthest to the right at the bottom of the post, if you wish to quote another poster.

If I have misinterpreted what is happening here, please feel free to contact me via email or PM and explain the situation.

Thanks :)

Sasha

You should go to Meta-link the Oracle knowledgebase and download the kernel params that need to be set for your version of Oracle and Linux (RHEL5) there are several. I would recommend using LVM2 which is default on RHEL5 and setting up an Static Oracle UID across all your boxes, this will prevent issues if you move to Oracle RAC later. Find out if you are going to use OCFS and/or ASM from your DBAs. If yes, then read up on how to set it up correctly. ASM isn't hard to setup, but, I use block devices and not raw (much easier and they work fine!!!).

OCFS is a b#$%h to setup and the combo of the two together ....well get ready for long nights. I have a doc if you need it.

Using LVM I would create the following partitions:

Keep /boot outside of the LVM config. then create another partition and make it the entire local drive, then slice it up into Logical Partitions
You should use RAID 10 at a bare minimum. The were Raid 10 on a dell 2950 or R900 with 146GB drives mirrored

The /usr/openv was for netbackup, ignore if your not using it.
swapping @ a rate of 1.5 times your physical memory is OLD world thinking. I will hear many arguments for and against. I would be happy with 4gb, but Oracle insist on 1.5X's I think they use it for something besides paging/swapping. Poor coding if you ask me. But these machines used 36GB of mem I don't think using half the disk for swap is a good idea anywhere. You decide. I used 16gb and things worked fine.

* LVM Partition Layout (Starting 7-28-2008):
====================================

Oracle 9i (Non-ASM)

/boot = 100mb
swap = 16gb
/ = 10gb
/tmp = 5gb
/home = 5gb
/var = 5gb
/opt = 5gb
/usr = 10gb
/oracle = 20gb
/usr/openv = 5gb

#######################################

Oracle 10g (Non-RAC)

/boot = 100mb
swap = 16gb
/ = 10gb
/tmp = 5gb
/home = 5gb
/var = 5gb
/opt = 3gb
/usr = 10gb
/oracle = 20gb
/usr/openv = 5gb
/asm = 5gb

########################################

Oracle 10g (RAC)

/boot = 100mb
swap = 16gb
/ = 10gb
/tmp = 5gb
/home = 5gb
/var = 5gb
/opt = 3gb
/usr = 10gb
/oracle = 20gb
/usr/openv = 5gb
/asm = 5gb
/crs = 5gb

Grapefurit,

well thanks for ur advice. I would really appreciate you if u looking for solutions.
And i always available on emil,messengers, every where with is same unique id vap16oct1984

and i love to give solutions and help any linux related issue.

Once again thanks a lot.

Thanks for the detailed outline. As I'm not yet very into Oracle, I'll have to read up on what OCFS, ASM and stuff is and how things will be set up here at work. When I get to it I'll report back here on how it goes.