meta données pour cette page
Installation Oracle Enterprise Manager 13.5
Ressources
https://www.oracle.com/enterprise-manager/downloads/linux-x86-64-13c-rel5-downloads.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 wget
- 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 /u01/app/oracle/SoftLibrary 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é
cp $SOFTWARE_EM_InstallConfFiles/new_install.rsp $SOFTWARE_EM_InstallConfFiles/new_install_oem1.rsp vi $SOFTWARE_EM_InstallConfFiles/new_install_oem1.rsp #################################################################### ## ## ## Copyright (c) 2015 Oracle. All rights reserved. ## ## ## ## Specify values for the variables listed below to customize ## ## your installation. ## ## ## ## Each variable is associated with a comment. The comment ## ## identifies the variable type. ## ## ## ## Specify values in the following format: ## ## ## ## Type Example ## ## ---- ------- ## ## string Sample Value ## ## boolean TRUE or FALSE ## ## number 1000 ## ## ## #################################################################### #################################################################### ### General RESPONSEFILE_VERSION=2.2.1.0.0 UNIX_GROUP_NAME=oinstall # ### MIDDLEWARE INVENTORY_LOCATION=/u01/app/oraInventory SECURITY_UPDATES_VIA_MYORACLESUPPORT=false DECLINE_SECURITY_UPDATES=true INSTALL_UPDATES_SELECTION=skip ORACLE_MIDDLEWARE_HOME_LOCATION=/u01/app/oracle/product/EnterpriseManager/oms_home ORACLE_HOSTNAME=oem1.labo.local AGENT_BASE_DIR=/u01/app/oracle/product/agent/ WLS_ADMIN_SERVER_USERNAME=weblogic WLS_ADMIN_SERVER_PASSWORD=ep8X5b_nGl4m WLS_ADMIN_SERVER_CONFIRM_PASSWORD=ep8X5b_nGl4m NODE_MANAGER_PASSWORD=ep8X5b_nGl4m NODE_MANAGER_CONFIRM_PASSWORD=ep8X5b_nGl4m SYSMAN_PASSWORD=fOsprl_6nCywp SYSMAN_CONFIRM_PASSWORD=fOsprl_6nCywp ORACLE_INSTANCE_HOME_LOCATION=/u01/app/oracle/product/EnterpriseManager/instance_home CONFIGURE_ORACLE_SOFTWARE_LIBRARY=true SOFTWARE_LIBRARY_LOCATION=/u01/app/oracle/SoftLibrary DEPLOYMENT_SIZE=SMALL AGENT_REGISTRATION_PASSWORD=d6gWro_dPq4f AGENT_REGISTRATION_CONFIRM_PASSWORD=d6gWro_dPq4f PLUGIN_SELECTION={} b_upgrade=false EM_INSTALL_TYPE=NOSEED CONFIGURATION_TYPE=ADVANCED CONFIGURE_SHARED_LOCATION_BIP=false # ### DATABASE DATABASE_HOSTNAME=oem1.labo.local LISTENER_PORT=1521 SERVICENAME_OR_SID=EMPDB SYS_PASSWORD=zDm_4439BnFUk MANAGEMENT_TABLESPACE_LOCATION=/u02/oradata/EMCDB/datafile/mgmt.dbf CONFIGURATION_DATA_TABLESPACE_LOCATION=/u02/oradata/EMCDB/datafile/mgmt_ecm_depot1.dbf JVM_DIAGNOSTICS_TABLESPACE_LOCATION=/u02/oradata/EMCDB/datafile/mgmt_deepdive.dbf
- 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
- Creation du software library
$OMS_HOME/bin/emcli login -username=sysman Enter password Login successful $OMS_HOME/bin/emcli add_swlib_storage_location -name="swlib_loc" -path="/u01/app/oracle/oraInventory" Location configuration initiated, this may take some time to complete... Location 'swlib_loc' created. Metadata registration will be initiated. This will take a few minutes to complete. INFO [Fri Feb 07 16:31:17 CET 2025] Software Library metadata from all installed plug-ins will be registered. INFO [Fri Feb 07 16:31:17 CET 2025] The following ordered plug-ins were found: INFO [Fri Feb 07 16:31:17 CET 2025] - oracle.sysman.cfw:13.5.1.0.0:0 INFO [Fri Feb 07 16:31:17 CET 2025] - oracle.sysman.db:13.5.1.0.0:0 INFO [Fri Feb 07 16:31:17 CET 2025] - oracle.sysman.si:13.5.1.0.0:0 INFO [Fri Feb 07 16:31:17 CET 2025] - oracle.sysman.xa:13.5.1.0.0:0 INFO [Fri Feb 07 16:31:17 CET 2025] - oracle.sysman.emas:13.5.1.0.0:0 INFO [Fri Feb 07 16:31:17 CET 2025] Starting Software Library metadata registration for platform ... INFO [Fri Feb 07 16:31:28 CET 2025] Finished registering Software Library metadata for platform. INFO [Fri Feb 07 16:31:28 CET 2025] Starting Software Library metadata registration for plug-in - oracle.sysman.cfw:13.5.1.0.0:0 INFO [Fri Feb 07 16:31:29 CET 2025] Finished registering Software Library metadata for plug-in - oracle.sysman.cfw:13.5.1.0.0:0 INFO [Fri Feb 07 16:31:29 CET 2025] Starting Software Library metadata registration for plug-in - oracle.sysman.db:13.5.1.0.0:0 INFO [Fri Feb 07 16:31:43 CET 2025] Finished registering Software Library metadata for plug-in - oracle.sysman.db:13.5.1.0.0:0 INFO [Fri Feb 07 16:31:43 CET 2025] Starting Software Library metadata registration for plug-in - oracle.sysman.si:13.5.1.0.0:0 INFO [Fri Feb 07 16:31:43 CET 2025] Finished registering Software Library metadata for plug-in - oracle.sysman.si:13.5.1.0.0:0 INFO [Fri Feb 07 16:31:43 CET 2025] Starting Software Library metadata registration for plug-in - oracle.sysman.xa:13.5.1.0.0:0 INFO [Fri Feb 07 16:31:43 CET 2025] Finished registering Software Library metadata for plug-in - oracle.sysman.xa:13.5.1.0.0:0 INFO [Fri Feb 07 16:31:43 CET 2025] Starting Software Library metadata registration for plug-in - oracle.sysman.emas:13.5.1.0.0:0 INFO [Fri Feb 07 16:31:51 CET 2025] Finished registering Software Library metadata for plug-in - oracle.sysman.emas:13.5.1.0.0:0 Metadata registration has completed. Location statistics refresh job will be submitted. Location statistics refresh job has been submitted.
Installation terminée, connexion via: https://oem1.labo.local:7803/em
ERREUR ORA-01843 :
ORA-01843: not a valid month en fin d'installation OMS
Il s'agit d'un bug, corrigé uniquement dans EM 23.
L'install est a nettoyer et relancer en changeant la langue
Nettoyage
- Lancer le script detachHome
cd $OMS_HOME/oui/bin ./detachHome.sh Le fichier journal du lanceur est /tmp/OraInstall2025-02-01_08-21-52PM/launcher2025-02-01_08-21-52PM.log. Vérification de l'espace de swap : il doit être supérieur à 500 Mo. Réel 2047 Mo Succès Vérification visant à déterminer si la plate-forme requiert une JVM 64 bits. Réel 64 Succès (64 bits non requis) L'opération detachHome a abouti. Journaux copiés vers /u01/app/oraInventory/logs.
- nettoyage des fichiers sur le FS
rm -Rf /u01/app/oracle/product/EnterpriseManager/oms_home/* rm -Rf /u01/app/oracle/product/agent/agent_13.5.0.0.0/
- valider qu'il n'y a plus de répertoire caché:
ls -la /u01/app/oracle/product/EnterpriseManager/oms_home/ ls -la /u01/app/oracle/product/agent/
- nettoyer la BDD
- nettoyage des users
SQL> DROP USER sysman cascade; SQL> DROP USER sysman_types cascade; SQL> DROP USER sysman_stb cascade; SQL> DROP USER sysman_opss cascade; SQL> DROP USER sysman_biplatform cascade; SQL> DROP USER sysman_bip cascade; SQL> DROP USER sysmanupgr_opss cascade; SQL> DROP USER sysman_apm cascade; SQL> DROP USER sysman_ro cascade; SQL> DROP USER sysman_mds cascade; SQL> DROP USER cloud_engine_user cascade; SQL> DROP USER cloud_swlib_user cascade; SQL> DROP USER mgmt_view cascade; SQL> DROP USER eus_engine_user cascade; SQL> DROP role mgmt_user;
- nettoyage des synonymes, si existants
SQL> spool synonyms.lst SQL> SELECT owner,synonym_name FROM dba_synonyms WHERE table_owner IN ('SYSMAN', 'SYSMAN_MDS', 'MGMT_VIEW', 'SYSMAN_BIP', 'SYSMAN_APM', 'SYSMAN_OPSS', 'SYSMAN_RO', 'SYSMAN_BIPLATFORM', 'SYSMANUPGR_OPSS', 'CLOUD_ENGINE_USER', 'CLOUD_SWLIB_USER', 'EUS_ENGINE_USER', 'SYSMAN_TYPES', 'SYSMAN_STB') ; SQL> spool off SQL> @synonyms.lst SQL> DROP SYNONYM schema.synonym_name;
- supprimer les tablespaces
SQL> DROP tablespace MGMT_ECM_DEPOT_TS including contents AND datafiles cascade constraints; SQL> DROP tablespace MGMT_TABLESPACE including contents AND datafiles cascade constraints; SQL> DROP tablespace MGMT_AD4J_TS including contents AND datafiles cascade constraints;
supprimer les entrées du registre
SQL> DELETE FROM SCHEMA_VERSION_REGISTRY WHERE COMP_NAME='Metadata Services'; SQL> DELETE FROM SCHEMA_VERSION_REGISTRY WHERE COMP_NAME='Authorization Policy Manager'; SQL> DELETE FROM SCHEMA_VERSION_REGISTRY WHERE COMP_NAME='Oracle Platform Security Services'; SQL> DELETE FROM SCHEMA_VERSION_REGISTRY WHERE COMP_NAME='OracleBI and EPM'; SQL> DELETE FROM SCHEMA_VERSION_REGISTRY WHERE COMP_NAME='Service Table'; SQL> COMMIT;
Reinstallation
- En root
yum install langpacks-en sudo su - oracle locale ... localectl set-locale LANG=en_US.utf8 locale export LANG=en_US.utf8 export LC_ALL=en_US.utf8 export NLS_LANG=american_america.utf8 export ORACLE_HOSTNAME=oem1.labo.local 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 $SOFTWARE_DIR 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