{"id":890,"date":"2019-04-15T09:39:03","date_gmt":"2019-04-15T00:39:03","guid":{"rendered":"https:\/\/dong1lkim.oboki.net\/?p=890"},"modified":"2019-09-01T22:23:14","modified_gmt":"2019-09-01T13:23:14","slug":"oracle-12c-silent-%ec%84%a4%ec%b9%98","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/data-engineering\/database\/oracle\/oracle-12c-silent-%ec%84%a4%ec%b9%98\/","title":{"rendered":"[oracle] 12c Silent \uc124\uce58"},"content":{"rendered":"<h1>Oracle 12c silent \ubaa8\ub4dc \uc124\uce58<\/h1>\n<h2>\uc0ac\uc804 \uc900\ube44<\/h2>\n<h3>\ucee4\ub110 \ud30c\ub77c\ubbf8\ud130 \uc124\uc815<\/h3>\n<p><code>vi \/etc\/sysctl.conf<\/code><\/p>\n<pre><code class=\"conf\">fs.aio-max-nr = 1048576\nfs.file-max = 6815744\nkernel.shmall = 2097152\nkernel.shmmax = 4056393728\nkernel.shmmni = 4096\nkernel.sem = 250 32000 100 128\nnet.ipv4.ip_local_port_range = 9000 65500\nnet.core.rmem_default = 262144\nnet.core.rmem_max = 4194304\nnet.core.wmem_default = 262144\nnet.core.wmem_max = 1048586\n<\/code><\/pre>\n<p><code>sysctl -p<\/code><\/p>\n<h3>User Limit \uc124\uc815<\/h3>\n<p><code>vi \/etc\/security\/limits.conf<\/code><\/p>\n<pre><code class=\"conf\">oracle  soft    nproc   2047\noracle  hard    nproc   16384\noracle  soft    nofile  1024\noracle  hard    nofile  65536\noracle  soft    stack   10240\n<\/code><\/pre>\n<h3>\uc758\uc874 \ud328\ud0a4\uc9c0 \uc124\uce58<\/h3>\n<pre><code class=\"bash\">yum update -y\nyum install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33.i686 gcc gcc-c++ glibc glibc.i686 glibc-devel glibc-devel.i686 ksh libgcc libgcc.i686 libstdc++ libstdc++.i686 libstdc++-devel libstdc++-devel.i686 libaio libaio.i686 libaio-devel libaio-devel.i686 libXext libXext.i686 libXtst libXtst.i686libX11 libX11.i686libXau libXau.i686 libxcb libxcb.i686 libXi libXi.i686 make sysstat unixODBC unixODBC-devel zip unzip libXrender\n<\/code><\/pre>\n<h3>Oracle \uc2dc\uc2a4\ud15c \uc0ac\uc6a9\uc790 \uc124\uc815<\/h3>\n<h4>Oracle \uc0ac\uc6a9\uc790 \uc0dd\uc131<\/h4>\n<pre><code class=\"bash\">groupadd dba\nuseradd oracle -g dba\npasswd oracle\n<\/code><\/pre>\n<h4>Oracle \uacbd\ub85c \uc0dd\uc131<\/h4>\n<pre><code class=\"bash\">mkdir -p \/app\/oracle \/app\/oraInventory\nchown oracle:dba \/app\/oracle \/app\/oraInventory\n<\/code><\/pre>\n<h4>\ud504\ub85c\ud30c\uc77c<\/h4>\n<p><code>vi ~\/.bash_profile<\/code><\/p>\n<pre><code class=\"bash\">export TMP=\/tmp\nexport TMPDIR=$TMP\nexport ORACLE_HOSTNAME=dsrc\nexport ORACLE_UNQNAME=orcl\nexport ORACLE_BASE=\/app\/oracle\nexport ORACLE_HOME=$ORACLE_BASE\/12.2\nexport ORACLE_SID=orcl\nexport PATH=\/usr\/sbin:$PATH\nexport PATH=$ORACLE_HOME\/bin:$PATH\nexport LD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib\nexport CLASSPATH=$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib\n<\/code><\/pre>\n<h2>Oracle Instance \uc124\uce58<\/h2>\n<h3>Installer \uc900\ube44<\/h3>\n<p>\ub2e4\uc74c \uacbd\ub85c\uc5d0\uc11c <code>Oracle Database 12c Release 2<\/code> \ub97c \ub2e4\uc6b4\ubc1b\uc544 \uc124\uce58\ud560 \uc11c\ubc84\uc5d0 \uc5c5\ub85c\ub4dc\ud55c\ub2e4. (\ub85c\uadf8\uc778 \ud544\uc694)<\/p>\n<p><a href=\"https:\/\/www.oracle.com\/technetwork\/database\/enterprise-edition\/downloads\/index.html\"><a href=\"https:\/\/www.oracle.com\/technetwork\/database\/enterprise-edition\/downloads\/index.html\">https:\/\/www.oracle.com\/technetwork\/database\/enterprise-edition\/downloads\/index.html<\/a><\/a><\/p>\n<p>\uc555\ucd95\uc744 \ud480\uace0,<\/p>\n<p><code>unzip linuxx64_12201_database.zip<\/code><\/p>\n<p>responseFile \uc744 \uc218\uc815\ud55c \ub2e4\uc74c,<\/p>\n<p><code>vi .\/database\/response\/db_install.rsp<\/code><\/p>\n<pre><code class=\"rsp\">oracle.install.responseFileVersion=\/oracle\/install\/rspfmt_dbinstall_response_schema_v12.2.0\noracle.install.option=INSTALL_DB_SWONLY\nUNIX_GROUP_NAME=dba\nINVENTORY_LOCATION=\/app\/oraInventory\nORACLE_HOME=\/app\/oracle\/12.2\nORACLE_BASE=\/app\/oracle\noracle.install.db.InstallEdition=EE\noracle.install.db.OSDBA_GROUP=dba\noracle.install.db.OSOPER_GROUP=dba\noracle.install.db.OSBACKUPDBA_GROUP=dba\noracle.install.db.OSDGDBA_GROUP=dba\noracle.install.db.OSKMDBA_GROUP=dba\noracle.install.db.OSRACDBA_GROUP=dba\noracle.install.db.config.starterdb.globalDBName=orcl\noracle.install.db.config.starterdb.SID=orcl\noracle.install.db.config.starterdb.characterSet=AL32UTF8\nSECURITY_UPDATES_VIA_MYORACLESUPPORT=false\nDECLINE_SECURITY_UPDATES=true\n<\/code><\/pre>\n<p>Installer \ub97c \uc2e4\ud589\ud55c\ub2e4.<\/p>\n<p><code>.\/database\/runInstaller -ignoreSysPrereqs -showProgress -silent -responseFile \/home\/oracle\/database\/response\/db_install.rsp<\/code><\/p>\n<h2>Database \uc0dd\uc131<\/h2>\n<p><code>dbca<\/code> \ub97c silent \ubaa8\ub4dc\ub85c \uc2e4\ud589\ud558\uae30 \uc704\ud574\uc11c \uba3c\uc800 responseFile \uc744 \uc791\uc131\ud55c\ub2e4.<\/p>\n<p><code>vi $ORACLE_HOME\/assistants\/dbca\/dbca.rsp<\/code><\/p>\n<pre><code class=\"rsp\">responseFileVersion=\/oracle\/assistants\/rspfmt_dbca_response_schema_v12.2.0\ngdbName=orcl\ntemplateName=General_Purpose.dbc\nsysPassword=oracle\nsystemPassword=oracle\nemExpressPort=5500\ndbsnmpPassword=oracle\ncharacterSet=AL32UTF8\n<\/code><\/pre>\n<p>\uc774\uc5b4\uc11c \uc544\ub798 \uba85\ub839\uc73c\ub85c <code>dbca<\/code>\ub97c \uc2e4\ud589\ud558\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131 \ub05d.<\/p>\n<p><code>dbca -silent -createDatabase -responseFile \/app\/oracle\/12.2\/assistants\/dbca\/dbca.rsp<\/code><\/p>\n<h2>Listener \uc0dd\uc131<\/h2>\n<p>\uc544\ub798 \uba85\ub839\uc73c\ub85c <code>netca<\/code>\ub97c \uc2e4\ud589\ud558\uba74 \uae30\ubcf8 \ub9ac\uc2a4\ub108\uac00 \uc0dd\uc131\ub41c\ub2e4.<\/p>\n<p><code>netca -silent -responseFile \/app\/oracle\/12.2\/assistants\/netca\/netca.rsp<\/code><\/p>\n<h2>\ucc38\uace0\uc790\ub8cc<\/h2>\n<ul>\n<li><a href=\"https:\/\/iskra.sarang.net\/178\">https:\/\/iskra.sarang.net\/178<\/a><\/li>\n<li><a href=\"http:\/\/www.br8dba.com\/install-12-2-database-binaries-in-silent-mode\/\">http:\/\/www.br8dba.com\/install-12-2-database-binaries-in-silent-mode\/<\/a><\/li>\n<li><a href=\"https:\/\/oracle-base.com\/articles\/misc\/database-configuration-assistant-dbca-silent-mode\">https:\/\/oracle-base.com\/articles\/misc\/database-configuration-assistant-dbca-silent-mode<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Oracle 12c silent \ubaa8\ub4dc \uc124\uce58 \uc0ac\uc804 \uc900\ube44 \ucee4\ub110 \ud30c\ub77c\ubbf8\ud130 \uc124\uc815 vi \/etc\/sysctl.conf fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 4056393728 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048586 sysctl -p User Limit \uc124\uc815 vi [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[48],"tags":[49,50],"class_list":["post-890","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle","tag-50"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/890","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/comments?post=890"}],"version-history":[{"count":3,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/890\/revisions"}],"predecessor-version":[{"id":1343,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/890\/revisions\/1343"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}