Search <book_title>...

NetBackup IT Analytics Installation and Upgrade Guide for Linux

Last Published: 2023-03-01

Product(s): NetBackup IT Analytics (11.0)

Install the Oracle patch

As a root user, copy the Oracle patch file from /tmp to/opt/aptare/oracle folder using the following command:
```
mv p34773489_190000_Linux-x86-64.zip /opt/aptare/oracle
```
Run the command su - aptare
Navigate to /opt/aptare/oracle folder and unzip the file.
```
cd /opt/aptare/oracle
unzip p34773489_190000_Linux-x86-64.zip
```
The above command will create a 34773489 folder in /opt/aptare/oracle folder.
If the below message is displayed while you unzip the file, enter y in its response.
replace PatchSearch.xml? [y]es, [n]o, [A]ll, [N]one, [r]ename: is displayed, enter y.
Set permission on patch folder 34773489.
```
chown -R aptare:dba 34773489
```
Note:
If the Oracle patch is not Veritas provided and have already installed Oracle patch, skip the following steps from 5 through 11.

As a 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 the permissions on the jar files and the 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
```
su - aptare

Run 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"

If the oracle home is already attached, the message 'Oracle Home already exists at this location. Select another location' will be displayed. Ignore the 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
```

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 step will verify for any conflicts on both the database RU patch and OJVM patches.
```
cd /opt/aptare/oracle/34773489
/opt/aptare/oracle/OPatch/opatch prereq 
CheckConflictAgainstOHWithDetail -ph ./
```

If no conflicts are detected, run the following commands to apply database RU patch from /opt/aptare/oracle/34773489/34765931 folder.

cd /opt/aptare/oracle/34773489/34765931
/opt/aptare/oracle/OPatch/opatch apply

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   34765931

Do you want to proceed? [y|n]
y

Is the local system ready for patching? [y|n]
y

Patching component oracle.jdk, 1.8.0.201.0...

Patch 34765931 successfully applied.

Sub-set patch [34419443] has become inactive due to the application of a 
super-set patch [34765931].

Please refer to Doc ID 2161861.1 for any possible 
further required actions.

Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/
opatch2023-02-06_15-44-28PM_1.log

 OPatch completed with warnings.

Note:

Ignore the warning message if it is related to rollback of patch 30565805. The message is displayed when no prior Oracle security patches were applied.

Run the following commands to apply OJVM patch from /opt/aptare/oracle/34773489/34786990 folder.

cd /opt/aptare/oracle/34773489/34786990
/opt/aptare/oracle/OPatch/opatch apply
Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   34786990
Do you want to proceed? [y|n]
y
Is the local system ready for patching? [y|n]
y
Patching component oracle.javavm.server, 19.0.0.0.0...
Patching component oracle.javavm.server.core, 19.0.0.0.0...
.
.
Patch 34786990 successfully applied.
Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/
opatch2023-02-06_15-50-55PM_1.log
OPatch succeeded.

Verify OPatch succeeded with the following command:
Note:
The commands will display the OPatch application of both the database and OJVM patches.
```
cd /opt/aptare/oracle/34773489
/opt/aptare/oracle/OPatch/opatch lsinventory -detail
```

Connect to sqlplus using the following command:

-bash-4.2$ sqlplus /nolog
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Feb 6 15:56:17 2023
Version 19.18.0.0.0
Copyright (c) 1982, 2022, 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
```

Run the database patch to complete the post-install SQL deployment for the patch being installed.

Run the following commands to apply the patch to the pluggable database (this may take few minutes).

/opt/aptare/oracle/OPatch/datapatch -verbose
Patch installation complete.  Total patches installed: 9

Validating logfiles...done
Patch 34411846 rollback (pdb CDB$ROOT): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/34411846
/24917919/34411846_rollback_SCDBCNTR_CDBROOT_2023Feb06_15_58_27.log 
(no errors)

Patch 34765931 apply (pdb CDB$ROOT): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/34765931
/25098466/34765931_apply_SCDBCNTR_CDBROOT_2023Feb06_15_58_27.log 
(no errors)

Patch 34786990 apply (pdb CDB$ROOT): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/34786990
/25032666/34786990_apply_SCDBCNTR_CDBROOT_2023Feb06_15_58_27.log 
(no errors)

Patch 34411846 rollback (pdb PDB$SEED): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/34411846
/24917919/34411846_rollback_SCDBCNTR_PDBSEED_2023Feb06_15_58_56.log 
(no errors)

Patch 34765931 apply (pdb PDB$SEED): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/34765931
/25098466/34765931_apply_SCDBCNTR_PDBSEED_2023Feb06_15_58_56.log 
(no errors)

Patch 34786990 apply (pdb PDB$SEED): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/34786990
/25032666/34786990_apply_SCDBCNTR_PDBSEED_2023Feb06_15_58_56.log 
(no errors)

Patch 34411846 rollback (pdb SCDB): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/34411846
/24917919/34411846_rollback_SCDBCNTR_SCDB_2023Feb06_15_58_56.log 
(no errors)

Patch 34765931 apply (pdb SCDB): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/34765931
/25098466/34765931_apply_SCDBCNTR_SCDB_2023Feb06_15_58_56.log 
(no errors)

Patch 34786990 apply (pdb SCDB): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/34786990
/25032666/34786990_apply_SCDBCNTR_SCDB_2023Feb06_15_58_56.log 
(no errors)
.
.
SQL Patching tool complete on Mon Feb  6 15:59:32 2023

Check the log file in /opt/aptare/cfgtoollogs/sqlpatch/ for errors.
The log file name includes the current timestamp:
Example: /opt/aptare/cfgtoollogs/sqlpatch/sqlpatch_
32228_2023_02_06_15_57_52/sqlpatch_invocation.log
Start all the services as a root user.
```
/opt/aptare/bin/aptare start
```