This document explains the use of ADRCI, an Oracle utility for trace file housekeeping. ADRCI is a command-line tool that is part of the fault diagnosability infrastructure introduced in Oracle Database Release 11g.
Flashback is a new feature introduced in Oracle 10g to recover database from any logical error like deleting records, dropping table or logical corruption due to multiple job runs. This document includes restore point creation and rollback procedure.
Nomenclature is the Naming Methodology that should be followed for better programming and understandable coding to make the mnemonic easier to use and read. This document provides the coding standards for Oracle applications.
Oracle Enterprise Manager (OEM) 13c, also known as Cloud Control 13c, is a web-based tool for managing Oracle software and hardware, both on-premises and in the cloud. It provides a central console for monitoring and administering databases, middleware, infrastructure, and hardware. This document explains Oracle Enterprise Manager 13c installation and maintenance.
Oracle quarterly releases patches also known as patch set update (PSU) which includes security & bug fixes. PSUs coinciding with the Critical Patch Updates (CPUs). This document covers Oracle database patching procedures on stand-alone and RAC databases.
SSL, or Secure Sockets Layer, is a security protocol used to protect data during transfer over internet. It's often used to protect sensitive information like usernames, passwords, and credit card details in online transactions. This document describes step by step installation of SSL in Oracle databases. SSL is one of the Oracle advanced security features available in Enterprise Edition.
Oracle Trace file Analyzer (TFA) provides several diagnostic tools in single bundle, making it easy to gather diagnostic information about oracle database and clusterware, which in turn helps with problem resolution when dealing with oracle support. This document demonstrates setup and usage of Oracle TFA.
This upgrade provides enhanced stability, reliability, and security, along with new features and a longer support lifecycle compared to older versions. This document explains various upgrade paths and procedures of Oracle database.
Oracle's Transparent Data Encryption (TDE) is a feature that encrypts data at rest within an Oracle database, protecting it from unauthorized access even if the storage media is compromised. It operates transparently, meaning applications and users don't need to be modified to work with encrypted data. TDE encrypts and decrypts data automatically as it's written to and read from storage. This document explains Transparent Data Encryption setup in Oracle database.