Category Archives: Upgrading and Patching

ohasd failed to start

Situation : 1) Two 11.2.0.4 RAC nodes( racnode1/2). Deleted node racnode2 . Upgraded OS from RHEL 4  to RHEL 7 for racnode2, then tried to add node racnode2 back into cluster from racnode1. 2) export IGNORE_PREADDNODE_CHECKS=Y, Ran addnode.sh ->  orainstRoot.sh->root.sh, … Continue reading

Posted in GI and RAC, Upgrading and Patching | Tagged , , , , , , , , , , | Leave a comment

Opatch Throws error : java.text.ParseException: Unparseable date: “2016.Aug.09 08:27:15 AEST

SYMPTOMS For 12.1.0.2 GI Home,  opatch  12.2.0.1.5 and later versions  throw below errors : $ opatch lsinventory Oracle Interim Patch Installer version 12.2.0.1.5 Copyright (c) 2016, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/12.1.0.2/grid Central Inventory : /u01/app/oraInventory from … Continue reading

Posted in 12c new features, Configuration, Upgrading and Patching | Tagged , , , , , , , , , , , , , , , | Leave a comment

ORA-01623: log 31 is current log for instance RACTEST3 (thread 3) – cannot drop

Three nodes RAC database was migrated to two nodes RAC database, while trying to drop online redo logs of thread 3,  the errors are as below: SQL> alter database drop logfile group 31; alter database drop logfile group 31 * … Continue reading

Posted in 12c new features, Configuration, GI and RAC, ORA- ERRORS, Upgrading and Patching | Tagged , , , , , | Leave a comment

Is MGMTDB Patched While Applying GI PSU ?

Yes, while applying PSU patch onto GI, we can see GIMR database “-MGMTDB” is patched as well. a) Logs from “opatchauto apply” shows MGMTDB is patched while applying GI PSU: System initialization log file is /u01/app/12.1.0.2/grid/cfgtoollogs/opatchautodb/systemconfig2016-09-19_12-46-41PM.log. Session log file is … Continue reading

Posted in 12c new features, Configuration, Upgrading and Patching | Tagged , , , , , , , | Leave a comment

How to Relink 12c Oracle GI / RAC Binaries after OS Upgrade

Here are the practical steps for relinking Oracle Grid Infrastructure and RAC binaries after OS upgrading or patching. Shut down  all the Oracle databases, stop EM agent, etc. $ srvctl stop database -d DBNAME $ emctl stop agent 2.  Stop … Continue reading

Posted in 12c new features, Upgrading and Patching | Tagged , , , , , , , , , , | 2 Comments

How to Fix Incomplete RDBMS DST Upgrading in 12c

There is a database upgraded from 11.2.0.4 to 12.1.0.2 by using “”Complete Checklist for Upgrading to Oracle Database 12c Release 1 using DBUA (Doc ID 1516557.1).”. For some reason, the DST upgrading was not complete successfully after the upgrading checking: … Continue reading

Posted in 12c new features, Upgrading and Patching | Tagged , , , , , | Leave a comment

How to use WGET to download Oracle binary software from MOS

Situation Due to security or firewall issue, we have to download Oracle software from a sever where web browser is unavailable. Here is an example how to download the patches by using wget utility. Implementation 1) Search the patch you want: … Continue reading

Posted in Oracle DBA Practice, Upgrading and Patching | Tagged , , , , , , , , | Leave a comment

Apply Database Patch Set Update 12.1.0.2.2 (Includes CPUJan2015) and Oracle JavaVM Component 12.1.0.2.2 Database PSU (Jan2015) onto CDB Database

1) Download and put in place opatch 12.1.0.1.6 as README required. 2)Download patch “p20132434_121020_Linux-x86-64.zip” which includes both database and JVM 12.1.0.2.2 PSU 3)unzip p20132434_121020_Linux-x86-64.zip 4) cd 20132434 [oracle@racnote1 20132434]$ ls -ltr drwxrwx—. 1 root vboxsf 0 Jan 21 01:09 19769480 -rwxrwx—. 1 … Continue reading

Posted in 12c new features, Upgrading and Patching | Tagged , , , , , , | 1 Comment

Apply OCT2014 DB PSU OJVM PSU and JDBC Patch Onto 11.2.0.4 ORACLE_HOME

Situation: There is a requirement to apply Oct 2014 PSU onto 11.2.0.4 ORACLE_HOME. From Oct 2014 onwards, Oracle JavaVM Component Database PSU is released as part of the Critical Patch Update program. It consists of two separate patches: One for … Continue reading

Posted in Oracle DBA Practice, Upgrading and Patching | Tagged , , , , , , , , | 1 Comment