Showing posts with label Exadata Certification. Show all posts
Showing posts with label Exadata Certification. Show all posts

Why Exadata for Oracle Databases?

Many time it comes in our mind that why we should go for Exadata, what benefits we can get if we go for Exadata so here we have given some views based on the Exadata architecture, experience and features. This is the most common question in interview.



No doubt there can be many more advantages than what we have given below as we have only given high level views.

  • Exadata is high performance and high available pre-configured device.
  • It consists of servers,storage networking and software in single pre-configured box which is massively scalable, secure and redundant.
  • Multiple compression tiers are available on Exadata which can help customer to compress data as per business requirement to save storage space.
  • Implementation time is very less compare to non-Exadata systems as it's comes as pre-configured and pre-tested.
  • In case on any issue with the Exadata than we need to communicate with only single vendor which doesn't required to contact multiple vendor like non-Exadata setup so solution of issue could be done quicker.
  • Only DMA (Database Machine Administrator) would be required to manage the Exadata so it can manage with lower TCO which reduce the huge cost of manageability.
  • Exadata provides extreme performance for both DW and OLTP databases which is making it and ideal platform for database consolidation.

1Z0-070 - Oracle Exadata X5 Administration

Recently Oracle released beta exam for Oracle Exadata Administration based on X5 machine. It may come in production within 2-3 months.

It is right time to clear 1Z0-027 certification before releasing new exam to become an Exadata administrator.

Let's throw some light on the exam details and exam topics.

Exam Number: 1Z1-070 (Beta), 1Z0-070 (Production)
Exam Name:     Oracle Exadata X5 Administrator

Exam Topics

Exadata Database Machine Overview
  • Identify the benefits of using Database Machine for different application classes
  • Describe Exadata Storage Server and the different Database Machine configurations
  • Describe the key capacity and performance specifications for Database Machine
Exadata Database Machine Architecture
  • Describe the Database Machine network architecture and requirements
  • Describe the Database Machine software architecture
  • Describe the Exadata Storage Server storage entities and their relationships
  • Describe how multiple Database Machines can be interconnected and scaled up
Key Capabilities of Exadata Database Machine
  • Describe the key capabilities of Exadata Database Machine
  • Describe the Exadata Smart Scan capabilities
  • Describe the capabilities of hybrid columnar compression
  • Describe the capabilities and uses of the Smart Flash Cache
  • Describe t he capabilities of Columnar Flash Caching
  • Describe the capabilities of the Smart Flash Log
  • Describe the purpose and benefits of Storage Indexes
  • Describe the capabilities and uses of Exadata Snapshot databases
  • Describe Cell to Cell Data Transfer and Exadata Network Resource Management
Exadata Database Machine Initial Configuration
  • Describe site planning requirements for Database Machine
  • Describe the installation and configuration process with the Exadata Deployment Assistant
  • Describe the default configuration for Database Machine
  • Describe supported and unsupported customizations for Database Machine
  • Describe database machine operating system options and configurations
Configure Exadata Storage Server
  • Configure Exadata software and resources using Cellcli or other tools
  • Create and configure ASM disk groups using Exadata
  • Use the CellCLI, ExaCLI, DCLI and ExaDCLI Exadata administration tools
  • Configure Exadata Storage Server security
I/O Resource Management
  • Use Exadata Storage Server I/O Resource Management to manage workloads within a database and across multiple databases
  • Configure database resource management plans and profiles
  • Configure category plans
  • Configure inter-database plans
  • Describe and configure the I/O resource manager objectives
  • Monitor I/O using I/O Metrics
Recommendations for Optimizing Database Performance
  • Optimize database performance in conjunction with Exadata Database Machine
  • Optimize Cell performance for Flash Cache and latency capping
  • Monitor and configure table indexes, accounting for the presence of Exadata
Using Smart Scan
  • Describe Smart Scan and the query processing that can be offloaded to Exadata Storage Server
  • Describe the requirements for Smart Scan
  • Describe the circumstances that prevent using Smart Scan
  • Identify Smart Scan in SQL execution plans including smart joins
  • Use database statistics and wait events to confirm how queries are processed
Consolidation Options and Recommendations
  • Describe the options for consolidating multiple databases on Database Machine
  • Describe the benefits and costs associated with different options
  • Identify the most appropriate approach for consolidation in different circumstances
