How to change OEM 12c Agent Port ?

Whenever we install EM agent, it will use default port at time of installation on target host. If we need to modify the port then we can follow below steps to change the port number.

Stop the EM Agent
$ $AGENT_HOME/bin/emctl stop agent

Modify the $AGENT_HOME/sysman/config/emd.properties file in the EM Agent home directory:

For example:
EMD_URL=http://example.com:3872/emd/main

Modify the <port number> in the EMD_URL property so the EM Agent uses a new unused port on the target host.

EMD_URL=http://example.com:3883/emd/main

Start the EM Agent.

$ $AGENT_HOME/bin/emctl start agent

Check the EM status

Exadata Patching Strategy

Let's have an overview of Exadata Machine patching.

1. Check latest patches available on Oracle note ID - 888828.1 
2. Download the required patches
3. Review the patch README file
4. Make step by step plan to apply patch for all the component
5. Run Exachk utility before the patch application, analyse the report and correct wherever it's required.
6. Automate the patch application process based on rolling or non-rolling method
7. Apply the patch

Useful Oracle Exadata Metalink Notes

Thought to list down some Exadata Document metalink which you can keep as a reference for lifetime.

Doc ID	Document Description
888828.1	Exadata Database Machine and Exadata Storage Server Supported Versions
1270094.1	Exadata Critical Issues
1353073.1	Exadata Diagnostics Collection Guide
1187674.1	Master Note for Oracle Exadata Database Machine and Oracle Exadata Stororage Server
1483344.1	Exadata Platinum Customer Outage Classifications and Restoration Action Plans
1571965.1	Maximizing Availability with Engineered Systems - Exadata
1262380.1	Exadata Testing Practices and Patching Explained
1306814.1	Oracle Software Patching with OPLAN
1110675.1	Oracle Exadata Database Machine Monitoring
1070954.1	Database Machine Healthcheck (Exachk)
1094934.1	Best Practices for Data Warehousing on the Database Machine
1269706.1	Best Practices for OLTP Applications on the Database Machine
1071221.1	Oracle Sun Database Machine Backup and Recovery Best Practices
1054431.1	Configuring DBFS on Oracle Exadata Database Machine
1084360.1	Bare Metal Restore Procedure for Compute Nodes on an Exadata Environment (Linux)
1339769.1	Master Note for Oracle Database Resource Manager
960510.1	Data Guard Transport Considerations on Oracle Database Machine
1551288.1	Understanding ASM Capacity and Reservation of Free Space in Exadata
401749.1	Shell Script to Calculate Values Recommended Linux HugePages / HugeTLB Configuration
1009715.1	Integrated Lights Out Manager (ILOM) CLI Quick Reference
1070954.1	Oracle Exadata Database Machine exachk or HealthCheck
1317159.1	Changing IP addresses on Exadata Database Machine
1244344.1	Exadata Starter Kit
1537407.1	Requirements and restrictions when using Oracle Database 12c on Exadata Database Machine
1551288.1	Understanding ASM Capacity and Reservation of Free Space in Exadata
1459611.1	How to Calculate Usable_FILE_MB / REQUIRED_MIRROR_FREE_MB
361468.1	HugePages on Oracle Linux 64-bit
761868.1	Oracle Exadata Diagnostic Information required for Disk Failures and some other Hardware issues
10386736	Documentation for Exadata 11.2 & 12.1

You can follow  our   Exadata Certification Question   to   achieve   maximum success in your Exadata exam.

Exadata Monitoring Command

Additional monitoring commands which are required with usual DBA skill set on DB and CELL server.

Database Server

    Linux: top, mpstat, vmstat, iostat, fdisk, ustat, sar, sysinfo

    Exadata: dcli

    ASM: asmcmd, asmca

    Clusterware: crsctl, srvctl

Cell Server

    Linux: top, mpstat, vmstat, iostat, fdisk, ustat, sar, sysinfo

    Cell management: cellcli, cellsrvstat


                                    Exadata Monitoring Tools

Exadata OneCommand Utility Steps

Onecommand:

• Onecommand utility is used to configure the Exadata machine based on given information through OEDA by customer.
• Also whatever steps are performed by oncecommand can be changed based on the customer's required configuration and environment.
• All the steps runs sequentially and each step must be completed before execution of next step.
• Steps can be run individually as well as in one shot with single command.

Below are the steps which need to be executed through onecommand utility. 

Step 0: Validate the environment.

Step 1: Create work directory

Step 2: Unzip files

Step 3: Setup SSH for the root user

Step 4: Update the /etc/hosts file

Step 5: Create the cellip.ora and cellinit.ora files

Step 6: Validate the InfiniBand network

Step 7: Update the cell software

Step 8: Validate the cells

Step 9: Check RDS using the ping command

Step 10: Run CALLIBRATE on the cells

