Untitled

[sandeep2363]

Kubernetes Deployment: Create and Manage YAML Files

Create a manifest file with command for deployment in Kubernet To deploy an Nginx application in Kubernetes, create a manifest file using the command “kubectl create deployment ngnix –image=ngnix –dry-run=client -o yaml > deploymentngnix.yaml.” Deploy the pod with “kubectl apply -f deploymentngnix.yaml,” verify using “kubectl get pods,” and delete resources with “kubectl delete -f…

[sandeep2363]

Kubernetes Dry Run Explained: Client and Server Modes

What is Dry Run? kubectl --dry-run lets you test a command without actually creating/updating resources. Types of Dry Run 1. Client Side (--dry-run=client) Use kubectl dry-run for client side validation of a manifest. Runs locally (no cluster call) Just checks syntax Does NOT validate with Kubernetes server kubectl create deployment my-app --image=nginx --dry-run=client -o yamlORKubectl…

[sandeep2363]

How to Use Kubectl for Cluster Management | listing resources | using kubectl explain

Essentials of Managing Kubernetes Contexts Get information about our current cluster context. Ensure we are login to correct cluster. Note: * mark on cluster which we are on in output of the command kubectl config get-contexts Change our context if needed by specify name kubectl config use-context <name> Get information about the API server for our current context kubectl cluster-info Get…

[sandeep2363]

Identifying Existing Docker Subnets

To display all configured Docker network subnets: docker network inspect $(docker network ls -q) | grep Subnet You can also list available Docker networks: docker network ls Inspect a specific network: docker network inspect <network_name> Example: docker network inspect bridge Choosing a Free Subnet Each interconnect network must use a unique subnet. Example: docker network create \…

[sandeep2363]

Display All Docker Networks and Subnets

Find the all docker network details The following command displays network names along with their subnet information: docker network inspect $(docker network ls -q) \| grep -E &apos;"Subnet"|Name&apos; This is useful for quickly identifying available address ranges before creating new Oracle RAC networks. Example: ubuntu01@ubuntu01-VirtualBox:/opt/.secrets$ docker network inspect $(docker…

[sandeep2363]

Troubleshooting AWS EventBridge EFS Restore Alerts

Overview While configuring EFS restore alerts via AWS Backup → EventBridge → SNS, you may face a situation where: ✅ Broad rules work (source: aws.backup)❌ Filtered rules do NOT trigger❌ No alert received for restore Even when configuration looks correct. Problem Scenario Working rule: Create this rule first as it activates on every event. This will assist in identifying whether the issue is…

[sandeep2363]

SQL Server STRING_SPLIT – Simple Explanation with Examples

1. What is STRING_SPLIT? STRING_SPLIT is a built-in function in SQL Server used to: 👉 Break a single string into multiple rows👉 Based on a separator (like ,, |, -, space, etc.) It returns a table of values (rows) where each part of the string becomes a row. Simple: STRING_SPLIT is a table-valued function that converts a delimited string into multiple rows based on a single-character…

[sandeep2363]

Oracle Database Architecture Explained | SGA, PGA & Background Processes

Oracle memory architecture is one of the most important concepts for DBAs.Every SQL query, transaction, and user connection uses Oracle memory internally. Oracle memory architecture mainly consists of: SGA – System Global Area PGA – Program Global Area Background ProcessesReal-time Example:Think of Oracle Database like a large company office.- SGA = Shared office area used by all employees.-…

View On WordPress

[sandeep2363]

Oracle Space Advisory and Segment Advisor Tutorial

How to Reclaim Unused Space in Oracle Database Oracle Space Advisory and Segment Advisor Tutorial Managing storage efficiently is one of the most important responsibilities of an Oracle DBA. As databases grow, tablespaces become full, objects consume unnecessary storage, and performance may degrade due to poor space management. Oracle provides powerful tools such as Space Advisory and Segment…

[sandeep2363]

How to Run SQL Tuning Advisor in Oracle Database – Step-by-Step Practical Guide

Performance tuning is one of the most important responsibilities of an Oracle DBA. Slow SQL queries can affect application performance, increase server load, and impact end users. Oracle provides a powerful built-in utility called SQL Tuning Advisor that helps identify performance problems and recommends solutions automatically. In this article, we will learn how to run SQL Tuning Advisor in…

[sandeep2363]

Understanding STRING_SPLIT in SQL Server

What is STRING_SPLIT? STRING_SPLIT is a built-in function in SQL Server that helps you: 👉 Break a single string into multiple rows👉 Based on a separator (like comma ,, pipe |, etc.) Real-Life Example Suppose you have a string: ‘Apple,Banana,Orange’ Then pass this string to the SQL Server STRING_SPLIT function then you get the following results: AppleBananaOrange Syntax STRING_SPLIT (…

[sandeep2363]

Check the error detail in Oracle Dataguard

One of my Dataguard Server is out of sync and even its is resolvable gap but i want to know the error which causing the issue. So that i know the root cause to avoid that problem in future. Error select status,gap_Status from v$archive_Dest_Status where dest_id=2;STATUS GAP_STATUS--------- ------------------------ERROR RESOLVABLE GAP Solution: To get the error detail: SELECT dest_id, status,…

[sandeep2363]

Understand how Oracle GoldenGate (OGG) works with tables lacking Primary/unique keys

How Lack of Primary Keys Affects GoldenGate Replication Oracle GoldenGate works best when tables have a Primary Key (PK) or Unique Index (UI).If a table does not have a unique way to identify each row, GoldenGate: Tries its best to guess which row to update or delete May update the wrong row Can make source and target data go out of sync How updates really work If no key or index exists,…

[sandeep2363]

Oracle EXPDP INCLUDE & EXCLUDE – Complete Guide with Working Commands

Oracle Data Pump (EXPDP) provides powerful options to control what gets exported using INCLUDE and EXCLUDE. In this blog, we’ll cover: What INCLUDE and EXCLUDE are Correct syntax (command line + parfile) Single and multiple object filtering Common errors and fixes Best practices used by DBAs What is INCLUDE and EXCLUDE? INCLUDE → Export only selected objects EXCLUDE → Export everything…

[sandeep2363]

ORA-12154: Cannot connect to database. Cannot find alias pdbnew

Created a new pluggable database but when try to connect it. I am getting the below error: Error [oracle@localhost dbbackup]$ sqlplus system@pdbnew SQL*Plus: Release 23.26.0.0.0 – Production on Sat Apr 18 13:14:22 2026Version 23.26.0.0.0 Copyright (c) 1982, 2025, Oracle. All rights reserved. Enter password:ERROR:ORA-12154: Cannot connect to database. Cannot find alias pdbnew…

View On WordPress

[sandeep2363]

Mastering Oracle User Profiles: A Guide to Unlimited Access and Security

In the world of Oracle Database administration, managing how users connect and how their passwords behave is a critical security task. By default, Oracle imposes restrictions to protect the database, but there are scenarios—such as configuring service accounts or development environments—where you need to grant unlimited access and unlimited login attempts. In this guide, we will walk through…

[sandeep2363]

ORA-16047: DGID mismatch between destination setting and target database

ERROR SQL> SELECT status, gap_status, error FROM v$archive_dest_status WHERE dest_id=2;STATUS GAP_STATUSERRORERROR RESOLVABLE GAPORA-16047: DGID mismatch between destination setting and targetdatabase Cause: Primary and Standby DB are NOT matching (DB_UNIQUE_NAME / DBID mismatch) Solution: Fix (Step-by-Step) 🔹 Step 1: Check both DB_UNIQUE_NAME Run on PRIMARY: show parameter…