Ceci est une ancienne révision du document !

Installation Oracle Enterprise Manager 13.5

Ressources

https://www.oracle.com/enterprise-manager/downloads/linux-x86-64-13c-rel5-downloads.html

https://docs.oracle.com/en/enterprise-manager/cloud-control/enterprise-manager-cloud-control/13.5/emadv/installing-enterprise-manager-silent-mode1.html

https://docs.dbagenesis.com/post/oracle-enterprise-manager-13c-release-5-installation

VM

oem1.labo.local SPECS (1 OMS, <100 Targets, <10 Agents, <3 Concurrent User Sessions):

RAM: 10GB
Disks
- OS: Template Santander
- /u01: 100GB
- /u02: 40GB
- /u07: 20GB
OS
- Rocky Linux 9

Prérequis

Création des disques

[root@oem1 ~]# lsblk
NAME        MAJ:MIN RM  SIZE RO TYPE MOUNTPOINTS
sr0          11:0    1 1024M  0 rom
xvda        202:0    0   20G  0 disk
├─xvda1     202:1    0    1G  0 part /boot
└─xvda2     202:2    0   19G  0 part
  ├─rl-root 253:0    0   17G  0 lvm  /
  └─rl-swap 253:1    0    2G  0 lvm  [SWAP]
xvdb        202:16   0  100G  0 disk
xvdc        202:32   0   40G  0 disk
xvde        202:64   0   20G  0 disk
 
 
pvcreate /dev/xvdb
pvcreate /dev/xvdc
pvcreate /dev/xvde
 
vgcreate vg_u01 /dev/xvdb
vgcreate vg_u02 /dev/xvdc
vgcreate vg_u07 /dev/xvde
 
lvcreate -n lv_u01 -l +100%FREE vg_u01
lvcreate -n lv_u02 -l +100%FREE vg_u02
lvcreate -n lv_u07 -l +100%FREE vg_u07
 
 
mkfs -t xfs /dev/mapper/vg_u01-lv_u01
mkfs -t xfs /dev/mapper/vg_u02-lv_u02
mkfs -t xfs /dev/mapper/vg_u07-lv_u07
 
mkdir /u01
mkdir /u02
mkdir /u07
 
vi /etc/fstab
 
#
# /etc/fstab
# Created by anaconda on Fri Jan 31 21:01:17 2025
#
# Accessible filesystems, by reference, are maintained under '/dev/disk/'.
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info.
#
# After editing this file, run 'systemctl daemon-reload' to update systemd
# units generated from this file.
#
/dev/mapper/rl-root     /                       xfs     defaults        0 0
UUID=179245c8-23f3-4240-9cc3-99a6fe89bd7d /boot                   xfs     defaults        0 0
/dev/mapper/rl-swap     none                    swap    defaults        0 0
#
##############################################################################
#
# ORACLE FS
#
###############################################################################
/dev/mapper/vg_u01-lv_u01           /u01          xfs     nodev,nosuid    0 0
/dev/mapper/vg_u02-lv_u02           /u02          xfs     nodev,nosuid    0 0
/dev/mapper/vg_u07-lv_u07          /u07          xfs     nodev,nosuid    0 0

montage des FS

mount -a

paquets nécessaires

yum  install binutils gcc gcc-c++ glibc glibc-devel libaio libgcc libnsl libstdc++  make motif motif-devel openssl sysstat bc compat-openssl11 elfutils-libelf fontconfig ksh libasan liblsan libX11 libXau libXi libXrender libXtst libxcrypt-compat libibverbs librdmacm libxcb libvirt-libs policycoreutils policycoreutils-python-utils smartmontools

Augmentation TCP Port Range

echo 11000 65000 > /proc/sys/net/ipv4/ip_local_port_range

Installation ORACLE_HOME 19.23

Prérequis

yum install oracle-database-preinstall-19c

création de l'arborescence applicative

