SCRIPTS

How to Find Current SCN in Oracle 0 (0)

December 26, 2022

How to Find Current SCN in Oracle In this acrticle, we will demonstrate different ways to find current SCN in Oracle. Follow the below SQLs to find SCN in Oracle….

Loading

๐Ÿ“Œ
0๐Ÿ’ฌ read more

Solution for ORA-00600: Internal Error Code, Arguments: [4193] [2206] in Oracle 0 (0)

October 9, 2022

Solution for ORA-00600: Internal Error Code, Arguments: [4193] [2206} in Oracle In this post we will see How to solve ORA-00600: Internal Error Code, Arguments: [4193] [2206], You can encounter…

Loading

๐Ÿ“Œ
0๐Ÿ’ฌ read more

Oracle Database Appliance Odacli & Odaadmcli Command reference 0 (0)

September 21, 2022

Oracle Database Appliance Odacli & Odaadmcli Command reference In this blog, we will demonstrate several different usages of odacli, odaadmcli & virsh commands along with some commands output that can…

Loading

๐Ÿ“Œ
0๐Ÿ’ฌ read more

How to Find Database Properties in Oracle 0 (0)

May 6, 2022

How to Find Database Properties in Oracle In this article, we will prepare a script for How to Find Database Properties in Oracle. Using the view DATABASE_PROPERTIES, we can fetch…

Loading

๐Ÿ“Œ
0๐Ÿ’ฌ read more

RMAN Incremental Level 1 Differential and Cumulative Database Backup Scripts in Oracle 0 (0)

October 7, 2021

RMAN Incremental Level 1 Differential and Cumulative Database Backup Scripts in Oracle In this article, we are going to prepare a script for RMAN Incremental and differential Level 1 (L1) database…

Loading

๐Ÿ“Œ
0๐Ÿ’ฌ read more

How to Enable & Disable Block Change Tracking (BCT) in Database Oracle 5 (1)

September 29, 2021

How to Enable & Disable Block Change Tracking in Database Oracle In this article, we will demonstrate How to Enable & Disable Block Change Tracking in Database Oracle. Block change…

Loading

๐Ÿ“Œ
0๐Ÿ’ฌ read more

RMAN Incremental Level 0 Database Backup Scripts in Oracle 1 (1)

September 28, 2021

RMAN Incremental Level 0 Database Backup Scripts in Oracle In this article, we are going to prepare a script for RMAN Incremental Level 0 (L0) database backup which includes backup of…

Loading

๐Ÿ“Œ
2๐Ÿ’ฌ read more

How to Find all Physicals Files in Multitenant Architecture CDB and PDB DATABASE in Oracle 5 (1)

September 21, 2021

How to Find all Physicals Files in Multinanent Architecture CDB and PDB DATABASE in Oracle Below is the command, how to find all physical files in Oracle in one short…

Loading

๐Ÿ“Œ
0๐Ÿ’ฌ read more

How to Find ROLE Creation Date in Oracle 5 (1)

August 12, 2021

How to Find Role Creation Date in Oracle In this article, we will prepare an SQL command for How to Find ROLE Creation Date in Oracle. View DBA_ROLES doesn’t have…

Loading

๐Ÿ“Œ
0๐Ÿ’ฌ read more

Validate Applied Patches in Database Oracle 19c 5 (1)

August 10, 2021

Validate Applied Patches in Database Oracle 19c In this article, we are going to demonstrate validate applied patches in Oracle 19c and 12c on both ORACLE HOME & DATABASE using…

Loading

๐Ÿ“Œ
0๐Ÿ’ฌ read more