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

Sep 20

Finding Oracle users with DBA privilege hidden by roles

Some users in Oracle may have very dangerous privileges without your consent, they can cause great damage to the database. Sometimes this privilege is hidden via a chain of roles, which makes it difficult to perception. Eg: SQL> CREATE USER SYSADM identified by "sysadm1"; SQL> CREATE ROLE A; SQL> CREATE ROLE B; SQL> CREATE ROLE …

Continue reading