SQL plan baselines are a new feature introduced in Version 11g. SQL execution plans determine how a query is executed and the path that is taken to retrieve the data. Plans can be evolved or improved over executions and should only change when a better plan can be found. When a query is hard parsed, …
Tablespace encryption is a feature introduced to increase security of your database. The idea is that by encrypting your tablespaces, you will stop anyone who gets a copy of your datafiles outside of your database from being able to access the data on them. For example someone may be able to get copies of your …
The ORA-15260 error when attempting ot issue an alter diskgroup command is a permissions issue. It will generally be because you are logged in as SYSDBA rather than SYSASM. Prior to 11gR2 you could log in and administer diskgroups with SYSDBA privileges but this changed with 11.2. SQL> ALTER DISKGROUP DATA add disk ‘/dev/oracleasm/disks/DISK2’;ALTER …
This tutorial leads straight on from ‘How to install Oracle Enterprise Linux 6 on Virtualbox’ and assumes that you have a clean install to work from. If you haven’t installed OEL6 or have any problems with this tutorial, I recommend that you follow that tutorial before this one. So, in virtual box, Guest additions gives you some cool …
Virtualbox is Oracle’s solution to visualization and as such it is very powerful. It is similar to VMware as it has much the same capabilities and you can run servers through it on an enterprise level. For the purposes of experimenting with operating systems and learning Oracle, it gives us some amazing benefits and makes …
Unfortunately, the installer or more specifically the root.sh script for the Oracle 11g grid (Clusterware) installer can be very flaky. If it fails and you need to fix something or rerun it for any reason, it will fail the next time if you have not cleaned up the install by de-configuring CRS. I also …
Firstly, you need to create files padded to the required disk size. So if you want 4 1Gb files you could execute the below commands on shared storage: dd if=/dev/zero of=/SHAREDDISK/asmDisk1-1 bs=1024k count=1000 dd if=/dev/zero of=/SHAREDDISK/asmDisk1-2 bs=1024k count=1000 dd if=/dev/zero of=/SHAREDDISK/asmDisk1-3 bs=1024k count=1000 dd if=/dev/zero of=/SHAREDDISK/asmDisk1-4 bs=1024k count=1000 dd creates your file, ‘if’=/dev/zero gets null …
This is a problem with the config of the NTP daemon (ntpd) which synchronizes time across the cluster. The specific error is to do with the boot time behavior of the daemon and needing the ‘Slewing’ option enabled. If you need to enable slewing, you can do it by typing ‘ntpd -x’, however, the grid …
If you have ever wondered what Hahoop, Memcached, NoSQL, Mapreduce or many of the other data based technologies that are springing up are, this is a superb whistle stop tour or the market. Hadroop is basically a system for distributing your data across multiple storage servers that all have processing capacity. Then when you …
Features embedded in Oracle Kernel Improves performance and manageability for NFS drives Configuring: NFS file system should be mounted and available. Direct NFS does not mount drives Direct NFS client uses either: configuration file called ‘oranfstab’ mount file tab – /etc/mtab First: $ ORACLE_HOME/ dbs/oranfstab which would specify the Direct NFS Client settings for a single database. Then /etc/oranfstab …