Posted in 2016

RESTful Services

I am collecting information about REST..

http://crunchify.com/how-to-build-restful-service-with-java-using-jax-rs-and-jersey/
https://github.com/zorkian/nagios-api

Advertisements
Posted in 2017

Patching a RAC, OJVM is rolling installable!

I want to write only necessary steps which I have executed on the RAC and show the whole datapatch!
I do basically the same as opatchauto, but in a step by step manner.
Since January 2017 you can conditially rolling patch a RAC. So what I have done is, patching a 2 Node RAC with local homes with PSU Jul2016 with OJVM to the newest PSU (26636286)

See Note
RAC Rolling Install Process for the “Oracle JavaVM Component Database PSU” (OJVM PSU) Patches (Doc ID 2217053.1)

database owner
 srvctl stop home -o /u01/app/oracle/12.1.0.2 -s /tmp/status -n <node>

root
 /u01/app/grid/12.1.0.2/crs/install/rootcrs.sh -prepatch

grid owner
 runuser -l oracle -c '/u01/app/grid/12.1.0.2/OPatch/opatch apply -silent -oh /u01/app/grid/12.1.0.2 -local /u01/install/26636286/26635815/26392192'
 runuser -l oracle -c '/u01/app/grid/12.1.0.2/OPatch/opatch apply -silent -oh /u01/app/grid/12.1.0.2 -local /u01/install/26636286/26635815/26392164'
 runuser -l oracle -c '/u01/app/grid/12.1.0.2/OPatch/opatch apply -silent -oh /u01/app/grid/12.1.0.2 -local /u01/install/26636286/26635815/21436941'
 runuser -l oracle -c '/u01/app/grid/12.1.0.2/OPatch/opatch apply -silent -oh /u01/app/grid/12.1.0.2 -local /u01/install/26636286/26635815/26713565'

database owner
 runuser -l oracle -c '/u01/install/26636286/26635815/26392192/custom/scripts/prepatch.sh -dbhome /u01/app/oracle/12.1.0.2'
 runuser -l oracle -c '/u01/app/oracle/12.1.0.2/OPatch/opatch apply -silent -oh /u01/app/oracle/12.1.0.2 -local /u01/install/26636286/26635815/26392192'
 runuser -l oracle -c '/u01/app/oracle/12.1.0.2/OPatch/opatch apply -silent -oh /u01/app/oracle/12.1.0.2 -local /u01/install/26636286/26635815/26713565'
 runuser -l oracle -c '/u01/install/26636286/26635815/26392192/custom/scripts/postpatch.sh -dbhome /u01/app/oracle/12.1.0.2'
 runuser -l oracle -c '/u01/app/oracle/12.1.0.2/OPatch/opatch apply -silent -oh /u01/app/oracle/12.1.0.2 -local /u01/install/26636286/26635845'

root
 /u01/app/grid/12.1.0.2/rdbms/install/rootadd_rdbms.sh
 /u01/app/grid/12.1.0.2/crs/install/rootcrs.sh -postpatch

database owner
 srvctl start home -o /u01/app/oracle/12.1.0.2 -s /tmp/status -n <node>

oracle@rac1 [ cdb11 ] OPatch]$ ./datapatch -verbose -skip_upgrade_check
 SQL Patching tool version 12.1.0.2.0 Production on Tue Nov 14 13:28:43 2017
 Copyright (c) 2012, 2016, Oracle. All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_7207_2017_11_14_13_28_43/sqlpatch_invocation.log

Connecting to database...OK
 Note: Datapatch will only apply or rollback SQL fixes for PDBs
 that are in an open state, no patches will be applied to closed PDBs.
 Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
 (Doc ID 1585822.1)
 Bootstrapping registry and package to current versions...done
 Determining current state...done

Current state of SQL patches:
 Patch 23177536 (Database PSU 12.1.0.2.160719, Oracle JavaVM Component (JUL2016)):
 Installed in CDB$ROOT ORCL PDB$SEED only
 Patch 26635845 (Database PSU 12.1.0.2.171017, Oracle JavaVM Component (OCT2017)):
 Installed in the binary registry only
 Bundle series PSU:
 ID 171017 in the binary registry and ID 160719 in PDB CDB$ROOT, ID 160719 in PDB PDB$SEED, ID 160719 in PDB ORCL

Adding patches to installation queue and performing prereq checks...
 Installation queue:
 For the following PDBs: CDB$ROOT PDB$SEED ORCL
 The following patches will be rolled back:
 23177536 (Database PSU 12.1.0.2.160719, Oracle JavaVM Component (JUL2016))
 The following patches will be applied:
 26635845 (Database PSU 12.1.0.2.171017, Oracle JavaVM Component (OCT2017))
 26713565 (DATABASE PATCH SET UPDATE 12.1.0.2.171017)

Installing patches...
 Patch installation complete. Total patches installed: 9

Validating logfiles...
 Patch 23177536 rollback (pdb CDB$ROOT): SUCCESS
 logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/23177536/20400035/23177536_rollback_CDB1_CDBROOT_2017Nov14_13_29_44.log (no errors)
 Patch 26635845 apply (pdb CDB$ROOT): SUCCESS
 logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26635845/21564421/26635845_apply_CDB1_CDBROOT_2017Nov14_13_33_01.log (no errors)
 Patch 26713565 apply (pdb CDB$ROOT): SUCCESS
 logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26713565/21602269/26713565_apply_CDB1_CDBROOT_2017Nov14_13_33_04.log (no errors)
 Patch 23177536 rollback (pdb PDB$SEED): SUCCESS
 logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/23177536/20400035/23177536_rollback_CDB1_PDBSEED_2017Nov14_13_35_07.log (no errors)
 Patch 26635845 apply (pdb PDB$SEED): SUCCESS
 logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26635845/21564421/26635845_apply_CDB1_PDBSEED_2017Nov14_13_38_18.log (no errors)
 Patch 26713565 apply (pdb PDB$SEED): SUCCESS
 logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26713565/21602269/26713565_apply_CDB1_PDBSEED_2017Nov14_13_38_25.log (no errors)
 Patch 23177536 rollback (pdb ORCL): SUCCESS
 logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/23177536/20400035/23177536_rollback_CDB1_ORCL_2017Nov14_13_35_07.log (no errors)
 Patch 26635845 apply (pdb ORCL): SUCCESS
 logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26635845/21564421/26635845_apply_CDB1_ORCL_2017Nov14_13_38_17.log (no errors)
 Patch 26713565 apply (pdb ORCL): SUCCESS
 logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26713565/21602269/26713565_apply_CDB1_ORCL_2017Nov14_13_38_21.log (no errors)
 SQL Patching tool complete on Tue Nov 14 13:40:32 2017