Oracle Enterprise Manager 13C (13.4) 설치 (#.1)
Oracle Enterprise Manager 13C (13.4) 설치 (#.1)
VM환경에서 설치하였고, CPU 4Core, RAM 16GB를 할당 했습니다.
Oracle Linux 7.8 x86_64를 이용하였습니다.
목적은 개인적은 테스트 용도로만 구성하였습니다.
EM Repository DB 설치
Oracle 19c 버전으로 설치하였고, 19.7 버전까지 업그레이드 하였습니다.
OS 설치후 yum 업데이트
yum update -y
DB 설치에 필요한 패키지 설치
yum install -y bc yum install -y binutils yum install -y compat-libcap1 yum install -y compat-libstdc++-33 yum install -y dtrace-utils yum install -y elfutils-libelf yum install -y elfutils-libelf-devel yum install -y fontconfig-devel yum install -y glibc yum install -y glibc-devel yum install -y ksh yum install -y libaio yum install -y libaio-devel yum install -y libdtrace-ctf-devel yum install -y libXrender yum install -y libXrender-devel yum install -y libX11 yum install -y libXau yum install -y libXi yum install -y libXtst yum install -y libgcc yum install -y librdmacm-devel yum install -y libstdc++ yum install -y libstdc++-devel yum install -y libxcb yum install -y make yum install -y net-tools # Clusterware yum install -y nfs-utils # ACFS yum install -y python # ACFS yum install -y python-configshell # ACFS yum install -y python-rtslib # ACFS yum install -y python-six # ACFS yum install -y targetcli # ACFS yum install -y smartmontools yum install -y sysstat yum install -y unixODBC
어차피 em을 설치할 때 또 필요한 패키지가 있습니다. 그냥 같이 설치해줍니다.
yum install -y binutils yum install -y compat-libcap1 yum install -y compat-libstdc++-33 yum install -y compat-libstdc++-33.i686 yum install -y gcc yum install -y gcc-c++ yum install -y glibc yum install -y glibc.i686 yum install -y glibc-devel yum install -y libaio yum install -y libaio-devel yum install -y libgcc yum install -y libgcc.i686 yum install -y libstdc++ yum install -y libstdc++.i686 yum install -y libstdc++-devel yum install -y dejavu-serif-fonts yum install -y ksh yum install -y make yum install -y sysstat yum install -y numactl yum install -y numactl-devel yum install -y motif yum install -y motif-devel yum install -y redhat-lsb yum install -y redhat-lsb-core yum install -y openssl
OS 설정값 변경
vi /etc/sysctl.d/98-oracle.conf fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 net.ipv4.conf.all.rp_filter = 2 net.ipv4.conf.default.rp_filter = 2 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 11000 65000 /sbin/sysctl -p /etc/sysctl.d/98-oracle.conf
vi /etc/security/limits.d/oracle-database-preinstall-19c.conf oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 16384 oracle hard nproc 16384 oracle soft stack 10240 oracle hard stack 32768 oracle hard memlock 134217728 oracle soft memlock 134217728
Selinux 설정변경
setenforce Permissive
Oracle 그룹 및 유저 추가
groupadd -g 54321 oinstall groupadd -g 54322 dba groupadd -g 54323 oper useradd -u 54321 -g oinstall -G dba,oper oracle passwd oracle
폴더 생성 및 권한 변경
mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1 mkdir -p /u01/oradata chown -R oracle:oinstall /u01 chmod -R 775 /u01
Oracle 유저 프로파일 생성
mkdir /home/oracle/scripts cat > /home/oracle/scripts/setEnv.sh <<EOF # Oracle Settings export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=em13c.bitekic.co.kr export ORACLE_UNQNAME=em13c export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1 export ORA_INVENTORY=/u01/app/oraInventory export ORACLE_SID=em13c export OMS_HOME=$ORACLE_BASE/middleware export AGENT_HOME=/u01/app/oracle/agent/agent_inst export DATA_DIR=/u01/oradata export PATH=/usr/sbin:/usr/local/bin:$PATH export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$OMS_HOME/oui/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib EOF echo ". /home/oracle/scripts/setEnv.sh" >> /home/oracle/.bash_profile
Database 설치
cd $ORACLE_HOME unzip -oq /<설치파일있는경로>/LINUX.X64_193000_db_home.zip ./runInstaller
GUI 설치 과정은 클릭하면 확대가 됩니다. 엔진설치 완료.
OPatch 업데이트
cd $ORACLE_HOME mv OPatch OPatch_old unzip -oq /<패치파일경로>/p6880880_190000_Linux-x86-64_2006.zip
$ opatch version OPatch Version: 12.2.0.1.21 OPatch succeeded.
em13c의 DB 템플릿이 19.5 버전 기준으로 작성되어 있어서 기왕 없하는거 19.7로 버전업을 진행하였습니다.
p6880880_190000_Linux-x86-64_2006.zip를 받아서 OPatch를 미리 업데이트하고, p30899722_190000_Linux-x86-64_2004.zip 받아서 버전업합니다.
cd <UNZIPPED_PATCH_LOCATION>/30899722/30869156 opatch apply
$ opatch apply Oracle Interim Patch Installer version 12.2.0.1.21 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc OPatch version : 12.2.0.1.21 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2020-06-23_15-57-35PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 30869156 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/oracle/product/19.0.0/dbhome_1') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '30869156' to OH '/u01/app/oracle/product/19.0.0/dbhome_1' ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.options.olap.awm, 19.0.0.0.0 ] , [ oracle.sqlj, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.xdk.parser.java.jaxb2, 19.0.0.0.0 ] , [ oracle.assistants.usm, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.rdbms.rsf, 19.0.0.0.0... Patching component oracle.rdbms, 19.0.0.0.0... Patching component oracle.rdbms.util, 19.0.0.0.0... Patching component oracle.assistants.acf, 19.0.0.0.0... Patching component oracle.assistants.deconfig, 19.0.0.0.0... Patching component oracle.assistants.server, 19.0.0.0.0... Patching component oracle.buildtools.rsf, 19.0.0.0.0... Patching component oracle.ctx, 19.0.0.0.0... Patching component oracle.ldap.rsf, 19.0.0.0.0... Patching component oracle.network.rsf, 19.0.0.0.0... Patching component oracle.rdbms.dbscripts, 19.0.0.0.0... Patching component oracle.sdo, 19.0.0.0.0... Patching component oracle.sqlplus, 19.0.0.0.0... Patching component oracle.dbjava.ic, 19.0.0.0.0... Patching component oracle.nlsrtl.rsf, 19.0.0.0.0... Patching component oracle.dbjava.jdbc, 19.0.0.0.0... Patching component oracle.dbdev, 19.0.0.0.0... Patching component oracle.network.client, 19.0.0.0.0... Patching component oracle.xdk.parser.java, 19.0.0.0.0... Patching component oracle.rdbms.deconfig, 19.0.0.0.0... Patching component oracle.oracore.rsf, 19.0.0.0.0... Patching component oracle.rdbms.lbac, 19.0.0.0.0... Patching component oracle.ldap.rsf.ic, 19.0.0.0.0... Patching component oracle.ldap.security.osdt, 19.0.0.0.0... Patching component oracle.ons, 19.0.0.0.0... Patching component oracle.sdo.locator, 19.0.0.0.0... Patching component oracle.rdbms.install.plugins, 19.0.0.0.0... Patching component oracle.marvel, 19.0.0.0.0... Patching component oracle.rdbms.install.common, 19.0.0.0.0... Patching component oracle.install.deinstalltool, 19.0.0.0.0... Patching component oracle.xdk.rsf, 19.0.0.0.0... Patching component oracle.rdbms.oci, 19.0.0.0.0... Patching component oracle.rdbms.drdaas, 19.0.0.0.0... Patching component oracle.precomp.rsf, 19.0.0.0.0... Patching component oracle.javavm.client, 19.0.0.0.0... Patching component oracle.precomp.common.core, 19.0.0.0.0... Patching component oracle.xdk, 19.0.0.0.0... Patching component oracle.sqlplus.ic, 19.0.0.0.0... Patching component oracle.odbc, 19.0.0.0.0... Patching component oracle.oraolap.dbscripts, 19.0.0.0.0... Patching component oracle.ldap.owm, 19.0.0.0.0... Patching component oracle.bali.ice, 11.1.1.7.0... Patching component oracle.ctx.rsf, 19.0.0.0.0... Patching component oracle.ovm, 19.0.0.0.0... Patching component oracle.rdbms.rman, 19.0.0.0.0... Patching component oracle.dbjava.ucp, 19.0.0.0.0... Patching component oracle.rdbms.dv, 19.0.0.0.0... Patching component oracle.duma, 19.0.0.0.0... Patching component oracle.network.listener, 19.0.0.0.0... Patching component oracle.oraolap, 19.0.0.0.0... Patching component oracle.sdo.locator.jrf, 19.0.0.0.0... Patching component oracle.rdbms.scheduler, 19.0.0.0.0... Patching component oracle.rdbms.crs, 19.0.0.0.0... Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0... Patching component oracle.precomp.common, 19.0.0.0.0... Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0... Patching component oracle.perlint, 5.28.1.0.0... Patching component oracle.precomp.lang, 19.0.0.0.0... Patching component oracle.jdk, 1.8.0.201.0... Patch 30869156 successfully applied. Sub-set patch [29517242] has become inactive due to the application of a super-set patch [30869156]. Please refer to Doc ID 2161861.1 for any possible further required actions. Log file location: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2020-06-23_15-57-35PM_1.log OPatch succeeded.
DB 생성
Oracle 공홈에 가면 em13c의 Download 페이지에 DB 템플릿이 있습니다.
19.5.0.0_Database_Template_for_EM13_4_0_0_0_Linux_x64.zip 파일을 받아서 $ORACLE_HOME/assistants/dbca/templates 밑에 복사해서 압축을 풀면 됩니다.
dbca 진행
Advanced configuration을 선택.
우측 하단에 Change 버튼을 누르고 아까 압축을 푼 템플릿 중에 19_5_0_0_Database_Template_for_EM13_4_0_0_0_Large_deployment.dbc 를 선택을 합니다.
이런 과정을 통해 DB 생성완료 되었습니다. 스크린샷에서 기본 옵션과 다른 점을 잘 체크하시기 바랍니다.
Oracle 에서 제공하는 템플릿을 이용해 DB를 생성하면, DB를 Default로 설치 했을때 변경해줘야 하는 파라미터 값이 미리 설정되어 있습니다.
_allow_insert_with_update_check=true session_cached_cursors=200 _optimizer_nlj_hj_adaptive_join= FALSE _optimizer_strans_adaptive_pruning = FALSE _px_adaptive_dist_method = OFF _sql_plan_directive_mgmt_control = 0 _optimizer_dsdir_usage_control = 0 _optimizer_use_feedback = FALSE _optimizer_gather_feedback = FALSE _optimizer_performance_feedback = OFF
SQL> show parameter _optimizer_nlj_hj_adaptive_join NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ _optimizer_nlj_hj_adaptive_join boolean FALSE SQL> show parameter _allow_insert_with_update_check NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ _allow_insert_with_update_check boolean TRUE
netca로 리스너를 추가하면 DB 생성 작업은 완료입니다.
$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 23-JUN-2020 16:29:53 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=em13c)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 23-JUN-2020 16:29:20 Uptime 0 days 0 hr. 0 min. 32 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/em13c/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=em13c)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Services Summary... Service "em13c" has 1 instance(s). Instance "em13c", status READY, has 1 handler(s) for this service... Service "em13cXDB" has 1 instance(s). Instance "em13c", status READY, has 1 handler(s) for this service... The command completed successfully
다음 포스트에서 em13c 설치를 계속 해보겠습니다.
최신 댓글