Infrastructure at your Service

Mouhamadou Diaw

Install Enterprise Manager 13c R5: Check the db edition Failed

A few days ago, I was setting an Enterprise Manager 13c R5 for a client. The configuration used is the following
-The EM binaries are installed in a separate server than the database
-The database of the repository is an Oracle pluggable database 19.12
The server for the EM binaries has following OS

[[email protected]:/opt/oracle]$ cat /etc/os-release
NAME="Red Hat Enterprise Linux"
VERSION="8.4 (Ootpa)"
ID="rhel"
ID_LIKE="fedora"
VERSION_ID="8.4"
PLATFORM_ID="platform:el8"
PRETTY_NAME="Red Hat Enterprise Linux 8.4 (Ootpa)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:redhat:enterprise_linux:8.4:GA"
HOME_URL="https://www.redhat.com/"
DOCUMENTATION_URL="https://access.redhat.com/documentation/red_hat_enterprise_linux/8/"
BUG_REPORT_URL="https://bugzilla.redhat.com/"

REDHAT_BUGZILLA_PRODUCT="Red Hat Enterprise Linux 8"
REDHAT_BUGZILLA_PRODUCT_VERSION=8.4
REDHAT_SUPPORT_PRODUCT="Red Hat Enterprise Linux"
REDHAT_SUPPORT_PRODUCT_VERSION="8.4"
[[email protected]:/opt/oracle]$

Be sure that following packages are installed

yum install openssl
yum install make
yum install libgcc.i686
yum install libstdc++.i686
yum install compat-libcap1
yum install compat-libstdc++-33
yum install compat-libstdc++-33.i686
yum install dejavu-serif-fonts
yum install libaio
yum install libaio-devel
yum install libgcc
yum install libstdc++
yum install libstdc++-devel
yum install libnsl
yum install sysstat
yum install binutils
yum install gcc
yum install gcc-c++
yum install glibc
yum install glibc-devel
yum install glibc-devel.i686
yum install motif
yum install motif-devel
yum install redhat-lsb
yum install redhat-lsb-core
yum install ksh
yum install numactl
yum install numactl-devel

Following files are downloaded from Oracle web site

[[email protected]:/opt/oracle]$ chmod +x em13500_linux64.bin
[[email protected]:/opt/oracle]$ ls -l
total 8363808
-rw-r--r-- 1 oracle dba 1897494675 Nov  8 15:25 em13500_linux64-2.zip
-rw-r--r-- 1 oracle dba 2130750885 Nov  8 15:28 em13500_linux64-3.zip
-rw-r--r-- 1 oracle dba 1454982045 Nov  8 15:30 em13500_linux64-4.zip
-rw-r--r-- 1 oracle dba 1494500710 Nov  8 15:32 em13500_linux64-5.zip
-rwxr-xr-x 1 oracle dba 1586801533 Nov  8 15:22 em13500_linux64.bin
[[email protected]:/opt/oracle]$

For the Install just lunch the em13500_linux64.bin

[[email protected]:/opt/oracle]$ ./em13500_linux64.bin
ERROR: Temporary directory /tmp does not have enough free space. At least 12289 MB of free space are required.
Please input another directory or [Exit]: /opt/oracle/tmp/
Launcher log file is /opt/oracle/tmp/OraInstall2021-11-08_03-45-28PM/launcher2021-11-08_03-45-28PM.log.
Extracting the installer . . . . . . . . . . . . . . . . . Done
Checking monitor: must be configured to display at least 256 colors.  Actual unknown.   Failed <<<<
Checking swap space: must be greater than 512 MB.   Actual 6143 MB    Passed
Checking if this platform requires a 64-bit JVM.   Actual 64    Passed (64-bit not required)

...
...

You have confirmed that the product can be installed on this platform.
Continuing with the installation.


Preparing to launch the Oracle Universal Installer from /opt/oracle/tmp/OraInstall2021-11-08_03-45-28PM
ScratchPathValue :/opt/oracle/tmp/OraInstall2021-11-08_03-45-28PM

Below the options I checked

The prerequisite checks fail as shown above.
-The parameter _allow_insert_with_update_check can be easily corrected.
-But the second about the database Edition is likely a bug because the database used for the repository is an Enterprise one.

After looking into Oracle document, I found the following document.

EM 13c: EM Installation Fails at the database prerequisite check with “DB should be enterprise edition” While Using Oracle 12c In-Memory Database for repository (Extreme Performance) (Doc ID 2365190.1)

The document is talking about a 12c database, but the described issue is same that the one I have even we don’t have the same output.

