Oracle 19c Update Patch

single-instance

How To Download And Install The Latest OPatch(6880880) Version

1. Please download the latest OPatch version from My Oracle Support (MOS) using the next reference: Patch 6880880 Or using the next URL:  https://updates.oracle.com/download/6880880.html
2. In the "Platform" field select the relevant platform that corresponds to the Oracle product.
3. Click the Download button.
4. Upload the opatch.zip file to your OS host and unzip it:

登录后复制

user(root)
chown oracle:ointsall /<unzipped_patch_location>/p6880880_190000_linux-x86-64.zip

user(oracle)
mv /<unzipped_patch_location>/p6880880_190000_linux-x86-64.zip $ORACLE_HOME/
mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_date_bak
cd $ORACLE_HOME
unzip p6880880_190000_linux-x86-64.zip

$ORACLE_HOME/OPatch/opatch version

• 1.
• 2.
• 3.
• 4.
• 5.
• 6.
• 7.
• 8.
• 9.
• 10.

Patch 36233263 - Database Release Update 19.23.0.0.240416(You must use the OPatch utility version 12.2.0.1.41 or later to apply this patch)

Determine whether any currently installed interim patches conflict with the patch being installed, 36233263:

登录后复制

unzip p36233263_<version>_<platform>.zip
cd 36233263
opatch prereq CheckConflictAgainstOHWithDetail -ph ./

• 1.
• 2.
• 3.

If you are using a Data Guard Physical Standby database, you must install this patch on both the primary database and the physical standby database.

shut down all instances and listeners associated with the Oracle home that you are updating.

登录后复制

sqlplus / as sysdba
alter system switch logfile;
alter system checkpoint;
shutdown immediate;
quit;

lsnrctl status
lsnrctl stop

• 1.
• 2.
• 3.
• 4.
• 5.
• 6.
• 7.
• 8.

Set your current directory to the directory where the patch is located and then run the OPatch utility by entering the following commands:

登录后复制

unzip -d <PATCH_TOP_DIR> p36233263_<version>_<platform>.zip
cd <PATCH_TOP_DIR> 36233263
$ORACLE_HOME/OPatch/opatch apply

• 1.
• 2.
• 3.

Patch 36199232 - Oracle JavaVM Component Release Update 19.23.0.0.240416

(Only for Installation) Determine whether any currently installed interim patches conflict with the patch as shown below:

登录后复制

$ cd <PATCH_TOP_DIR>/36199232

$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Set your current directory to the directory where the patch is located and then run the OPatch utility by entering the following commands:

$ cd <PATCH_TOP_DIR>/36199232
Install the patch by running the following command:

$ opatch apply

Verify whether the patch has been successfully installed by running the following command:

$ opatch lsinventory

Start the services from the Oracle home.

If there are errors, see Known Issues.

• 1.
• 2.
• 3.
• 4.
• 5.
• 6.
• 7.
• 8.
• 9.
• 10.
• 11.
• 12.
• 13.
• 14.
• 15.
• 16.
• 17.
• 18.

Steps	Non-CDB Oracle Database	Steps	Single/Multitenant (CDB/PDB) Oracle Database
1	% sqlplus /nolog	1	% sqlplus /nolog
2	SQL> Connect / as sysdba	2	SQL> Connect / as sysdba
3	SQL> startup	3	SQL> startup
4	SQL> quit	4	SQL> alter pluggable database all open;
5	% cd $ORACLE_HOME/OPatch	5	SQL> quit
6	% ./datapatch -sanity_checks (optional)	6	% cd $ORACLE_HOME/OPatch
7	% ./datapatch -verbose	7	% ./datapatch -sanity_checks (optional)
		8	% ./datapatch -verbose

Compile invalid objects

@?/rdbms/admin/utlrp.sql

RAC：

Patch 36233126 - GI Release Update 19.23.0.0.240416（You must use the OPatch utility version 12.2.0.1.41 or later to apply this patch.）