Study Guide for 1Z0-027 Certification

Exadata Database Machine Overview

• Identify the benefits of using Database Machine for different application classes
• Describe the integration of the Database Machine with Oracle Database Clusterware and ASM
• Describe Exadata Storage Server and the different Database Machine configurations
• Describe the key capacity and performance specifications for Database Machine
• Describe the key benefits associated with Database Machine

Exadata Database Machine Architecture

• Describe the Database Machine network architecture
• Describe the Database Machine software architecture
• Describe the Exadata Storage Server storage entities and their relationships
• Describe how multiple Database Machines can be interconnected
• Describe site planning requirements for Database Machine
• Describe network requirements for Database Machine

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 the capabilities of the Smart Flash Log
• Describe the purpose and benefits of Storage Indexes
• Describe the capabilities and uses of Exadata Secure Erase

Exadata Database Machine Initial Configuration

1Z0-485 Exadata Certification Study Guide

Oracle has released new certification for Implementation specialist after 1Z0-536.

Certification Code - 1Z0-485
Certification Name - Oracle ExadataDatabase Machine 2014 Implementation Essentials

You can get detailed Study Guide on below link. Hope it will help you to get certified.

1Z0-485 Certification Study Guide - Oracle ExadataDatabase Machine 2014 Implementation Essentials Study Guide


You can refer 1Z0-485 Q&A here...

Also refer 1Z0-027 (Exadata X3 Administration) Question Bank.

Exadata Documentation Download

You can find all the Exadata documentation on Exadata storage server itself on below location.

/usr/share/doc/oracle/Exadata

In case you don’t have Exadata access or you don’t have Exadata in your organization than you can download Exadata documentation from metalink.

Download patch 10386736 from metalink. All the latest versions are available on this patch.

click on image to enlarge

Remove Exadata Flash Grid disk and configure as normal Flash

In previous blog we have created Grid Disk on Flash Disk. Here we are removing Flash Grid Disk and configuring normal Flash Cache.

Step-1
Remove or move database or any contents to some another ASM Disk group

Step-2
Drop ASM disk group which was create on flash disk

Step-3
Drop all the flash grid disk

CellCLI> drop griddisk all prefix=flashdisk force
GridDisk FlashDisk_FD_00_exa1cel01 successfully dropped
GridDisk FlashDisk_FD_01_exa1cel01 successfully dropped
GridDisk FlashDisk_FD_02_exa1cel01 successfully dropped
GridDisk FlashDisk_FD_03_exa1cel01 successfully dropped
GridDisk FlashDisk_FD_04_exa1cel01 successfully dropped
GridDisk FlashDisk_FD_05_exa1cel01 successfully dropped
GridDisk FlashDisk_FD_06_exa1cel01 successfully dropped
GridDisk FlashDisk_FD_07_exa1cel01 successfully dropped

Step-4

Oracle Exadata default passwords

When Exadata get deployed,  by default it configured with Oracle standard username and password. As per good practice you should always change default password once Exadata handed over to you from Oracle. Below is the list of default Users and Passwords for Exadata.

Database Server

root/welcome1

oracle/welcome1

grid/welcome1

grub/sos1Exadata

Database server ILOMs

root/welcome1

Exadata Storage Cell Server

root/welcome1

celladmin/welcome1

cellmonitor/welcome1

Download Free Oracle Exadata Certification Exam Dumps

Exadata Storage Cell Server ILOMs

How to enable Exadata writeback Flashcache on cell storage ? (WriteThrough to WriteBack)

Steps to enabling the Flashcache mode:

This can be done in rolling as well as non-rolloing manner.

First check flashcache mode with below command on all cell servers with the use of dcli utility on DB node. It can be check on cell each server also with cellcli utility.

dbnode1#dcli -l root -g cellgroup "cellcli -e list cell detail" | grep "flashCacheMode"

10.156.110.10: flashCacheMode:          WriteThrough
10.156.110.11: flashCacheMode:          WriteThrough
10.156.110.12: flashCacheMode:          WriteThrough
10.156.110.13: flashCacheMode:          WriteThrough
10.156.110.14: flashCacheMode:          WriteThrough
10.156.110.15: flashCacheMode:          WriteThrough
10.156.110.16: flashCacheMode:          WriteThrough

Step-1
Also we can find flashcache mode in each cell by executing below command:

cellcli>list cell detail

flashCacheMode: WriteThrough     --->Currently flashCacheMode configured as WriteThrough

Step-2
Now drop flashcache on each cell server: (If you are following rolling manner then do one by one on each cell server)

cellcli> drop flashcache

Step-3
Be sure asmdeactivationoutcome is YES before disabling grid disk

CellCLI> list griddisk attributes name,asmmodestatus,asmdeactivationoutcome

Step-4

Oracle Exadata vs IBM Power Systems

