Oracle 19c is packed up with lots of cool features, I’ve summarized the significant ones in below categories. Support: [Supported untill 2027. As per Note 742060.1 –which keeps changing]   Performance Features: – SQL plan management automatically evolve the plans and accept the best ones. – Gather Statistics Auto task can run more frequently: – […]

Problem: When connecting from Oracle Client 11g to an 18c DB or higher it throws this error: ORA-28040: No matching authentication protocol Analysis: Starting from 18c SQLNET.ALLOWED_LOGON_VERSION_SERVER parameter is defaulted to 12, which means; if your applications is using Oracle Client 11g to connect to the DB server they will get ORA-28040 unless you set […]

Introduction: In this post, I’ll discuss the migration of 11.2.0.3 RAC DB on Oracle Linux 6 to 19.4 RAC on a different cluster on Oracle Enterprise Linux OEL7 using GoldenGate to guarantee zero downtime. You don’t have to be an expert in GoldenGate to get this job done, this post will provide a step by […]

There are two ways to drop an Oracle database: Before starting: 1) It’s always wise to take a Full backup of the database before dropping it. 2) If the database is already registered with Grid/Cloud Control, un-register it: Connect to Grid Control with an admin user (e.g. SYSMAN) Targets -> Databases -> Select DB_NAME “ORCL” […]

In Part I I’ve installed the Linux OS and prepared the shared filesystem (ISCSI configuration & OCFS2) In Part II I’ve prepared the Linux OS for the RAC installation, installed 11.2.0.3 Grid Infrastructure and Database software.In Part III I’ve created a physical standby database under 11.2.0.3 Oracle Home on the new RAC server being refreshed […]

In Part I I’ve installed the Linux OS and prepared the shared filesystem (ISCSI configuration & OCFS2)  In Part II I’ve prepared the Linux OS for the RAC installation, installed 11.2.0.3 Grid Infrastructure and Database software. In this part I’ll create a physical standby database under 11.2.0.3 Oracle Home on the new RAC server will be refreshed from the 11.2.0.1 primary database for […]

In Part I I’ve installed the Linux OS and prepared the shared filesystem (ISCSI configuration & OCFS2) In this part I’ll prepare the Linux OS for the RAC installation, install Grid Infrastructure 11.2.0.3 and install Database software. Packages Requirements: (install the same packages version or later) ================== OEL 5 Required packages for 11.2.0.2 and later versions: ——————————————————————– […]

In this post I’ll discuss full implementation of upgrading Oracle RAC 11.2.0.1 to 11.2.0.3, the new RAC 11.2.0.3 will be installed on a new hardware (outplace upgrade). This lengthy post (in order to make it more beneficial) I divided it to FOUR major posts:   Part I   OS Installation, Filesystem preparation (OCFS2 on ISCSI) […]

Part II : Database Upgrade steps from 11.2.0.1 to 11.2.0.3 (Standalone DB)In this part I’ll discuss database upgrade steps from 11.2.0.1 to 11.2.0.3, I already covered 11.2.0.3 database software installation steps on a server already running 11.2.0.1 database using out-place method in Part I : environment preparation & 11.2.0.3 Software Installation.In case you’re interested in RAC database […]

Part I : environment preparation & 11.2.0.3 Software Installation (Standalone DB) In this part I’ll discuss OUT-PLACE installation steps of Oracle 11.2.0.3 (standalone DB) on a Linux server already have an Oracle 11.2.0.1 setup with databases up and running. Database upgrade steps (Standalone DB) will be covered in Part IIIn case you’re interested in RAC database upgrade from […]