Category: Oracle Database General

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

In this article, we will update a newly installed version of Oracle Grid and Database 11.2.0.3, running on Linux X86_64 (RAC) for the Patch Set Update 7 (11.2.0.3.7), dated July/2013. For this, we need to download the following packages from Oracle Metalink website: p16742216_112030_Linux-x86-64.zip -> PSU 7 p6880880_112000_Linux-x86-64.zip -> Latest OPatch version After uploading the …

Continue reading