{"id":866,"date":"2020-01-03T16:41:37","date_gmt":"2020-01-03T08:41:37","guid":{"rendered":"http:\/\/www.821121.com\/?p=866"},"modified":"2021-02-02T14:24:44","modified_gmt":"2021-02-02T06:24:44","slug":"oracle19c%e5%8d%95%e5%ae%9e%e4%be%8b%e9%83%a8%e7%bd%b2%e6%96%87%e6%a1%a3","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=866","title":{"rendered":"Oracle19c\u5355\u5b9e\u4f8b\u90e8\u7f72\u6587\u6863"},"content":{"rendered":"<pre><code class=\"language-sql\">\u5b9e\u9a8c\u73af\u5883\uff1acentos 7.6(19c\u5728linux\u4e0a\u6700\u4f4e\u8fd0\u884c\u7248\u672c\u4e3a7.4\u4ee5\u4e0a)   Oracle 19c 19.3.0\n\nip\uff1a192.168.0.100   hostname\uff1acmdb     <\/code><\/pre>\n<h1>1\u3001\u914d\u7f6eyum\u3001\u4fee\u6539\u65f6\u95f4<\/h1>\n<pre><code class=\"language-sql\">mount  \/dev\/sr0 \/mnt\ncd \/etc\/yum.repos.d\/\nrm -rf *\n\nvi \/etc\/yum.repos.d\/ol.repo   \n[local-source]\nname=ol\nbaseurl=file:\/\/\/mnt\/\nebabled=1\ngpgcheck=0\ngpgkey=file:\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-oracle\n\nyum install bc gcc gcc-c++ binutils compat-libcap1 compat-libstdc++ dtrace-modules dtrace-modules-headers \ndtrace-modules-provider-headers dtrace-utils elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel \nksh libaio libaio-devel libdtrace-ctf-devel libX11 libXau libXi libXtst libXrender libXrender-devel libgcc librdmacm-devel \nlibstdc++ libstdc++-devel libxcb make smartmontools sysstat \n\ndate\nrm -rf \/etc\/localtime\nln -s \/usr\/share\/zoneinfo\/Asia\/Shanghai \/etc\/localtime<\/code><\/pre>\n<h1>2\u3001\u521b\u5efa\u7528\u6237\u3001\u7ec4\u3001\u76ee\u5f55<\/h1>\n<pre><code class=\"language-sql\">\/usr\/sbin\/groupadd -g 54321 oinstall\n\/usr\/sbin\/groupadd -g 54322 dba\n\/usr\/sbin\/groupadd -g 54323 oper\n\/usr\/sbin\/useradd -u 54321 -g oinstall -G dba,oper oracle\n\nmkdir -p \/u01\/app\/oracle\/product\/19.3.0\/db_1\nchown -R oracle:oinstall \/u01\/\nchmod -R 775 \/u01\/\n\npasswd oracle<\/code><\/pre>\n<h1>3\u3001\u914d\u7f6e\u7cfb\u7edf\u53c2\u6570<\/h1>\n<pre><code class=\"language-sql\">vi \/etc\/sysctl.conf\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\nfs.aio-max-nr = 1048576\nnet.ipv4.ip_local_port_range = 9000 65500\nsysctl --system\n\nvi \/etc\/security\/limits.conf\noracle soft nofile 1024\noracle hard nofile 65536\noracle soft stack 10240\noracle hard stack 32768\noracle soft nproc 16384\noracle hard nproc 16384\nroot soft nproc 2047\n\nvi \/etc\/pam.d\/login \u6dfb\u52a0\uff1a\nsession required pam_limits.so \n\nvi \/etc\/profile\u6dfb\u52a0\uff1a\nif [ $USER = &quot;oracle&quot; ] || [ $USER = &quot;grid&quot; ] ; then\n    if [ $SHELL = &quot;\/bin\/ksh&quot; ]; then\n       ulimit -u 16384\n       ulimit -n 65536\n    else\n       ulimit -u 16384 -n 65536\n    fi\nfi<\/code><\/pre>\n<h1>4\u3001\u5173\u95ed\u9632\u706b\u5899\u548cselinux\u3001ntp<\/h1>\n<pre><code class=\"language-sql\">\u9632\u706b\u5899\nsystemctl stop firewalld.service\nsystemctl disable firewalld.service\n\nselinux\nvi \/etc\/selinux\/config\nSELINUX=disabled\n\n\u5173\u95edNTP:\nsystemctl stop ntpd.service\nsystemctl disable ntpd.service<\/code><\/pre>\n<h1>5\u3001oracle\u7528\u6237\u73af\u5883\u53d8\u91cf<\/h1>\n<pre><code class=\"language-sql\">vi .bash_profile\n\u5728\uff0c\u7f16\u8f91\u6a21\u5f0f\u4e0b\u8f93\u5165\nexport TMP=\/tmp \nexport TMPDIR=$TMP \nexport ORACLE_SID=cmdb\nexport ORACLE_BASE=\/u01\/app\/oracle \nexport ORACLE_HOME=$ORACLE_BASE\/product\/19.3.0\/db_1\nexport TNS_ADMIN=$ORACLE_HOME\/network\/admin \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\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib \numask 022\nexport NLS_LANG=AMERICAN_AMERICA.UTF8\nsource .bash_profile<\/code><\/pre>\n<h1>6.\u4e0a\u7a7f\u5b89\u88c5\u5305\u5e76\u89e3\u538b<\/h1>\n<pre><code class=\"language-sql\">yum -y install zip unzip\nsu - oracle\nunzip LINUX.X64_193000_db_home.zip -d \/u01\/app\/oracle\/product\/19.3.0\/db_1\/\n<\/code><\/pre>\n<h1>7\u3001Missing or Ignored package compat-libstdc++-33-3.2.3 causes Text Issues (\u6587\u6863 ID 2254198.1)<\/h1>\n<pre><code class=\"language-sql\">linux7\u7f3a\u5c11\u8be5\u5305\uff0c\u9700\u8981\u53bb\u7f51\u4e0a\u4e0b\u8f7d\u624b\u52a8\u5b89\u88c5\uff0c\u6216\u8005\u4e0d\u5b89\u88c5\u4e0d\u4f1a\u5f71\u54cd\u6570\u636e\u5e93\u7684\u4f7f\u7528\uff0c\u8be6\u60c5\u770bmos\u6587\u68632254198.1\n<\/code><\/pre>\n<h1>8\u3001\u56fe\u5f62\u5316\u5b89\u88c5<\/h1>\n<pre><code class=\"language-sql\">export DISPLAY=192.168.0.1:0.0\nLANG=en_US .\/runInstaller<\/code><\/pre>\n<p>\u56fe\u5f62\u5316\u754c\u9762\u5982\u4e0b\uff1a<br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416660126.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416670000.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416678698.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416685586.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416693594.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416699328.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416705954.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416711242.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416716562.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416721534.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416726657.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416734424.png\" alt=\"file\" \/><\/p>\n<h1>9\u3001DBCA<\/h1>\n<p>dbac\u56fe\u5f62\u5982\u4e0b\uff1a<br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416743890.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416749612.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416755202.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416763352.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416768303.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416773907.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416779438.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416785494.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416790099.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416795019.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416799926.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416804587.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416808756.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416814011.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416818807.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416828907.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416834647.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416846482.png\" alt=\"file\" \/><br \/>\n<img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/12\/image-1607416852309.png\" alt=\"file\" \/><\/p>\n<p>\/u01\/app\/oracle\/product\/19.3.0\/db_1\/assistants\/dbca\/templates    \u6a21\u677f\u6570\u636e\u5e93<br \/>\n\/u01\/app\/oracle\/admin\/cmdb\/scripts      \u6570\u636e\u5e93\u521b\u5efa\u811a\u672c\u4f4d\u7f6e<br \/>\n\/u01\/app\/oracle\/cfgtoollogs\/dbca\/cmdb\/trace.log_2020-12-07_03-36-03PM     DBCA\u65e5\u5fd7<br \/>\n\/u01\/app\/oracle\/diag\/rdbms\/cmdb\/cmdb\/trace\/alert_cmdb.log     \u6570\u636e\u5e93\u544a\u8b66\u65e5\u5fd7<\/p>\n<h1>10\u3001\u6253\u5f00\u6570\u636e\u5e93\uff0c\u6253\u5f00\u76d1\u542c<\/h1>\n<pre><code class=\"language-sql\">sqlplus \/ as sysdba\nlsnrctl start<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u5b9e\u9a8c\u73af\u5883\uff1acentos 7.6(19c\u5728linux<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49,51],"tags":[],"class_list":["post-866","post","type-post","status-publish","format-standard","hentry","category-oracle-19c","category--oracle-19c"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/866","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=866"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/866\/revisions"}],"predecessor-version":[{"id":899,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/866\/revisions\/899"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=866"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=866"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=866"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}