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.
Get trusted Exadata Certification Exam Question bank for Oracle Exadata Administrator and Implementation exam.100% money back guarantee if you fail.
Showing posts with label exadata documentation. Show all posts
Showing posts with label exadata documentation. Show all posts
Useful Oracle Exadata Metalink Notes
| 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 |
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
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
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.
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
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)
Step-3
Be sure asmdeactivationoutcome is YES before disabling grid disk
CellCLI> list griddisk attributes name,asmmodestatus,asmdeactivationoutcome
Step-4
Exadata Documentation
Exadata and Storage cell documentation will be available by default on the below path on each storage cell server.
[root@cellserver1 doc]# pwd
/opt/oracle/cell/doc
[celladmin@cellserver doc]#ls -ltr
total 29
drwxr-xr-x 3 root root 4096 Jan 23 2014 Japanese
drwxr-xr-x 7 root root 4096 Jan 23 2014 doc
-rwxr-xr-x 1 root root 5419 Jan 23 2014 welcome.html
[root@cellserver1 doc]# pwd
/opt/oracle/cell/doc
[celladmin@cellserver doc]#ls -ltr
total 29
drwxr-xr-x 3 root root 4096 Jan 23 2014 Japanese
drwxr-xr-x 7 root root 4096 Jan 23 2014 doc
-rwxr-xr-x 1 root root 5419 Jan 23 2014 welcome.html