Mir Sayeed Hassan – Oracle Blog

How to export the dumpfile by using the LOGTIME parameter using expdp in Oracle database 19C

Brief: – This parameter LOGTIME give us the timestamp for each and every export operation during expdp., therefore its easy to check the diagnise/elapsed time taken for execution.
– By default LOGTIME=NONE, If you want to use this feature use this parameter...
Read more..

Error opening the PDB db as MAX_STRING_SIZE migration is incomplete for pluggable database PDB$SEED in Oracle 19C DB

Check the database version

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

NAME       OPEN_MODE       VERSION
--------------------------------------
PEPTEST    READ WRITE     19.0.0.0.0

Check the CDB & PDBS

SQL>... 
Read more..			

How to export the dumpfile backup into multiple directory 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

This scenario...
Read more..

How to create a logical directory in Oracle Database 19C for Export & Import (expdp/impdp)

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

Login...
Read more..

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

The name of...
Read more..

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..