Blog

Charles Kim’s Upcoming Presentations at OOW 2012

On September 22, 2012, Posted by , In Exadata,ZFSSA, With Comments Off on Charles Kim’s Upcoming Presentations at OOW 2012

If you are going to be at Oracle OpenWorld this year, please stop by and say Hi .. Here’s all the sessions that I will be a presenter or a panelist at: UGF4410The Perfect Marriage: Oracle Exadata with Sun ZFS … Continue reading

ASM IO Statistics (asmiostat.sh)

On September 15, 2012, Posted by , In ASM, With Comments Off on ASM IO Statistics (asmiostat.sh)

ASM IO Statistics (asmiostat.sh) Please refer to the following Metalink: ASMIOSTAT Script to collect iostats for ASM disks [ID 437996.1]   This script is applicable for 10.2 and 11.1 ASM instances.      The following command will gather ASM IO … Continue reading

Clone non-rac Grid Infrastructure

On May 17, 2012, Posted by , In General DBA, With Comments Off on Clone non-rac Grid Infrastructure

[oracle@my562b bin]$ ./detachHome.sh Starting Oracle Universal Installer… Checking swap space: must be greater than 500 MB.   Actual 4094 MB    Passed The inventory pointer is located at /etc/oraInst.loc The inventory is located at /apps/oraInventory ‘DetachHome’ was successful. The contents of the inventory XML file looks like this: [root@my562b ContentsXML]# cat inventory.xml <?xml version=”1.0″ standalone=”yes” ?> <!– […]

Setting DISPLAY with X authority file utility – xauth

On May 15, 2012, Posted by , In Display,Linux,RAC,Red Hat,X,xuath, With Comments Off on Setting DISPLAY with X authority file utility – xauth

Setting DISPLAY with X authority file utility – xauth From the X Server where the VNC Server is at: $: xauth list $DISPLAYviscdb105.visctech.com:1 MIT-MAGIC-COOKIE-1 fc0f22b8861edcea596a68db0ec3059dviscdb105.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 […]

Create ASMLIB disks for EMC disks

On May 15, 2012, Posted by , In ASM,ASMLIB,EMC,Linux,RAC, With Comments Off on Create ASMLIB disks for EMC disks

Create ASMLIB disks with /etc/init.d/oracleasm command.  You must be logged in as root: – root: cat /proc/partitions  |grep emcpower  120    32    1048576 emcpowerc  120    33    1047383 emcpowerc1  120    48    1048576 emcpowerd  120    49    1047383 emcpowerd1  120    64    1048576 emcpowere  120    65    1047383 emcpowere1  120    80    1048576 emcpowerf  120    81    1047383 emcpowerf1  120    96    1048576 emcpowerg […]

UA-43005198-1