By Mouhamadou Diaw

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

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
[oracle@gridserver01:/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"
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"
[oracle@gridserver01:/opt/oracle]$

Be sure that following packages are installed

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
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

1
2
3
4
5
6
7
8
9
[oracle@gridserver01:/opt/oracle]$ chmod +x em13500_linux64.bin
[oracle@gridserver01:/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
[oracle@gridserver01:/opt/oracle]$

For the Install just lunch the em13500_linux64.bin

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
[oracle@gridserver01:/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

1
[oracle@gridserver01:/opt/oracle]$ ./em13500_linux64.bin

We do execute the file allroot.sh

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
[root@gridserver01:~]# /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 ......
[root@gridserver01:~]#

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

1
2
3
4
[oracle@gridserver01:/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
[oracle@gridserver01:/opt/oracle/product/middleware/oms13cr5/install/requisites/properties]$

Configuration of the EM

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

1
2
3
4
5
6
7
8
9
10
11
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

1
[oracle@gridserver01:~]$ /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

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
[oracle@gridserver01:/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
[oracle@gridserver01:/opt/oracle]$

Execute the root.sh scripts

1
2
3
4
5
[root@gridserver01:~]# /opt/oracle/product/middleware/agent/agent_13.5.0.0.0/root.sh
Finished product-specific root actions.
/etc exist
[root@gridserver01:~]#

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

1
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