Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me






  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39
  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

Patching Oracle Database 19C Release Update on April 2024 19.23 (p36233126) On Grid Infrastructure Standalone Server

Posted by Mir Sayeed Hassan on May 29th, 2024

Apply Patching Oracle Database 19C Release Update on April 2024 19.23 (p36233126) On Grid Infrastructure Standalone Server.

Check the status of Database

[oracle@stagdb1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed May 15 01:11:01 2024 
Version 19.22.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected... 
Read more..

Posted in DB Patch | Comments Off on Patching Oracle Database 19C Release Update on April 2024 19.23 (p36233126) On Grid Infrastructure Standalone Server

Patching Oracle Database 19C Release Update on April 2024 19.23 (p36233263) on Single Instance Database

Posted by Mir Sayeed Hassan on May 29th, 2024

Patching Oracle Database 19C Release Update on April 2024 19.23 (p36233263) on Single Instance Database

Check the status of Database

SQL> select instance_name, version, open_mode from V$database, v$instance;

INSTANCE_NAME    VERSION       OPEN_MODE
---------------- ------------------------
peptestdb       19.0.0.0.0    READ WRITE

Verify...
Read more..

Posted in DB Patch | Comments Off on Patching Oracle Database 19C Release Update on April 2024 19.23 (p36233263) on Single Instance Database

Patching Oracle Database 19C Grid Infrastructure on Standalone server for Patch_19.22 (p35940989)

Posted by Mir Sayeed Hassan on May 19th, 2024

Patching Oracle Database 19C Grid Infrastructure on Standalone server for Patch_19.22 (p35940989)

Check the status of Database

[oracle@stagdb1 ~]$ sqlplus / as sysdba

SQL> select instance_name, version, open_mode from V$database, v$instance;

INSTANCE_NAME    VERSION        OPEN_MODE
---------------- ---------------------------
DBSTAGE  ... 
Read more..

Posted in DB Patch | Comments Off on Patching Oracle Database 19C Grid Infrastructure on Standalone server for Patch_19.22 (p35940989)

APPLY THE LATEST OPTACH (12.2.0.1.42) ON 19C DATABASE

Posted by Mir Sayeed Hassan on May 12th, 2024

APPLY THE LATEST OPTACH (12.2.0.1.42) ON 19C DATABASE

Check the status of Database

SQL> select instance_name, version, open_mode from v$database, v$instance;

INSTANCE_NAME     VERSION        OPEN_MODE
---------------- ---------------------------
testdb1          19.0.0.0.0      READ WRITE

Check the last updated OPatch

[oracle@testdb... 
Read more..

Posted in DB Patch | Comments Off on APPLY THE LATEST OPTACH (12.2.0.1.42) ON 19C DATABASE

Export the data by using the where clause from Pluggable database in Oracle 19C

Posted by Mir Sayeed Hassan on May 12th, 2024

Export the data by using the where clause from Pluggable database in Oracle 19C

Check the database status

SQL> select instance_name,version, open_mode from V$instance, v$database;

INSTANCE_NAME    VERSION        OPEN_MODE
---------------- --------------------------
prod1db         19.0.0.0.0      READ WRITE

Check the CDB & PDB...
Read more..

Posted in Datapump (Expdp/Impdp) | Comments Off on Export the data by using the where clause from Pluggable database in Oracle 19C

Encrypting Pluggable database in Oracle 19c by using the Oracle Transparent Data Encryption (TDE)

Posted by Mir Sayeed Hassan on April 23rd, 2024

Encrypting Pluggable database in Oracle 19c by using the Oracle Transparent Data Encryption (TDE).

Here will implement Transparent Data Encryption method in our Oracle 19c Test Environment, The Database should contain the Pluggable database init.

Check the database status, name , version of Oracle database

SYS @ ora19cdb > select status,version,... 
Read more..

Posted in DBA Administration | Comments Off on Encrypting Pluggable database in Oracle 19c by using the Oracle Transparent Data Encryption (TDE)