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 […]
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 […]
Nice script to tidy up the output of crsctl status resource script #!/usr/bin/ksh # # 11g CRS resource status query script # # Description: # – Returns formatted version of crs_stat -t, in tabular # format, with the complete rsc names and filtering keywords # – The argument, $RSC_KEY, is optional and if passed to […]
Currently I have 2 disk groups DATA and FLASH for my RAC 11GR2 cluster I need to move them to a new storage array so here are the steps taken. 1. Create New Disk Groups FLASH2 & DATA2 Use asmca to create the new disks Create a FLASH2 diskgroup Create a DATA2 diskgroup New disk […]
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 […]
Enabling Statspack for 11gR2 RAC With 11g standard edition you can no longer buy the tuning and diagnostic packs so no awr reports so back to the old statspack, this is the steps i used to install statspack on my 2 node 11gR2 RAC cluster. 1. Create the perfstat schema SQL> @?/rdbms/admin/spcreate Choose the PERFSTAT […]
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 […]
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 […]
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 […]
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 […]
For the Love of Data 