Category: Install Upgrade and Patches

How To Clone Oracle Database Home In 19c by Using Deprecated Clone.pl

In following two posts, “clone.pl” has been used for cloning 12c and 18c Oracle Database Home.

How to Clone Oracle RAC Home in 12c

Cloning an Oracle Database Home in 18c

Lets’ follow  How to Clone 19c Oracle Database Home , and try to clone 19c ORCALE_HOME from one host to another.

Please note cloning is a re-running of new installation, which uses make, (ora)ld, etc.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

Oracle Database 19c Software Installation in Silent Mode

This blog illustrates how to install 19c Oracle database software  on Oracle Linux in silent mode.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

Deinstall 18c Grid Infrastructure Home After Being Upgraded to 19c

Grid Infrastructure 18c has been upgraded to 19c GI successfully. So 18c GI_HOME needs to be de-installed.  There are two ways to uninstall the old GI_HOME ( 18c ).

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

How to Apply Oracle RAC PSU/RU/RUR Patches by Using Fleet Maintenance in Oracle Enterprise Manager Cloud Control

It is a recommended new way to apply patches by using fleet maintenance in  Enterprise Manager (EM) Cloud Control .  Fleet maintenance uses the Out of Place Patching option. Also this can be done only via emcli verb and there is no GUI option available.

This post demonstrates how to apply the latest Release Update DB Apr 2020 Release Update 12.2.0.1.200414  and  OJVM Apr 2020 Release Update 12.2.0.1.200414.

Environment:

RAC Database : RACTESTB
RAC Instances: RACTESTB1 / RACTESTB2
Current ORACLE_HOME:    /u01/app/oracle/product/12.2.0/dbhome_1
Referenced ORACLE_HOME: /u01/app/oracle/product/12.2.0/dbhome_g
REF_TARGET_NAME : OraDB12c_Home1_g
New Out of Place ORACLE_HOME:/u01/app/oracle/product/12.2.0/dbhome_2

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

Check and Confirm RU and OJVM Applied into CDB/PDB

Check patches have been applied onto CDB.

SQL> connect / as sysdba
SQL> select PATCH_ID,VERSION,STATUS,ACTION,DESCRIPTION 
       from dba_registry_sqlpatch 
      where DESCRIPTION like '%12.2.0.1.200414%';

  PATCH_ID VERSION   STATUS   ACTION  DESCRIPTION
---------- --------- -------- ------- ------------------------------------------------
  30805580 12.2.0.1 SUCCESS  APPLY    OJVM RELEASE UPDATE 12.2.0.1.200414
  30886680 12.2.0.1 SUCCESS  APPLY    DATABASE APR 2020 RELEASE UPDATE 12.2.0.1.200414

Also confirm patches have been applied onto PDB.

SQL> alter session set container=RACTESTBPDB;

Session altered.

SQL> select PATCH_ID,VERSION,STATUS,ACTION,DESCRIPTION 
from dba_registry_sqlpatch 
where DESCRIPTION like '%12.2.0.1.200414%';

PATCH_ID VERSION STATUS ACTION DESCRIPTION
---------- --------- -------- ------- ------------------------------------------
30805580 12.2.0.1 SUCCESS APPLY OJVM RELEASE UPDATE 12.2.0.1.200414
30886680 12.2.0.1 SUCCESS APPLY DATABASE APR 2020 RELEASE UPDATE 12.2.0.1.200414

Check Cluster Database Configuration Updated with New Home

Oracle targets and cluster database are updated with new ORACLE_HOME accordingly.

[oracle@racnode1 ~]$ srvctl config database -d RACTESTB
Database unique name: RACTESTB
Database name: RACTESTB
Oracle home: /u01/app/oracle/product/12.2.0/dbhome_2
...
..
.

chmod: changing permissions of ‘$ORACLE_HOME/bin/extjobO’: Operation not permitted

While applying Oracle database PSU/RU/RUR patches, we always see the following or similar warnings.

OPatch found the word "error" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
chmod: changing permissions of ‘/u01/app/oracle/product/12.2.0/dbhome_1/bin/extjobO’: Operation not permitted
make: [iextjob] Error 1 (ignored)

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe