Howto upgrade Oracle EM 12c with Database Vault enabled

In recent days, I updated the EM 12c release 12.1.0.3.0 to 12.1.0.4.0. However, the database where the repository was placed had Oracle Database Vault enabled and I was not even allowed to temporarily disable it during the upgrade (security policy of the company). The best way to have proceeded with the installation without facing problems would be shutting …

Continue reading

Howto repoint your Oracle Management Agent to a different OEM 12c Server

Maybe one day you might face a situation where you lose, change or reinstall your Oracle EM 12c Server and if you do so, you won’t need to reinstall all the OMS agents running on your client hosts. All you need is to create a new instance of the agent inside each of your client hosts …

Continue reading

Howto solve Session waiting SQL*Net from/to DBLink forever

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

Howto get current session container in Oracle 12c

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

Howto upgrade Oracle EM 12c from R2 to R3

In this article, we will describe step by step of how to upgrade Oracle Enterprise Manager 12c R2 (12.1.0.2) to Oracle Enterprise Manager 12c R3 (12.1.0.3) running on Red Hat el5 64 bits. First of all, you need to download the installation files and place in you machine: [oracle@ec12mntrjr001 em12cR3]$ ls -la total 5942464 drwxr-xr-x …

Continue reading