Migrating Databases to Exadata Database Machine
  • Describe the steps to migrate your database to Database Machine
  • Explain the main approaches for migrating your database to  Database Machine
  • Identify the most appropriate approach for migration in different circumstances
Bulk Data Loading 
  • Describe the various options for staging data to be bulk loading into Database Machine
  • Configure the Database File System (DBFS) feature for staging input data files
  • Use external tables based on input data files stored in DBFS to perform high-performance data loads
Exadata Database Machine Platform Monitoring
  • Describe the purpose and uses of SNMP for the Database Machine
  • Describe the purpose and uses of IPMI for the Database Machine
  • Describe the purpose and uses of ILOM for the Database Machine
Configuring Enterprise Manager Cloud Control 12c  to Monitor Exadata Database Machine
  • Describe the Enterprise Manager cloud Control architecture as it specifically applies to Exadata Database Machine
  • Describe the placement of agents, plug-ins and targets
  • Describe the discovery process and post discovery configurations
Monitoring Exadata Storage Servers
  • Describe Exadata Storage Server metrics, alerts, Thresholds and active requests
  • Describe and use Exedata Storage Server Quarantines, Disk Scrubbing and repair
  • Monitor Exadata Storage Server using Command line or Cloud control
Monitoring Exadata Database Machine Database Servers
  • Describe the monitoring recommendations for Exadata Database Machine database servers
  • Use Cloud Control or DBMCLI to monitor Exadata Database Machine Database Servers
Monitoring the InfiniBand Network
  • Monitor InfiniBand switches With Cloud Control or CLI
  • Monitor InfiniBand switch ports
  • Monitor InfiniBand ports on the database servers ajd Cells with LIST IBPORT command
  • Monitor the InfiniBand subnet master location
  • Monitor the InfiniBand network topology
Monitoring other Exadata Database Machine Components
  • Monitor Exadata Database Machine components: Cisco Switch, Power Distribution Units
Monitoring Tools
  • Use monitoring tools: Exachk, ExaWatcher, TFA Collector DiagTools, ADRCI, Imageinfo and Imagehistory, OSWatcher
Backup and Recovery for Exadata Database Machines
  • Describe how RMAN backups are optimized using Exadata Storage Server
  • Describe the recommended approaches for disk-based and tape-based backups of databases on Database Machine
  • Describe the recommended best practices for backup and recovery on Database Machine to  Exadata and non-Exadata storage
  • Perform backup and recovery
  • Connect a media server to the Database Machine InfiniBand network
Database Machine Maintenance tasks
  • Power Database Machine on and off
  • Safely shut down a single Exadata Storage Server
  • Replace a damaged physical disk on a cell
  • Replace a damaged flash card on a cell
  • Move all disks from one cell to another
  • Use the Exadata Cell Software Rescure Procedure
Patching Exadata Database Machine
  • Describe how software is maintained on different Database Machine components
  • Describe the recommended patching process for Database Machine with patchmgr, oplan and dbnodeupdate utilities
Database Machine Automated Support Ecosystem
  • Describe the Auto Service Request (ASR) function and how it relates to Exadata Database Machine
  • Describe the implementation requirements for ASR
  • Describe the ASR configuration process
  • Describe Oracle Configuration Manager (OCM) and how it relates to Exadata Database Machine
Source: www.oracle.com

1Z0-070 Oracle Exadata Exam Dumps

Boost Your Earning Potential with Oracle Certification...

Recently Certification Magazine has released the Salary Survey 2015 based on the certification credentials, which includes top 75 IT certifications. The best news is that Oracle is also one of the hottest certification now a days based on this survey. 

You will not surprise if Oracle Exadata will become the most valuable certification in Oracle technology in coming days because it includes multiple skills and now a days employer looking for multi skilled folks than single skill specialist. So grab an opportunity and earn Oracle Certification credentials to stay ahead in the competition.

Below three Oracle certification stood in the top 75 certifications in Cert Mag survey 2015.


You can go through whole survey detail by clicking on below image.



You can follow our Oracle Exadata Certification Exam Dumps to achieve maximum success in your Exadata certification.

Why You Should Be Oracle Exadata Certified?

When you hear word Exadata , what first thing comes in your mind? Now the time comes for Exadata DMA rather than traditional DBA who can manage entire setup including network, storage, server, operating system, database, grid, asm etc...

To get this job you have to demonstrate your skill to the customer which is definitely 50% fulfilled if you are exadata certified. If you go to any Oracle customer who are on traditional oracle setup, all are thinking switch to the exadata machine because of many benefits for business as well operational.

Monitoring Commands for Infiniband Switch


Infiniband is new for DBA so, DBA are not familiar with it in terms of management or monitoring but believe us monitoring or manage IB switches is not that much difficult.It's required just bit effort to understand how it works and how we can manage it. 

From Oracle Documentation you can learn it very well. Also it's not required much time to familiar with IB switches.

We can monitor IB switches using command line interface by executing simple linux commands for IB switches. 

Here we have give some of the commands which you can use for basic IB switch monitoring.

How To Gather Exadata Statistics ?


Very quick note on gathering of Exadata statistics. 

Why?

Gathering Exadata specific system statistics ensure the optimizer is aware of Exadata scan speed.

Accurately accounting for the speed of scan operations will ensure the optimizer chooses an optimal execution plan in a Exadata environment. 

Following command gathers Exadata specific system statistics

SQL>exec dbms_stats.gather_system_stats(‘EXADATA’);


Risk:

Lack of Exadata specific stats can lead to less performance optimizer plans.


Action / Repair:

To see if Exadata specific optimizer stats have been gathered, run the following query on a system with at least 11.2.0.2 BP18 or 11.2.0.2 BP8 Oracle software. 

Exadata Document Available Publicly

Its great news to all Oracle techies. Now Oracle Exadata Document is available publicly on Oracle website. No need Oracle support id to view the document.

You can get it from below link.

                                         Oracle Exadata Documentation


GoldenGate - libnnz11.so: cannot open shared object file

While login into Goldengate command line interface we faced below error. Resolution or error is not that much complicated but many time we are not able to find out what can be the issue while working in under pressure situation so thought to write this piece.

[oracle@ggtest ogg]$ ./ggsci
./ggsci: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory

Only need to export library from oracle home to resolve this error. It is better to append this in .bash_profile of Oracle user.

[oracle@ggtest ogg]$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib
[oracle@ggtest ogg]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.

GGSCI>

Comparison between Exadata X4-2 and X5-2

Obliviously ED X5 would be faster and flexible compare to earlier version of ED. Here we have given comparison between X5 and X4 full configuration ED rack based on datasheet provided by Oracle.



Now from X5-2 Oracle introduced Oracle Virtual Machine to do the virtualization on ED machine, if there is any requirement of hard limits on CPUs and memory or required independent OS/Admin than we can use this virtualization feature.

There is no licence cost for OVM , it's free of cost with ED X5-2.

From ED X5-2 High performance disk has been replaced with Extream Flash (EF).

What is Exacheck in Exadata and what it does?

Exacheck:

Exacheck is designed to audit configuration of Oracle Exadata Machine which includes DB Server, Cell Storage, Infiniband switch, Software, Database, and Ethernet Network.

When to execute:

Exachek report should be fetched after the initial Oracle Exadata Database Machine deployment, as a part of the routine maintenance schedule (at least monthly),before and after any system configuration change and patching activity.

Phases:

There are four phase in exachek execution.

1) Minimal Input 
2) Data Collection
3) Analysis
4) HTML Report Generation

umount: /u01 device is busy

Recently we faced this error while un-mounting /u01 file system.

You can get this error in two case either some one is logged in into the file system or some process is using this file system.

We have checked that no one is using /u01 file system now only one option was there , some process is using /u01 file system which is not allowing us to un-mount it.

We can check with below command that which processes are associated with /u01 file system.

How to disable/enable CPUs in Linux ?

It's quite interesting to know how to disable and enable CPU core in Linux in different scenario.

Thought came from Exadata architecture as Exadata 1/8th Rack comes with 16 cores but only half of the CPUs will be enabled on the DB server, that's why we have to pay Oracle licence cost for half core only.

This enabling and disabling can be controlled by resource control utility which comes with Exadata, so what we can do to enable or disable cpu core in non Exadata server?

We have performed this test on test server which has four CPU cores.

Step 1: Check Total Available CPU

There are multiple method to check it, we have checked it with TOP utility which give you better understanding. It shows 4 cpu cores are available.









What is HARD in Oracle Exadata?