Cost comparison for business decision-makers between Oracle Exadata and IBM power system

The FactPoint Group is a Silicon Valley-based research, and consulting firm that is dedicated to the business improvement of its clients.Factpoint Group has conducted survey for Exadata vs IBM Power system with the help of customers as well as technical team who are using these systems.

The research produce TCO comparison for both the systems which includes:

• Acquisition costs
• Implementation and deployment costs
• Operations and maintenance costs for three years.

Below are the major points which were included in the research.

Implementation Cost

As per  research Oracle Exadata require 59% fewer man-hours than the traditional IBM system.

Implementation Time

Implementation of Exadata can be completed within one week where IBM system requires 3 week for implementation.

Operation and Maintenance labor

How to move a datafile from one ASM disk group to another

Explaining how to move datafile from one ASM DG to another.

Note: Database must be in archivelog mode before doing this activity.

1. Find the name of the datafile that you're going to migrate

SQL> SELECT file_name FROM dba_data_files;

FILE_NAME

----------------------------------------------

+DATA/mydb/datafile/system.312.825938943

+DATA/mydb/datafile/sysaux.313.825938957

+DATA/mydb/datafile/undotbs1.314.825938971

+DATA/mydb/datafile/undotbs2.315.825938991

+DATA/mydb/datafile/users.317.825939005

+DATA/mydb/datafile/mydb01.dbf

+RECO/mydb/datafile/mydb_tbs.7665.836338453 <Moving this file from +RECO to +DATA

7 rows selected.

2. Take the datafile offline

SQL> Alter database datafile '+RECO/mydb/datafile/mydb_tbs.7665.836338453' offline;

Database altered.

3. Copy the file using RMAN:

Exadata Exam Study Guide - 1Z0-536

The Oracle Exadata 11g Essentials Exam Study Guide is designed to provide students with the information that can help them learn more to pass the Oracle Exadata 11g Essentials Exam (1Z0-536).

Below linked Oracle document will give you End to End guideline with course content to clear the Examination(1Z0-536).

• Exadata11g-Exam-Study-Guide (1Z0-536)

Sample Question for 1Z0-536                                               Question Bank to clear 1Z0-536 certification 

You can follow our Exadata Certification Question Bank to achieve maximum success in your Exadata certification exam.

Command to read the file contents of tar and zip file in Unix

#unzip -l read.zip

#tar -tvf read.tar

#tar -ztvf read.tar.gz

#tar -jtvf read.tar.bz2

Oracle Clusterware Log Files (11.2)

Below are a list of Clusterware log files and their associated process that can be used to diagnose/resolve errors.

For the below log file names server hostname is "dbserver01" and Grid Infrastructure is installed under /u01/app/11.2.0/grid/ (UNIX).

Summary of all Clusterware events on this host

$GI_HOME/log/dbserver01/alertdbserver01.log

Oracle High Availability Services Daemon OUT

$GI_HOME/log/dbserver01/ohasd/ohasdOUT.log

Oracle High Availability Services Daemon

$GI_HOME/log/dbserver01/ohasd/ohasd.log 

Cluster Ready Services OUT

$GI_HOME/log/dbserver01/crsd/crsdOUT.log

Cluster Ready Services Daemon

$GI_HOME/log/dbserver01/crsd/crsd.log

Cluster Synchronisation Service OUT

$GI_HOME/log/dbserver01/cssd/cssdOUT.log

Cluster Synchronisation Service Daemon

Error while loading shared libraries: libclntsh.so.11.1

Error:

error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory

Solution:

Export Library path and try again. It will work.

$LD_LIBRARY_PATH=$ORACLE_HOME/lib

$export LD_LIBRARY_PATH

What is Total Cost of Ownership? (TCO)

Total cost of ownership (TCO) is a financial estimate intended to help buyers and owners determine the direct and indirect costs of a product or system.

Total Cost of Ownership is the combined hard and soft costs of owning networked information assets. 'Hard' costs include items such as the purchase price of the asset, implementation fees, upgrades, maintenance contracts, support contracts, and disposal costs. These costs are considered 'hard costs' because they are tangible and easily accounted for. Even more significant in most environments however, are the 'soft' costs related to management, support, training, hidden costs, and downtime. Because they don't occur at acquisition time, they are often overlooked in budgets, often leading to unexpected increases or worse, a transfer of management and support responsibility to end users.

Although many companies factor TCO into the purchasing equation, they often underestimate the hidden costs of a new technology solution, which can result in negative consequences. For example, if don’t have the resources you need to adequately maintain a solution, you may skip upgrades and patches required to keep the solution running securely and at peak performance. Or, if you misjudge the time and expense needed to train employees on a new product or service, they may never use it productively.
While TCO helps you to determine hidden costs of a new technology solution, return on investment (ROI) analysis helps to illuminate benefits that may not be readily apparent, such as improved employee productivity or increased customer satisfaction. ROI assessments can be more subjective in nature than TCO, because these indirect benefits are usually harder to measure than direct costs.

