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" 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" [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