Thursday 10 April 2014

Thursday 14 November 2013

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

Sunday 10 November 2013

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

Friday 1 November 2013

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

Wednesday 18 September 2013

The Arup Nanda Blog: Advanced Linux Commands Mastery Series on OTN

The Arup Nanda Blog: Advanced Linux Commands Mastery Series on OTN: Luis Daziano from Argentina asked me about the location of the series I wrote for Oracle Technology Network on Advanced Linux commands. For...

Tuesday 10 September 2013

Friday 16 August 2013

alt.oracle: RMAN 12c – More SQL without ‘sql’

alt.oracle: RMAN 12c – More SQL without ‘sql’: Up until version 12c, the RMAN command line parser was capable of parsing certain DML and DDL statements.  To do this, we use the “sql” com...

Thursday 8 August 2013

alt.oracle: Oracle 12c - Out With the Grid, In With the Cloud

alt.oracle: Oracle 12c - Out With the Grid, In With the Cloud: So Oracle database 12c is out now.  The cloud (and hence the “c”) is hanging over us.  At least we don’t have to hear about “the grid” anymo...

Wednesday 7 August 2013