mkdir /home/oracle
mkdir -p /u01/Downloads/tmp
mkdir -p /u01/Downloads/EM_InstallConfFiles
mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1
mkdir -p /u01/app/oracle/product/EnterpriseManager/oms_home
mkdir -p /u01/app/oracle/product/EnterpriseManager/instance_home
mkdir -p /u01/app/oracle/product/agent/
mkdir -p /u01/app/oracle/oraInventory
mkdir -p /u02/oradata
mkdir -p /u07/oradata/FRA
chown -R oracle:oinstall /u01 /u02 /u07 /home/oracle
chmod -R 775 /u01/* /u02/* /u07/*
chmod 700 /home/oracle

mdp ORACLE

passwd oracle

installation des binaires avec une Golden Image 19.23

sudo su - oracle
export ORACLE_HOSTNAME=oem1.labo.local
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
export ORA_INVENTORY=/u01/app/oraInventory
export CV_ASSUME_DISTID=OL8
export SOFTWARE_DIR=/u01/Downloads
export SOFTWARE_TEMPDIR=/u01/Downloads/tmp
export SOFTWARE_EM_InstallConfFiles=/u01/Downloads/EM_InstallConfFiles
 
cd $ORACLE_HOME
unzip -oq ${SOFTWARE_DIR}/db_home-19.23_2025-01-29.zip
 
./runInstaller -ignorePrereq -waitforcompletion -silent                    \
-responsefile ${ORACLE_HOME}/install/response/db_install.rsp               \
oracle.install.option=INSTALL_DB_SWONLY                                    \
ORACLE_HOSTNAME=${ORACLE_HOSTNAME}                                         \
UNIX_GROUP_NAME=oinstall                                                   \
INVENTORY_LOCATION=${ORA_INVENTORY}                                        \
SELECTED_LANGUAGES=en,en_GB                                                \
ORACLE_HOME=${ORACLE_HOME}                                                 \
ORACLE_BASE=${ORACLE_BASE}                                                 \
oracle.install.db.InstallEdition=EE                                        \
oracle.install.db.OSDBA_GROUP=dba                                          \
oracle.install.db.OSBACKUPDBA_GROUP=dba                                    \
oracle.install.db.OSDGDBA_GROUP=dba                                        \
oracle.install.db.OSKMDBA_GROUP=dba                                        \
oracle.install.db.OSRACDBA_GROUP=dba                                       \
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false                                 \
DECLINE_SECURITY_UPDATES=true
 
 
		Launching Oracle Database Setup Wizard...
 
		[WARNING] [INS-13001] Oracle Database is not supported on this operating system. Installer will not perform prerequisite checks on the system.
		   CAUSE: This operating system may not have been in the certified list at the time of the release of this software.
		   ACTION: Refer to My Oracle Support portal for the latest certification information for this operating system. Proceed with the installation if the operating system has been certified after the release of this software.
		The response file for this session can be found at:
		 /u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_2025-01-29_04-30-02PM.rsp
 
		You can find the log of this install session at:
		 /tmp/InstallActions2025-01-29_04-30-02PM/installActions2025-01-29_04-30-02PM.log
 
		As a root user, execute the following script(s):
				1. /u01/app/oraInventory/orainstRoot.sh
				2. /u01/app/oracle/product/19.0.0/dbhome_1/root.sh
 
		Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes:
		[oem1]
		Execute /u01/app/oracle/product/19.0.0/dbhome_1/root.sh on the following nodes:
		[oem1]

En ROOT, exécuter les scripts de POST install

/u01/app/oraInventory/orainstRoot.sh
/u01/app/oracle/product/19.0.0/dbhome_1/root.sh

ouverture port Firewall local

firewall-cmd --permanent --add-port={80,443,1521,3872,4889,4903,7102,7202,7301,7403,7788,7803,9788,9851}/tcp
firewall-cmd --reload

Provisionnement de la BDD

En ORACLE

export ORACLE_HOSTNAME=oem1.labo.local
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
export ORA_INVENTORY=/u01/app/oraInventory
export CV_ASSUME_DISTID=OL8
 
cd $ORACLE_HOME/bin
./dbca -silent -createDatabase \
 -templateName General_Purpose.dbc \
 -gdbname EMCDB -sid EMCDB  \
 -initParams db_unique_name=EMCDB \
 -characterSet AL32UTF8 \
 -sysPassword xxxxxxx \
 -systemPassword xxxxxxx \
 -createAsContainerDatabase true \
 -numberOfPDBs 1 \
 -pdbName EMPDB \
 -pdbAdminPassword xxxxxxx \
 -databaseType MULTIPURPOSE \
 -memoryMgmtType auto_sga \
 -totalMemory 2000 \
 -storageType FS \
 -datafileDestination /u02/oradata/ \
 -redoLogFileSize 1024 \
 -useOMF true \
 -emConfiguration NONE \
 -ignorePreReqs

Paramétrage BDD

ALTER pluggable database EMPDB save state;
ALTER system SET "_allow_insert_with_update_check"=TRUE;
ALTER system SET session_cached_cursors=200 scope=spfile;

Paramétrage BDD si nécessaire

ALTER system SET sga_target=800M scope=both;
ALTER system SET pga_aggregate_target=450M scope=both;

En ORACLE, démarrage du listener

lsnrctl start

Installation Enterprise Manager

Il faut 37.5GB espace libre sur le /u01

weblogic ⇒ xxxx
nodemanager ⇒ xxxx

génération des templates de fichiers de réponse (en ORACLE)
- ici on utilise le paramètre -J-Djava.io.tmpdir qui permet de contourner les /tmp en noexec et avec une taille réduite

cd $SOFTWARE_DIR
./em13500_linux64.bin -J-Djava.io.tmpdir=$SOFTWARE_TEMPDIR -getResponseFileTemplates -outputLoc $SOFTWARE_EM_InstallConfFiles
	Launcher log file is /u01/Downloads/tmp/OraInstall2025-01-30_01-21-35PM/launcher2025-01-30_01-21-35PM.log.
	Extracting the installer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Done
	Copying response file template(s)
	to /u01/Downloads/EM_InstallConfFiles
	  Copying response file template softwareOnlyWithPlugins_install.rsp
	  Copying response file template emprereqkit_upgrade.rsp
	  Copying response file template upgrade.rsp
	  Copying response file template new_install.rsp
	  Copying response file template emprereqkit_install.rsp
	  Copying response file template softwareOnlyWithPlugins_upgrade.rsp
	Finished copying response file template(s)
 
	The log(s) can be found here: /u01/Downloads/tmp/OraInstall2025-01-30_01-21-35PM.

fichier de réponse personnalisé

vi $SOFTWARE_EM_InstallConfFiles/new_install_oem1.rsp

installation (avec répertoire tmp alternatif 14GB mini - 2 à 3 heures d'installation)

nohup ./em13500_linux64.bin -J-Djava.io.tmpdir=$SOFTWARE_TEMPDIR -silent -responseFile $SOFTWARE_EM_InstallConfFiles/new_install_oem1.rsp > /tmp/EnterpriseManager-install.log 2>&1 &
 
tail -f /tmp/EnterpriseManager-install.log

Erreurs rencontrées:

[FATAL] [DBT-05509] Failed To Connect To The Specified Database <DBNAME>

suivre note MOS ⇒ https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=378268410874197&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=2710298.1&_afrWindowMode=0&_adf.ctrl-state=w8saijlna_4

Solution qui semble liée à l'agent Dynatrace ⇒ mv /etc/ld.so.preload /etc/ld.so.preload_bkup

Post install

correction du bug ORACLE lié à RHEL/OL9

ln -s /u01/app/oracle/product/agent/agent_13.5.0.0.0/instantclient/libclntshcore.so.12.1 /u01/app/oracle/product/EnterpriseManager/oms_home/lib/libclntshcore.so.12.1

/etc/oratab

# This file is used by ORACLE utilities.  It is created by root.sh
# and updated by either Database Configuration Assistant while creating
# a database or ASM Configuration Assistant while creating ASM instance.
 
# A colon, ':', is used as the field terminator.  A new line terminates
# the entry.  Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
#   $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively.  The third field indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
EMCDB:/u01/app/oracle/product/19.0.0/dbhome_1:Y
OMS:/u01/app/oracle/product/EnterpriseManager/oms_home:N
agent13cr5:/u01/app/oracle/product/agent/agent_13.5.0.0.0:N

paramétrage de l'auto start

emctl config oms -get_startup_mode
emctl config oms -set_startup_mode  normal

config de l'agent

vi /u01/app/oracle/product/agent/agent_13.5.0.0.0/bin/emctl
	DEFAULT_EMSTATE=/u01/app/oracle/product/agent/agent_13.5.0.0.0

Démarrage OMS (Si la DB tourne)

/u01/app/oracle/product/EnterpriseManager/oms_home/bin/emctl start oms
/u01/app/oracle/product/EnterpriseManager/oms_home/bin/emctl status oms

Démarrage de l'agent Enterprise manager

/u01/app/oracle/product/agent/agent_13.5.0.0.0/bin/emctl start agent
/u01/app/oracle/product/agent/agent_13.5.0.0.0/bin/emctl status agent

Installation terminée, connexion via: https://oem1.labo.local:7803/em

Outils

menus et recherche rapide

recherche rapide

statut du site

Outils de la page

meta données pour cette page