{"id":5988,"date":"2023-05-10T17:57:10","date_gmt":"2023-05-10T08:57:10","guid":{"rendered":"\/blog\/?p=5988"},"modified":"2023-09-21T09:26:20","modified_gmt":"2023-09-21T00:26:20","slug":"rocky-linux-8-7%ec%97%90-oracle-db-%ec%84%a4%ec%b9%98","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=5988","title":{"rendered":"Install Oracle DB 19c on Rocky Linux 8.7"},"content":{"rendered":"\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"atomic\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"false\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">01. \ud544\uc694\ud55c \ud328\ud0a4\uc9c0 \uc124\uce58\n  dnf -y install glibc-devel\n  dnf -y install ksh\n  dnf -y install libaio-devel\n  dnf -y install libstdc++-devel\n  dnf -y install make\n  dnf -y install nfs-utils\n  dnf -y install psmisc\n  dnf -y install sysstat\n  dnf -y install xorg-x11-utils\n  dnf -y install xorg-x11-xauth\n  dnf -y install libnsl*\n  curl -o compat-libcap1-1.10-7.el7.x86_64.rpm \"http:\/\/mirror.centos.org\/centos\/7\/os\/x86_64\/Packages\/compat-libcap1-1.10-7.el7.x86_64.rpm\"\n  curl -o compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm \"http:\/\/mirror.centos.org\/centos\/7\/os\/x86_64\/Packages\/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm\"\n  dnf localinstall compat-libcap1-1.10-7.el7.x86_64.rpm -y\n  dnf localinstall compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm -y\n\n02.\uc0ac\uc6a9\uc790 \ubc0f \uadf8\ub8f9 \ucd94\uac00\n  groupadd -g 1501 oinstall\n  groupadd -g 1502 dba\n  groupadd -g 1503 oper\n  groupadd -g 1504 backupdba\n  groupadd -g 1505 dgdba\n  groupadd -g 1506 kmdba\n  groupadd -g 1507 racdba\n  useradd -u 1501 -g oinstall -G dba,oper,backupdba,dgdba,kmdba,racdba -c \"Oracle Database\" oracle\n  echo 'Password' | passwd oracle --stdin\n\n03.\uc0ac\uc6a9\uc790 limit \uac12 \ucd94\uac00\nvi \/etc\/security\/limits.d\/30-oracle.conf\n---------------------------------------\noracle  soft    nofile          1024\noracle  hard    nofile          65536\noracle  soft    nproc           16384\noracle  hard    nproc           16384\noracle  soft    stack           10240\noracle  hard    stack           32768\noracle  hard    memlock         134217728\noracle  soft    memlock         134217728\n---------------------------------------\n\n04.sysctl \ucd94\uac00\n  vi \/etc\/sysctl.d\/98-oracle.conf\n---------------------------------------\nfs.file-max = 6815744\nkernel.sem = 250 32000 100 128\nkernel.shmmni = 4096\nkernel.shmall = 1073741824\nkernel.shmmax = 4398046511104\nkernel.panic_on_oops = 1\nnet.core.rmem_default = 262144\nnet.core.rmem_max = 4194304\nnet.core.wmem_default = 262144\nnet.core.wmem_max = 1048576\nnet.ipv4.conf.all.rp_filter = 2\nnet.ipv4.conf.default.rp_filter = 2\nfs.aio-max-nr = 1048576\nnet.ipv4.ip_local_port_range = 9000 65500\n---------------------------------------\n  sysctl -p \/etc\/sysctl.d\/98-oracle.conf\n\n05.GRUB_CMDLINE_LINUX\uc5d0 'transparent_hugepage=never' \ucd94\uac00\n  cat \/sys\/kernel\/mm\/transparent_hugepage\/enabled\n    [always] madvise never\n  vi \/etc\/default\/grub\n---------------------------------------\n  GRUB_CMDLINE_LINUX=\"resume=UUID=7c106dd4-b200-410e-ad8c-3e9ed9d6e9af transparent_hugepage=never\"\n---------------------------------------\n  grub2-mkconfig -o \/boot\/grub2\/grub.cfg\n  reboot\n  cat \/sys\/kernel\/mm\/transparent_hugepage\/enabled\n    always madvise [never]\n\n06. Oracle DB \ub2e4\uc6b4\ub85c\ub4dc\n  https:\/\/www.oracle.com\/kr\/database\/technologies\/oracle-database-software-downloads.html\n\n  19.3 - Enterprise Edition (also includes Standard Edition 2)\n  Linux x86-64 RPM \ub2e4\uc6b4\ub85c\ub4dc\n\n07.\uc124\uce58 \uc9c4\ud589\n  wget --no-check-certificate \"https:\/\/yum.oracle.com\/repo\/OracleLinux\/OL7\/latest\/x86_64\/getPackage\/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm\"\n  dnf localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm -y\n  rpm -Uvh oracle-database-ee-19c-1.0-1.x86_64.rpm\n\n  \/etc\/init.d\/oracledb_ORCLCDB-19c configure\n\n09.\uad8c\ud55c\uc124\uc815 \uc2a4\ud06c\ub9bd\ud2b8 \uc2e4\ud589 (root \uad8c\ud55c\uc73c\ub85c \uc2e4\ud589)\n  chown -R oracle:oinstall \/opt\/oracle\n  \/opt\/oracle\/oraInventory\/orainstRoot.sh\n  \/opt\/oracle\/product\/19c\/dbhome_1\/root.sh\n\n10.oracle \uacc4\uc815\uc5d0 \ud658\uacbd \ubcc0\uc218 \ucd94\uac00\n  su - oracle\n  vi ~\/.bash_profile\n---------------------------------------\n# for Oracle\nexport TMP=\/tmp\nexport TMPDIR=$TMP\nexport ORACLE_HOSTNAME=db\nexport ORACLE_BASE=\/opt\/oracle\nexport ORACLE_HOME=$ORACLE_BASE\/product\/19c\/dbhome_1\nexport ORA_INVENTORY=$ORACLE_BASE\/oraInventory\nexport ORACLE_SID=ORCLCDB\nexport PDB_NAME=pdb1\nexport DATA_DIR=$ORACLE_BASE\/oradata\nexport PATH=$ORACLE_HOME\/bin:$PATH\nexport NLS_LANG=KOREAN_KOREA.AL32UTF8\nexport LD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib\nexport CLASSPATH=$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib\n---------------------------------------\n  source ~\/.bash_profile\n\n11.\ub9ac\uc2a4\ub108 \uc2e4\ud589\n  lsnrctl start\n\n12.\ud14c\uc2a4\ud2b8\n  su - oracle\n  sqlplus \/ as sysdba\n    -- \uc624\ub77c\ud074 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\uba85\uc744 \ud655\uc778\n    SELECT NAME, DB_UNIQUE_NAME FROM v$database;\n    -- \uc624\ub77c\ud074 SID\ub97c \ud655\uc778\n    SELECT instance FROM v$thread;\n\n13.systemd \uc2a4\ud06c\ub9bd\ud2b8 \ub4f1\ub85d\n  # \ubd80\ud305\uc2dc dbstart \uc720\ud2f8\ub9ac\ud2f0\ub97c \uc0ac\uc6a9\ud558\ub3c4\ub85d \uc124\uc815(N\u2192Y)\n  sed -i 's\/:N$\/:Y\/g' \/etc\/oratab\n  vi \/usr\/lib\/systemd\/system\/oracle_instance.service\n---------------------------------------\n[Unit]\nDescription=a service to start oracle databases automatically\nAfter=syslog.target network.target\n\n[Service]\nType=oneshot\nRemainAfterExit=yes\nRestart=no\nEnvironment=ORACLE_BASE=\/opt\/oracle\nEnvironment=ORACLE_HOME=\/opt\/oracle\/product\/19c\/dbhome_1\nEnvironment=ORACLE_SID=ORCLCDB\nExecStart=\/opt\/oracle\/product\/19c\/dbhome_1\/bin\/dbstart ORACLE_HOME\nExecStop=\/opt\/oracle\/product\/19c\/dbhome_1\/bin\/dbshut ORACLE_HOME\nUser=oracle\nGroup=oinstall\n\n[Install]\nWantedBy=multi-user.target\n---------------------------------------\n  vi \/usr\/lib\/systemd\/system\/oracle_listener.service\n---------------------------------------\n[Unit]\nDescription=a service to start oracle listener automatically\nAfter=syslog.target network.target\n\n[Service]\nType=oneshot\nRemainAfterExit=yes\nRestart=no\nEnvironment=ORACLE_BASE=\/opt\/oracle\nEnvironment=ORACLE_HOME=\/opt\/oracle\/product\/19c\/dbhome_1\nEnvironment=ORACLE_SID=ORCLCDB\nExecStart=\/opt\/oracle\/product\/19c\/dbhome_1\/bin\/lsnrctl start\nExecStop=\/opt\/oracle\/product\/19c\/dbhome_1\/bin\/lsnrctl stop\nUser=oracle\nGroup=oinstall\n\n[Install]\nWantedBy=multi-user.target\n---------------------------------------\n  systemctl daemon-reload\n  systemctl enable oracle_listener.service\n  systemctl enable oracle_instance.service\n  systemctl restart oracle_listener.service\n  systemctl restart oracle_instance.service\n\n14. initorcl.ora\n  su - oracle\n  cp -f \/opt\/oracle\/product\/19c\/dbhome_1\/dbs\/init.ora \/opt\/oracle\/product\/19c\/dbhome_1\/dbs\/initorcl.ora\n  vi \/opt\/oracle\/product\/19c\/dbhome_1\/dbs\/initorcl.ora\n---------------------------------------\ndb_name='ORCLCDB'\nmemory_target=1G\nprocesses = 150\naudit_file_dest='\/opt\/oracle\/admin\/ORCLCDB\/adump'\naudit_trail ='db'\ndb_block_size=8192\ndb_domain=''\ndb_recovery_file_dest='\/opt\/oracle\/fast_recovery_area'\ndb_recovery_file_dest_size=2G\ndiagnostic_dest='\/opt\/oracle'\ndispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'\nopen_cursors=300\nremote_login_passwordfile='EXCLUSIVE'\nundo_tablespace='UNDOTBS1'\ncontrol_files = ('\/opt\/oracle\/oradata\/ORCLCDB\/control01.ctl', '\/opt\/oracle\/oradata\/ORCLCDB\/control02.ctl')\ncompatible ='11.2.0'\n---------------------------------------\n  mkdir \/opt\/oracle\/fast_recovery_area\n  chown -R oracle:oinstall \/opt\/oracle\/fast_recovery_area\n\n15.alert \ub85c\uadf8 \ud655\uc778\n  tail -n 100 \/opt\/oracle\/diag\/rdbms\/orclcdb\/ORCLCDB\/trace\/alert_ORCLCDB.log\n\n16. \uc218\ub3d9 \uc2dc\uc791 \ubc0f \uc885\ub8cc\n  sqlplus \/ as sysdba\n    -- \uac15\uc81c \uc885\ub8cc\n    shutdown immediate\n    -- \uc2dc\uc791\n    startup open<\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[39,10],"tags":[],"class_list":["post-5988","post","type-post","status-publish","format-standard","hentry","category-os_linux_unix_macos","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/5988","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5988"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/5988\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5988"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5988"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5988"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}