Tag Archives: oracle

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 , , , , , , , , , | Leave a comment

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

Round 1: BR*Tools x RMAN – Incremental Backups

Since this is a big topic to put together with practical examples I will start with Incremental backups. Which tool is best? Up to you… the main difference is: BR*Tools is file based while RMAN is block based. I will … Continue reading

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