Hardware Assisted Resilient Data (HARD)
  • HARD will prevent data corruptions from being written to storage disks.
  • Oracle database validates and add protection while sending data to the storage server.
  • Whenever data will go to storage server , first it will check if there is any data corruption. If it found the corrupted data , it would stops corrupted data from being written to disk.
  • Previously or in non-Exadata hardware it's not possible to prevent corrupted data to be written on to the storage and that was major reason for database corruption in many cases which Oracle has eliminated with the use of storage software which has been introduced in Exadata storage cell.
  • There is nothing to set on Database level or storage level as  HARD handle corruption transparently which also included for ASM rebalance.

Script to Find Hidden Parameters in Oracle

SELECT
  x.ksppinm name,
  y.ksppstvl VALUE,
  decode(ksppity,
    1,   'BOOLEAN',
    2,   'STRING',
    3,   'INTEGER',
    4,   'PARAMETER FILE',
    5,   'RESERVED',
    6,   'BIG INTEGER',
    'UNKNOWN') typ,

Exadata Bundle Patch Bug on 11.2.0.3.18ExadataDatabase

One of our team member has shared resolution of bug while patching on Exadata storage server.

Below is the full story

System landscape:

Exadata Machine = Exadata 1/8th Rack X3-2 machine
Platform = Linux x86-64 
Product = Oracle Database 
Version = 11.2.0.3.18ExadataDatabase 

