Blog

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 […]

Access Control List in Oracle Database 11g

On May 14, 2012, Posted by , With Comments Off on Access Control List in Oracle Database 11g

  We had a request at one of our clients to open access from Apex to LDAP.  Here’s an example of creating the ACL and adding privileges. begin   dbms_network_acl_admin.create_acl (     acl         => ‘ldap_web.xml’,     description => ‘Allow Apex to LDAP Service’,     principal   => ‘MYSCHEMA’,     is_grant    => TRUE,     privilege   => ‘connect’     […]

Exadata single command to get all the hostnames and IP addresses of all the compute nodes

On May 1, 2012, Posted by , In Exadata, With Comments Off on Exadata single command to get all the hostnames and IP addresses of all the compute nodes

From the home directory where the dbs_group file resides:   dcli -g dbs_group -l oracle ‘grep -i `hostname` /etc/hosts’ On the half Rack Exadata, here’s  the output that you would expect: viscdb01: 10.0.0.70 viscdb01.visctech.com viscdb01 viscdb02: 10.0.0.71 viscdb02.visctech.com viscdb02 viscdb03: 10.0.0.72 viscdb03.visctech.com viscdb03 viscdb04: 10.0.0.73 viscdb04.visctech.com viscdb04 You can run a similar command to list […]

ODA Rant

On April 28, 2012, Posted by , In RAC, With Comments Off on ODA Rant

Oracle spends 4.5 billion on R&D.  ODA is a 4u box Marketed as HA in a box. You can license 2 cores up to 24 –> 3.06Ghz, 12 mb L3 of cache per socket (Intel XEON 5674) Bottom node is Server node SN#0 –> have to run the install on the bottom node Top node […]

VM World 2012 Call For Papers

On April 19, 2012, Posted by , In Linux, With Comments Off on VM World 2012 Call For Papers

VM World 2012 Call for papers is now open until May 18. VM World will be at San Francisco this year at the Moscone Center, August 27 – 30 Education.Choose from more than 200 Breakout Sessions and Hands-on Labs covering topics such as the hybrid cloud, enabling IT as a service and delivering end-user freedom while […]

UA-43005198-1