Oracle

I will share with you Step by Step Oracle Tutorial | Oracle Database Tutorials for Beginners in this post.

Summary: The Master database is a very important database because it holds the primary configuration of the SQL database. But in case if it is corrupted then the user has …

You should set STREAM_POOL_SIZE  2gb Disk quality and network bandwith should be high. You should add heartbeat source and target to analyezed lag. You should add batchsql , groupstransops 180000 …

  Hi ,   General errors and solutions for goldengate operations   1-) After goldengate upgrade from 12c to 19c , mapping error for replicat. You should add keycols parameter …

Hi, Sometimes You can get “RMAN-06941: Database must be closed and mounted EXCLUSIVE and RESTRICTED. ” error.

I will explain How to Add Disks to ASM Disk Group in Oracle with ALTER DISKGROUP DATA ADD DISK Command in this post. Let’s review the Add and drop Disks …

Hi, I will explain _ALLOW_RESETLOGS_CORRUPTION Parameter Usage in Case of Corruption in this post.

Hi Folks,   Conversion functions convert a value from one datatype to another. Generally, the form of the function names follows the convention datatype TO datatype. The NULL-related functions facilitate …

Hi, I will explain How to Apply PSU Patch in Oracle and Patch Apply Steps in this post. I will show you How to Apply PSU Patch in Oracle and …

Hi Folks,   Datetime functions operate on date (DATE), timestamp (TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE), and interval (INTERVAL DAY TO SECOND, INTERVAL YEAR TO …