Mir Sayeed Hassan – Oracle Blog

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

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