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
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
Posted in DB Patch | Comments Off on Patching Oracle Database 19C Release Update on April 2024 19.23 (p36233263) on Single Instance Database
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)
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
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
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)