Oracle Database 12c Software Install on Redhat 6

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: […]

Changing Default profile limits

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 […]

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 […]

ORA-12012: error on auto execute of job “ORACLE_OCM”.”MGMT_CONFIG_JOB_2_1″

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 […]

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 […]