Blog

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

Best Practices for Gathering Optimizer Statistics

On April 17, 2012, Posted by , In General DBA, With Comments Off on Best Practices for Gathering Optimizer Statistics

A must read for everyone:  twp-bp-optimizer-stats-04042012-1577139.pdf

UA-43005198-1