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 […]
The following are the steps I used to install Oracle 12c on Red Hat 6 Download the Software from Technet The 2 zip files needed are linuxamd64_12c_database_1of2.zip & linuxamd64_12c_database_2of2.zip OS Settings Ensure the Hostname is in /etc/hosts [root@dba05tst stage]# cat /etc/hosts |grep dba05tst 172.23.11.222 dba05tst Disable the Firewall Settings [root@dba05tst stage]# service iptables save iptables: […]
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 […]
How to change the default profile limits useful for setting the password life time to stop the password timing out and asking the user to change the password especially when applications are connecting to the DB. SYSTEM@WEBDB1> @qprofileEnter value for 1: DEFAULTold 1: select * from dba_profiles where profile =upper(‘&1’)new 1: select * from dba_profiles […]
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 […]
Got the following error on a 11.2.0.3 RAC database, after investigation it turns out to be a Oracle Configuration Manager (OCM) error as we don’t use this product its safe to just disable the jobs Error Sun Oct 13 06:00:01 2013 Errors in file /u01/app/oracle/diag/rdbms/test/TEST1/trace/TEST1_j004_20464.trc: ORA-12012: error on auto execute of job “ORACLE_OCM”.”MGMT_CONFIG_JOB_2_1″ ORA-29280: invalid […]
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 […]
For the Love of Data 