Monday 26 June 2017

Exadata Release Dates and Basic Configuration Details


Exadata Basic configurations
Eight Rack – 2 Database Servers (Compute Nodes) & 3 Storage Servers
Quarter Rack – 2 Database Servers & 3 Storage Servers
Half Rack – 4 Database Servers & 7 Storage Servers
Full Rack – 8 Database Servers & 14 Storage Servers 

Exadata Major Release Dates:
Exadata V1 =====> September 2008
Exadata V2 =====> September 2009
Exadata X2 =====> September 2010
Exadata X3 =====> September 2012
Exadata X4 =====> December 2013
Exadata X5 =====> January 2015 (6th Generation Exadata)
Exadata X6 =====> April 2016 (7th Generation Exadata)

Sunday 25 June 2017

Manual Steps for Apply/Rollback Patch

Steps for Applying the Patch
Execute the following on each node of the cluster in non-shared CRS and DB home environment to apply the patch.

1.  Stop the CRS managed resources running from DB homes.
If this is a GI Home environment, as the database home owner execute:
$ srvctl stop home -o <ORACLE_HOME> -s <statusfilelocation> -n <node name>
If this is an Oracle Restart Home environment, as the database home owner execute:
$ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location>

2. Run the pre root script.
If this is a GI Home, as the root user execute:
# <GI_HOME>/crs/install/rootcrs.pl -prepatch
If this is an Oracle Restart Home, as the root user execute:
# <GI_HOME>/crs/install/roothas.pl -prepatch

3. Patch GI home.
As the GI home owner execute:
$ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%OCW TRACKING BUG%
$ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%ACFS TRACKING BUG%
$ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%DBWLM TRACKING BUG%
$ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%RDBMS PSU TRACKING BUG%

4. Patch DB home.
As the database home owner execute:
$ <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%OCW TRACKING BUG%/custom/scripts/prepatch.sh -dbhome <ORACLE_HOME>
$ <ORACLE_HOME>/OPatch/opatch apply -oh <ORACLE_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%OCW TRACKING BUG%
$ <ORACLE_HOME>/OPatch/opatch apply -oh <ORACLE_HOME> -local <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%RDBMS PSU TRACKING BUG%
$ <UNZIPPED_PATCH_LOCATION>/%BUGNO%/%OCW TRACKING BUG%/custom/scripts/postpatch.sh -dbhome <ORACLE_HOME>  

5. Run the post script
As the root user execute:
# <GI_HOME>/rdbms/install/rootadd_rdbms.sh
If this is a GI Home, as the root user execute:
# <GI_HOME>/crs/install/rootcrs.pl -postpatch
If this is an Oracle Restart Home, as the root user execute:
# <GI_HOME>/crs/install/roothas.pl -postpatch

6. Start the CRS managed resources that were earlier running from DB homes
If this is a GI Home environment, as the database home owner execute:
$ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> -n <node name>
If this is an Oracle Restart Home environment, as the database home owner execute:
$ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> 

7. For each database instance running on the Oracle home being patched, run the datapatch utility as described in next table.

8: Steps to Run the datapatch Utility for Single Tenant Versus Multitenant (CDB/PDB)
Set environment to oracle database
cd $ORACLE_HOME/OPatch
./datapatch –verbose

set line 155
select * from dba_registry_sqlpatch;
SELECT patch_id, version, status, bundle_id, bundle_series,ACTION_TIME FROM dba_registry_sqlpatch;
select owner,object_type,count(*) from dba_objects where status='INVALID' group by owner,object_type order by owner,object_type ;
@$ORACLE_HOME/rdbms/admin/utlrp.sql


Reference: Patch Installation and Deinstallation for 12.1.0.x.x GI PSU and Database Proactive Bundle Patch (Doc ID 1591616.1)

Generate Patch Steps with Oplan

Oplan is a utility that facilitates the patch installation process by providing you with step-by-step patching instructions specific to your environment. 

      Oplan comes with latest OPatch
