Mar 25

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

Feb 19

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

Dec 01

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

Nov 18

Installing Oracle EM 12c agent on Windows manually

In this tutorial I will explain how to install the Oracle Enterprise Manager 12c agent on Windows. The method via Cloud Control’s website is not always intuitive and simple, since it requires an SSH client for Windows running on your server. 1) Verifying if the agent exists on OMS. To begin, open your Cloud Control …

Continue reading

Oct 12

Howto rename managed target on Oracle EM 12c

During many months the only way that I found to rename a Managed Target on OEM Cloud Control was deleting and adding it again. However, there is another way as I will show you. This procedure was tested and validated on EMc 12.1.0.2. So, if you choose to try at another version, make it at your …

Continue reading