if you want check the CPU patch is whether rolling support or not

To check if a CPU patch supports rolling upgrades, you need to use the opatch query -all command. This command provides detailed information about the patches applied to your Oracle Home.

Here's the SOP:

Standard Operating Procedure (SOP) to Check if a CPU Patch Supports Rolling Upgrade:

1. Log in to the Oracle Server: Connect to the server where your Oracle database software is installed, using the oracle user or an account with appropriate permissions to run opatch.

2. Set Oracle Environment: Ensure your ORACLE_HOME and PATH are correctly set for the Oracle Home you want to check. You can use the oraenv utility for this:

   . oraenv
   

   (Enter the ORACLE_SID associated with the ORACLE_HOME you're interested in, or set ORAENV_ASK=N and ORACLE_SID before running).

3. Execute opatch query -all: Run the opatch command with the -all option.

   opatch query -all
   

4. Review the Output: In the output generated by opatch query -all, look for a line that explicitly states whether the patch is a rolling patch or not.

   You will find a line similar to this:

   Patch is a rolling patch: true
   

   or

   Patch is a rolling patch: false
   

   • If the value is true, then the CPU patch supports rolling upgrades.
   • If the value is false, then the CPU patch does not support rolling upgrades, and a full cluster shutdown might be required for patching.

This line is the definitive indicator within the opatch output for rolling patch support.