Tag Archives: oracle

GUOB Techday / LAD OTN Tour 2017

Last Saturday (Aug, 5th) it was held in São Paulo the 8th edition of GUOB Techday. This event is one of the most important event for DBAs and Oracle Professionals, it is part of the Latin America Oracle Technology Network … Continue reading

Posted in GUOB | Tagged , , , , , , , , , , , , , , , , , | Leave a comment

Batch Script – Reading parameter file into variables

Hi folks, quick tip on how to easily read a parameter file from a batch script. This is an idea I had to make the life easier when trying to troubleshoot connection issues from client to server and I had … Continue reading

Posted in Scripts | Tagged , , , , , , , , , , , | Leave a comment

Oracle ASM on FreeNAS 8.3.0 x86

Hey there folks, just writing this very quick tip on how to setup an iSCSI storage for your *crash and burn* environment… In this tutorial I will not care for network settings, security or anything, I will just demonstrate the … Continue reading

Posted in Storage | Tagged , , , , , , , , , | 2 Comments

Makefile:183: *** Error: unable to find the sources of your current Linux kernel

Hello folks, recently I ran on this error while installing virtualbox on Red Hat 6. It will probably work for Oracle Linux/Centos as well. The reason you are receiving this error message is probably because of missing packages, such as … Continue reading

Posted in Virtualization | Tagged , , , , , , , , , , , , | Leave a comment

RAC 11g R2: CRS-5008: Invalid attribute value

Hi folks, I recently had to change the public IP address for the RAC. All went well except the VIPs and the network stopped working. Here is what I got from crsctl status: [root@rac2 ~]# /u01/app/11.2.0/grid/bin/crsctl status res -t ——————————————————————————– … Continue reading

Posted in ORACLE Database | Tagged , , , , , , , | 3 Comments

Linux: Extend LVM by adding disk

Here is the current scenario: /u01 is under a LVM which is running out of space. The idea is to add space by adding a new disk (since this is a virtual machine, the disk being added is 15GB only) … Continue reading

Posted in Linux | Tagged , , , , , , , , , , | 2 Comments

Move RAC database from one diskgroup to another in ASM (Manually)

This approach is quite annoying because it has a lot of steps and things to consider, yet here goes a summary of how it could be done in a 3 node RAC as example: Scenario: Database is TSP, instances are … Continue reading

Posted in ORACLE Database | Tagged , , , , , , , , , , , , , | 2 Comments