Change Listener ports RAC

Had to change some listener ports from 1521 to 8001 on a RAC environment recently here are the steps taken. 1. Check the listener status [oracle@test0101 20299013]$ srvctl status listener -l LISTENER Listener LISTENER is enabled Listener LISTENER is running on node(s): test0101,test0102 2. Modify the listener [oracle@test0101 20299013]$ srvctl modify listener -l LISTENER -p 8001 3. Bounce […]

11gR2 RAC recovery test

I was working on a recovery guide for a RAC cluster I built so I thought I would share the recovery of the DATA diskgroup. The set-up is a 2 node RAC cluster running 11.2.0.3 standard edition ASM with 2 disk groups DATA and FLASH. The OCR and voting disk are in the DATA diskgroup […]

ORA-00245: control file backup failed; target is likely on a local file system

Oracle 11.2.0.3 RAC DB backup failing with the following error: Error Mon Oct 07 01:03:28 2013 Errors in file /u01/app/oracle/diag/rdbms/testdb/TESTDB1/trace/TESTDB1_ora_25286.trc: ORA-00245: control file backup failed; target is likely on a local file system Cause This is down to the snapshot controlfile being on a local disk and it needs to be on a shared disk […]

RAC 11Gr2 Changing Public IPs

Public IP addresses 1. Check current network information: oracle@test01 /export/home/oracle $ oifcfg getif bond0  172.23.72.0  global  public bond1  172.23.58.16  global  cluster_interconnect 2. Delete the existing interface information from OCR oracle@test02 /export/home/oracle $ oifcfg delif -global bond0/172.23.72.0 3. Add it back with the correct information  oracle@test02 /export/home/oracle $ oifcfg setif -global bond0/172.29.2.0:public 4. Shutdown the cluster […]

Relocate a SCAN listener

Steps to relocate a scan listener oracle@test01 /export/home/oracle $ srvctl status scan SCAN VIP scan1 is enabled SCAN VIP scan1 is running on node test02 SCAN VIP scan2 is enabled SCAN VIP scan2 is running on node test02 SCAN VIP scan3 is enabled SCAN VIP scan3 is running on node test02 oracle@test01 /export/home/oracle $ srvctl […]

Clearing down a failed 11.2.0.3 Grid Infrastructure Install

The following is the steps needed to clear down a failed 11.2.0.3 RAC install, the root.sh part of the install can cause numerious issue so these steps have been used on several occasions Run the rootcrs.pl to deconfig the cluster Run on the first node root@testnode1)$ ./rootcrs.pl -deconfig -verbose -force Using configuration parameter file: ./crsconfig_params […]

VIP showing INTERMEDIATE

In a 11gR2 RAC cluster a VIP was showing as INTERMEDIATE and the listener was running fine on both node the actions i took to move the resource back to the correct node Checking the status The output from crsctl status resource -t ora.rac2.vip 1        ONLINE  INTERMEDIATE rac1                     FAILED OVER Moving the VIP back to […]