November 2014 archive

Nov 14

OCM 11g Preparation - Stripe data files across multiple physical devices and locations

Here you need to know how to strip the oracle data files. It is "data files", not "datafiles". So, don't forget to strip any kind of oracle file in different mount points, like: Controlfiles Redologs Tablespaces (create more than one datafile for each) You can also do a indirect striping using +ASM diskgroups across multiple …

Continue reading

Nov 13

Howto apply OJVM PSU, DB PSU and Generic JDBC Patch in 11.2.0.4

Starting at October 2014, all the DB PSU come along with the OJVM PSU option on the main download page (Doc ID 756671.1). Oracle recommends to install both, as well as the Generic JDBC Patch that is also available there. In this tutorial, I will show how to install the OJVM PSU, DB PSU and JDBC …

Continue reading

Nov 07

Rename schema in Oracle 11g with Loopback DBLink

In this article, we will deal a very common situation where the DBA is tasked to rename or clone a user into the same database. In the following lines, I will explain how to make this copy without higher complexities and with no need to generate intermediate dump files, using DataPump import utility with a …

Continue reading