Posted by Mir Sayeed Hassan on February 12th, 2025
Apply Patching Oracle Database 19C release Update on OCT 2024 19.25 (p36916690) On Grid Infrastructure Standalone Server.
Check the status of Database
[oracle@Paymentdb ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Feb 12 14:27:08 2025
Version 19.23.0.0.0
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Connected...
Read more..
Posted in DB Patch | Comments Off on Apply Patching Oracle Database 19C release Update on OCT 2024 19.25 (p36916690) On Grid Infrastructure Standalone Server.
Posted by Mir Sayeed Hassan on February 11th, 2025
APPLY THE LATEST OPTACH 6880880 (12.2.0.1.45) ON Grid Infrastructure 19C DATABASE
Check the status of database
SQL> select instance_name, version, open_mode from v$database, v$instance;
INSTANCE_NAME VERSION OPEN_MODE
------------------------------------------
ora19ctdb1 19.0.0.0.0 READ WRITE
Check existing OPatch applied.
[oracle@payment-dbs...
Read more..
Posted in DB Patch | Comments Off on APPLY THE LATEST OPTACH 6880880 (12.2.0.1.45) on Grid Infrastructure 19C DATABASE
Posted by Mir Sayeed Hassan on February 4th, 2025
Apply the Latest DB RU Patch_19.25 36912597 for Oracle Database 19C
Check the status of Database
SQL> select instance_name, version, open_mode from V$database, v$instance;
INSTANCE_NAME VERSION OPEN_MODE
---------------- ------------------------------------
ora19cdb 19.0.0.0.0 READ WRITE
SQL> show pdbs
CON_ID...
Read more..
Posted in DB Patch | Comments Off on Apply the Latest DB RU Patch_19.25 36912597 for Oracle Database 19C
Posted by Mir Sayeed Hassan on January 29th, 2025
Apply the latest OPatch 6880880 (12.2.0.1.45) issued on Jan-2025 on 19C Database
SQL> select instance_name, version, open_mode from v$database, v$instance;
INSTANCE_NAME VERSION OPEN_MODE
---------------- ----------------- --------------------
ora19ctdb1 19.0.0.0.0 READ WRITE
Check existing OPatch applied.
[oracle@ora19ctdb ~]$ $ORACLE_HOME/OPatch/opatch...
Read more..
Posted in Patching | Comments Off on Apply the latest OPatch 6880880 (12.2.0.1.45) issued on Jan-2025 on 19C Database
Posted by Mir Sayeed Hassan on December 8th, 2024
How to use the REUSE_DUMPFILES Parameter using expdp in Oracle database 19C
Brief: – In case if you use existing dumpfile name, you will get an error as its already exists, To overcome this use this REUSE_DUMPFILES=YES parameter to overwrite the existing dumpfile name without error.
– By default is REUSE_DUMPFILES=NO
Posted in Datapump (Expdp/Impdp) | Comments Off on How to use the REUSE_DUMPFILES Parameter using expdp in Oracle database 19C
Posted by Mir Sayeed Hassan on December 8th, 2024
How to export the dumpfile default directory location in Oracle database 19C
Check the database version
SYS> select name, status, open_mode, version from V$database, v$instance;
NAME STATUS OPEN_MODE VERSION
----------------------------------------------
ORA19CDB OPEN READ WRITE 19.0.0.0.0
Posted in Datapump (Expdp/Impdp) | Comments Off on How to export the dumpfile default directory location in Oracle database 19C
