VISC3 – oracle: sudo -u root -s -H
[sudo] password for oracle:
– root: /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets (‘’). Hitting <ENTER> without typing an
answer will keep that current value. Ctrl-C will abort.
Default user to own the driver interface : oracle
Default group to own the driver interface : dba
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]:
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver: [ OK ]
Scanning the system for Oracle ASMLib disks: [ OK ]
Disable NUMA in /etc/grub.conf
If you notice in Oracle Linux 5.6, Oracle starts to disable NUMA at boot time as shown in the following grub.conf file:
[root@rac561 ~]# cat /etc/grub.conf # grub.conf generated by anaconda # # Note that you do not have to rerun grub after making changes to this file # NOTICE: You do not have a /boot partition. This means that # all kernel and initrd paths are relative to /, eg. # root (hd0,0) # kernel /boot/vmlinuz-version ro root=/dev/sda1 # initrd /boot/initrd-version.img #boot=/dev/sda default=0 timeout=5 splashimage=(hd0,0)/boot/grub/splash.xpm.gz hiddenmenu title Oracle Linux Server (2.6.32-100.26.2.el5uek) root (hd0,0) kernel /boot/vmlinuz-2.6.32-100.26.2.el5 ro root=/dev/sda1 rhgb quiet numa=off initrd /boot/initrd-2.6.32-100.26.2.el5.img
Looking at /proc/cmdline, you will notice that the numa=off argument was passed at boot:
</p> <p>[root@rac561 ~]# cat /proc/cmdline ro root=/dev/sda1 rhgb quiet numa=off</p> <p>
Posted by Charles Kim, Oracle ACE Director
Screen Cheat Sheet
screen Cheat Sheet launch screen with your individual unix id: $ screen
Detach from Screen:
control+d, release, then type d
Find the list of screen sessions:
screen -ls There is a screen on: 21586.pts-3.rac02 (Detached) 1 Socket in /var/run/screen/S-ckim
If you are already attached then your screen “-ls” will show as (Attached); however, it you are already sudo’d to oracle, you will not seen a valid result set because oracle did not start the screen session.
> screen -ls There is a screen on: 21586.pts-3.rac02 (Attached) 1 Socket in /var/run/screen/S-ckim.
Re-attach to previous screen session
rac02:/home/ckim > screen -r 21586.pts-3.rac02
If you running putty, your putty terminal title will change.
Tip: Do not exit your screen session, always detach from it !!
Rename your screen session:
Control+a (lower a) followed by Shift+A (capital A)
Then rename “bash” to whatever you want Again your putty terminal title will change
There is no need to start multiple sessions of screen. Within screen, you can create sub-screen sessions:
control-a followed by c (for create)
The trick is to put a Title for each screen session:
control-a followed by Capital A
To toggle between each screen session:
control-a n --> next screen control-a p --> previous screen
The title of your screen and window will change
List all your windows: control-a ”
How do you scrollback on the screen to see past output First, create a file called .screenrc in your $HOME directory: Add the line below to set buffer to 32000 lines:
To view previous buffer, go into Copy Mode
Next: Control-a [ Control-u - Scrolls a half page up. Control-d - Scrolls a half page down Control-b - Scrolls a full page up. Control-f - Scrolls the full page down.
Posted by Charles Kim, Oracle ACE Director
Setting up Hugepages
Setting up HugePages requires one kernel parameter change and modifications to two entries to the /etc/securities/limits.conf file. The kernel parameter that needs to be modified is vm.nr_hugepages. The default hugepage size is 2M. The kernel parameters needs to be set in granules of 2M. For example, if we are allocating 48GB as our hugepage size, we will need to set our kernel parameter to 24576 (48*1024/2) in the /etc/sysctl.conf file.
Respectively, the /etc/security/limits.conf file needs to be adjusted to set soft and hard limits for oracle:
oracle soft memlock 50331648 oracle hard memlock 50331648
After the kernel parameters are set, it is highly recommended that you reboot the server.
Created by Charles Kim, Oracle ACE Director
Oracle ASM Book
Charles Kim is also the technical editor for the Automated Storage Management book by Nitin Vengurlekar, Rich Long, and Murali Vallath. This comprehensive resource provides full details on Oracle Automatic Storage Management (ASM), Oracle’s integrated file and volume management interface. You will get full details on general operations, administration, best practices, and expert techniques. Oracle DBAs will be able to implement robust storage solutions with help from this useful guide.
In the next release, Charles will be the contributing author for this book.
Learn Key Skills, Insights and Strategies around Oracle in Virtual Data Centers
Please join us to learn why the virtualization of Oracle is accelerating. Learn strategies, tips and skills from the subject matter experts and understand why knowledge experts in Oracle virtual data centers are becoming the most sought after specialists in the IT industry. The virtualization of Oracle on VMware is one of the fastest growing segments in the IT industry. The demand for Oracle virtualization experts on VMware is greatly exceeding the supply.
This workshop is being presented by three industry recognized Oracle experts and Oracle Ace’s Michael Corey, Charles Kim and George Trujillo.
08:30 a.m. Welcome, Registration & Breakfast
09:00 a.m. Virtualization Architecture and Fundamentals
09:30 a.m. Understanding the Rapid Acceleration of Oracle Virtualization
09:45 a.m. Key Strategies for Migrating to Virtual Servers
10:45 a.m. Break
11:00 a.m. What DBAs need to Know about Virtual Infrastructure and Management
12:00 p.m. Key Tuning and Monitoring Metrics DBAs Need to Know
12:30 p.m. Lunch & Networking
Breakfast and Lunch will be provided
REGISTER TODAY. Seating is limited for this program and will be available on a first come, first served basis.
Virtualization Best Practices
Below is a link to a number of VMware best practices around Virtualizing Oracle, Exchange, SQL Server, SAP and Enterprise Java. Virtual infrastructures like anything else needs to be properly designed and configured for the workloads that need to be supported.
It is very important that VMware best practices are followed. As a Tier One Specialist at VMware, I see three areas where best practices need to be followed:
- VMware best practices: Oracle, SAP, Peoplesoft, Exchange, Oracle Fusion Applications, etc. do not understand they are in a VM. The tuning and configuration has to be on the hosts and clusters supporting the VMs.
- Storage venders best practices for virtualization: 80% of the issues around virtual infrastructures are due to the design, configuration and implementation of storage. Get your storage right.
- Virtual infrastructure team best practices: Properly design and set up tiering, processes, provisioning, monitoring, etc.
From a virtualizing Oracle on VMware perspective there are four key documents you need to know inside and out:
- Best Practices Guide
- RAC Deployment Guide
- Workload Characterization Study
- High Availability Guide
This link will take you to each of the best practice sections:
Public Yum Server
Configure your server for Yum (Yellowdog Updater Modified):
There’s no more need to look for CDs from your pile of CDs or from the clutter of your desk. Earlier in 2009, Oracle launched their public yum server which offers a free and convenient way to install packages from the Enterprise Linux and Oracle VM. Obviously, the Yum server if offered without support.
We will show you how to setup your Red Hat or Oracle Enterprise Linux to use Oracle’s public Yum repository. In this example, we only focus on 64-bit Red Hat 5 Update 3.
[root@rac01 ~]# cd /etc/yum.repos.d/ [root@rac01 yum.repos.d]# ls -ltr total 0 [root@rac01 yum.repos.d]# wget http://public-yum.oracle.com/public-yum-el5.repo --11:27:04-- http://public-yum.oracle.com/public-yum-el5.repo Resolving public-yum.oracle.com... 18.104.22.168 Connecting to public-yum.oracle.com|22.214.171.124|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 1402 (1.4K) [text/plain] Saving to: `public-yum-el5.repo'</p> <p>100%[=========================================================>] 1,402 --.-K/s in 0s</p> <p>11:27:04 (83.6 MB/s) - `public-yum-el5.repo' saved [1402/1402]
Edit the file public-yum-el5.repo with your choice of editor such as vi. Change enabled=0 to enabled=1 for the following sections since we are on RH5 U3
Portions of your yum.repos.d file should look something like this:
[el5_u3_base] name=Enterprise Linux $releasever U3 - $basearch - base baseurl=http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/3/base/$basearch/ gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5 gpgcheck=1 enabled=1</p> <p>[el5_addons] name=Enterprise Linux $releasever - $basearch - addons baseurl=http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/addons/$basearch/ gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5 gpgcheck=1 enabled=1</p> <p>[el5_oracle_addons] name=Enterprise Linux $releasever - $basearch - oracle_addons baseurl=http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/oracle_addons/$basearch/ gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5 gpgcheck=1 enabled=1
Install missing RPM needed to install Oracle
Here’s an example of downloading the compat-db RPM and installing the package
[root@rac01 yum.repos.d]# yum install compat-db Loaded plugins: security Setting up Install Process Parsing package install arguments Package compat-db-4.2.52-5.1.x86_64 already installed and latest version Resolving Dependencies --> Running transaction check ---> Package compat-db.i386 0:4.2.52-5.1 set to be updated --> Finished Dependency Resolution</p> <p>Dependencies Resolved</p> <p>================================================================================================== Package Arch Version Repository Size ================================================================================================== Installing: compat-db i386 4.2.52-5.1 el5_u3_base 1.7 M</p> <p>Transaction Summary ================================================================================================== Install 1 Package(s) Update 0 Package(s) Remove 0 Package(s)</p> <p>Total download size: 1.7 M Is this ok [y/N]: y Downloading Packages: compat-db-4.2.52-5.1.i386.rpm | 1.7 MB 00:01 Running rpm_check_debug Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Installing : compat-db [1/1]</p> <p>Installed: compat-db.i386 0:4.2.52-5.1 Complete!
Posted by Charles Kim, Oracle ACE Director
Viscosity Technology Tags: Viscosity Technology Exadata and Virtualization Experts
Charles Kim @ OOW 2012
Come see Charles Kim @ Oracle OpenWorld 2012