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

Category Archives: SQL

save SQLPLUS commands history on Linux within the package rlwrap (readline wapper).

By Wadhah DAOUEHI | August 3, 2016 - 4:42 pm |June 1, 2018 Linux, Oracle, SQL
Leave a comment

This article explains how to save SQLPLUS commands history on Linux within the package rlwrap … Read More →

Dealing with INVALID status of Oracle database components after upgrade to 12c (12.1.0.2)

By Wadhah DAOUEHI | August 31, 2015 - 11:38 pm |June 1, 2018 Linux, Oracle, Oracle Database, SQL
Leave a comment
Dealing with INVALID status of Oracle database components after upgrade to 12c (12.1.0.2)

This article deals with INVALID, OPTION OFF status of Oracle database components AMD, ORDIM, JAVAVM, … Read More →

Active Oracle database duplication

By Wadhah DAOUEHI | November 20, 2014 - 10:49 pm |June 1, 2018 Linux, Oracle, Oracle Database, SQL
Leave a comment

This article explains how to set up an Active Oracle database duplication with the RMAN … Read More →

Database SQL; Delete vs Truncate and segment size allocated

By Wadhah DAOUEHI | August 31, 2014 - 10:24 pm |June 1, 2018 Oracle, Oracle Database, SQL
Leave a comment

This article shows the differences between SQL commands delete and truncate in Oracle Database with … Read More →

  • Oracle ACE


  • Oracle Certified Expert




  • Oracle Cloud Infrastructure


  • MySQL: Administrator Certified Professional


  • PostgreSQL: Certified Associate


  • Recent Posts

    • Real-time cascading within Oracle Data Guard 12c
    • Deploy OEMCC 13c5 Agent In Silent Mode
    • Get OEMCC 13c5 Agent zip file
    • Oracle ACE
    • CRS-6706: After Grid Infrastructure upgrade from 19.3 to 19.12
    • 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
    • Upgrade the oracle Opatch
    • Check Oracle Clusterware patch release
    • Max 3 PDBs within 21c Standard Edition S2, not bad
    • Upgrade Oracle Home 19c (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
    • Create a Service Naming with NETMGR within Oracle 12.2
    • Create a Listener with NETMGR within Oracle 12.2
    • Convert Oracle Dedicaded to shared server
    • [DBT-12510] The database option ‘SAMPLE_SCHEMA’ is not feasible to be installed in the current Oracle home.
    • Convert Oracle RAC 19c Policy manager to Administrator managed
    • 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
Wadhah DAOUEHI | Powered by Mantra & WordPress.
LinkedIn YouTube Twitter