meta données pour cette page
Ceci est une ancienne révision du document !
Installation Oracle Enterprise Manager 13.5
Ressources
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 glibc-devel
- 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 ORACLE, démarrage du listener
lsnrctl start
- 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
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;
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>
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