Category: Oracle Database General

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

One of the important tasks that the DBA has is to keep organized and controlled the schemas that exist in the database. Some companies have a standard nomenclature for its employees and service providers usernames and to avoid the creation of wrong logins, you can make a process to force an username pattern. To accomplish …

Continue reading

In large corporations, it is still common to find several different Oracle versions (9i, 10g and 11g) communicating with each other. Among some of them, the Oracle Compatibility Matrix alerts that some error may occurs. Even so, the DBA still creates the database link with the impression that will always work. If we analyze the …

Continue reading

Oracle 12c is now available and you have the ability to keep change your session current container. If your using SQLPlus, it's easy to check using "show con_name": [oracle@syslogfubddsne001 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Wed Feb 19 11:42:19 2014 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle …

Continue reading

In this article we will upgrade a database running on Oracle RAC version 11.2.0.1 to version 11.2.0.3. The steps to upgrade from the version 11.2.0.2 are very similar, only changing the dependent packages and patches. Our RAC database is running on a Red Hat, with the following specifications: O.S: Red Hat Enterprise Linux Server release …

Continue reading