Search <book_title>...

NetBackup IT Analytics Installation and Upgrade Guide for Linux

Last Published: 2025-03-04

Product(s): NetBackup IT Analytics (11.4)

Installing the Oracle patches

As a root user, create a copy of Oracle database combo patch and JDK bundle patch files from /tmp to /opt/aptare/oracle folder using following commands:
```
mv p37262172_190000_Linux-x86-64.zip /opt/aptare/oracle
mv p37213431_190000_Linux-x86-64.zip /opt/aptare/oracle
```
Navigate to /opt/aptare/oracle folder and unzip the file.
```
cd /opt/aptare/oracle
unzip p37262172_190000_Linux-x86-64.zip
```
The above command will create a 36866623 folder in /opt/aptare/oracle folder.
unzip p37213431_190000_Linux-x86-64.zip
The above command will create a 36866578 folder in /opt/aptare/oracle.
During the unzip if you see the below message put 'y' as shown below.
```
replace PatchSearch.xml? [y]es, [n]o, [A]ll, [N]one, [r]ename: y
```
Set permission on patch folders 37262172 and 37213431
```
chown -R aptare:dba 37262172
chown -R aptare:dba 37213431
```
Note:
If you have already installed an Oracle patch previously, skip the following steps from 4 through 10.

As root user copy the two jar files from /tmp to /opt/aptare/oracle/sqldeveloper/sqldeveloper/lib folder.

mv xdb6.jar /opt/aptare/oracle/sqldeveloper/sqldeveloper/lib
mv xmlparserv2-sans-jaxp-services.jar 
/opt/aptare/oracle/sqldeveloper/sqldeveloper/lib

Change permissions on the jar files and perl

cd /opt/aptare/oracle/sqldeveloper/sqldeveloper/lib
chown -R aptare:dba xdb6.jar
chown -R aptare:dba xmlparserv2-sans-jaxp-services.jar
cd /opt/aptare/oracle
chown -R aptare:dba perl
chmod -R 775 perl

Check if oraInventory folder is available under /opt/. If the folder is not available, then
```
cd /opt/aptare/upgrade
cp oraInventory.zip /opt/
unzip oraInventory
```
Check permission on /opt/oraInventory folder if it is aptare:dba else change the permission
```
cd /opt/
chown -R aptare:dba oraInventory
```
Run su - aptare command.

Run the following command to attach the Oracle home

$ORACLE_HOME/oui/bin/runInstaller -silent -ignoreSysPrereqs -invPtrLoc "/opt/aptare/oracle/oraInst.loc" -attachHome ORACLE_HOME="/opt/aptare/oracle" ORACLE_HOME_NAME="OraDB19c_home" INVENTORY_LOCATION="/opt/oraInventory"

Note:

If the oracle home is already attached, Oracle Home already exists at this location. Select another location message is displayed. Ignore this message.

Follow the steps to make changes for fuser if you see the fuser error 'Missing command :fuser'
```
cd /opt/aptare/oracle/bin/
touch fuser
chmod 755 fuser
```
Connect as user aptare, if continuing from step 3 by using the below command else proceed to next step.
su - aptare

Set PATH. Make sure you set all the paths else patch application might fail.

export PATH=$PATH:/opt/aptare/oracle/OPatch
export PATH=$PATH:/usr/ccs/bin
PATH=$PATH:/opt/aptare/oracle/sqldeveloper/sqldeveloper/lib

Check for any OPatch conflicts.

This will check for conflicts for both the database RU patch and OJVM patches.

cd /opt/aptare/oracle/37262172
/opt/aptare/oracle/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /opt/aptare/oracle
Central Inventory : /opt/oraInventory
from              : /opt/aptare/oracle/oraInst.loc
OPatch version    : 12.2.0.1.45
OUI version       : 12.2.0.7.0
Log file location : /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-02-07_13-48-23PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

If no conflicts are detected, run the following command to apply database RU patch from /opt/aptare/oracle/37262172/37260974 folder.

cd /opt/aptare/oracle/37262172/37260974
   
