Apply the Latest DB RU Patch_19.25 36912597 for Oracle Database 19C
Mir Sayeed Hassan's Oracle Blog
by Mir Sayeed Hassan
3d ago
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 CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------------------------ 2 PDB$SEED READ ONLY NO 3 TEST_PDB READ WRITE NO 4 D2T_PDB Read More The post Apply the Latest DB RU Patch_19.25 36912597 for Oracle Database 19C appeared first on Mir Sayeed Hassan - Oracle Bl ..read more
Visit website
Apply the latest OPatch 6880880 (12.2.0.1.45) issued on Jan-2025 on 19C Database
Mir Sayeed Hassan's Oracle Blog
by Mir Sayeed Hassan
3d ago
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 lsinventory Oracle Interim Patch Installer version 12.2.0.1.42 Copyright (c) 2025, Oracle Corporation. All rights reserved. Oracle Home : Read More The post Apply the latest OPatch 6880880 (12.2.0.1.45) issued on Jan-2025 on 19C Database ap ..read more
Visit website
How to use the REUSE_DUMPFILES Parameter using expdp in Oracle database 19C
Mir Sayeed Hassan's Oracle Blog
by Mir Sayeed Hassan
2M ago
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 Check the database version. Read More The post How to use the REUSE_DUMPFILES Parameter using expdp in Oracle database 19C appeared first on Mir Sayeed Hassan - Oracle Blog ..read more
Visit website
How to export the dumpfile default directory location in Oracle database 19C
Mir Sayeed Hassan's Oracle Blog
by Mir Sayeed Hassan
2M ago
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 the default directory is “DATA_PUMP_DIR” and directory name convention as dumfile name “export.dmp” logfile name “export.log” Note: Read More The post How to export the dumpfile default directory location in Oracle database 19C appeared first on Mir Sayeed Hassan - Oracle Blog ..read more
Visit website
How to exclude the statistics, table_statistics, index_statistics when export of dumpfile in Oracle database 19C
Mir Sayeed Hassan's Oracle Blog
by Mir Sayeed Hassan
2M ago
How to exclude the statistics, table_statistics, index_statistics when export of dumpfile 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 Note: – Use the below parameter to exclude the statistics EXCLUDE=STATISTICS in expdp – This can be Read More The post How to exclude the statistics, table_statistics, index_statistics when export of dumpfile in Oracle database 19C appeared first on Mir Sayeed Hass ..read more
Visit website
How to use the METRICS Parameter by using expdp in Oracle database 19C
Mir Sayeed Hassan's Oracle Blog
by Mir Sayeed Hassan
2M ago
How to use the METRICS Parameter by using expdp in Oracle database 19C Brief: – This will give the information about the number of objects associated along with the elapsed time. – Default METRICS=N, To apply this Parameter use METRICS=Y Check the database version SYS> select name, status, open_mode, version from V$database, v$instance; NAME STATUS Read More The post How to use the METRICS Parameter by using expdp in Oracle database 19C appeared first on Mir Sayeed Hassan - Oracle Blog ..read more
Visit website
How to exclude the statistics, table_statistics, index_statistics when export of dumpfile in Oracle database 19C
Mir Sayeed Hassan's Oracle Blog
by Mir Sayeed Hassan
2M ago
How to exclude the statistics, table_statistics, index_statistics when export of dumpfile 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 Note: – Use the below parameter to exclude the statistics EXCLUDE=STATISTICS in expdp – This can be Read More The post How to exclude the statistics, table_statistics, index_statistics when export of dumpfile in Oracle database 19C appeared first on Mir Sayeed Hass ..read more
Visit website
How to export the dumpfile by using the LOGTIME parameter using expdp in Oracle database 19C
Mir Sayeed Hassan's Oracle Blog
by Mir Sayeed Hassan
2M ago
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 Read More The post How to export the dumpfile by using the LOGTIME parameter using expdp in Oracle database 19C appeared first on Mir Sayeed Hassan - Oracle Blog ..read more
Visit website
Error opening the PDB db as MAX_STRING_SIZE migration is incomplete for pluggable database PDB$SEED in Oracle 19C DB
Mir Sayeed Hassan's Oracle Blog
by Mir Sayeed Hassan
2M ago
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> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------------ 2 PDB$SEED Read More The post Error opening the PDB db as MAX_STRING_SIZE migration is incomplete for pluggable database PDB$SEED in Oracle 19C DB appeared first on Mi ..read more
Visit website
How to export the dumpfile backup into multiple directory in Oracle database 19C
Mir Sayeed Hassan's Oracle Blog
by Mir Sayeed Hassan
3M ago
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 is when the client requested to take the table/schema/fulldb dumpfile backup by using the multiple directory due Read More The post How to export the dumpfile backup into multiple directory in Oracle database 19C appeared first on Mir Sayeed Hassan - Oracle Blog ..read more
Visit website

Follow Mir Sayeed Hassan's Oracle Blog on FeedSpot

Continue with Google
Continue with Apple
OR