August 28, 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 

Copyright (c) 1996, 2021 Oracle Corporation.  All rights reserved.

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.

August 19, 2021

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.

August 6, 2021

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 

                     Copyright (c) 2002 Oracle Corporation

                        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

Copyright (c) 1990-2008 Info-ZIP - Type 'zip "-L"' for software license.

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


How to Fix formsweb.cfg When Fusion Middleware Enterprise Manager Is Not Accessible

Recently for one of my customer  I ran into a tricky situation while Fusion Middleware Enterprise Manager (EM) 12c was completely inaccessib...