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

• 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!