/opt/aptare/oracle/OPatch/opatch apply

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 37260974
Do you want to proceed? [y|n]
y    
User Responded with: Y
All checks passed.
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch 37260974 to OH '/opt/aptare/oracle'
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.pg4mq, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.precomp.companion, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.ldap.ztk, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.java.sqlj.sqljruntime, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] , [ oracle.jdk, 1.8.0.391.11 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 19.0.0.0.0...
Patching component oracle.rdbms.util, 19.0.0.0.0...
Patching component oracle.rdbms, 19.0.0.0.0...
Patching component oracle.assistants.acf, 19.0.0.0.0...
Patching component oracle.nlsrtl.rsf.ic, 19.0.0.0.0...
Patching component oracle.precomp.common, 19.0.0.0.0...
Patching component oracle.precomp.lang, 19.0.0.0.0...
Patching component oracle.jdk, 1.8.0.201.0...

Patch 37260974 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [37260974].

Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-02-07_13-59-13PM_1.log
OPatch succeeded.

Note:

Ignore any warnings related to rollback of patch. This message is displayed when no prior Oracle security patches were applied.

Run the following commands to apply OJVM patch from /opt/aptare/oracle/37262172/37102264 folder.

cd /opt/aptare/oracle/37262172/37102264 
    /opt/aptare/oracle/OPatch/opatch apply
Verifying environment and performing prerequisite checks...
OPatch continues with these patches:37102264
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/opt/aptare/oracle')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '37102264' to OH '/opt/aptare/oracle'
Patching component oracle.javavm.server, 19.0.0.0.0...
Patching component oracle.javavm.server.core, 19.0.0.0.0...
Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...
Patching component oracle.rdbms, 19.0.0.0.0...
Patching component oracle.javavm.client, 19.0.0.0.0...
Patch 37102264 successfully applied.
Sub-set patch [36414915] has become inactive due to the application of a super-set patch [36878697].
Refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-02-07_14-08-56PM_1.log
OPatch succeeded.

Navigate to /opt/aptare/oracle/37213431 and check for any OPatch conflicts for the JDK bundle patch.

cd /opt/aptare/oracle/37213431
/opt/aptare/oracle/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /opt/aptare/oracle
Central Inventory : /opt/oraInventory
   from           : /opt/aptare/oracle/oraInst.loc
OPatch version    : 12.2.0.1.45
OUI version       : 12.2.0.7.0
Log file location : /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-02-07_14-19-28PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.

If no conflicts are detected, execute the following commands to apply JDK patch from /opt/aptare/oracle/37213431 folder.

cd /opt/aptare/oracle/37213431
   
/opt/aptare/oracle/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.45
Copyright (c) 2025, Oracle Corporation.  All rights reserved.


Oracle Home       : /opt/aptare/oracle
Central Inventory : /opt/oraInventory
   from           : /opt/aptare/oracle/oraInst.loc
OPatch version    : 12.2.0.1.45
OUI version       : 12.2.0.7.0
Log file location : /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-02-07_14-20-58PM_1.log


Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 37213431

Do you want to proceed? [y|n]
y
User Responded with: Y

All checks passed.
Backing up files...
Applying interim patch '37213431' to OH '/opt/aptare/oracle'

ApplySession: Optional component(s) [ oracle.jdk, 1.8.0.191.0 ], [ oracle.jdk, 1.8.0.391.11]
not present in the Oracle Home or a higher version is found.
Patching component oracle.jdk, 1.8.0.201.0...
Patch 36866578 successfully applied.
Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/opatch2025-02-07_14-20-58PM_1.log

OPatch succeeded.

Ignore any messages about JDK not present or higher version present, "ApplySession: Optional component(s) [ oracle.jdk, 1.8.0.191.0 ] not present in the Oracle Home or a higher version is found."

Verify OPatch succeeded with the following commands which will display the OPatch application results for the database, OJVM and JDK bundle patches:
```
/opt/aptare/oracle/OPatch/opatch lsinventory -detail
    .
    .
    .
OPatch succeeded.
```
Connect to SQL Plus using following command:
-bash-4.2$ sqlplus /nolog
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Feb 7 14:23:49 2025
Version 19.26.0.0.0
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Connect as sysdba
SQL> connect / as sysdba
Connected to an idle instance.
Start the database.
SQL> startup
ORACLE instance started.
:
:
Database mounted.
Database opened.
Open all pluggable database.
SQL> alter pluggable database all open;
Pluggable database altered.
Exit from SQL prompt.
SQL> quit

Datapatch is run to complete the post-install SQL deployment for the patch being installed.

Run the following command to apply the patch to the pluggable database (This may take few minutes)

/opt/aptare/oracle/OPatch/datapatch -verbose

Note:

If run utlrp.sql message is displayed, to re-validate, run it

SQL Patching tool version 19.26.0.0.0 Production on Fri Feb  7 14:26:04 2025
Copyright (c) 2012, 2025, Oracle.  All rights reserved.

Log file for this invocation: /opt/aptare/cfgtoollogs/sqlpatch/sqlpatch_17246_2025_02_07_14_26_04/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done

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 interim SQL patches:
Interim patch 37102264 (OJVM RELEASE UPDATE: 19.26.0.0.250121 (37102264)):
  Binary registry: Installed
  PDB CDB$ROOT: Not installed
  PDB PDB$SEED: Not installed
  PDB SCDB: Not installed

Current state of release update SQL patches:
  Binary registry:
    19.26.0.0.0 Release_Update 250118124854: Installed
  PDB CDB$ROOT:
    No release update patches installed
  PDB PDB$SEED:
    No release update patches installed
  PDB SCDB:
    No release update patches installed

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED SCDB
    No interim patches need to be rolled back
    Patch 37260974 (Database Release Update : 19.26.0.0.250121 (37260974)):
      Apply from 19.1.0.0.0 Feature Release to 19.26.0.0.0 Release_Update 250118124854
    The following interim patches will be applied:
      37102264 (OJVM RELEASE UPDATE: 19.26.0.0.250121 (37102264))

Installing patches...
Patch installation complete.  Total patches installed: 6
Validating logfiles...
done
Patch 37260974 apply (pdb CDB$ROOT): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/37260974/26040769/
37260974_apply_SCDBCNTR_CDBROOT_2025Feb07_14_26_53.log (no errors)
Patch 37102264 apply (pdb CDB$ROOT): SUCCESS

  logfile: /opt/aptare/cfgtoollogs/sqlpatch/37102264/25987410/37102264_apply_SCDBCNTR_CDBROOT_2025Feb07_14_26_53.log (no errors)
Patch 37260974 apply (pdb PDB$SEED): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/37260974/26040769/
37260974_apply_SCDBCNTR_PDBSEED_2025Feb07_14_30_39.log (no errors)
Patch 37102264 apply (pdb PDB$SEED): SUCCESS

  logfile: /opt/aptare/cfgtoollogs/sqlpatch/37102264/25987410/37102264_apply_SCDBCNTR_PDBSEED_2025Feb07_14_30_39.log (no errors)
Patch 37260974 apply (pdb SCDB): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/37260974/26040769/
37260974_apply_SCDBCNTR_SCDB_2025Feb07_14_30_39.log (no errors)
Patch 37102264 apply (pdb SCDB): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/37102264/25987410/
37102264_apply_SCDBCNTR_SCDB_2025Feb07_14_30_39.log (no errors)

Automatic recompilation incomplete; run utlrp.sql to revalidate.
PDBs: PDB$SEED

SQL Patching tool complete 

-bash-4.2$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jul 17 13:09:16 2024
.
Version 19.24.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.

Connected to:

Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production

Version 19.24.0.0.0

SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

Check the log files in /opt/aptare/cfgtoollogs/sqlpatch/ for errors. The log file name includes the current timestamp:

Example:

Log file for this invocation: 
/opt/aptare/cfgtoollogs/sqlpatch/sqlpatch_20899_2024_10_26_01_55_09/sqlpatch_invocation.log

Start all the services as a root user.
```
/opt/aptare/bin/aptare start
```