Search <book_title>...

APTARE IT Analytics Installation and Upgrade Guide for Linux

Last Published: 2022-09-01

Product(s): APTARE IT Analytics (10.6)

Installing the Oracle patch

As a root user, copy the Oracle patch file from /tmp to /opt/aptare/oracle folder using following command:
```
mv p34133642_190000_Linux-x86-64.zip /opt/aptare/oracle
```
su - aptare
Navigate to /opt/aptare/oracle folder and unzip the file.
```
cd /opt/aptare/oracle
unzip p34133642_190000_Linux-x86-64.zip
```
The above command will create a 34133642 folder in /opt/aptare/oracle folder
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 folder 34133642
```
chown -R aptare:dba 34133642
```
Note:
If you have already installed an Oracle patch previously, skip the following steps from 5 through 11.

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
```
Execute su -aptare

Execute 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
```

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.

cd /opt/aptare/oracle/34133642
/opt/aptare/oracle/OPatch/opatch prereq CheckConflictAgainstOHWithDetail 
-ph ./

If no conflicts are detected, execute the following command to apply patch from /opt/aptare/oracle/34133642 folder.

/opt/aptare/oracle/OPatch/opatch apply

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   34133642
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...

Sub-set patch [33806152] has become inactive due to the application of a super-set patch [34133642].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /opt/aptare/oracle/cfgtoollogs/opatch/opatch2022-07-20_20-44-05PM_1.log
OPatch succeeded.

Verify OPatch succeeded with the following command:

/opt/aptare/oracle/OPatch/opatch lsinventory -detail

Connect to SQL Plus using following command:
-bash-4.2$ sqlplus /nolog
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jul 20 20:55:30 2022
Version 19.16.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

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

Execute the following command 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: 3

Validating logfiles...done

Patch 34133642 apply (pdb CDB$ROOT): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/34133642/24865470/
34133642_apply_SCDBCNTR_CDBROOT_2022Jul20_20_58_00.log (no errors)

Patch 34133642 apply (pdb PDB$SEED): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/34133642/24865470/
34133642_apply_SCDBCNTR_PDBSEED_2022Jul20_20_59_00.log (no errors)

Patch 34133642 apply (pdb SCDB): SUCCESS
  logfile: /opt/aptare/cfgtoollogs/sqlpatch/34133642/24865470/
34133642_apply_SCDBCNTR_SCDB_2022Jul20_20_59_00.log (no errors)
SQL Patching tool complete on Wed Jul 20 21:00:09 2022

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