1.  As Oracle Home owner, run the following command
$ORACLE_HOME/OPatch/oplan/oplan generateApplySteps <bundle patch location>
For example: $ORACLE_HOME/OPatch/oplan/oplan generateApplySteps /tmp/1277345
2.   Patch installation instructions specific to your target will be available as HTML and text format in these locations:
$ORACLE_HOME/cfgtoollogs/oplan/<TimeStamp>/InstallInstructions.html
$ORACLE_HOME/cfgtoollogs/oplan/<TimeStamp>/InstallInstructions.txt
3.    Rollback steps
 $ORACLE_HOME/OPatch/oplan/oplan RollbackSteps <bundle patch location>  
4.  Oplan Output:
$ORACLE_HOME/OPatch/oplan/oplan generateApplySteps /u01/12c_BP/25433352
$ORACLE_HOME/OPatch/oplan/oplan generateApplySteps /u01 /12c_BP/25433352
from oplan /u01/app/oracle/product/12.1.0.2.0/dbnoRAC/OPatch/oplan/../auto/core/bin/../../core/modules/features/oracle.glcm.oplan.core.classpath.jar:/u01/app/oracle/product/12.1.0.2.0/dbnoRAC/OPatch/oplan/../auto/core/bin/../../core/modules/features/oracle.glcm.osys.core.classpath.jar:/u01/app/oracle/product/12.1.0.2.0/dbnoRAC/OPatch/oplan/../auto/core/bin/../../database/modules/oplan_db.jar
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=128M; support was removed in 8.0
Processing request...
Review the log messages captured in the following file: /u01/app/oracle/product/12.1.0.2.0/dbnoRAC/cfgtoollogs/oplan/2017-06-26-04-48-43/log.txt

Could not generate patching steps for the following databases as they do not run from the current host.
        Database Name: EMREP
        Oracle Home: /u01/app/oracle/product/12.1.0.2/dbnoRAC
        Host:  vnupoidb02
        Database Name: JAYABPM
        Oracle Home: /u01/app/oracle/product/12.1.0.2/dbnoRAC
        Host:
        Database Name: JAYFET
        Oracle Home: /u01/app/oracle/product/12.1.0.2/dbnoRAC
        Host:
To generate the patching steps for the above databases, execute it on host where the databases are running.
Success!
Follow the instructions outlined in the following Installation Instructions document and patch your system:
Apply Instructions (HTML)    : /u01/app/oracle/product/12.1.0.2.0/dbnoRAC/cfgtoollogs/oplan/2017-06-26-04-48-43/ApplyInstructions.html
Apply Instructions (TEXT)    : /u01/app/oracle/product/12.1.0.2.0/dbnoRAC/cfgtoollogs/oplan/2017-06-26-04-48-43/ApplyInstructions.txt
[oracle@vnupoidb01 2017-06-26-04-48-43]$ pwd
/u01/app/oracle/product/12.1.0.2.0/dbnoRAC/cfgtoollogs/oplan/2017-06-26-04-48-43

5.  [oracle@vnupoidb01 2017-06-26-04-48-43]$ ls -ltr
total 6884
-r--r----- 1 oracle oinstall       0 Jun 26 04:48 log.txt.lck
dr-xr-x--- 3 oracle oinstall    4096 Jun 26 04:50 machine-readable
-r--r----- 1 oracle oinstall  112032 Jun 26 04:50 README.html
-r--r----- 1 oracle oinstall  338935 Jun 26 04:50 OplaceSwitchbackRolling.txt
-r--r----- 1 oracle oinstall  332425 Jun 26 04:50 OplaceApplyRolling.txt
-r--r----- 1 oracle oinstall  208814 Jun 26 04:50 InplaceApplyRollingManual.txt
-r--r----- 1 oracle oinstall  112631 Jun 26 04:50 InplaceApplyRollingAuto.txt
-r--r----- 1 oracle oinstall  201561 Jun 26 04:50 InplaceApplyNonRollingManual.txt
-r--r----- 1 oracle oinstall  200174 Jun 26 04:50 InplaceApplyNonRollingDcli.txt
-r--r----- 1 oracle oinstall   12903 Jun 26 04:50 ApplyInstructions.txt
-r--r----- 1 oracle oinstall   24107 Jun 26 04:50 configuration.png
-r--r----- 1 oracle oinstall     393 Jun 26 04:50 README
-r--r----- 1 oracle oinstall 3171001 Jun 26 04:50 log.txt
-r--r----- 1 oracle oinstall 2266059 Jun 26 04:50 ApplyInstructions.html