Click on below given link to download the document: 1: Important_Frequently_Ask_Oracle_SQL_Interview_Queries_With_Solutions-(Set1) Password For Opening Document : Airydba@159 Thank you for Reading…This is AIRY…Enjoy 🙂
Adding an additional disk to Linux Machine
Adding an additional disk to Linux Machine: In one of my Oracle RAC practical, I got shortage of disk space in my Linux machine so I have decided to add one more…
Oracle 12c R1 New Features For DBAs
Oracle 12c R1 New Features For DBAs : 1: Enterprise Manager and Other Tools Enterprise Manager (EM) Cloud Control home page Enterprise Manager Express home page versus Enterprise Manager Database Control SQL…
DNS Server Configuration For Oracle-RAC in RHEL 5/6/7- Airy’s notes
DNS Configuration: IP Addresses and other settings: DNS Server Details: 3 Nodes Details: Node1: Node2: Node3: Work To be performed on Machine on which DNS to be configure: Orignal “/etc/named.conf” file :…
Generating Automatic Workload Repository Reports
Generating Automatic Workload Repository Reports: Oracle provide following scripts to produce Automatic workload repository reports . They are similar in format to the statspack reports and give the option of HTML or plain text formats. The…
Introduction of Automatic Workload Repository (AWR)
Automatic Workload Repository (AWR) in Oracle 11g : Oracle has provided many performance gathering and reporting tools time to time. Before oracle 8i UTLBSTAT / UTLESTAT scripts were used to monitor performance…
Automatic Workload Repository Views
Automatic Workload Repository Views : Historical data (snapshot) stored in AWR can be seen using the following views: Thank you for reading …..This is Airy…Enjoy 🙂
Deleting a Node from RAC
Click on Below given link to get the step by step process to Delete a Node from RAC. Deleting-A-Node-from-cluster-By-AIRYDBA Password for opening the document is : Airydba@159 Thank you for reading… This…
Adding 3rd Node in RAC using addnode.sh
Click on Below given link to get the step by step Adding 3rd Node in RAC using addnode.sh: AddNode-airydba Password for opening the document is : Airydba@159 Thank you for reading… This…
Redo Apply Mode in Oracle 12c R2 Dataguard
Redo Apply Mode in Oracle 12c R2 Dataguard: Primary Side: [oracle@paw-prim ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Mon Mar 6 00:33:16 2017 Copyright (c) 1982, 2017, Oracle. All…