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).
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.