In this article we will see how we make a mechanism that will inform us by email when some of the standby databases that synchronize with the primary have fallen behind in the sequence number of the logs or because... read more
How to improve a previously run query on an Oracle database (SQL Tuning Advisor with AWR Snapshots)
In a previous article we analyzed how to improve a query in Oracle using the SQL Tuning Advisor. But in order to run the SQL Tuning Advisor, the query must still be in the Shared Pool, i.e. in memory... read more
What do I do when Oracle Grid Cluster Services (CRS) won't start as system file permissions have been lost
In this article we will see what to do when one of the Oracle Cluster servers/nodes shows an error and the Cluster Services (CRS) do not start. The symptom When we go to start Cluster Services (CRS): It shows us the… read more
Useful commands to manage Oracle Grid Infrastructure / RAC (crsctl / srvctl)
In this article we will see some useful commands to manage databases installed on Oracle Grid Infrastructure. We manage Oracle Cluster Resources (CRS) through the CRSCTL tool and Oracle Database , Listener and… read more
How to install Enterprise Manager Cloud Control for Oracle database monitoring and administration
In this article we will see how to install Oracle Enterprise Manager Cloud Control on Oracle Linux / Red Hat Linux step by step. This tool provides the ability to manage Oracle databases through… read more
How to install an Oracle Real Application Cluster (RAC) on Linux using Direct NFS
In this article we will see step by step how to install an Oracle Database belonging to a Real Application Cluster (RAC) on a Linux operating system (Oracle Linux 7.7) with shared NFS disks without using Oracle ASM (Automatic Storage... read more
How to enable Oracle Direct NFS for increased performance between Oracle Database and NFS Shares
In this article we will see how to enable Direct NFS for Oracle Database connectivity with NFS Servers. When we enable it the communication between Oracle Database and NFS Servers is done directly, without involving the kernel of… read more
How do we set up a Windows Server as an NFS Server to have shared NFS disks on Unix
In this article how we can have shared disks between Microsoft Windows Server and Unix through NFS protocol. We will see step by step how to create a Microsoft Windows NFS Server and how to mount the disks in... read more
What is Oracle Real Application Cluster (RAC)
In this article we will see a detailed description of what Oracle RAC (Real Application Cluster) is, what features it provides and how it works. Oracle RAC is a software that allows us to connect multiple servers (up to… read more