When two solutions provide roughly equivalent benefits over the solution lifecycle, but have different types of costs associated with acquisition, maintenance and operation, a TCO comparison gives you a framework to better evaluate competing solutions to a problem, and avoid getting stuck with hidden costs and unwanted surprises.
For instance, a cloud or software-as-a-service (SaaS) customer management solution may provide business benefits very similar to what an in-house customer management solution would provide. However, TCO over a given time period may vary greatly. That’s because the very different business and delivery models and the cost and pricing structures for cloud computing and on-premise solution significantly affect TCO.

For example, on-site solutions usually require significant upfront capital expenditures for hardware, software and application software, along with IT resources to install and configure these components. As a result, first-year costs for on-site solutions are often much higher than those associated with SaaS or cloud computing solutions, and total costs to maintain and manage on-site infrastructure and solutions continue to be a factor over time. On the flip side, TCO analysis may actually favor on-site solutions as the number of users rises and the total time period factored into the calculation increases.

What to Consider

Think about your business and how long you expect to be using a particular solution. In the case of a core business solution, such as accounting or financial, many companies look at a TCO a period of four or five years (generally thought of as the useful life of hardware and software without the need for major replacements).
In less core or strategic areas — which will vary from business to business — you may want to look at TCO over a shorter time period. Regardless, TCO calculations usually include several categories and components, such as:

• Planning and selection: How long will it take to evaluate the solution, the vendor and service level agreements (if applicable)? Consider whether you can try the product for free and/or if you need to invest money or resources to set up a test environment.

• IT infrastructure requirements: For on-site solutions, do you need to buy hardware and software upfront to run the solution? What associated expenses will you have for space, power and cooling? Consider if you will you need to add, shift or outsource IT personnel to manage and maintain the infrastructure, and how much this will cost. For a SaaS or cloud solution, do you need to upgrade or add networking capabilities or bandwidth?

• Application subscription or license costs: What is the per user charge for the license (on-site) solution, or the per user subscription fee (cloud or SaaS solution)? Are ongoing maintenance costs for patches, bug-fixes, upgrades, etc. included in this price or billed separately?

• Application design, configuration and implementation: What resources (internal and/or external) will it take to design and configure the solution so it fits your business needs? Factor in relevant data migration, integration and customization costs, and any system testing necessary.

• Administration and maintenance: For an on-site solution, what is required to transition daily system administration to your internal staff? How much time, resources and money will you need to invest to manage, upgrade, trouble-shoot, patch, etc. over the solution lifecycle?

• Training costs: What IT administrative training and/or end-user costs are involved to get everyone on board and productive in using the solution.

While TCO is very important for most companies, you should also consider other factors — including contract terms, service level agreements, data security requirements and customization and integration needs — just to name a few. Many companies under-invest when it comes to thoroughly evaluating IT solution requirements and options.

You can get TCO comparision between Oracle Exadata and IBM Power system HERE...

Start and Stop Cell Server Processes

Cell services automatically starts with cell boot. If manually start and stop required than we can follow below procedure.

1. Start and stop through OS command

Stop:

Login as a root or celladmin and execute below command to stop services. 

[root@excell01 ~]# service celld stop

Stopping the RS, CELLSRV, and MS services...
The SHUTDOWN of services was successful.

Start:

[root@excell01 ~]# service celld start

Starting the RS, CELLSRV, and MS services...
Getting the state of RS services...
running
Starting CELLSRV services...
The STARTUP of CELLSRV services was successful.
Starting MS services...
The STARTUP of MS services was successful.

2. We can also manage this services with cellcli command utility as given below

Stop:

[root@excell01 ~]# cellcli -e alter cell shutdown services all

Start:

[root@excell01 ~]# cellcli -e alter cell startup services all


3. We can shutdown all services on all the cell servers with the use of dcli utility on DB node as below:

Stop:

[root@exdb01]#dcli -g cell_group -l root "cellcli -e alter cell shutdown services all"

Start:

[root@exdb01]#dcli -g cell_group -l root "cellcli -e alter cell startup services all"

Here cell_group is the list of cell server which contains IP of all the cell.

Verify Hardware and Firmware configuration on Exadata

Database Node

#/opt/oracle.SupportTools/CheckHWnFWProfile

Output would be as below:

[SUCCESS] The hardware and firmware profile matches one of the supported profile

If any result other than "SUCCESS" then investigate and correct the condition.

Verify on Cell Server

CellCLI> alter cell validate configuration

The output will be like :  Cell RanDomcel08 successfully altered

If any result other than "successfully altered" then investigate and correct the condition.