Opatch issue

[Roshan]

Oracle Database 12c
Red Hat Linux 6.5

Hello,

when I am applying database PSU patch, I am getting the error below

[ora12c@RHIS-OF-APP01 OPatch]$ opatch apply 24433133
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


ZOP-51: The patch location is not valid for apply, because it doesn't have correct metadata, or it points to a patch directory.
Argument(s) Error... Patch location is not valid for apply

Please check the arguments and try again.

OPatch failed with error code 135

Grateful if you can investigate

Regards,
Roshan

[ErmanArslansOracleBlog]

For PSU, you need to supply the directory name. (If apply PSU patch with traditional "opatch apply", the sub-directory for database/OCW patch should be given.)
"Read the readme to apply the PSU patch . Follow the read me of it."

You can refer to this document for understanding what I mean;
opatch apply" failed with Error Code 135/ZOP-51 (Doc ID 2102532.1)

[Roshan]

I checked the Oracle SID and fixed it. I shutdown the database and listener and I was able to proceed.

Thanks.

Is there a way I can apply database patches with no downtime?

[ErmanArslansOracleBlog]

setting the ORACLE_SID environment variable fixed it? Are you sure?
ORACLE_SID must be set right, but is it the cause of the error ZOP-51?

In your previous comment it can be seen that you are giving an argument to the opatch apply command.

Here you give patch number, and it is wrong. There is no usage like that.
" opatch apply 24433133 " --> this is wrong. So this actually seemed to be your problem.. You just need to execute "opatch apply"

As for your other question;

Applying patches with No down time can be done in RAC environments. I mean the rolling strategy ->

Patching RAC using a rolling strategy - No down time (Rolling Patch)
With this method, there is no downtime. Each node would be patched and brought up while all the other nodes are up and running, resulting in no disruption of the system.

Rolling patching strategy incur no downtime, however, some rolling patches may incur downtime due to post-installation steps, i.e. running sql scripts to patch the actual database. Please refer to patch readme to find out whether post-installation steps requires downtime or not.

Ofcourse, the patch that you want to install should be Rac Rolling installable.

For example, the patch that you are trying to apply is not RAC rolling installable.
It is written in its readme -> This patch is not Oracle RAC Rolling installable.

[Patricia]

I got this same message when I tried to apply a patch with the wrong directory/file permissions. I copied the file to the server as root and forgot to sudo su to oracle when I unzipped it. Once I  'chown -R' the entire patch directory, the patch installed perfectly.

Misleading error message and took me a while to find it.

[ErmanArslansOracleBlog]

thanks for sharing Patricia.

[Rajesh]

Hi,
I installed Oracle database 12C and after installation am trying to apply patches.When i tried am getting the same error.

Oracle home path :-
oracle_home : C:\oracle12c\product\12.2.0\dbhome_1

I used the below commands :-
set oracle_home=c:\oracle12c\product\12.2.0\dbhome_1
set PATH=c:\oracle12c\product\12.2.0\dbhome_1\OPatch;%PATH%

Can anyone suggest me of how to resolve the issue.

[ErmanArslansOracleBlog]

Send me the output of the opatch session.
I want to see the Error code of Opatch.

[Rajesh]

Thanks for the reply,

I executed the below command :-
C:\oracle12c\product\12.2.0\dbhome_1\OPatch>opatch apply

After typing opatch apply and enter i got the below error messages :-

Oracle Interim Patch Installer version 12.2.0.1.14
Copyright (c) 2018, Oracle Corporation.  All rights reserved.


ZOP-51: The patch location is not valid for apply, because it doesn't have correct metadata, or it points to a patch directory.
Argument(s) Error... Patch location is not valid for apply

Please check the arguments and try again.

OPatch failed with error code = 135



*********************

I saw in the cfgtoollogs folder and in the log file i got the below message :-


[Nov 14, 2018 1:09:07 AM] [INFO]    ZOP-51: The patch location is not valid for apply, because it doesn't have correct metadata, or it points to a patch directory.
[Nov 14, 2018 1:09:07 AM] [SEVERE]  OUI-67135:Argument(s) Error... Patch location is not valid for apply
[Nov 14, 2018 1:09:07 AM] [INFO]    Please check the arguments and try again.
[Nov 14, 2018 1:09:07 AM] [INFO]    Stack Description: java.lang.UnsupportedOperationException: Argument(s) Error... Patch location is not valid for apply
                                   
                                    at oracle.opatch.OPatch.process(OPatch.java:791)
                                    at oracle.opatch.OPatch.main(OPatch.java:861)

[ErmanArslansOracleBlog]

You are in the wrong directory.
Go to patch directory and apply the patch from there..

Please read opatch documentation..