I decide to do the proposed workaround to do the installation in two steps
1-Install the software only
2-Do the configuration after

Install software only

As previously, we run again the em13500_linux64.bin

[[email protected]:/opt/oracle]$ ./em13500_linux64.bin

We do execute the file allroot.sh

[[email protected]:~]# /opt/oracle/product/middleware/oms13cr5/allroot.sh

Starting to execute allroot.sh .........

Starting to execute /opt/oracle/product/middleware/oms13cr5/root.sh ......
Check /opt/oracle/product/middleware/oms13cr5/install/root_gridserver01_2021-11-08_16-52-52.log for the output of root script

Finished product-specific root actions.
/etc exist
/opt/oracle/product/middleware/agent/agent_13.5.0.0.0
Finished execution of  /opt/oracle/product/middleware/oms13cr5/root.sh ......


Starting to execute /opt/oracle/product/middleware/agent/agent_13.5.0.0.0/root.sh ......

Finished product-specific root actions.
/etc exist
/opt/oracle/product/middleware/agent/agent_13.5.0.0.0
Finished execution of  /opt/oracle/product/middleware/agent/agent_13.5.0.0.0/root.sh ......
[[email protected]:~]#

After the install sotware only successfully finished, in the file /opt/oracle/product/middleware/oms13cr5/install/requisites/properties/stopPrereqOnDemand.properties we verify that these two parameters have following values

-id_check_db_is_enterprise_edition=TRUE
-id_check_optimizer_adaptive_features_param=TRUE

[[email protected]:/opt/oracle/product/middleware/oms13cr5/install/requisites/properties]$ grep -E 'id_check_optimizer_adaptive_features_param|id_check_db_is_enterprise_edition' stopPrereqOnDemand.properties
id_check_db_is_enterprise_edition=TRUE
id_check_optimizer_adaptive_features_param=TRUE
[[email protected]:/opt/oracle/product/middleware/oms13cr5/install/requisites/properties]$

Configuration of the EM

Before launching the configuration, we modify these parameters on DB side

SQL> alter system set "_allow_insert_with_update_check" = true;

System altered.

SQL>

SQL> alter session set session_cached_cursors =500;

Session altered.

SQL>

Then we launch the configuration

[[email protected]:~]$ /opt/oracle/product/middleware/oms13cr5/sysman/install/ConfigureGC.sh

Logs of the install can be found here: /opt/oracle/product/middleware/oms13cr5/cfgtoollogs/

We can then validate the grid control status

[[email protected]:/opt/oracle]$ /opt/oracle/product/middleware/oms13cr5/bin/emctl status oms -details
Oracle Enterprise Manager Cloud Control 13c Release 5
Copyright (c) 1996, 2021 Oracle Corporation.  All rights reserved.
Enter Enterprise Manager Root (SYSMAN) Password :
Console Server Host        : gridserver01.zut.ad.exemple.com
HTTP Console Port          : 7788
HTTPS Console Port         : 7803
HTTP Upload Port           : 4889
HTTPS Upload Port          : 4903
EM Instance Home           : /opt/oracle/product/middleware/gc_inst/em/EMGC_OMS1
OMS Log Directory Location : /opt/oracle/product/middleware/gc_inst/em/EMGC_OMS1/sysman/log
OMS is not configured with SLB or virtual hostname
Agent Upload is locked.
OMS Console is locked.
Active CA ID: 1
Console URL: https://gridserver01.zut.ad.exemple.com:7803/em
Upload URL: https://gridserver01.zut.ad.exemple.com:4903/empbs/upload

WLS Domain Information
Domain Name            : GCDomain
Admin Server Host      : gridserver01.zut.ad.exemple.com
Admin Server HTTPS Port: 7102
Admin Server is RUNNING

Oracle Management Server Information
Managed Server Instance Name: EMGC_OMS1
Oracle Management Server Instance Host: gridserver01.zut.ad.exemple.com
WebTier is Up
Oracle Management Server is Up
JVMD Engine is Up
[[email protected]:/opt/oracle]$

Execute the root.sh scripts

[[email protected]:~]# /opt/oracle/product/middleware/agent/agent_13.5.0.0.0/root.sh

Finished product-specific root actions.
/etc exist
[[email protected]:~]#

Then you should be able to connect using following URL with SYSMAN credentials

https://gridserver01.zut.ad.exemple.com:7803/em/

Conclusion

In this blog I share the issue I had when installing EM 13c R5. Hope this may help

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Mouhamadou Diaw
Mouhamadou Diaw

Senior Consultant