Posts by Vijay B

File Share Witness server Offline Issue in SQL Server.

1. Introduction This document provides a detailed investigation and resolution report for the File Share Witness server issue observed in the failover cluster for the server TEST. It outlines the findings, steps…

Read More

Queue enable issue in SQL Server

Introduction This document provides a detailed procedure for diagnosing and resolving the issue of a SQL Server queue that automatically disables itself after being re-enabled. This behavior is often caused…

Read More

SQL Server Maintenance Plan

Introduction: A SQL Server Maintenance Plan is an essential strategy for managing and optimizing the performance of your SQL Server databases. These plans are designed to automate routine database management…

Read More

SQL DB Linked Servers

Introduction:  SQL Server Linked Servers is a feature in Microsoft SQL Server that allows you to connect and execute commands against OLE DB data sources on different servers. This functionality…

Read More

Create users and assign access in DynamoDB

Introduction: Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. When working with DynamoDB, creating users and assigning access rights is…

Read More

Steps to backup Dynamo DB

Introduction: DynamoDB, Amazon’s managed NoSQL database service, is a scalable and highly available solution for storing and retrieving data. Despite its robust infrastructure, it is essential to implement regular backups…

Read More

Delete 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

Autoconfig Completed with error issue in applptmp

Autoconfig Completed with error issue in applptmp Introduction: The objective of this blog is to overcome an error while running autoconfig in oracle EBS 12.2.10 application tier. While running autoconfig in application tier…

Read More

TABLE RECOVERY USING RMAN BACKUP

Objective is to recover a table using the database and archive log backup with the help of timestamp and backup destination. Here, As an example we have an database user…

Read More

In order to up multiple Apex application in a single instance.

The objective of this blog is to start multiple apex application in a single instance. While doing so, we get an issue in apex applications.   Issue: We have about…

Read More