Here we are doing prechek to apply bundle patch on Exadata. ((Quarterly Full Stack Download Patch (QFSDP) Oct 2014)

Go to the patch directory and first execute cleanup to clean previous patch manager utility.

Here patch directory for storage cell is "/bpatch/19625719/Infrastructure/11.2.3.3.1/ExadataStorageServer_InfiniBandSwitch/patch_11.2.3.3.1.140708/"

#./patchmgr -cells /root/cellgroup -cleanup                                                     
2014-12-06 12:01:05 +0800        :Working: DO: Cleanup ...
2014-12-06 12:01:45 +0800        :SUCCESS: DONE: Cleanup

Executing pre-check through patchmgr utility 

#./patchmgr -cells ~/cellgroup -patch_check_prereq -rolling

2014-12-06 12:09:47 +0800        :Working: DO: Initialize files, check space and state of cell services. Up to 1 minute ...
2014-12-06 12:10:24 +0800        :SUCCESS: DONE: Initialize files, check space and state of cell services.
2014-12-06 12:10:24 +0800        :Working: DO: Copy, extract prerequisite check archive to cells. If required start md11 mismatched partner size correction. Up to 40 minutes ...
2014-12-06 12:10:38 +0800 Wait correction of degraded md11 due to md partner size mismatch. Up to 30 minutes.
2014-12-06 12:10:40 +0800        :SUCCESS: DONE: Copy, extract prerequisite check archive to cells. If required start md11 mismatched partner size correction.
2014-12-06 12:10:40 +0800        :Working: DO: Check prerequisites on all cells. Up to 2 minutes ...
2014-12-06 12:12:36 +0800        :SUCCESS: DONE: Check prerequisites on all cells.
2014-12-06 12:12:36 +0800        :Working: DO: Execute plugin check for Patch Check Prereq ...
2014-12-06 12:12:36 +0800 :INFO: Patchmgr plugin start: Prereq check for exposure to bug 17854520 v1.1. Details in logfile /bpatch/19625719/Infrastructure/11.2.3.3.1/ExadataStorageServer_InfiniBandSwitch/patch_11.2.3.3.1.140708/patchmgr.stdout.
2014-12-06 12:12:36 +0800 :INFO: This plugin checks dbhomes across all nodes with oracle-user ssh equivalence, but only for those known to the local system. dbhomes that exist only on remote nodes must be checked manually.
2014-12-06 12:12:55 +0800 :WARNING: ACTION REQUIRED: Required fix for bug 17854520 not found in dbhome /u01/app/oracle/product/11.2.0.3/dbhome_1 on dbadm01. Install the fix before performing rolling cell patching.
2014-12-06 12:12:55 +0800 :WARNING: ACTION REQUIRED: Required fix for bug 17854520 not found in dbhome /u01/app/oracle/product/11.2.0.3/dbhome_1 on dbadm02. Install the fix before performing rolling cell patching.
2014-12-06 12:12:55 +0800 :WARNING: Patchmgr plugin complete: Prereq check failed - fix for bug 17854520 is required
2014-12-06 12:12:56 +0800        :FAILED: Details in files <cell_name>.log /bpatch/19625719/Infrastructure/11.2.3.3.1/ExadataStorageServer_InfiniBandSwitch/patch_11.2.3.3.1.140708/patchmgr.stdout, /bpatch/19625719/Infrastructure/11.2.3.3.1/ExadataStorageServer_InfiniBandSwitch/patch_11.2.3.3.1.140708/patchmgr.stderr
2014-12-06 12:12:56 +0800        :FAILED: DONE: Execute plugin check for Patch Check Prereq.
[ERROR] Patch prerequisite checks failed. Please run cleanup before retrying.

As per above output, pre-check has not been completed successfully and we need to apply bug fix 17854520 on Grid and RDBMS home.


Now let's do the exercise to resolve this issue.


Things To Do Before Applying Bundle Patch On Exadata

One of our reader asked us, what we should take care before applying the bundle patch on Exadata, so thought to write this article where we have mentioned some points based on our patching experience, we can say it's part of bundle patch pre-preparation.

Missing of single point can lead you to difficult stage which we can eliminate by planing better.

               "Always plan for worst to do the best"


  • Make sure that you have backup plan for Exadata box connectivity in case you are doing things remotely
  • Install VNC client on your workstation
  • Install VNC server on Exadata in case if you required GUI. You can also use Xmanager and Xming to take GUI from your workstation

Linux Server Performance Analyzer Utilities

If there is any Linux performance issue we mostly go to Google and find commands to analyze the performance but multiple time it's difficult to find it when we required some specific details so, we have tried here to place all the Linux performance utility which can help you to analyze the Linux server performance.

There are multiple utilities available to analyse Linux server. Which includes CPUs, Memory, I/O, disk, network analysis.


UtilityDiscription
free Displays free and used memory.
iostat Displays disk I/O statistics.
netstat Reports on network statistics.
mpstat Reports CPU statistics.
vmstat Monitors processes, CPU, memory, or disk I/O bottlenecks.
ps Identifies highest CPU- and memory-consuming sessions. Used to identify Oracle
sar Displays CPU, memory, disk I/O, and network usage, both current and historical
top Identifies sessions consuming the most resources.
watch Periodically runs another command.
du Displays disk usage.
df Reports on free disk space.

                                              How to calculate IOPS in Exadata ?

Oracle Database In-Memory (DBIM)

Let's first understand why DBIM is revolutionized...

Generally Organization keeps different database for Reporting and Application Transaction because of the performance issues so whenever any transactions happen to the Application Transaction database it will immediately replicate to report database which help to get up date data while fetching report from the reporting database.

Business don't want to access same database for reporting and transaction because of the performance impact on single DB as mixed workload can slow the database and  that's why they prefer to keep separate database for both activity which gives overhead of h/w & s/w management, required more resources to handle both environment and ultimately it will  increase TCO at the end of day.

To overcome from this situation Oracle comes with DBIM (Database In Memory) which keeps frequently accessed data in memory to get faster response and decrease the response time by eliminating disk IO. It will store Database in storage only but it will store most accessible data in memory which gives faster response compare to read from disk. We can also influence object which we want to keep in memory.

Exadata Dictionary Views

Listed down some Exadata views which can help you to get Exadata related statistics

Get Cell Definition

V$CELL 
GV$CELL 

Exadata cell effectiveness and statistics

V$SYSSTAT 

V$SEGMENT_STATISTICS 

V$SQL 

Historical view of the types and frequencies of the requests being run by a cell.

V$CELL_REQUEST_TOTALS 

Cell Performance Statistics

V$CELL_STATE 

Display Exadata Cell Threads

V$CELL_THREAD_HISTORY

Backup Related View

V$BACKUP_DATAFILE 

Useful Files in Solaris

Message log:  /var/adm/messages

Tape driver configuration file:  /kernel/drv/st.conf

Disk driver configuration file:  /kernel/drv/sd.conf

File defining filesystems to mount:  /etc/vfstab

Kernel configuration parameters:  /etc/system

Names and IP addr of machines:  /etc/hosts

Default Port Numbers:  /etc/services

                                    Analyze Linux Server Performance