• About Me
  • Contact
  • Linux
  • Oracle
Wadhah DAOUEHI
Wadhah DAOUEHI
Oracle and Linux blog
LinkedIn YouTube Twitter
  Menu
Skip to content
  • About Me
  • Contact
  • Linux
  • Oracle
LinkedIn YouTube Twitter
LinkedIn YouTube Twitter

Category Archives: Oracle Database

« Older posts
Newer posts »

Convert Oracle RAC to RAConeNode 19c, Database is administrator managed

By Wadhah DAOUEHI | July 7, 2021 - 11:41 pm |July 7, 2021 High Availability, Oracle 12c, Oracle Database, OracleLinux8
Leave a comment

This article explains the steps to convert an existing Oracle database 19c (19.9) RAC 2 … Read More →

Upgrade Oracle Database RAC 2 nodes CDB, 2 PDBs from 19.3 to 19.9

By Wadhah DAOUEHI | July 7, 2021 - 10:46 pm |July 7, 2021 High Availability, Linux, Oracle 19c, Oracle Database, OracleLinux8
Leave a comment

This article explains the steps to upgrade Oracle Database RAC 2 nodes with CDB mode … Read More →

Max 3 PDBs within 21c Standard Edition S2, not bad

By Wadhah DAOUEHI | May 15, 2021 - 3:45 pm |November 1, 2021 Oracle Database
Leave a comment

While the feature “Multi-Tenant” begin within 12c, now is a mandatory for both Editions “Enterprise … Read More →

Upgrade Oracle Home 19c (19.3 to 19.9)

By Wadhah DAOUEHI | November 19, 2020 - 11:24 am |November 19, 2020 Oracle 19c, Oracle Database, OracleLinux8
Leave a comment

We are going to enjoy the upgrade steps of Oracle Database Home 19c from 19.3 … Read More →

Password-Mode Encryption RMAN Backup

By Wadhah DAOUEHI | October 28, 2020 - 4:50 pm |October 17, 2021 Oracle 12.2, Oracle Database, Security
Leave a comment

May you want to restore an Oracle database Backup, in an other environment and you … Read More →

Black or White List by IP address SQL NET

By Wadhah DAOUEHI | October 20, 2020 - 1:56 pm |October 17, 2021 Linux, Oracle Database, Security
Leave a comment

To prevent every one to connect to Oracle database directly, we can just authorize the … Read More →

Register Oracle service name on Listener other than 1521

By Wadhah DAOUEHI | October 17, 2020 - 11:07 am |October 17, 2021 Linux, Oracle 12.2, Oracle Database
Leave a comment

While the default port number of the Oracle LISTENER 1521, then the Oracle database will … Read More →

Convert Oracle Dedicaded to shared server

By Wadhah DAOUEHI | September 16, 2020 - 6:02 pm |September 1, 2021 Oracle 19c, Oracle Database, OracleLinux8
Leave a comment

Converting Oracle database connection mode from Dedicated mode to Shared mode within Oracle Database 19c … Read More →

Convert Oracle RAC 19c Policy manager to Administrator managed

By Wadhah DAOUEHI | September 1, 2020 - 11:39 am |September 1, 2021 Oracle, Oracle 19c, Oracle Database, OracleLinux8
Leave a comment

This article explains the steps to convert Oracle database 19c RAC 2 nodes policy manager … Read More →

[FATAL] [DBT-06103] The port (5,500) is already in use. ACTION: Specify a free port, Oracle 19c

By Wadhah DAOUEHI | May 29, 2020 - 9:59 pm |May 31, 2020 Linux, Oracle 19c, Oracle Database
Leave a comment

While installing the Oracle Database Software, we have find this Fatal Error: Error: [FATAL] [DBT-06103] … Read More →

«‹34567›»
  • Oracle ACE Pro


  • Oracle Certified Expert




  • Oracle Cloud Infrastructure


  • MySQL: Administrator Certified Professional


  • PostgreSQL: Certified Associate


  • Recent Posts

    • 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 !
Wadhah DAOUEHI | Powered by Mantra & WordPress.
LinkedIn YouTube Twitter