Create a login using SSMS for SQL Server
To use SQL Server, you need a login. You can log in using a regular Windows account or a special SQL Server account. SQL Server Supports two Authentication Modes:…
Read MoreDemystifying Load Balancer Setup in Oracle Cloud Infrastructure (OCI)
Demystifying Load Balancer Setup in Oracle Cloud Infrastructure (OCI) Introduction Load Balancing allows customers to distribute web requests among a group…
Read MoreComprehensive Guide: Removing and Adding RAC Nodes in Oracle Clusterware
Overview Diving into the intricacies of Oracle Clusterware management, this comprehensive guide elucidates the meticulous steps involved in the process of deleting and adding RAC nodes within the Oracle environment. …
Read MoreTroubleshooting and Resolving ‘CheckApplicable’ Prerequisite Error When Applying Oracle GI RU July-2023 Patch
Overview of blog In this blog post, we will explore a comprehensive solution to resolve the issue of ‘oracle.rdbms.deconfig, 19.0.0.0.0’: Cannot delete file ‘/usr/local/oracle/19.3.0.0/suptools/tfa’ and the subsequent ‘CheckApplicable’ prerequisite failure.…
Read MoreManual Failover of Oracle Data Guard
A failover is performed only when the primary database becomes unavailable, and there is no possibility of recovering the primary database. Steps involve in failover Connect to Physical Standby…
Read MoreFortifying Oracle Identity Cloud Service with Multifactor Authentication (MFA)
Fortifying Oracle Identity Cloud Service with Multifactor Authentication (MFA) Introduction Oracle Identity Cloud Service employs MFA, where users utilize two-factor verification, incorporating extra information or a second device during logins…
Read MoreHARNESSING BLOCK CHANGE TRACKING FOR ENHANCED PERFORMANCE
Block changing tracking improves the performance of incremental backups by recording changed blocks in the block change tracking file. During an incremental backup, instead of scanning all data blocks to identify which blocks have changed, RMAN uses this file to identify the changed blocks that need to be backed up. TO ENSURE THE CURRENT PERFORMANCE OF INCREMENTAL BACKUPS: SQL> select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,’mm/dd/yy hh24:mi’) start_time, to_char(END_TIME,’mm/dd/yy hh24:mi’) end_time, elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS order by session_key; The above command will show the performance of daily incremental backups. i.e., How many hours the database backup is running before enabling the block change tracking. TO ENSURE THE BLOCK CHANGE TRACKING IS ENABLED IN THE DATABASE: SQL> select status, filename from v$block_change_tracking; It will show the block change tracking is enabled in our database or not. If it shows disabled, we want to enable the parameter by issue the below command. SQL> alter database enable block change tracking; NOTE:- After enables the BLOCK_CHANGE_TRACKING, wait for a day to complete the database backup. Then issue the above command to ensure the incremental backup performance. It will show you the positive differences compares to the earliest performance.
Read MoreORA-20004:ERROR IN SENDING AN EMAIL IN APEX
ORA-20004: Error in sending an Email – You have exceeded the maximum number of email messages per workspace. Please contact your administrator. REASON: Actually, Number of mails can be sent…
Read MoreODA (Oracle Database Appliance) Monitoring commands
Hardware monitoring commands: – Display information about the environment and hardware:- odaadmcli show env_hw Display information about the filesystem:- odaadmcli show fs Display information about the Memory:- odaadmcli show memory…
Read MoreDelete Archive logs in primary database and then sync primary and standby databases.
Delete Archive logs in primary database and then sync primary and standby databases. Introduction: This article delves into the careful process of deleting archive logs in a primary database and…
Read More