Oracle On Unix Like

The presentation will focus on how Linux penetrated the enterprise OS market and Oracle installations on industry standard servers. This will outline main high availability techniques and tunable system considerations. The presenter will make a comparison between Linux and Unix environment and show why Linux is not yet at the level of the proprietary Unix systems.

Transcript

1. www.cnsys.bg BGOUG Autumn conference 2009 OracleUnix-like Svetoslav Gyurov 1 Svetoslav Gyurov CNSys PLC 13-15 November 2009
2. www.cnsys.bg Comparison HP-UX Commercial UNIX for 25 years Working on PA-RISC / EPIC platforms (HP) A lot of man-hours in design and implementation. 2 Comes with (optional) support contracts. Linux Free as in freedom, not as in free beer Open source GNU's not Unix!
3. www.cnsys.bg How Linux penetrated the market 1998 - Oracle8 released on the Linux platform – first commercial database on Linux 2003 - Oracle10g supports 64-bit Linux (Red Hat 3.0) with IPF (Itanium Processor Family) 2006 - Oracle announces the Unbreakable Linux 3 2006 - Oracle announces the Unbreakable Linux program 2007 - Oracle released Oracle Database 11g for Linux 2009 - Oracle release Oracle Database 11gR2 first for Linux
4. www.cnsys.bg Open Source into the Enterprise Low costs servers and OS High-performance - near the UNIX systems No HW dependant - support of ISS Open source - constantly finding/fixing bugs. 4 Biggest community wins Fast and easy deploy Commercial support Opportunity to reduce IT infrastructure costs
5. www.cnsys.bg Certified Linux for Oracle RHEL (Red Hat Enterprise Linux) SLES (SuSE Linux Enterprise) 5 OEL (Oracle Enterprise/Unbreakable linux)
6. www.cnsys.bg Memory For 32-bit: Use VLM, PAE For 64-bit: Use Huge pages Not swappable Decreased page table overhead 6 Eliminated page table lookup overhead Faster overall memory performance For 11g use AMM - /dev/shm
7. www.cnsys.bg Network Bonding mii-tool – obsolete Use LACP (if possible) Jumbo frames 7 50% reduction in CPU overhead 75% reduction in Global cache buffer waits IP Reassemblies dropped by 10x Use it only for RAC private interconnects Not an IEEE standard
8. www.cnsys.bg Storage options Cluster File system – OCFS2, Veritas CFS Almost ZFS - Btrfs – B-Tree or “butter” FS ADVM and ACFS – certified for OEL 5 / Red Hat 5 NFS, Direct NFS 8 LVM (no) RAW
9. www.cnsys.bg Multipath Linux Connectivity: FC HBA driver Auto compilation Load balancing: 9 Multipath driver and tools Device Mapper Multipath Enablement Kit
10. www.cnsys.bg Multipath Linux again Ignore /dev/sd*, use /dev/mapper Partition the disks: Use parted, not fdisk Use kpartx 10 EMC Powerpath - /dev/emcpowerxx IBM SDD - /dev/vpath HP SecurePath
11. www.cnsys.bg Multipath Linux 11
12. www.cnsys.bg Multipath HP-UX FC drivers included HP-UX 11iv2 – additional software (license) HP-UX 11iv3 – native (active/active) Multipath is transparent 12 EMC Powerpath driver
13. www.cnsys.bg 13
14. www.cnsys.bg ASMLib (for Linux) Alternative interface for ASM to identify and access block devices Kernel driver Library and tools 14 Multipath disks - /dev/dm; /dev/mapper Disk scan order – FSFU (first scanned, first used) Do not delete /opt/oracle/extapi
15. www.cnsys.bg CRS11g / ASM 11g installation Oracle 11.1 - vote and ocr disks can be block devices and not raw Oracle 11.2 – Desupport of block and raw devices Oracle Clusterware - ASM - Database Version Compatibility Doc ID: 337737.1 15 Compatibility Doc ID: 337737.1
16. www.cnsys.bg Patches and updates up2date Public yum server: http://public-yum.oracle.com/ swinstall / update-ux Standard patch bundles 16
17. www.cnsys.bg System backup and recovery Linux Clonezilla, Acronis – offline MondoRescue - online HP-UX 17 Ignite-UX – deploy, create, recover make_tape_recovery make_media_install
18. www.cnsys.bg Administration & Support Persistent device naming Flex10 udev Monitoring 18 OnlineDiag, PSP MP, iLO Openview, Nagios OSWatcher, OSWg – Doc ID 301137.1
19. www.cnsys.bg Q&A Thank you! 19 Thank you! s.gyurov@cnsys.bg