Installing, Tuning, And Deploying Oracle Database On SUSE .

Installing, Tuning, andDeploying Oracle Database onSUSE Linux Enterprise Server 12 Technical IntroductionArun SinghSr. Technical ManagerArun.Singh@suse.com

Agenda2 Introduction SUSE Components Oracle Components Installation‒Grid Infrastructure‒Database Tuning Q&A

SUSE & OracleTechnology Partner Strong Partnership‒800 certified Oracle Apps in SUSE ISV Catalog‒Relationship since first Oracle version 8.0.5 on SUSE 6.0‒Testing, supporting partners/customers on technical issues‒Bugs, customer problem escalation, future features, etc.‒Combined testing efforts - service packs and Oracle patchesOracle products are certified to run on SUSE LinuxEnterprise Server ‒3 Supported platforms : Linux x86-64 and IBM System z

SUSE Components

SoftwareSelect Oracle Server Base (orarun)5

Oracle Server Base (orarun)What it provides?Helps to meet Oracle Database Installationprerequisites:‒Creates user‒‒Creates groups‒6oracledba, oinstall‒Install required packages‒Sets required SUSE Linux Enterprise kernel parameters‒Sets Oracle environment variables‒ORACLE SID‒ORACLE BASE‒ORACLE HOME

Oracle Server Base (orarun)Adopting new directory locationSteps to change default /opt/oracle to /home/oracle:‒Creates new directory : mkdir /home/oracle‒Set proper owner & groups‒ chown oracle /home/oracle‒ chgrp oinstall /home/oracle‒Set ORACLE BASE /home/oracle in /etc/sysconfig/oracle‒Change ORACLE BASE in /etc/profile.d/oracle.s[sh]‒7ORACLE BASE /home/oracle

Oracle Database StorageFile SystemStorage/File System‒XFS‒Oracle ASM‒ASMLib‒ASM Cluster File System‒NFS/NAS‒OCFS2‒Part of SLE12 HAENote: “raw” storage in not supported8

SUSE Linux InstallFile System Selection9

Oracle Components

Oracle DatabaseSupport/Certification MatrixName (Version)SLES10 (SP4)SLES11 (SP3)SLES1210gR2 (10.2.0.5)1111gR2 (11.2.0.4)Validated12cR1 (12.1.0.2)Validated

Oracle Database SoftwareDownload & Unzip Locally Oracle Database 11gR2‒p13390677 112040 Linux-x86-64 1of7.zip‒p13390677 112040 Linux-x86-64 2of7.zipOracle Database 12cR1‒linuxamd64 12102 database 1of2.zip‒linuxamd64 12102 database 2of2.zipChange “CV ASUME DISTID SUSE11” in database/stage/cvu/cv/admin/cvu config12

Oracle Grid Infrastructure SoftwareDownload & Unzip LocallyIncludes Oracle Clusterware & Oracle ASM Oracle Grid Infrastructure 11gR2‒ p13390677 112040 Linux-x86-64 3of7.zipOracle Grid Infrastructure 12cR1‒linuxamd64 12102 grid 1of2.zip‒linuxamd64 12102 grid 2of2.zipChange “CV ASUME DISTID SUSE11” in grid/stage/cvu/cv/admin/cvu config13

InstallationOracle Grid Infrastructure

Oracle Grid InfrastructurePrepare Oracle recommends creating separate user/groups forGrid Infrastructure & Database‒Create user grid‒Create asmdba, asmadmin groups Create raw disk partitions to be used by Oracle ASM Set owner/group of ASM disks‒ Check & Install libcap1 packages‒15Use udev rules for boot persistenceTo avoid clscfg.bin error at install time

InstallationOracle Grid Infrastructure16

InstallationOracle Grid InfrastructureStart Installation: grid/runInstaller17

InstallationOracle Grid Infrastructure18

InstallationOracle Grid Infrastructure19

InstallationOracle Grid Infrastructure20

InstallationOracle Grid Infrastructure21

InstallationOracle Grid Infrastructure22

InstallationOracle Grid Infrastructure23

InstallationOracle Grid Infrastructure24

InstallationOracle Grid Infrastructure25

InstallationOracle Grid InfrastructureNote: Verify these warnings manually & then select “Ignore”26

InstallationOracle Grid InfrastructureNote: Save response file to use later for unattended install.27

InstallationOracle Grid Infrastructure28