Run OPatch Conflict Check

登录后复制

Determine whether any currently installed one-off patches conflict with this patch 36233126 as follows:

As the Grid home user:

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/36233126/36233263
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/36233126/36240578
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/36233126/36233343
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/36233126/36460248
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/36233126/36383196

For Oracle home, as home user:

% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/36233126/36233263
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/36233126/36240578

• 1.
• 2.
• 3.
• 4.
• 5.
• 6.
• 7.
• 8.
• 9.
• 10.
• 11.
• 12.
• 13.
• 14.

The command output reports pass and fail messages as per the system space availability:

If OPatch reports Prereq "checkSystemSpace" failed., then cleanup the system space as the required amount of space is not available.

If OPatch reports Prereq "checkSystemSpace" passed., then no action is needed. Proceed with patch installation.

OPatchAuto

Add the directory containing the OPatchAuto to the $PATH environment variable. For example:

登录后复制

# export PATH=$PATH:<GI_HOME>/OPatch

• 1.

Or, when using -oh flag:

登录后复制

# export PATH=$PATH:<oracle_home_path>/OPatch

• 1.

To patch the Grid home and all Oracle RAC database homes of the same version:

登录后复制

# opatchauto apply <UNZIPPED_PATCH_LOCATION>/36233126

• 1.

To roll back the patch from the Grid home and each Oracle RAC database home:

登录后复制

# opatchauto rollback <UNZIPPED_PATCH_LOCATION>/36233126

• 1.

Patch 36199232 - Oracle JavaVM Component Release Update 19.23.0.0.240416

(Only for Installation) Determine whether any currently installed interim patches conflict with the patch as shown below:

登录后复制

$ cd <PATCH_TOP_DIR>/36199232

$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Set your current directory to the directory where the patch is located and then run the OPatch utility by entering the following commands:

$ cd <PATCH_TOP_DIR>/36199232
Install the patch by running the following command:

$ opatch apply

Verify whether the patch has been successfully installed by running the following command:

$ opatch lsinventory

Start the services from the Oracle home.

If there are errors, see Known Issues.

• 1.
• 2.
• 3.
• 4.
• 5.
• 6.
• 7.
• 8.
• 9.
• 10.
• 11.
• 12.
• 13.
• 14.
• 15.
• 16.
• 17.
• 18.

Steps	Non-CDB Oracle Database	Steps	Single/Multitenant (CDB/PDB) Oracle Database
1	% sqlplus /nolog	1	% sqlplus /nolog
2	SQL> Connect / as sysdba	2	SQL> Connect / as sysdba
3	SQL> startup	3	SQL> startup
4	SQL> quit	4	SQL> alter pluggable database all open;
5	% cd $ORACLE_HOME/OPatch	5	SQL> quit
6	% ./datapatch -sanity_checks (optional)	6	% cd $ORACLE_HOME/OPatch
7	% ./datapatch -verbose	7	% ./datapatch -sanity_checks (optional)
		8	% ./datapatch -verbose

Steps	Non-CDB Oracle Database	Steps	Single/Multitenant (CDB/PDB) Oracle Database
1	% sqlplus /nolog	1	% sqlplus /nolog
2	SQL> Connect / as sysdba	2	SQL> Connect / as sysdba
3	SQL> startup	3	SQL> startup
4	SQL> quit	4	SQL> alter pluggable database all open;
5	% cd $ORACLE_HOME/OPatch	5	SQL> quit
6	% ./datapatch -sanity_checks (optional)	6	% cd $ORACLE_HOME/OPatch
7	% ./datapatch -verbose	7	% ./datapatch -sanity_checks (optional)
		8	% ./datapatch -verbose

Compile invalid objects

@?/rdbms/admin/utlrp.sql

原创作者: u_13647939 转载于: https://blog.51cto.com/u_13647939/11286095