Book Review: Packt's Oracle Advanced PL/SQL Developer Professional Guide by Saurabh K. Gupta

Book Review: Packt's Oracle Advanced PL/SQL Developer Professional Guide by Saurabh K. Gupta

ASM Support Guy: ASM in Exadata

ASM Support Guy: ASM in Exadata: ASM is a critical component of the Exadata software stack. It is also a bit different - compared to non-Exadata environments. It s...

The Arup Nanda Blog: Sangam 13 Presentations and Scripts

The Arup Nanda Blog: Sangam 13 Presentations and Scripts: Thank you all those who attended my sessions at Sangam13 -- the annual conference of All India Oracle User Group in Hyderabad. I saw many ...

Exadata Certification: Exadata Offload Processing

Exadata Certification: Exadata Offload Processing: Exadata offloading is to offload processing to the storage tier. Offloading and Smart Scan are two terms that are used somewhat interchan...

Exadata Certification: Exadata Storage Server Shutdown/Startup procedure ...

Exadata Certification: Exadata Storage Server Shutdown/Startup procedure ...: Procedure to shutdown and startup the Exadata Storage server for maintenance Shutdown Procedure 1.    Execute below command to che...

Exadata Certification: How to find serial number of Exadata Server/Storag...

Exadata Certification: How to find serial number of Exadata Server/Storag...: #ipmitool sunoem cli "show /SYS/product_serial_number" Connected. Use  ^ D to exit. -> show /SYS product_serial_number /SY...

Exadata Certification: EHCC with Example - Exadata Compression

Exadata Certification: EHCC with Example - Exadata Compression: Here I have created three tables with same data as per below. 1. Test  with no compression 2. Test_hcc_archive with archive high compres...

Exadata Certification: Verify InfiniBand Fabric Topology

Exadata Certification: Verify InfiniBand Fabric Topology: Verifying infiniband topology whether it is configured current or not. If it not gives the desired output as per below then it will cause t...

Exadata Certification: Verify Hardware and Firmware on Exadata Components...

Exadata Certification: Verify Hardware and Firmware on Exadata Components...: If the hardware and firmware are not validated, inconsistencies between database and storage servers can lead to problems and outages. W...

Exadata Certification: Exadata Monitoring Tools

Exadata Certification: Exadata Monitoring Tools: Listed known Exadata monitoring tools as well as configuration check tool Exacheck -- To check whether Exadata configuration has been d...

Exadata Certification: User Equivalence between DB Node and Storage Cell

Exadata Certification: User Equivalence between DB Node and Storage Cell: We are configuring SSH equivalence for oracle user between DB server and storage as per below First I am checking the hostname on storage s...

Exadata Certification: DBFS creation in Oracle

Exadata Certification: DBFS creation in Oracle: Follow below steps to create DBFS -- Create the mount point for DBFS [root@db01 ]# mkdir /dbfs_dir --Setup the database [root@db...

Exadata Certification: Pre-login Message / Banner Configuration in Linux

Exadata Certification: Pre-login Message / Banner Configuration in Linux: Create a text file with banner description #vi /etc/ssh/ssh-banner-message.txt WARNING: Unauthorized access to this system is forbidd...

Exadata Certification: ASR Installation and Registration procedure with O...

Exadata Certification: ASR Installation and Registration procedure with O...: Plateforms: RHEL 3 or latter x86 SUSE Linux 9 or latter x86 OEL 4 or latter x86 Software Requirement (08/10/2013) : Oracle Automat...

Exadata Certification: Location of Log files in Exadata

Exadata Certification: Location of Log files in Exadata: On the cell nodes ================ 1. Cell alert.log file /opt/oracle/cell/log/diag/asm/cell/{node name}/trace/alert.logorif th...