User Tools

Site Tools


patching_oracle_database_appliance_oda

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
patching_oracle_database_appliance_oda [2018/12/06 21:05] – created 91.177.234.129patching_oracle_database_appliance_oda [2023/07/30 23:06] (current) – external edit 127.0.0.1
Line 1: Line 1:
-====== Patching_Oracle_Database_Appliance_(ODA====== +  * [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=888.1|Primary Note for Database Proactive Patch Program (Doc ID 888.1)]] - Patching master document,  or 
- +  * [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=2118136.2|Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (Doc ID 2118136.2)]] 
-Useful ODA documents:<br /> +Useful ODA documents:\\ 
-  * [[https://docs.oracle.com/cd/E80799_01/doc.121/e80525/toc.htm|Database Appliance Administration and Reference Guide (12.1.2.9)]]<br />+  * [[https://docs.oracle.com/cd/E80799_01/doc.121/e80525/toc.htm|Database Appliance Administration and Reference Guide (12.1.2.9)]]\\
   * [[https://docs.oracle.com/cd/E22693_01/doc.12/e55580/oakcli.htm|Database Appliance Administration and Reference Guide (12.1.2.2)]]   * [[https://docs.oracle.com/cd/E22693_01/doc.12/e55580/oakcli.htm|Database Appliance Administration and Reference Guide (12.1.2.2)]]
   * [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=1417713.2|Master ODA document]]   * [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=1417713.2|Master ODA document]]
   * [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=888888.1|Oracle Database Appliance - 12.1.2 and 2.X Supported ODA Versions & Known Issues (Doc ID 888888.1)]]   * [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=888888.1|Oracle Database Appliance - 12.1.2 and 2.X Supported ODA Versions & Known Issues (Doc ID 888888.1)]]
   * [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=1937782.1|12.1.0.2 Proactive Database Bundle Patches]]   * [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=1937782.1|12.1.0.2 Proactive Database Bundle Patches]]
-<br />+
  
 Bundle patches for ODA are installed in 3 stages.<br > Bundle patches for ODA are installed in 3 stages.<br >
 Upto and including 12.1.2.6, this is performed as so:<br > Upto and including 12.1.2.6, this is performed as so:<br >
-<code>0@@</code> +<code> 
-From 12.1.2.7 onwards this has changed to:<br /> +oakcli update -patch 12.1.2.6.--infra     # patches the server firm/software 
-<code>1@@</code> +oakcli update -patch 12.1.2.6.0 --gi        # patches the Grid (ASM/ACFS) firm/software 
-=====Patch preparation===== +oakcli update -patch 12.1.2.6.0 --database  # patches the ORACLE_HOME(s) software 
-Show version details of all ODA components<br />+</code> 
 +From 12.1.2.7 onwards this has changed to:\\ 
 +<code> 
 +oakcli update -patch 12.1.2.9.0 --server    # patches the server and Grid firm/software 
 +oakcli update -patch 12.1.2.9.0 --storage   # patches the Shared storage including HDD, SSD, Controller, and Expander 
 +oakcli update -patch 12.1.2.9.0 --database  # patches the ORACLE_HOME(s) software 
 +</code> 
 +==== Patch preparation ==== 
 +Show version details of all ODA components\\
 **Note: all oakcli commands must be executed as root** **Note: all oakcli commands must be executed as root**
-<code>2@@</code>+<code> 
 +/opt/oracle/oak/bin/oakcli show version -detail 
 +</code>
  
-Patching ODA means patching the O/S, the Grid Infrastructure (GI) and the RDBMS (or any combination thereof).<br />+Patching ODA means patching the O/S, the Grid Infrastructure (GI) and the RDBMS (or any combination thereof).\\
  
