Soumya's Database Blog : August 2021

OEM 13.5 installation fails during OMSCA With the Error: OMS service creation failed

Environment Details:-

OMS DB Version	19.3.0
OEM Version	13.5.0.0.0
OS	Windows Server 2019

Error Details:-

During Oracle Enterprise manager 13.5 installation following error message is seen inside

OMS_HOME/cfgtoollogs/omsca/omsca_<timestamp>.log location

Aug 28, 2021 11:24:51 AM oracle.sysman.omsca.util.CoreOMSConfigAssistantUtil execCommand

INFO: Output messages of the command C:\app\Middleware\bin\emctl.bat create service -oms_svc_name OracleManagementServer_EMGC_OMS1_1 :

Oracle Enterprise Manager Cloud Control 13c Release 5

Creating oms service OracleManagementServer_EMGC_OMS1_1...

OMS service creation failed. Aborting...

Aug 28, 2021 11:24:51 AM oracle.sysman.omsca.util.CoreOMSConfigAssistantUtil execCommand

INFO: error messages of the command C:\app\Middleware\bin\emctl.bat create service -oms_svc_name OracleManagementServer_EMGC_OMS1_1 :

Solution:-

1) Ensure that the following packages are installed on the OMS Server. If not install them.

Microsoft Visual C++ 2010 Redistributable Package
Microsoft Visual C++ 2012 Redistributable Package
Microsoft Visual C++ 2015 Redistributable Package Update 3

2) Delete the <OMS_BASE_DIR>\gc_inst directory created during the oms configuration.

3) If the OEM installer is still running click on "Retry".

If not, execute following from command prompt:

$ 13.5_OMS_HOME/oui/bin> ./runConfig.sh ORACLE_HOME=<13.5_OMS_HOME> MODE=perform ACTION=configure COMPONENT_XML={encap_oms.1_0_0_0_0.xml}

This should resolve the issue.

How to install ansible on Oracle Linux 7

OS : OEL 7.9

Download EPEL Repo

You can download EPEL repo from this link

https://dl.fedoraproject.org/pub/epel/

To download directly in the server use wget command

[root@bastionhost opc]# wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm

Install EPEL repo

[root@bastionhost opc]# rpm -Uvh epel-release-latest-7.noarch.rpm

warning: epel-release-latest-7.noarch.rpm: Header V4 RSA/SHA256 Signature, key ID 352c64e5: NOKEY

Preparing... ################################# [100%]

Updating / installing...

1:epel-release-7-13 ################################# [100%]

Install Anisble

[root@bastionhost opc]# yum install ansible

Loaded plugins: langpacks, ulninfo

https://ookla.bintray.com/rhel/repodata/repomd.xml: [Errno 14] HTTPS Error 403 - Forbidden

Trying other mirror.

epel/x86_64/metalink | 8.4 kB 00:00:00

epel | 4.7 kB 00:00:00

(1/3): epel/x86_64/group_gz | 96 kB 00:00:00

(2/3): epel/x86_64/updateinfo | 1.0 MB 00:00:02

(3/3): epel/x86_64/primary_db | 6.9 MB 00:00:03

Resolving Dependencies

--> Running transaction check

---> Package ansible.noarch 0:2.9.18-1.el7 will be updated

---> Package ansible.noarch 0:2.9.24-2.el7 will be an update

--> Finished Dependency Resolution

Dependencies Resolved

================================================================================================================

Package Arch Version Repository Size

================================================================================================================

Updating:

ansible noarch 2.9.24-2.el7 epel 17 M

Transaction Summary

================================================================================================================

Upgrade 1 Package

Total download size: 17 M

Is this ok [y/d/N]: y

Downloading packages:

epel/x86_64/prestodelta | 1.3 kB 00:00:00

warning: /var/cache/yum/x86_64/7Server/epel/packages/ansible-2.9.24-2.el7.noarch.rpm: Header V4 RSA/SHA256 Signature, key ID 352c64e5: NOKEY

Public key for ansible-2.9.24-2.el7.noarch.rpm is not installed

ansible-2.9.24-2.el7.noarch.rpm | 17 MB 00:00:06

Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-7

Importing GPG key 0x352C64E5:

Userid : "Fedora EPEL (7) <epel@fedoraproject.org>"

Fingerprint: 91e9 7d7c 4a5e 96f1 7f3e 888f 6a2f aea2 352c 64e5

Package : epel-release-7-13.noarch (installed)

From : /etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-7

Is this ok [y/N]: y

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Warning: RPMDB altered outside of yum.

Updating : ansible-2.9.24-2.el7.noarch 1/2

Cleanup : ansible-2.9.18-1.el7.noarch 2/2

Verifying : ansible-2.9.24-2.el7.noarch 1/2

Verifying : ansible-2.9.18-1.el7.noarch 2/2

Updated:

ansible.noarch 0:2.9.24-2.el7

Complete!

Verify Anisble Version:-

[root@bastionhost opc]# ansible --version

ansible 2.9.24

config file = /etc/ansible/ansible.cfg

configured module search path = [u'/root/.ansible/plugins/modules', u'/usr/share/ansible/plugins/modules']

ansible python module location = /usr/lib/python2.7/site-packages/ansible

executable location = /bin/ansible

python version = 2.7.5 (default, Nov 13 2020, 02:52:00) [GCC 4.8.5 20150623 (Red Hat 4.8.5-44.0.3)]

Installation complete. Ansible is ready to use.

Preclone on DBTier fails with RC-20010: Fatal: Could not find Info-ZIP's zip version 2.3 in the PATH

While running adpreclone on DB Tier , it fails with error RC-20010: Fatal: Could not find Info-ZIP's zip version 2.3 in the PATH

Environment Details:-

Application Version	R12.1.1
DB Version	11.2.0.4
OS	RHEL 7

While running adpreclone on dbTier following error message is thrown

[orapay@ccuine EIILPAY_ccuine]$ perl adpreclone.pl dbTier

Redwood Shores, California, USA

Oracle Applications Rapid Clone

Version 12.0.0

adpreclone Version 120.20.12010000.2

Enter the APPS User Password:

…

| 0% completed RC-20010: Fatal: Could not find Info-ZIP's zip version 2.3 in the PATH. Please make sure you have zip version 2.3 in your PATH and rerun the command.zip 2.3 is normally available in $ORACLE_HOME/bin/ or it can be downloaded from http://www.info-zip.org/Zip.html

ERROR while running Stage...

Fri Aug 6 22:14:12 2021

ERROR while running perl /PAYROLL/EIILPAY/db/tech_st/11.2.0.4/appsutil/bin/adclone.pl java=/PAYROLL/EIILPAY/db/tech_st/11.2.0.4/jdk/jre mode=stage stage=/PAYROLL/EIILPAY/db/tech_st/11.2.0.4/appsutil/clone component=dbTier method=CUSTOM dbctx=/PAYROLL/EIILPAY/db/tech_st/11.2.0.4/appsutil/EIILPAY_ccuine105.xml showProgress ...

Reason:- The error is observed because Zip Version other zip version is installed in whereas adpreclone.pl is expecting ZIP version 2.3.

[orapay@ccuine105 ~]$ zip -v

This is Zip 3.0 (July 5th 2008), by Info-ZIP.

So the above output shows our server has zip version 3 installed. And adpreclone is looking for ver 2.3

Solution:-

Solution 1: Stay with zip 2.3

1.1 download zip 2.3 from http://www.info-zip.org/

1.2 unzip this file to a directory

1.3 Add this directory in the PATH variable (now 'which zip' should give this location).

Please make sure you have zip version 2.3 in your PATH

1.4 Re-run adpreclone.pl

Solution 2 : Use zip 3.0

2.1 Take a backup of you environment

2.2 Review readme of Patch : 9171651 and apply all pre-requisites

2.3 Apply patch Patch : 9171651 R12 RAPIDCLONE CONSOLIDATED FIXES JUL/2010

2.4 Retry the adpreclone.pl

Solution 3: Copy Zip from appstier

3.1 scp or copy zip v2.3 from the apps tier’s location $ORACLE_HOME/bin,

to /usr/bin location.

3.2Make sure to take a backup of original zip in /usr/zip. And then retry adpreclone. It should work.

Once done revert back to original zip version