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 설치를 계속 해보겠습니다.

 

 

You may also like...

댓글 남기기

이메일은 공개되지 않습니다. 필수 입력창은 * 로 표시되어 있습니다