InstallationOracle Grid Infrastructure29

InstallationOracle Grid Infrastructure30

InstallationOracle Grid Infrastructure31

InstallationOracle Grid Infrastructure32

InstallationOracle Grid Infrastructure33

InstallationOracle Database

InstallationSUSE Linux Enterprise Server 12Note: Static IP Address35

InstallationOracle Database 12cStart Installation: database/runInstaller36

InstallationOracle Database 12c37

InstallationOracle Database 12c38

InstallationOracle Database 12c39

InstallationOracle Database 12c40

InstallationOracle Database 12c41

InstallationOracle Database 12c42

InstallationOracle Database 12cNote: Verify these warnings manually & then select “Ignore”43

InstallationOracle Database 12cNote: Save response file to use later for unattended install.44

InstallationOracle Database 12c45

InstallationOracle Database 12c46

InstallationOracle Database 12c47

InstallationOracle Database 12c48

InstallationOracle Database 12cNote: Change Oracle Database start settings in /etc/oratab &/etc/sysconfig/oracle, so that database starts after server reboot.49

InstallationOracle Database 11gR2Note: Fix above error & select “Retry”50

InstallationOracle Database 11gR2Note: Ignore this error as libaio1 is new name for libaio51

Tuning

TuningOptimize Storage/File System SUSE Linux Enterprise Server OS 53‒iostat/vmstat/top‒I/O scheduler‒elevator cfq/noop/deadline‒echo cfq/noop/deadline /sys/block/DEVICE/queue/schedulerOracle Database‒Configure & use “hugepages”‒Distribute “redo log” files

TuningServer Report Oracle Enterprise Manager‒Configure Parameters‒Analyze PerformanceAWR (Automatic Workload Repository)‒Create Snapshot:SQL EXEC DBMS WORKLOAD REPOSITORY.create snapshot;- run workload/testSQL EXEC DBMS WORKLOAD REPOSITORY.create snapshot;‒Generate html report (in current working directory):‒54SQL @ ORACLE HOME/rdbms/admin/awrrpt.sql

TuningOracle Enterprise Manager55

TuningAWR Snapshot56

TuningAWR Demo Report57

Installation & TuningHelpful Documents Oracle Database Installation (11gR2/12cR1)‒ SUSE Linux Enterprise System Analysis & Tuning‒ book sle tuning/book sle tuning.pdfOracle Database Performance /docs/OracleDB on A/E49058-05.pdf

SUSE Linux – Misc.Oracle Software and Support SUSE tp://www.suse.com/oracleOracle elivery.oracle.com/Oracle Support‒59http://support.oracle.com (Metalink)

Questions & AnswersThank you.60

61Corporate Headquarters 49 911 740 53 0 (Worldwide)Join us on:Maxfeldstrasse 590409 NurembergGermanywww.suse.comwww.opensuse.org

Unpublished Work of SUSE LLC. All Rights Reserved.This work is an unpublished work and contains confidential, proprietary and trade secret information of SUSE LLC.Access to this work is restricted to SUSE employees who have a need to know to perform tasks within the scope oftheir assignments. No part of this work may be practiced, performed, copied, distributed, revised, modified, translated,abridged, condensed, expanded, collected, or adapted without the prior written consent of SUSE.Any use or exploitation of this work without authorization could subject the perpetrator to criminal and civil liability.General DisclaimerThis document is not to be construed as a promise by any participating company to develop, deliver, or market aproduct. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in makingpurchasing decisions. SUSE makes no representations or warranties with respect to the contents of this document,and specifically disclaims any express or implied warranties of merchantability or fitness for any particular purpose. Thedevelopment, release, and timing of features or functionality described for SUSE products remains at the solediscretion of SUSE. Further, SUSE reserves the right to revise this document and to make changes to its content, atany time, without obligation to notify any person or entity of such revisions or changes. All SUSE marks referenced inthis presentation are trademarks or registered trademarks of Novell, Inc. in the United States and other countries. Allthird-party trademarks are the property of their respective owners.

3 SUSE & Oracle Technology Partner Strong Partnership ‒800 certified Oracle Apps in SUSE ISV Catalog ‒Relationship since first Oracle version 8.0.5 on SUSE 6.0 ‒Testing, supporting partners/customers on technical issues ‒Bugs, customer problem escalation, future features, etc. ‒Combined testing efforts - service packs and Oracle patches Oracle products are certified to run .