• 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

Author Archives: Wadhah DAOUEHI

« Older posts
Newer posts »

Upgrade the oracle Opatch

By Wadhah DAOUEHI | July 3, 2021 - 7:54 pm |July 4, 2021 Linux, Oracle, Oracle 19c, OracleLinux8
Leave a comment

We are using the Opatch version 6880880, you download it from support.oracle.com Upgrade the OPatch: … Read More →

Check Oracle Clusterware patch release

By Wadhah DAOUEHI | July 2, 2021 - 7:27 pm |July 4, 2021 High Availability, Linux, Oracle 19c
1 Comment

1.Check Oracle Clusterware software version on both nodes: [root@host01 ~]# crsctl query crs softwareversion -all … 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 →

RMAN-08138: warning: archived log not deleted – must create more backups

By Wadhah DAOUEHI | November 2, 2020 - 11:55 am |October 16, 2021 Linux
Leave a comment

An other errors of one of my costumer, trying to enjoy the Oracle backup and … Read More →

RMAN-08591: warning: invalid archived log deletion policy

By Wadhah DAOUEHI | November 1, 2020 - 11:39 am |October 16, 2021 Linux
Leave a comment

We want to share with you the solution of one of my costumer, trying to … Read More →

Password-Mode Decryption RMAN Backup

By Wadhah DAOUEHI | October 28, 2020 - 5:00 pm |October 17, 2021 Oracle, Oracle 12.2, Security
Leave a comment

For security reasons, after making an encryption RMAN backups, we can decrypt our backups using … 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 →

«‹89101112›»
  • Oracle ACE Pro


  • Oracle Certified Expert




  • Oracle Cloud Infrastructure


  • MySQL: Administrator Certified Professional


  • PostgreSQL: Certified Associate


  • Recent Posts

    • 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 19c: Interval Partitioning (2/2)
    • Oracle 19c: Interval Partitioning (1/2)
    • Oracle Database 19c: Shared Server mode
    • SYS.DBMS_BACKUP_RESTORE & SYS.DBMS_RCVMAN RMAN
Wadhah DAOUEHI | Powered by Mantra & WordPress.
LinkedIn YouTube Twitter