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

Aug 13

Howto upgrade Oracle Grid 11g to 11.2.0.3

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

Aug 12

Howto upgrade Oracle Grid 11.2.0.3 to PSU 7

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