List Of my articles about Oracle Database 26ai, 23ai, 19c, 18c, 12c and 11g, Oracle Grid Infrastructure, RAC, Data Guard, Tuning database, Oracle Database Appliance ODA, ACFS, OCFS2, MySQL and Linux

• Oracle Database 19c Security Hardening – Part 12: Securing Oracle Data Pump (expdp & impdp)
• Oracle Database 19c Security Hardening – Part 11: Reducing the Attack Surface: Oracle XML DB, JVM, HTTP Services, and Optional Components
• Oracle Database 19c Security Hardening – Part 10: Securing Oracle Scheduler, External Jobs, and Operating System Credentials
• Oracle Database 19c Security Hardening – Part 9: Securing Database Links (DB Links)
• Oracle Database 19c Security Hardening – Part 8: Securing Oracle RMAN Backups
• Oracle Database 19c Security Hardening – Part 7: Protecting Data at Rest with Transparent Data Encryption (TDE)
• Oracle Database 19c Security Hardening – Part 6: Securing Your Database with Unified Auditing
• Oracle Database 19c Security Hardening – Part 5: Managing Privileges and Applying the Principle of Least Privilege
• Oracle Database 19c Security Hardening – Part 4: Strengthening Authentication and Password Security
• Oracle Database 19c Security Hardening – Part 3: Securing Oracle Listener and SQL*Net
• Oracle Database 19c Security Hardening – Part 2: First Security Checks After Installation
• Oracle Database 19c Security Hardening – Part 1: Introduction
• Oracle Database 19c: Transporting Tablespaces from a Non-CDB to a PDB
• Oracle 19c Recovery Catalog: Installation and Configuration
• Oracle RAC 19c: Change SCAN adresses
• Oracle RAC 19c: Change VIPs adresses
• Oracle ODA X9-2 (19c): Check networks status
• Oracle ODA X9 (19c): Erase appliance Configuration
• Oracle ODA X9 (19c): Create a Backup ACFS volume
• Oracle ODA X9 (19c): Resize DB Home Storage
• Oracle Database 19c: How to Verify Locked and Expired User Accounts
• Oracle Database 19c: How to Verify DBA Accounts and Audit DBA Roles
• Oracle 19c – SQL Access Path: Index Fast Full Scan
• Oracle ASM : Monitor Disk Group Space Usage in 19c
• Hourly Redo Activity Analysis Using V$LOG_HISTORY
• Identify Where Database Time Is Spent (Wait Events + CPU)
• Calculate Real Table Size (Including Indexes, LOBs and LOB indexes)
• Oracle 19c: Index-Organized Table (IOT)
• Oracle 19c – SQL Access Path: Index Skip Scan
• Oracle 19c – SQL Access Path: Index Full Scan
• Oracle 19c – SQL Access Path: Index Range Scan
• Oracle 19c – SQL Access Path: Index Unique Scan
• Oracle 19c – SQL Access Path: ROWID Scan
• Oracle 19c – SQL Access Path: Full Table Scan
• OS_AUTHENT_PREFIX External Authentication in Oracle Database 19c
• Oracle 19c Flashback Technology (7/7): Data Archives
• Oracle 19c Flashback Technology (6/7): Flashback Database/PDB
• Oracle 19c Flashback Technology (5/7): TRANSACTION
• Oracle 19c Flashback Technology (4/7): Table
• Oracle 19c Flashback Technology (3/7): Drop Table
• Oracle 19c Flashback Technology (2/7): Versions Query
• Oracle 19c Flashback Technology (1/7): Query
• Recommended UNDO Tablespace Size in Oracle 19c Using the Undo Advisor (SQL Only)
• Understanding UNDO Configuration and RETENTION GUARANTEE in Oracle 19c
• Materialized View Log in Oracle 19c (ON COMMIT)
• Materialized View Log in Oracle 19c (ON DEMAND)
• Reinitializing the Same Password After Expiration in Oracle 19c
• Switching Session User in Oracle Database
• Monitoring the Oracle Fast Recovery Area (FRA)
• Database 19c Vault: OWNER/Manager privileges
• Enabling the Database Vault (Initialisation parameters)
• [FATAL] [DBT-09352] Error in validating dbv_owner credentials
• Oracle 19c: Convert Table to range partition online
• Oracle 19c: Automatic List-Partitioned Table (2/2)
• Oracle 19c: Automatic List-Partitioned Table (1/2)
• Oracle Database 19c: Interval Partitioning (2/2)
• Oracle Database 19c: Interval Partitioning (1/2)
• Oracle Database 19c: Shared Server mode
• SYS.DBMS_BACKUP_RESTORE & SYS.DBMS_RCVMAN RMAN
• Oracle 19c: pdb_storage_clause
• NGINST-64051: Invalid Central Inventory location “null”.
• 23ai: Create table if not exists
• 23ai: Direct join with DELETE
• 23ai: Direct join with UPDATE
• 23ai: BOOLEAN Column Data Type <Enhancement 02>
• 23ai: BOOLEAN Column Data Type <Enhancement 01>
• 23ai: Having with alias
• Create FREE 23ai Database
• Oracle Database 23ai installation RPM
• Oracle Database 23ai Preinstallation RPM
• 23c: Oracle database: Close in steps
• 23c: Database has been previously opened and closed
• Get OEMCC 13c5 Agent zip file (Windows)
• Error Installing Oracle cloud control 13c5 on Windows Server 2016
• Enable LOCAL_UNDO for PDBs
• ORA-65500: could not modify DB_UNIQUE_NAME, resource exists
• Create an Oracle Database 19c using SQL
• Can’t locate Term/ReadKey.pm
• Reason = profile limit idle_time
• Errors while standby_file_management = manual in standby DB
• Oracle Database Server/Client certificate/TCPS (Oracle 19c)
• Create Client Wallet and Certificate (Oracle 19c)
• Create Server Wallet and Certificate (Oracle 19c)
• Reinstate failed for Data Guard: Flashback Database is disabled
• Reinstate for Data Guard succeeded
• Reinstate failed for Data Guard: Flashback Database is disabled
• Physical/Logical Health Monitor check (Oracle 19c)
• Restore/Recover datafile from Standby without database catalog (19c)
• Backup as copy database to an other server with RMAN (Oracle 19c)
• Oracle Database Software Upgrade 19.18 to 19.19 (19c)
• RMAN duplicate to create a clone database READ/Write
• Check/Recover a corrupted Block (Oracle 19c)
• RMAN duplicate Database for Data Guard ( 19c )
• Oracle 23c: Change Database Name FREE to DB23c
• New Features 23c: GROUP BY with Aliases/Position Number
• New Features 23c: Table with EXIST or NOT EXIST Clause
• New Features 23c: Asynchronous Transactions
• New Features 23c: BOOLEAN Column Data Type
• New Features 23c: Table VALUES Constructor
• New Features 23c: Select without DUAL
• Cloud Control Enterprise Manager 13c, Email notifications
• Patch 34765931 – Database Release Update 19.18.0.0.230117 (REL-JAN230131)
• Create our first 23c instance: FREE
• Install 23c Oracle Database: Free Version
• Welcome 23c Oracle Database: Free Version
• Warning: ORA-16714: Some Parameter are inconsistent with the database setting
• Add Oracle database service Naming (tnsnames.ora) 19c
• Register Database services in Listener (Oracle 19c)
• Warning: ORA-16714: Some Parameter are inconsistent with the database setting
• Real-time cascading within Oracle Data Guard 12c
• Deploy OEMCC 13c5 Agent In Silent Mode
• Get OEMCC 13c5 Agent zip file
• Upgrade Oracle Home 19c Software (19.3 to 19.12)
• OPatch 12.2.0.1.27 for DB 19.0.0.0.0
• Convert RAC 19c administrator managed to policy manager
• Convert Oracle RAConeNode to RAC 19c, Database is administrator managed
• Convert Oracle RAC to RAConeNode 19c, Database is administrator managed
• Upgrade Oracle Database RAC 2 nodes CDB, 2 PDBs from 19.3 to 19.9
• Upgrade Oracle Clusterware GI 19c from 19.3 to 19.9
• RMAN-08138: warning: archived log not deleted – must create more backups
• RMAN-08591: warning: invalid archived log deletion policy
• Password-Mode Decryption RMAN Backup
• Password-Mode Encryption RMAN Backup
• Black or White List by IP address SQL NET
• Register Oracle service name on Listener other than 1521
• Upgrade the oracle Opatch
• Check Oracle Clusterware patch release
• Upgrade Oracle Home 19c (19.3 to 19.9)
• Create a Service Naming with NETMGR within Oracle 12.2
• Create a Listener with NETMGR within Oracle 12.2
• [DBT-12510] The database option ‘SAMPLE_SCHEMA’ is not feasible to be installed in the current Oracle home.
• Install Oracle Database 19c Silent Mode On Oracle Linux 8
• [FATAL] [DBT-06103] The port (5,500) is already in use. ACTION: Specify a free port, Oracle 19c
• [WARNING] [INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck’ 19c on Oracle Linux 8
• Install Oracle Database 19c Silent Mode Software Only
• Install Oracle database 19c prerequisites on Oracle Linux 8
• Install OCI CLI on Oracle Linux 8
• Get prepared for the Oracle Cloud Infrastructure 2019 Certified Architect Professional
• RAC 12cR2 Cluster Bug: HANG DUE TO HIGH GC INDEX OPERATIONS/ENQ: TX ROW LOCK CONTENTION WAITS: Bug resolved via Patch 28023081
• Patch 26609817: DATABASE RELEASE UPDATE 12.2.0.1.170814 (RAC)
• Oracle Cloud Control database Plug-in on the agent in 12cR1
• Bug while creating new administrator manager RAC 12cR1 while we have one
• DevOps/DBA n°2: Oracle database EE 18c on Docker Image based on Oracle Linux 7u7
• DevOps/DBA n°1: Oracle database EE 19c on Docker Image based on Oracle Linux 7u7
• [FATAL] [DBT-11211] 19c DBCA: The AMM option is not allowed while the physical memory is greater than 4GB
• Drop guaranteed restore points: ORA-38781
• Upgrade Oracle database from 12c (12.1.0.2) to 19c (19.3.0.0) using the RMAN backup
• Install Oracle database 12cR1 RAC 3 nodes on Oracle Linux 6u10
• Installing Oracle Grid Infrastructure 12cR1 on 3 nodes
• Check prerequisites before installing Oracle Grid Infrastructure on 3 nodes
• Install Oracle database 19c3 on ASM
• Create a new ASM DiskGoup on 19c3
• Install Oracle Grid Infrastructure Standalone 19c3
• Upgrade OEMCC Agents 12c4 to 13c2
• Upgrade Oracle Enterprise Manager Cloud Control 12.1.0.4 to 13.2.0.0 on Oracle Linux 6.5
• Restore MySQL 5.7 Backup with MySQL Enterprise Backup MEB 4.1.0
• Online full backup of MySQL server 5.7 using the MySQL Enterprise Backup
• Upgrade MySQL Server 5.5 to 5.7 on Oracle Linux 7
• Convert SNAPSHOT STANDBY to PHYSICAL STANDBY 12cR1
• Convert PHYSICAL STANDBY to SNAPSHOT STANDBY 12cR1
• Transportable tablespace from 11gR2 to 12cR1
• Resize RAC 11gR2 Cluster Health Monitor repository
• Upgrade Oracle Database 12cR1 to 12cR2 with RMAN
• Change a PDB Character Set within Oracle database 12cR2 (12.2.0.1) using the DMU tool
• Unplug a pluggable database 12cR2 using DBCA
• Create a pluggable database 12cR2 using DBCA
• Change Oracle database 12cR2 Name with DBNEWID
• Upgrade Oracle Database from 12.1.0.2 to 12.2.0.1 using DBUA
• Dealing with: ORA-01804: failure to initialize timezone information
• Enable Archivelog on Oracle database 12R2
• Install Step by Step Oracle database 12R2 on Oracle Linux 7
• Install prerequisites for Oracle database 12R2 on Oracle Linux 7
• Move audit Trail table to created-user Tablespace with Oracle database 11g & 12c
• Enable HugePages RHEL 7/OL 7 within Oracle Database 12c
• List of Linux physical devices, mapped by ASM disks, using Major & minor number
• Dealing with INVALID status of Oracle database components after upgrade to 12c (12.1.0.2)
• Upgrade Oracle database from 11.2.0.4 to 12c (12.1.0.2) using the RMAN backup
• Upgrade Oracle database from 11.2.0.4 to 12c (12.1.0.2) using the RMAN backup
• Upgrade Oracle database from 11.2.0.1 to 11.2.0.4 using RMAN backup
• Part 2: Upgrade Oracle Grid Infrastructure & Database from 11gR2 to 12C
• Part 1: Install Oracle Grid infrastructure standalone & Oracle Database 11gR2
• Creation of ASM disks on Oracle Linux using ASMLib
• Active Oracle database duplication
• Active-passive High Availability Solution for Oracle Database without Data Guard solution:
  • Part 2: Active-passive High Availability Solution for Oracle Database without Data Guard
  • Part 1: Active-passive High Availability Solution for Oracle Database without Data Guard
• Database SQL; Delete vs Truncate and segment size allocated
• DNS configuration to use the SCAN with Oracle RAC Database
• Mount an OCFS2 while the SELinux status on enforcing mode
• SAN and OCFS2 over IP Multipathing (bonding) on two Ethernet cards
• Set up an automatically Oracle database backup with expdp!