ASRblogger

How to check Tablespace Utilization in Oracle ?

Hey Folks, As a DBA, performing routine checks for tablespace monitoring is a fundamental task. Here are some scripts that can assist in monitoring tablespace usage within the database. set…

asrblogger November 17, 2024No Comments

BigData Data Engineering

Install and Configure OpenSearch & OpenSearch Dashboard

OpenSearch is a community-driven, open-source search and analytics suite used by developers to ingest, search, visualize, and analyze data. OpenSearch consists of a data store and search engine (OpenSearch), a…

Avnish Singh September 29, 2024No Comments

ASM Oracle

How to Rename ASM Diskgroup ??

Hey Folks, Today I faced an issue while configuring Oracle DR setup which was due to different diskgroup present in primary (DGDATA) and standby (DATA). While running Active duplicate command…

asrblogger September 14, 2024No Comments

Oracle Scripts

How to Create & Delete Symbolic Link (Symlink)?

A symlink is a symbolic Linux/ UNIX is a special kind of file that points to another file on your machine/server, or a connected file system. It similar to a…

asrblogger September 14, 2024No Comments

DataGuard Oracle Scripts

Steps to Startup & Shutdown Oracle Data Guard !

To start a physical standby database, follow these steps using SQL*Plus with administrator privileges: Start the database in NOMOUNT mode: Use the STARTUP NOMOUNT command to initialize the standby database.…

asrblogger September 14, 2024No Comments

DataGuard Oracle Scripts

How to Check Sync between Primary & Standby DB ??

Primary --Check DB role (PRIMARY/STANDBY) SELECT DATABASE_ROLE, DB_UNIQUE_NAME AS INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE; DATABASE_ROLE INSTANCE OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL SWITCHOVER_STATUS ---------------- ------------------------------ -------------------- -------------------- -------------------- -------------------- PRIMARY pvtnddb…

asrblogger September 14, 2024No Comments

Oracle

Better error messages in Oracle 23ai !!

Hey Folks !! With the enhancement in Oracle 23ai features one of the beautiful thing which we can see is to get a descriptive error messages which was not present…

asrblogger August 16, 2024No Comments

Oracle

Enhanced Querying: Eliminating the “FROM DUAL” Clause in Oracle Database 23ai !!

Hey Folks !! Oracle Database 23c, the latest long-term support release, brings over 300 new features, with a focus on three key areas:1. AI for Data2. Dev for Data3. Mission-Critical…

asrblogger August 16, 2024No Comments

Oracle

What is the difference between Prepatch and Postpatch in Oracle Patching !!

Hey Folks !! In Oracle patching, the terms prepatch and postpatch refer to specific sets of tasks or procedures that need to be performed before and after applying a patch…

asrblogger August 14, 2024No Comments

Oracle

How to identify the top Wait Events within a Wait Class in Oracle ??

Each wait event in Oracle belongs to a specific class. Below is a breakdown of the various wait classes and their descriptions:1. Administrative These waits occur due to DBA commands…