{"id":46,"date":"2020-03-25T08:42:25","date_gmt":"2020-03-25T07:42:25","guid":{"rendered":"http:\/\/mohrthomas.de\/?page_id=46"},"modified":"2023-06-16T08:02:15","modified_gmt":"2023-06-16T07:02:15","slug":"dba-blog","status":"publish","type":"page","link":"https:\/\/mohrthomas.de\/?page_id=46","title":{"rendered":"dba-blog"},"content":{"rendered":"\n

unzipPatch? OMSPatcher failed with error code = 238 EM12c<\/h1>\n\n\n\n

Hi,<\/p>\n\n\n\n

while applying the patch 28491093 i got error code = 238 with “OMSPatcher finds that no sub-patch(es) can be applied to the OMS system.”
 
I assumed that i took the wrong one but emcli returns plug-in-Versions which match the patch.
I searched logs for a couple of days, but had to create a SR at Oracle.
During Webex-session the Support (Thank you!) found a log which Shows that a file is missing\u2026\u2026..
I downloaded the patch again and used 7-zip\u2026\u2026.and it works.

<\/p>\n\n\n\n

Command cp with asmcmd cannot use Wildcards.<\/h1>\n\n\n\n

Since Oracle 12.2 the backup of the ocr must be stored in ASM.
But i prefer having this on the local file system. This should be done with a scheduled task.
My batch:
set oracle_home=C:\\gridhome
set oracle_sid=+asm1
cmd \/c asmcmd ls +DATA\/Oravirt12c\/OCRBACKUP\/ >> C:\\ocrbkup\\files_ocrbkup.txt
cmd \/c for \/f %%f in (C:\\ocrbkup\\files_ocrbkup.txt) do asmcmd cp +DATA\/Oravirt12c\/OCRBACKUP\/%%f c:\\ocrbkup\\
del C:\\ocrbkup\\files_ocrbkup.txt<\/p>\n\n\n\n


<\/p>\n\n\n\n

Installing EM13.2 agent from OMS-host which is running on Windows <\/h1>\n\n\n\n

Having a Windows-environment for our Oracle-RAC’s we decided to install OL 7.8 as OS for 19c.<\/p>\n\n\n\n

So after i’ve finished installation i tried to push EM13.2CC-agent from the WIN-OMS to the new target-maschine.
Since only the agent for the platform the OMS was installed on is included by default i first added agent to the software-library by Self-Update.
It shows AVAILABLE so start deploying it via the GUI >> error
Seems to be an issue while trying to Unzip.
Ok, let’s try the command-line according to MOS-DOC 1360083.1.
emcli get_agentimage -destination= -platform=”
ends with
ERROR: Command C:\\’PATH’\\unzip.exe c:\\’PATH’\\13.2.0.0.0_Plugins_226.zip -d c:\\’PATH’\\13.2.0.0.0_Plugins_226.zip -d ‘PATH’ execution failed.

emcli get_supported_platforms returns
Version = 13.2.0.0.0
Platform = Linux x86-64
Platform = Microsoft Windows x64 (64-bit)

Platforms list displayed successfully.
emcli list_plugins_on_server
OMS name is OMS:Port_Management_Service
Plug-in Name Plugin-id Version [revision]
Oracle Cloud Framework oracle.sysman.cfw 13.2.2.0.0
Oracle Database oracle.sysman.db 13.2.2.0.0
Oracle Fusion Middleware oracle.sysman.emas 13.2.2.0.0
Systems Infrastructure oracle.sysman.si 13.2.2.0.0
Oracle Exadata oracle.sysman.xa 13.2.2.0.0

<\/p>\n\n\n\n

But when downloading the agent_image i notice that the plugin-zip has size of just 1k.<\/p>\n\n\n\n

Found no solution, so i created a SR.
As per advice from MOS I did AgentPull.sh from target-side but still<\/p>\n\n\n\n

\u2026..
zip warning: missing end signature–probably not a zip file (did you
zip warning: remember to use binary mode when you transferred it?)
zip warning: (if you are trying to read a damaged archive try -F)

zip error: Zip file structure invalid (\/u01\/app\/oracle\/product\/agent13c\/\/plugin.zip)
ERROR: curl command:\/usr\/bin\/curl https:\/\/OMS:Port\/em\/install\/getAgentImage?user=sysman&platform=Linux x86-64&version=13.2.0.0.0&ignoreDiscoveryPlu gin=&script=download&host=Machine-name&type=pluginimage –insecure -o \/u01\/app\/oracle\/product\/agent13c\/\/plugin.zip -S –stderr \/u01\/app\/oracle\/product\/agent13c\/\/er ror.txt failed.

<\/p>\n\n\n\n

So, it seeems still an issue with the zip-file.<\/p>\n\n\n\n

OK, so let’s take another machine outside the network and work with VM.
I tried to install EM 13.2 on a LINUX machine in order to get an agent from that machine, but Installation failed.
Seems to be described in DOC ID 2270676.1.
But file which is mentioned could not be found in MW-Home.
So still working on this.<\/p>\n\n\n\n

Then tried to get a pre-built VM from Oracle, found
https:\/\/www.oracle.com\/technetwork\/server-storage\/vm\/documentation\/readme-em-13200-20190114-5278095.txt<\/p>\n\n\n\n

But it seems to me that only 13.4 is available now.<\/p>\n\n\n\n

Ah, Doc ID 2315652.1 made it.
Installation OMS on Linux-VM was successful.
Then proceeded acc to 1360083.1. (with transferring agentCore.zip from VM to Target-Machine)<\/p>\n\n\n\n





<\/p>\n\n\n\n









<\/p>\n\n\n\n

<\/p>\n\n\n\n

Oracle autoupgrade with Windows-Services and DataGuard 12.2 > 19c

<\/h1>\n\n\n\n

As described in Oracle documentation the Windows-Service
has been deleted while upgrade and must be re-created with oradim afterwards.

It worked for the Primary DB but dgmgrl showed some errors regarding the connectivity
to the Standby-DB.
My colleagues and me found following solution:

Create the service without password-clause
then create pwd-file with compatibility-level<\/em>
12.2<\/em>
!! > This password-file had been copied to the Standby-Site and renamed (unique-DB-Name) !!<\/em>

DataGuard works!
<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n