-====Download latest ODA patch bundle====+=== Download latest ODA patch bundle ===
 Latest ODA patches are found in [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=888888.1|Oracle Database Appliance - 12.1.2 and 2.X Supported ODA Versions & Known Issues (Doc ID 888888.1)]] Latest ODA patches are found in [[https://support.oracle.com/epmos/faces/DocumentDisplay?id=888888.1|Oracle Database Appliance - 12.1.2 and 2.X Supported ODA Versions & Known Issues (Doc ID 888888.1)]]
-====Download and copy zip files====+=== Download and copy zip files ===
 Download the files on the relevant patch page for your hardware, copy them to wherever you store patches on the server and Read the README. Download the files on the relevant patch page for your hardware, copy them to wherever you store patches on the server and Read the README.
-====Copy zip files to /tmp====+=== Copy zip files to /tmp ===
 Copy the zip files from your patch storage area to /tmp on both ODA_BASE nodes. Copy the zip files from your patch storage area to /tmp on both ODA_BASE nodes.
-====Check space====+=== Check space ===
 Make sure there is enough space in /root, /tmp, $ORACLE_HOME, and /opt for the unzippped / installed files. Make sure there is enough space in /root, /tmp, $ORACLE_HOME, and /opt for the unzippped / installed files.
-====Verify ODA version==== +=== Verify ODA version === 
-<code>3@@</code> +<code> 
-====Unpack zip files====+/opt/oracle/oak/bin/oakcli show version 
 +</code> 
 +=== Unpack zip files ===
 Do not use unzip! Do not use unzip!
-<code>4@@</code> +<code> 
-====Delete zips from /tmp====+cd /tmp 
 +oakcli unpack –package p25064836_121290_Linux-x86-64_1of2.zip 
 +oakcli unpack –package p25064836_121290_Linux-x86-64_2of2.zip 
 +</code> 
 +=== Delete zips from /tmp ===
 If unpack -package was successful, files can be removed from /tmp. If unpack -package was successful, files can be removed from /tmp.
-<code>5@@</code> +<code> 
-====Check if the patch is likely to work!==== +rm -rf /tmp/p25064836_121290_Linux-x86-64* 
-The following command will inform you whether the patch will succeed. If the output indicates a possible problem, for example, an unpacked version of the patch is not available on the system, you may wish to defer applying the patch until you have downtime to fix the expected problem.<br />+</code> 
 +=== Check if the patch is likely to work! === 
 +The following command will inform you whether the patch will succeed. If the output indicates a possible problem, for example, an unpacked version of the patch is not available on the system, you may wish to defer applying the patch until you have downtime to fix the expected problem.\\
 From Node 0: From Node 0:
-<code>6@@</code> +<code> 
-====Remove any non-standard RPMs==== +oakcli validate -c ospatch -ver <version to be installed> 
-If the validation check reveals any RPMs, they must be removed prior to patching.<br />+e.g. 
 +oakcli validate -c ospatch -ver 12.1.2.9.0 
 +</code> 
 +=== Remove any non-standard RPMs === 
 +If the validation check reveals any RPMs, they must be removed prior to patching.\\
 Note: Perform check on both nodes, there may be differences! Note: Perform check on both nodes, there may be differences!
-<code>7@@</code>+<code> 
 +rpm -e --nodeps libtermcap-devel.x86_64 
 +rpm -e --nodeps yum-downloadonly.noarch 
 +rpm -e --nodeps gpg-pubkey 
 +rpm -e --nodeps check_mk-agent.noarch 
 +rpm -e --nodeps readline-devel.x86_64 
 +</code>
  
-====Backup sysctl.conf====+=== Backup sysctl.conf ===
 This file will probably be modified by any server patches This file will probably be modified by any server patches
-<code>8@@</code>+<code> 
 +export DATESTAMP=`date +%Y%m%d` 
 +cp /etc/sysctl.conf /etc/sysctl.conf_${DATESTAMP} 
 +</code>
  
-=====Patch the ODA infrastructure===== +==== Patch the ODA infrastructure ==== 
-The oakcli patching process has component specific logging enabled for each component being patched.<br />+The oakcli patching process has component specific logging enabled for each component being patched.\\
 These log files can be found under the directory <tt>/opt/oracle/oak/log/$(hostname)/patch/12.1.2.9.0</tt> These log files can be found under the directory <tt>/opt/oracle/oak/log/$(hostname)/patch/12.1.2.9.0</tt>
-====Review size of shared repository==== +=== Review size of shared repository === 
-<code>9@@</code>+<code> 
 +oakcli show repo 
 +</code>
  
 and add space if necessary and add space if necessary
-<code>10@@</code> +<code> 
-====Stop any running jobs====+oakcli configure repo srepo -incsize 100G 
 +</code> 
 +=== Stop any running jobs ===
 Before updating the repository, agent, server, or database, ensure that there will be no jobs running or pending during the update window. Before updating the repository, agent, server, or database, ensure that there will be no jobs running or pending during the update window.
  
-====Ready for patching...====+=== Ready for patching... ===
 Perform any specifics such as Perform any specifics such as
-  * Set database in blackout in OEM +  *  Set database in blackout in OEM 
-  * Any other monitoring software? +  *  Any other monitoring software? 
-  * Ensure archivelogs are not deleted. They will be needed for application on physical standby later. +  *  Ensure archivelogs are not deleted. They will be needed for application on physical standby later. 
-  * anything else that could be a problem.+  *  anything else that could be a problem.
 For example, here we use rlwrap for command line editing so these aliases will no longer work as we just uninstalled the readline package so comment them for now. For example, here we use rlwrap for command line editing so these aliases will no longer work as we just uninstalled the readline package so comment them for now.
-<code>11@@</code>+<code> 
 +cd 
 +vi .bash_profile 
 +  - alias sqlplus='rlwrap -D2 -ic sqlplus' 
 +  - alias dgmgrl='rlwrap -D2 -ic dgmgrl' 
 +  - alias rman='rlwrap -D2 -ic rman' 
 +  - alias asmcmd='rlwrap -D2 -ic asmcmd' 
 +  - alias lsnrctl='rlwrap -D2 -ic lsnrctl' 
 +  - alias adrci='rlwrap -D2 -ic adrci' 
 +  - alias impdp='rlwrap -D2 -ic impdp' 
 +  - alias expdp='rlwrap -D2 -ic expdp' 
 +</code>
 If these commands are going to be used, they will need unaliasing before use! e.g. If these commands are going to be used, they will need unaliasing before use! e.g.
-<code>12@@</code>+<code> 
 +unalias lsnrctl 
 +</code>
  
-====Stop the Snap Management Utility==== +=== Stop the Snap Management Utility === 
-<code>13@@</code>+<code> 
 +/opt/oracle/smu/bin/smu stop 
 +</code>
  
-====Shutdown any virtual machines==== +=== Shutdown any virtual machines === 
-<code>14@@</code>+<code> 
 +oakcli stop vm odavmdp1 -force 
 +oakcli stop vm odavmdp2 -force 
 +oakcli stop vm odavmdb3 -force 
 +oakcli stop vm odavmoms1 -force 
 +</code>
  
-====Shutdown Grid agent / Listeners==== +=== Shutdown Grid agent / Listeners === 
-<code>15@@</code>+<code> 
 +export ORACLE_SID=AGENT 
 +ORAENV_ASK=NO 
 +. oraenv 
 +emctl stop agent 
 +export TNS_ADMIN=$ORACLE_HOME/network/admin/ 
 +lsnrctl stop LISTENER_DATAGUARD 
 +</code>
  
-====Shutdown and backup ODA_BASE====+=== Shutdown and backup ODA_BASE ===
 Note: Do this on both nodes! Note: Do this on both nodes!
-<code>16@@</code>+<code> 
 +oakcli stop oda_base
  
-====Optonally reconfigure ODA_BASE==== +cd /OVS 
-<code>17@@</code>+tar -cvzf  oakDom1.odavm01-rac.tar.gz /OVS/Repositories/odabaseRepo/VirtualMachines/oakDom1 
 +</code>
  
-====Restart ODA_BASE====+=== Optonally reconfigure ODA_BASE === 
 +<code> 
 +oakcli configure oda_base 
 +</code> 
 + 
 +=== Restart ODA_BASE ===
 After tarball has been successfully created, ODA_BASE can be restarted. After tarball has been successfully created, ODA_BASE can be restarted.
-<code>18@@</code> +<code> 
-====Stop the shared repositories====+oakcli start oda_base 
 +</code> 
 +=== Stop the shared repositories ===
 This was done before applying GI patch but as server patch now includes GI, stop repositories before applying server patch. This was done before applying GI patch but as server patch now includes GI, stop repositories before applying server patch.
-<code>19@@</code>+<code> 
 +oakcli stop repo srepo 
 +oakcli show repo 
 +</code>
  
-====List the components that require patching====+=== List the components that require patching ===
 If any component shows as “Up-to-date” for the supported version, then it indicates that the existing version on the system is current and that component will not be patched. If any component shows as “Up-to-date” for the supported version, then it indicates that the existing version on the system is current and that component will not be patched.
-<code>20@@</code> +<code> 
-====Apply the ODA infrastructure (server) patch==== +From node 0: 
-Nodes can be patched one at a time by using the -local switch<br />+/opt/oracle/oak/bin/oakcli update -patch  12.1.2.9.0 --verify 
 +</code> 
 +=== Apply the ODA infrastructure (server) patch === 
 +Nodes can be patched one at a time by using the -local switch\\
 If both nodes are to be patched automatically (rolling patch), do not specify -local switch but command must then be executed from node 0. If both nodes are to be patched automatically (rolling patch), do not specify -local switch but command must then be executed from node 0.
-<code>21@@</code>+<code> 
 +From node 0: 
 +/opt/oracle/oak/bin/oakcli update -patch <patch bundle version> --server -local 
 +e.g. 
 +/opt/oracle/oak/bin/oakcli update -patch  12.1.2.9.0 --server -local 
 +</code>
 Note: If using '-local' switch, do not run this command simultaneously on both nodes! Note: If using '-local' switch, do not run this command simultaneously on both nodes!
  
-====Run post server patch patch checks====+=== Run post server patch patch checks ===
 Check cluster is working ok. Check cluster is working ok.
-<code>22@@</code> +<code> 
-====Check NFS mounts are working====+su - grid 
 +export ORACLE_SID=+ASM1 
 +ORAENV_ASK=NO 
 +. oraenv 
 +${ORACLE_HOME}/bin/crsctl check crs 
 +/opt/oracle/oak/bin/oakcli show version -detail 
 +</code> 
 +=== Check NFS mounts are working ===
 List mount points that //should be// mounted List mount points that //should be// mounted
-<code>23@@</code>+<code> 
 +grep nfs /etc/fstab | egrep -e "^#" -v | wc -l 
 +</code>
 List mount points that //are// mounted List mount points that //are// mounted
-<code>24@@</code>+<code> 
 +df -hPt nfs | tail -n +2 | wc -l 
 +</code>
  
-=====Patch the Grid infrastructure===== +==== Patch the Grid infrastructure ==== 
-Note: As of 12.1.2.7.0, this step is included in the '--server' patch<br /> +Note: As of 12.1.2.7.0, this step is included in the '--server' patch\\ 
-====Stop the shared repositories==== +=== Stop the shared repositories === 
-<code>25@@</code>+<code> 
 +oakcli stop repo srepo 
 +oakcli show repo 
 +</code> 
 + 
 +=== Apply the GI patch === 
 +**Note: As of 12.1.2.7.0, this step is included in the '--server' patch**\\
  
-====Apply the GI patch==== 
-**Note: As of 12.1.2.7.0, this step is included in the '--server' patch**<br /> 
-<br /> 
 Carefully read the known issues before applying the GI Patch. Carefully read the known issues before applying the GI Patch.
-<code>26@@</code>+<code> 
 +/opt/oracle/oak/bin/oakcli update -patch  12.1.2.6.0 --gi 
 +</code>
  
-====Check cluster health==== +=== Check cluster health === 
-<code>27@@</code>+<code> 
 +${ORACLE_HOME}/grid/bin/crsctl check crs 
 +</code>
  
-=====Patch the Shared Storage===== +==== Patch the Shared Storage ==== 
-**Note: This section is new as of 12.1.2.7.0**<br /> +**Note: This section is new as of 12.1.2.7.0**\\ 
-====Stop the shared repositories==== +=== Stop the shared repositories === 
-<code>28@@</code>+<code> 
 +oakcli stop repo srepo 
 +oakcli show repo 
 +</code>
  
-====Apply the Storage patch==== +=== Apply the Storage patch === 
-Note: The storage patching has no '-local' option. It must start from node 0, node 0 is patched first followed by the node 1. Both nodes will be rebooted.<br />+Note: The storage patching has no '-local' option. It must start from node 0, node 0 is patched first followed by the node 1. Both nodes will be rebooted.\\
 From node 0: From node 0:
-<code>29@@</code>+<code> 
 +/opt/oracle/oak/bin/oakcli update -patch  12.1.2.9.0 --storage 
 +</code>
  
-====Check cluster health==== +=== Check cluster health === 
-<code>30@@</code>+<code> 
 +${ORACLE_HOME}/grid/bin/crsctl check crs 
 +</code>
  
-====Check/change some file permissions==== +=== Check/change some file permissions === 
-<code>31@@</code>+<code> 
 +su - grid 
 +export ORACLE_SID=+ASM1 
 +ORAENV_ASK=NO 
 +. oraenv 
 +ls -al ${ORACLE_HOME}/bin/osdbagrp ${ORACLE_HOME}/lib/acfsreplcrs.pl 
 +chmod 755 ${ORACLE_HOME}/bin/osdbagrp ${ORACLE_HOME}/lib/acfsreplcrs.pl 
 +</code>
  
-====Restore sysctl.conf====+=== Restore sysctl.conf ===
 Check for higher values of variables. Check for higher values of variables.
  
-=====Patch the RDBMS===== +==== Patch the RDBMS ==== 
-====Apply the database patch==== +=== Apply the database patch === 
-Once the infrastructure and GI patches (or server and storage) have been completed successfully, the RDBMS patches can be applied.<br /> +Once the infrastructure and GI patches (or server and storage) have been completed successfully, the RDBMS patches can be applied.\\ 
-It can be applied locally on each node or as a rolling upgrade and both nodes will be patched automatically.<br />+It can be applied locally on each node or as a rolling upgrade and both nodes will be patched automatically.\\
 If '-local' is not specified, the command must be run from node 0. If '-local' is not specified, the command must be run from node 0.
-<code>32@@</code>+<code> 
 +/opt/oracle/oak/bin/oakcli update -patch  12.1.2.9.0  --database <-local> 
 +</code>
  
-====Verify database versions==== +=== Verify database versions === 
-<code>33@@</code> +<code> 
-=====Post ODA patch activities===== +oakcli show dbhomes -detail 
-====Restart any physical standby databases==== +oakcli show databases -detail 
-====Restart RAC cluster==== +</code> 
-<code>34@@</code> +==== Post ODA patch activities ==== 
-====Verify all ODA components are now up-to-date==== +=== Restart any physical standby databases === 
-<code>35@@</code> +=== Restart RAC cluster === 
-====Restart any virtual machines==== +<code> 
-<code>36@@</code> +svrctl start database 
-====Remount ZFS volumes on virtual machines====+</code> 
 +=== Verify all ODA components are now up-to-date === 
 +<code> 
 +/opt/oracle/oak/bin/oakcli show version -detail 
 +</code> 
 +=== Restart any virtual machines === 
 +<code> 
 +oakcli start vm odavmdp1 
 +oakcli start vm odavmdp2 
 +oakcli start vm odavmdb3 
 +oakcli start vm odavmoms1 
 +</code> 
 +=== Remount ZFS volumes on virtual machines ===
 Log in to each of the VMs in turn Log in to each of the VMs in turn
-<code>37@@</code> +<code> 
-====Restart OMS====+sudo mount /orasoft 
 +sudo mount /orabackups/RMAN 
 +sudo mount /orabackups/datapump_hist 
 +</code> 
 +=== Restart OMS ===
 login to OMS server login to OMS server
-<code>38@@</code> +<code> 
-====Check ODA Grid agent====+cd /u01/OracleHomes/Middleware/oms/bin 
 +./emctl status oms 
 +./emctl start oms 
 +</code> 
 +=== Check ODA Grid agent ===
 Kill any old processes and restart agent Kill any old processes and restart agent
-<code>39@@</code>+<code> 
 +export ORACLE_SID=agent 
 +ORAENV_ASK=NO 
 +. oraenv 
 +ps -ef | grep emagent 
 +kill -9 <pid where agent is 12.1.0.6> 
 +emctl start agent 
 +</code>
  
-====Reinstall any previously uninstalled RPMs====+=== Reinstall any previously uninstalled RPMs ===
 Check for later versions? Check for later versions?
-  * Nagios plugin +  *  Nagios plugin 
-<code>40@@</code> +<code> 
-  * Oracle Snap Management Utility +cd /orasoft/rpm 
-<code>41@@</code> +yum install check-mk-agent-1.2.6p14-e23d6a3d4540a28a.noarch.rpm 
-  * other +</code> 
-<code>42@@</code>+  *  Oracle Snap Management Utility 
 +<code> 
 +cd /orasoft/oracle_snapmanager/oracle-smu-1.2.0-ga/Linux/noarch/ 
 +rpm -i oracle-smu-1.2.0-27.noarch.rpm 
 +/opt/oracle/smu/bin/smu start 
 +</code> 
 +  *  other 
 +<code> 
 +yum install libtermcap-devel.x86_64 
 +yum install yum-downloadonly.noarch 
 +yum install gpg-pubkey 
 +yum install readline-devel.x86_64 
 +</code>
  
-====Uncomment any specific Oracle commands====+=== Uncomment any specific Oracle commands ===
 Like these aliases setup for readline wrapping Like these aliases setup for readline wrapping
-<code>43@@</code> +<code> 
-====Uncomment any jobs that clean up archivelogs==== +alias sqlplus='rlwrap -D2 -ic sqlplus' 
-====Take databases out of blackout on OEM====+alias dgmgrl='rlwrap -D2 -ic dgmgrl' 
 +alias rman='rlwrap -D2 -ic rman' 
 +alias asmcmd='rlwrap -D2 -ic asmcmd' 
 +alias lsnrctl='rlwrap -D2 -ic lsnrctl' 
 +alias adrci='rlwrap -D2 -ic adrci' 
 +alias impdp='rlwrap -D2 -ic impdp' 
 +alias expdp='rlwrap -D2 -ic expdp' 
 +</code> 
 +=== Uncomment any jobs that clean up archivelogs === 
 +=== Take databases out of blackout on OEM ===
 ...and any other monitoring software ...and any other monitoring software
-====Check public keys====+=== Check public keys ===
 Patching may destroy public keys Patching may destroy public keys
-<code>44@@</code>+<code> 
 +ssh admin@oda02-rac -p 8002 
 +</code>
 If password is requested, keys are corrupt. If password is requested, keys are corrupt.
-=====When it all goes tits up===== +==== When it all goes tits up ==== 
-====infra patch fails with==== +=== infra patch fails with === 
-<code>45@@</code> +<code> 
-  * Solution+[[root@odavm02-rac bin]]# ./crsctl stop crs 
 +CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'odavm02-rac' 
 +CRS-2673: Attempting to stop 'ora.crsd' on 'odavm02-rac' 
 +CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'odavm02-rac' 
 +CRS-2679: Attempting to clean 'ora.DATA.DBSTAGING.advm' on 'odavm02-rac' 
 +CRS-2680: Clean of 'ora.DATA.DBSTAGING.advm' on 'odavm02-rac' failed 
 +CRS-2799: Failed to shut down resource 'ora.DATA.DBSTAGING.advm' on 'odavm02-rac' 
 +CRS-2794: Shutdown of Cluster Ready Services-managed resources on 'odavm02-rac' has failed 
 +CRS-2675: Stop of 'ora.crsd' on 'odavm02-rac' failed 
 +CRS-2799: Failed to shut down resource 'ora.crsd' on 'odavm02-rac' 
 +CRS-2795: Shutdown of Oracle High Availability Services-managed resources on 'odavm02-rac' has failed 
 +CRS-4687: Shutdown command has completed with errors. 
 +CRS-4000: Command Stop failed, or completed with errors. 
 +</code> 
 +  *  Solution
 Recreate STAGING volume on ODA_BASE. Recreate STAGING volume on ODA_BASE.
-<code>46@@</code> +<code> 
-====infra patch fails with==== +[[grid@odavm01-rac ~]]$ asmcmd 
-<code>47@@</code> +ASMCMD> volcreate -G DATA -s 1024G DBSTAGING 
-  * Solution+ASMCMD> volinfo -G DATA  DBSTAGING 
 +Diskgroup Name: DATA 
 + 
 +         Volume Name: DBSTAGING 
 +         Volume Device: /dev/asm/dbstaging-358 
 +         State: ENABLED 
 +         Size (MB): 1048576 
 +         Resize Unit (MB): 32 
 +         Redundancy: MIRROR 
 +         Stripe Columns: 4 
 +         Stripe Width (K): 128 
 +         Usage: 
 +         Mountpath: 
 + 
 + 
 +[[grid@odavm01-rac ~]]$ /sbin/mkfs -t acfs /dev/asm/dbstaging-358 
 +mkfs.acfs: version                   = 11.2.0.4.0 
 +mkfs.acfs: on-disk version           = 39.0 
 +mkfs.acfs: volume                    = /dev/asm/dbstaging-358 
 +mkfs.acfs: volume size               = 1099511627776 
 +mkfs.acfs: Format complete. 
 + 
 + 
 +[[grid@odavm01-rac ~]]$ /sbin/acfsutil registry -a -f /dev/asm/dbstaging-358 /staging 
 +acfsutil registry: mount point /staging successfully added to Oracle Registry 
 + 
 + 
 +[[grid@odavm01-rac ~]]$ /sbin/acfsutil registry -l /staging 
 +Device : /dev/asm/dbstaging-358 : Mount Point : /staging : Options : none : Nodes : all : Disk Group : DATA : Volume : DBSTAGING 
 + 
 + 
 +[[root@odavm01-rac ~]]# /bin/mount -t acfs /dev/asm/dbstaging-358 /staging 
 + 
 +[[root@odavm01-rac /]]# chown oracle:oinstall /staging 
 + 
 +[[root@odavm01-rac ~]]# df -h /staging 
 +Filesystem            Size  Used Avail Use% Mounted on 
 +/dev/asm/dbstaging-358 
 +                      1.0T  2.2G 1022G   1% /staging 
 +</code> 
 +=== infra patch fails with === 
 +<code> 
 +INFO: Running  prepatching on node 1 
 +ERROR  : Ran '/usr/bin/ssh -l root odavm02-rac /opt/oracle/oak/pkgrepos/System/12.1.2.5.0/bin/prepatch -v 12.1.2.5.0 --infra' and it returned code(1) and output is: 
 + INFO: 2015-10-30 21:57:52: checking avaiable free space on /tmp, /u01 and /opt 
 + WARNING: 2015-10-30 21:57:52: Free space on / is less than 3G. 
 + INFO: 2015-10-30 21:57:52: Please free up space on /. 
 + WARNING: 2015-10-30 21:57:52: Free space on / is less than 3G. 
 + INFO: 2015-10-30 21:57:52: Please free up space on /. 
 + ERROR: 2015-10-30 21:57:52: One or more volumes are running low on free space 
 + INFO: 2015-10-30 21:57:52: Please look at the log /opt/oracle/oak/log/odavm02-rac/patch/12.1.2.5.0/prepatch_5974.log for more details 
 + 
 +error at<Command = /usr/bin/ssh -l root odavm02-rac /opt/oracle/oak/pkgrepos/System/12.1.2.5.0/bin/prepatch -v 12.1.2.5.0 --infra> and errnum=<1> 
 +ERROR  : Command = /usr/bin/ssh -l root odavm02-rac /opt/oracle/oak/pkgrepos/System/12.1.2.5.0/bin/prepatch -v 12.1.2.5.0 --infra did not complete successfully. Exit code 1 #Step -1# 
 +Exiting... 
 +ERROR: Failed to apply the patch 
 +</code> 
 +  *  Solution
 Clean the / directory and ensure at least 3G available! Clean the / directory and ensure at least 3G available!
-====gi patch fails with==== +=== gi patch fails with === 
-<code>48@@</code> +<code> 
-  * Solution+[[root@odavm01-rac ~]]# /opt/oracle/oak/bin/oakcli update -patch  12.1.2.5.0 --gi 
 +WARNING: One or more shared repos are running. They need to be stopped before patching the GI 
 +You have new mail in /var/spool/mail/root 
 +[[root@sdtcsynoda01-rac ~]]# oakcli show repo 
 + 
 +          NAME                          TYPE            NODENUM  FREE SPACE     STATE           SIZE 
 +          odarepo1                      local                         N/    N/            N/A 
 +          odarepo2                      local                         N/    N/            N/A 
 +          srepo                         shared          0            14.88%     ONLINE          307200.0M 
 +          srepo                         shared          1            14.88%     ONLINE          307200.0M 
 +</code> 
 +  *  Solution
 Stop the shared repositories Stop the shared repositories
-<code>49@@</code> +<code> 
-====If Grid agent does not restart==== +[[root@odavm01-rac ~]]# oakcli stop repo srepo
-<code>50@@</code>+
  
-  * Problem+Successfully stopped SharedRepo srepo on node 1 
 +Successfully stopped SharedRepo srepo on node 0 
 + 
 +[[root@odavm01-rac ~]]# oakcli show repo 
 + 
 +          NAME                          TYPE            NODENUM  FREE SPACE     STATE           SIZE 
 +          odarepo1                      local                         N/    N/            N/A 
 +          odarepo2                      local                         N/    N/            N/A 
 +          srepo                         shared          0               N/    OFFLINE         N/A 
 +          srepo                         shared          1               N/    OFFLINE         N/A 
 + 
 +</code> 
 +=== If Grid agent does not restart === 
 +<code> 
 +[[oracle@odavm02-rac SH]]$ emctl status agent 
 +Oracle Enterprise Manager Cloud Control 12c Release 4 
 +Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved. 
 +--------------------------------------------------------------- 
 +Status agent Failure:unable to connect to http server at https://odavm02-rac.localwan.net:3872/emd/lifecycle/main/. [[peer not authenticated]] 
 + 
 + 
 +[[oracle@odavm02-rac SH]]$ emctl start agent 
 +Oracle Enterprise Manager Cloud Control 12c Release 4 
 +Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved. 
 +Agent status could not be determined.  Check the agent process 
 +Consult emctl.log and emagent.nohup in: /u01/app/oracle/agent/12.1.0.4/agent_inst/sysman/log 
 +</code> 
 + 
 +   Problem
 Grid agent was probably started from wrong ORACLE_HOME Grid agent was probably started from wrong ORACLE_HOME
  
-  * Solution+  *  Solution
 Kill any old agent processes and restart Kill any old agent processes and restart
-<code>51@@</code>+<code> 
 +ps -ef | grep emagent 
 +kill -9 <emagent processes> 
 +emctl start agent 
 +</code> 
patching_oracle_database_appliance_oda.1544130327.txt.gz · Last modified: 2018/12/06 21:05 by 91.177.234.129

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki