Blog

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

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

UA-43005198-1