This article is an introduction to the series of articles that will be presented on this site covering the Red Hat Certified System Administration (RHCSA EX200) and Red Hat Certified Engineer ( RHCE EX300) certification exams. You need to keep in mind the following notes when reading the associated articles. Continue reading
Linux Antivirus (clamav, freshclam, clamscan, clamtk)
There are a number of commercial antivirus products available for Linux, but ClamAV is free and is easily installed on Fedora and Enterprise Linux distributions. Continue reading
OS Backup Commands
This article contains a summary of the operating system backup commands you might encounter whilst backing up Oracle databases.
Oracle Shell Scripting
This article presents some basic techniques for creating Windows batch files and UNIX/Linux shell scripts that connect to SQL*Plus and RMAN. Continue reading
Oracle Naming Conventions
Some of the typical naming conventions used for objects in Designer and the database. Nothing is carved in stone, but these are the sort of rules I follow: Continue reading
Deadlocks
A deadlock occurs when two or more session are waiting for data locked by each other, resulting in all the sessions being blocked. Oracle automatically detects and resolves deadlocks by rolling back the statement associated with the transaction that detects the deadlock. Typically, deadlocks are caused by poorly implemented locking in application code. This article shows the steps necessary to identify the offending application code when a deadlock is detected. Continue reading
Measuring Storage Performance For Oracle Systems
Storage vendors offer endless amounts of performance data on their products, but the information doesn’t necessarily reflect how the storage will perform when it is used by an Oracle database. This article outlines two easy ways to test the performance of your storage systems using utilities provided by Oracle. Continue reading
RAID
RAID is an acronym for Redundant Arrays of Inexpensive Disks. These provide a mechanism for load balancing and securing your data across
multiple disks. In this article I’ll give a brief explanation of the most commonly used RAID levels and how they should be used with Oracle. Continue reading
Security-Enhanced Linux (SELinux)
This article covers the basic concepts of Security-Enhanced Linux (SELinux), with specific reference to the information needed for the RHCSA EX200 certification exam. Extra information is required for the RHCE EX300 certification exam, which will be supplied by another article.
Remember, the exams are hands-on, so it doesn’t matter which method you use to achieve the result, so long as the end product is correct. Continue reading