X

Alejandro Vargas' Blog

Try Oracle Cloud Platform For Free

Engineered Systems

Moving Databases from ASM to ZFS on Exadata

Exadata is the best database machine available to run every Oracle database workload. But many times, within Exadata proliferate a large number of test and...

Exadata is the best database machine available to run every Oracle database workload. But many times, within Exadata proliferate a large number of test and development databases, that do not require the special features available with Exadata, the Storage cells and ASM. One possibility is to move these large and less demanding databases to a storage layer that is also less expensive, ZFS is a perfect match, can be connected to Exadata, available to RAC databases, and...

Moving an X3-2 Storage cell to an X7-2 Exadata

I've been adding storage cells to Exadatas for a long while, usually newer storage cells to a bit older Exadata. Yesterday I had the oposite case, moving six...

I've been adding storage cells to Exadatas for a long while, usually newer storage cells to a bit older Exadata. Yesterday I had the oposite case, moving six X3-2 cells to an X-7 Exadata. This mix of old and new storage cells is supported and can be done, but it took me a while to understand that the syntax of /opt/oracle.cellos/cell.conf had to remain as X-3. Usually I take the cell.conf from a working cell, and edit it to match the names and IP's on the cell to add, then...

MySQL Slave on the BDA, Issues Synchronizing it

Synchronizing a MySQL slave database on the BDA is something I've done several times as part of the pre-requisites of a BDA upgrade. Is a simple task and there...

Synchronizing a MySQL slave database on the BDA is something I've done several times as part of the pre-requisites of a BDA upgrade. Is a simple task and there are two goods douments that provide a step by step guide to implement it. My favorite one is Doc 2152683.1, because almost does not affect online work, except for the time it takes to dump the Master database. How to Reset MySQL Slave Replication without Full BDA Cluster Downtime (Doc ID 2152683.1) If downtime is...

Connection from Data Center to Cisco Switch issue on Exadata X7

It may happen that when trying to reach the Exadata machine using the management network, the data center switch that connects to the Exadata Cisco switch get a...

It may happen that when trying to reach the Exadata machine using the management network, the data center switch that connects to the Exadata Cisco switch get a 'connection rejected' error. On X7-2 port 48 of the Cisco switch is setup by default as ‘spanning tree network’ that set the BPDU* filter to disable, and communications between customer switch and the Cisco are rejected. To solve run this command on the Cisco: spanning tree BPDU filter en Enabling BPDU filtering in...

How to replace old Exadata storage cells with the new X7-2 storage cells, without downtime

Lately I had to help various customers to replace their old storage cells with the new X7-2 ones. There are huge benefits in doing this, the X7 has 25.5TB of...

Lately I had to help various customers to replace their old storage cells with the new X7-2 ones. There are huge benefits in doing this, the X7 has 25.5TB of flash, 12 x 10TB disks and 192 GB of DDR4 Memory.                       The question my customers asked the most was: Can we do the migration from our old storage to the new X7 without downtime and without risk? The answer was: YES! For doing this I've prepared and implemented a procedure that cover step by step how to...

How to setup passwordless ssh in Exadata using dcli

Setting passwordless ssh root connection using dcli is fast and simple and will easy later to execute commands on all servers using this utility.In order to do...

Setting passwordless ssh root connection using dcli is fast and simple and will easy later to execute commands on all servers using this utility.In order to do that you should have either:DNS resolution to all Database and Storage nodes OR have them registered in /etc/hosts1) Create a parameter file that contains all the server names you want to reach via dcli, tipically we have a cell_group for storage cells, a dbs_group for database servers and an all_group for both of...

Bash security fix made available for Exadata

Complete information about the security fix availability should be reviewed, before applying the fix, in MOS DOC:  Responses to common Exadata security scan...

Complete information about the security fix availability should be reviewed, before applying the fix, in MOS DOC:  Responses to common Exadata security scan findings (Doc ID 1405320.1)The security fix is available for download from:http://public-yum.oracle.com/repo/OracleLinux/OL5/latest/x86_64/getPackage/bash-3.2-33.el5_11.4.x86_64.rpmThe summary installation instructions are as follows:1) Download getPackage/bash-3.2-33.el5_11.4.x86_64.rpm2)...