Dear Readers, In this article, we will see the following Realtime Usecase. Realtime Usecase : My Client swiggy wants to administrate theri technical Engineers as follows. They have team such as Developers,Database Admins,Linux Admins and storage admins.All the team should be in two levles L1… Read More
Hi Dears, In this article, we will see Install Oracle VM Virtual Box On Windows. Oracle VirtualBox Oracle VM VirtualBox is a free, open-source, cross-platform application for creating, managing and running virtual machines (VMs). Virtual machines are computers whose hardware components are emulated by the… Read More
How to drop a two-node Oracle RAC database database manually. In this article, we wrote an Clear steps for dropping a two node oracle database with Pre-requisite steps. Server: sewnpossqa01/02 Database : npossqa1 DB Unique name: sewnpossqa1 Step 1: Take consistent export of NPOSSQA1 database… Read More
Dear Readers, In this article, we will see the following Real-Time Use Case On Storage. Realtime Usecase : My Client, Nokia needs a Windows Server for Data Storage. So Launch a Server with three Additional Volumes. Volume capacities should be 10GB & 5GB. Duplicate the… Read More
Dear Readers, In this article, we wrote an automation job for Shell Script to gather stats for Stale tables. Note : 1) Please test the Shell script in Non-Prod before implementing it in Production. Script for gather stats for Stale tables #!/bin/bash function PreChks {… Read More
Dear Readers, Please check the below articles to get good knowledge on Oracle Architecture. SNO Article Name Article Link 1 Startup and Shutdown modes in Oracle https://www.ktexperts.com/startup-and-shutdown-modes-in-oracle/ 2 ORACLE ARCHITECTURE -4(PHYSICAL REPRESENTATION OF DATABASE) https://www.ktexperts.com/oracle-architecture-4physical-representation-of-database/ 3 ORACLE OPTIONAL BACKGROUND PROCESSES https://www.ktexperts.com/oracle-optional-background-processes/ 4 ORACLE ARCHITECTURE -2… Read More
Dear Readers, Please check the below articles to get good knowledge on Oracle Partitioning. SNO Article Name Article Link 1 Partition https://www.ktexperts.com/partition/ 2 Oracle : Partitioning using online Redefinition method which requires minimal downtime https://www.ktexperts.com/oracle-partitioning-using-online-redefinition-method-which-requires-minimal-downtime/ 3 Oracle : High Level steps for Partitioning a non… Read More
Dear Readers, Please check the below articles to get good knowledge on Oracle ASM. SNO Article Name Article Link 1 Oracle : Rename ASM Disk Label in Oracle 12c (RAC) https://www.ktexperts.com/oracle-rename-disk-label-rac/ 2 Oracle : Add ASM Disks to existing Diskgroup (RAC) https://www.ktexperts.com/oracle-add-asm-disks-to-existing-diskgroup/ 3 Oracle :… Read More
Dear Readers, Please check the below articles to get good knowledge on Oracle Tablespaces. SNO Article Name Article Link 1 Tablespace Management in Oracle. https://www.ktexperts.com/tablespace-management-in-oracle/ 2 Oracle : Storage Management https://www.ktexperts.com/oracle-storage-management/ 3 Transportable Tablespace between two pluggable database(PDB’s) https://www.ktexperts.com/transportable-tablespace-between-two-pluggable-databasepdbs/ 4 ORACLE: Cross Platform Transportable Tablespace… Read More
Dear Readers, Please check the below articles to get good knowledge on RMAN (Recovery Manager). SNO Article Name Article Link 1 How to add Container database to Existing RMAN Recovery catalog https://www.ktexperts.com/how-to-add-container-database-to-existing-rman-recovery-catalog/ 2 How to Create an RMAN Recovery Catalog https://www.ktexperts.com/how-to-create-an-rman-recovery-catalog/ 3 Cloning a Standalone… Read More
Dear Readers, Please check the below articles to get good knowledge on Oracle 18c. SNO Article Name Article Link 1 Oracle 18c New Features for DBA’s https://www.ktexperts.com/oracle-18c-new-features-for-dbas/ 2 Oracle 18C new feature: Private Temporary Tables https://www.ktexperts.com/oracle-18c-new-feature-private-temporary-tables/ 3 Oracle 18C new feature: Cancel SQL instead of… Read More
Dear Readers, Please check the below articles to get good knowledge on Data Pump (Export & Import). SNO Article Name Article Link 1 How to Kill & Trace Datapunp Job https://www.ktexperts.com/how-to-kill-trace-datapunp-job/ 2 How to Generate DDL from existing dumpfile https://www.ktexperts.com/how-to-generate-ddl-from-existing-dumpfile/ 3 How to utilize PARFILE… Read More
Dear Readers, Please check the below articles to get good knowledge on Oracle DataGuard Articles. SNO Article Name Article Link 1 Step By Step Configuration of Oracle DGMGRL Utility https://www.ktexperts.com/step-by-step-configuration-of-oracle-dgmgrl-utility/ 2 Oracle Physical Standby Data guard in 11g https://www.ktexperts.com/oracle-physical-standby-data-guard-in-11g/ 3 Switchover and Switchback in Oracle… Read More
Dear Readers, Please check the below articles to get good knowledge on Oracle Production Support Scripts. SNO Article Name Article Link 1 Oracle : Check Partition Summary More than N Days (60 Days) https://www.ktexperts.com/oracle-partition-check-summary-more-than-n-days-60-days/ 2 UNDO segments not Releasing Space https://www.ktexperts.com/undo-segments-not-releasing-space/ 3 Oracle : How… Read More
Dear Readers, Please check the below articles to get good knowledge on Performance Tuning. SNO Article Name Article Link 1 Autonomous Health Framework https://www.ktexperts.com/autonomous-health-framework/ 2 Oracle: Free Buffer Wait https://www.ktexperts.com/oracle-free-buffer-wait/ 3 Internal mechanism of Buffer Cache https://www.ktexperts.com/internal-mechanism-of-buffer-cache/ 4 Performance Investigation(Database / SQL) https://www.ktexperts.com/performance-investigation-database-sql/ 5 Oracle:… Read More
Dear Readers, In this article, we will see the following Create AWS EC2 Instance Using Cloud Formation. Steps to Follow : Logging to AWS Account Create a Key Pair Create Stack for creating AWS EC2 Verify EC2 Instance Graphically Connect to EC2 Instance Using Putty… Read More
Dear Readers, This article will see the following Create and configure a virtual cloud network(VCN) by using VCN Wizard. By using this option VCN will create with below-added resources by default Includes: ➸ VCN ➸ Public subnet ➸ Private subnet ➸ Internet gateway (IG) ➸… Read More
Dear Readers, This article will see the following Table Restore Depends On Time in Oracle. We receive requests from the requester stating that they have lost data of some tables and want us to restore it. As it is a time-consuming method to restore the… Read More
Dear Readers, This article will see the following Change DBID in Oracle. NID is the tool that is used to change DBID or database name. Before changing the NID safer side take the backup of the database, and related files dependent on DB. [root@detedb1 ~]$… Read More
Dear Readers, This article will see the following Create and configure a virtual cloud network(VCN). Sign in to Oracle Cloud Infrastructure Console using your cloud tenant name, user name, and password. From the OCI services menu, click Virtual Cloud Networks under Networking. Choose the appropriate… Read More
