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, …
May 17
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 …
May 16
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 …
May 16
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. …