Category Archives: ORACLE Database

GUOB Tech Day / LA OTN TOUR 2017

On Aug, 5th we will have the GUOB Tech Day in São Paulo! This is an amazing opportunity to exchange knowledge and ideas with great Oracle Professionals from Brazil and around the world. I strongly encourage everyone that can go … Continue reading

Posted in ORACLE Database | Leave a comment

RAC 11gR2: Change SCAN VIP subnet

First of all, check whether your DNS servers is resolving to the new IPs. This is usually done by a network administrator. [oracle@rac2 ~]$ nslookup rac-scan Server:        144.180.76.91 Address:    144.180.76.91#53 Name:    rac-scan.localdomain Address: 144.180.76.121 Name:    rac-scan.localdomain Address: 144.180.76.123 Name:   … Continue reading

Posted in ORACLE Database | 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

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

How to add SCAN LISTENER in 11gR2

Originally posted on Oracle Technologies Blog:
My 11gR2 grid infrastructure completed with only one scan listener. The following log shows that …. [grid@rac01 grid]$ srvctl config scan SCAN name: rac-scan, Network: 1/133.22.38.0/255.255.255.0/eth2 SCAN VIP name: scan1, IP: /rac-scan.example.com/133.22.67.192 [grid@rac01 grid]$…

Posted in ORACLE Database | Leave a comment

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

Must have free tools for DBAs

This is not news to most DBAs, but I’ll list my favorite free tools anyway. Assuming you are using Windows on your laptop, here is a list of free tools that I really enjoy and personally consider a “must have” … Continue reading

Posted in ORACLE Database | Tagged , , , , , , , , , , , , , | Leave a comment