Setup udev rules with Red Hat 5/6 on VMware
May 16, 2013 Leave a Comment
[root@rhel59dra ~]# /sbin/scsi_id -g -u -s /block/sdc
Note:
[root@rhel59dra ~]# ls -l /dev/ASM*
Oracle ACE Director: Charles Kim
May 16, 2013 Leave a Comment
[root@rhel59dra ~]# /sbin/scsi_id -g -u -s /block/sdc
[root@rhel59dra ~]# ls -l /dev/ASM*
May 10, 2013 Leave a Comment
Here’s a simple stored procedure that I’ve been using for about a decade. From the application or from database triggers, if I want to record anything to the alert log, I can simply invoke this stored procedure and write error messages to the alert log.
Most of the DBAs have implemented alert log scanners and will send alert notifications if new ORA- error messages pop up in the alert log file.
create or replace procedure edba_write_alert
( p_message varchar2,p_oranum NUMBER default 20001)isbegindbms_system.ksdddt;dbms_system.ksdwrt(2, ‘ORA-’||to_char(p_oranum)||’: ‘||p_message);end;/grant execute on edba_write_alert to public;
April 26, 2013 Leave a Comment
Mount the CD/DVD: mount /dev/cdrom /mnt/cdrom
Then trick the baseurl directives to point to the file instead of Oracle’s public yum server in the /etc/yum.repos.d/public-yum-ol6.repo/public-yum-el5.repo or /etc/yum.repos.d/public-yum-ol6.repo file:
[root@ovmanager media]# mount /dev/cdrom /mnt
mount: block device /dev/sr0 is write-protected, mounting read-only[oracle@ovmanager yum.repos.d]$ pwd/etc/yum.repos.d[oracle@ovmanager yum.repos.d]$ vi public-yum-el5.repo
[ol5_u8_base]
name=Oracle Linux $releasever Update 8 installation media copy ($basearch)#baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL5/8/base/$basearch/baseurl=file:///mnt/OL5.8/Server/gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5gpgcheck=0enabled=1
Now you are ready to install packages from your local yum repository
By Charles Kim, Oracle ACE Director
April 26, 2013 Leave a Comment
April 15, 2013 Leave a Comment
cat dg_tar.ksh
tar cpfX – dg.exclude dgmenu > dg.tar
$ cat dg.exclude
dgmenu/old
dgmenu/conf
dgmenu/log
afiedt.buf
*.old
*.bkup
Notes:
1. dgmenu is the directory that we are creating a tar-ball for
February 10, 2013 Leave a Comment
We will post the 10th session shortly …
|
Session # |
Title |
Room Assignment and Time |
|
604 |
Rolling your own Database Operations Center (DOC) using Oracle Technology you already own |
Mile High Ballroom 2A => Mon, Apr 08, 2013 (09:45 AM – 10:45 AM) |
|
344 |
Performance Tuning your DB Cloud in OEM 12c Cloud Control – 360 Degrees |
Mile High Ballroom 4A => Mon, Apr 08, 2013 (09:45 AM – 10:45 AM) |
|
614 |
Automate Data Guard Best Practices |
Mile High Ballroom 2B => Mon, Apr 08, 2013 (05:00 PM – 06:00 PM) |
|
|
|
|
|
477 |
Why Every Database Needs to be Virtualized |
Mile High Ballroom 4A => Tue, Apr 09, 2013 (12:00 PM – 12:30 PM) |
|
343 |
Oracle VM, OEM 12c and Cloud Computing: Panel of Experts |
C#13 vSIG Meeting => Tue, Apr 09, 2013 (4:15 PM – 5:15 PM) |
|
|
|
|
|
441 |
ASM New Features – The New ASM Frontier |
Mile High Ballroom 2C => Wed, Apr 10, 2013 (08:15 AM – 09:15 AM) |
|
414 |
Engineered Systems Curriculum: The Perfect Marriage: ZFS Storage Appliance with Exadata |
Mile High Ballroom 1C => Wed, Apr 10, 2013 (11:00 AM – 12:00 PM) |
|
783 |
Virtualized Oracle Stretched RAC Cluster using VMware vSphere and EMC VPLEX |
Mile High Ballroom 2A => Wed, Apr 10, 2013 (04:15 PM – 05:15 PM) |
|
|
|
|
|
757 |
From Big Data to Exadata: The Best of Both Worlds for Business Analytics |
Mile High Ballroom 1B => Thu, Apr 11, 2013 (09:45 AM – 10:45 AM) |
|
|
|
|
December 8, 2012 Leave a Comment

