Howto upgrade Oracle Database 11.2.0.3 to PSU 6

In this article, we will update a newly installed version of non-RAC Oracle Database 11.2.0.3, running Linux X86_64 to the Patch Set Update 6 (11.2.0.3.6), dated April/2013. For this, we need to download the following packages from Oracle's website: p16056266_112030_Linux-x86-64.zip -> PSU 6 p6880880_112000_Linux-x86-64.zip -> Latest version of OPatch After transfering the files to the server, …

Continue reading

Howto install oracle-validated RPM in Red Hat el5

The oracle-validated RPM package already does all the arrangements for you of dependencies during the installation of Oracle in an Enterprise Linux 5. However, the latest versions of this package have been demanding as a prerequisite the uek-kernel, which limited the installation only in Oracle Linux 5 distribution. In this topic, we will learn how …

Continue reading

Howto setup a new database target on Oracle EM 12c Cloud Control

In this post, we will make Oracle EM 12c monitor a new target (in which case it will be a Oracle Database non-RAC). In this example, we are dealing with an Oracle 11gR2 single instance database running on a Linux x86_64. The steps to be performed are: Configure the Linux OS of the database to …

Continue reading

Howto create a readonly user on 12c Cloud Control

In this post, we are demonstrating how to create a user that has view only permissions in Oracle Enterprise Manager 12c. The aim is to give it to any team or user that can check all monitorable objects, but can not make any changes to it. The focus is on performance analysis, monitor and availability. …

Continue reading