Latest Blog Posts

Turn off most of Oracle auto tasks

To disable the AUTO TASK space advisor, and sql tuning advisor, and disable weekday maintenance window for auto optimizer stats collection, you could execute this. This code works on 12c and likely a couple of versions previous to 12c – but have not tested recently. BEGIN dbms_auto_task_admin.disable(client_name => ‘auto space advisor’, operation => NULL, window_name => NULL);…

Virtual Box Additions Fails

Virtual Box Additions Fails cd /etc/yum.repos.d wget http://public-yum.oracle.com/public-yum-ol6.repo yum update # make sure these guys are installed yum install gcc yum install kernel-uek-devel # yes you have to reboot – or it’s not gonna pick all this up reboot re-run the VBoxAdditions process

Add space to a dynamic virtual hard drive with VirtualBox with a RHEL/CentOS/OEL 6 VM

This blog assumes your VM is RHEL or clone of RHEL using the logical volume manager – if you are not using LVM – this approach will not work. To start with expand the virtual drive from the command line (Windows in the example). VBoxManage modifyhd <absolute path to file> –resize <size in MB> For…

Oracle 12c Create a Pluggable Container DB From Seed & Changing Containers

# Creating a pluggable container from the seed container pdb$seed # First create a data sub-directory under the root container cdb$root data directory as follows (your path may vary to your oradata dir): # while logged in as the oracle / Linux user that admins the 12c database cd /u01/app/oracle/product/12.1.0.2/oradata/orcl mkdir pdbmf11g cd pdbmf11g #…