Viscosity’s Core Competency centers arounds Oracle Real Application Clusters (RAC). Because we are the top Oracle RAC Experts, we intimately know storage architecture, network infrastructure, operating systems, and most importantly, Oracle RAC database interactions within the ecosystem.
Viscosity was formed by former Oracle Employees each of which worked in various capacities within Oracle Corporation. These capacities include Oracle Database, RAC Development, Oracle Consulting and Oracle Technical Architects, Design and Performance Tuning experts.
I am a co-founder and President of Viscosity North America, an Oracle ACE Director, an Oracle Certified DBA, Certified RAC Expert and a VMware Certified Professional. I specialize in Exadata, RAC, and Virtualization (VMware and Oracle VM) and authored three books: Oracle Database 11g New Features for DBA and Developers, Linux Recipes for Oracle DBAs and Oracle Data Guard 11g Handbook. I hold certifications in Oracle, VMware, Red Hat Linux, and Microsoft and has over 20 years of Oracle experience. I’ve sat on the panel of experts at VM World and Oracle OpenWorld for virtualization and Linux. I was one of the founding members of the IOUG virtualization SIG that launched in 2011 at Oracle OpenWorld.
If you look at the core of our competencies, we focus on what we are best at … RAC. RAC experts are expected to have in-depth knowledge in networks, clustering, storage, and operating systems. Several of the managing directors have served as system administrators in past lives and hold specialized certifications in flavors of Unix.
Because we know RAC, we know infrastructure. Because we know infrastructure, we’ve adjusted our focus to the world of Database Cloud. Not only do we adopt Oracle’s consolidation theme with Oracle RAC, we are heavily invested in VMware and Oracle VM. Several of the managing directors at Viscosity hold certifications on VMware.
Another area of mastery that we have taken is in the world of Exadata and Oracle engineered systems. Not only are we the experts in Exadata implementation and performance tuning, we are also experts inother engineered systems such as the ZFS Storage Appliance and Oracle Database Appliance.
Viscosity’s Oracle Center of Expertise has developed best practices and tight partner relationships to implement world-class solutions. Our vast experience and intellectual property give customers insight into what is driving IT complexity. We can deliver a set of practical executable plans for simplifying IT infrastructure, helping reduce operating costs while freeing up resources for new business initiatives.
November 8, 2012 Leave a Comment
dbca with the silent option is the best way to create a database. If you issue the find command from $ORACLE_HOME, you will see that oracle ships with two generic templates:
rhel59dra:/u01/app/oracle/product/11.2.0/db
dbca -silent \
May 15, 2012 Leave a Comment
From the X Server where the VNC Server is at:
$: xauth list $DISPLAY
viscdb105.visctech.com:1 MIT-MAGIC-COOKIE-1 fc0f22b8861edcea596a68db0ec3059d
viscdb105.visctech.com/unix:1 MIT-MAGIC-COOKIE-1 fc0f22b8861edcea596a68db0ec3059d
Then you go to your database server where you will launch runInstaller from:
$: xauth add viscdb105.visctech.com:1 MIT-MAGIC-COOKIE-1 fc0f22b8861edcea596a68db0ec3059d
$: xauth add viscdb105.visctech.com/unix:1 MIT-MAGIC-COOKIE-1 fc0f22b8861edcea596a68db0ec3059d
Set your DISPLAY like you would normally do:
VPRD1 – oracle: xclock Error: Can’t open display:
viscdb007:/apps/oracle/software/11.2.0.3/grid
VPRD1 – oracle: export DISPLAY=viscdb105.visctech.com:1
viscdb007:/apps/oracle/software/11.2.0.3/grid
Test your connection
if you have xclock installed on the database server. If you do not have xclock, you can copy xclock from another machine that has it installed.
VPRD1 – oracle: xclock
Warning: Missing charsets in String to FontSet conversion
$: ./runInstaller
Starting Oracle Universal Installer…
Checking Temp space: must be greater than 120 MB. Actual 1810 MB Passed
Checking swap space: must be greater than 150 MB. Actual 32031 MB Passed
Checking monitor: must be configured to display at least 256 colors
>>> Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<<
Some requirement checks failed. You must fulfill these requirements before
continuing with the installation,
Continue? (y/n) [n] y
>>> Ignoring required pre-requisite failures. Continuing…
Preparing to launch Oracle Universal Installer …
May 15, 2012 Leave a Comment
Create ASMLIB disks with /etc/init.d/oracleasm command.
You must be logged in as root:
- root: cat /proc/partitions |grep emcpower
- root: /etc/init.d/oracleasm scandisks
Scanning the system for Oracle ASMLib disks:
You can verify the the disks on the other RAC nodes with the listdisks option:
- root: /etc/init.d/oracleasm listdisks
TRAX_PV101_DISK1
TRAX_PV101_DISK2
TRAX_PV101_DISK3
TRAX_PV101_DISK4
TRAX_PV101_DISK5