{"id":675,"date":"2022-12-15T08:18:21","date_gmt":"2022-12-15T08:18:21","guid":{"rendered":"https:\/\/d1m0.com\/?p=675"},"modified":"2022-12-16T10:56:38","modified_gmt":"2022-12-16T10:56:38","slug":"oracle-database-ol9-1","status":"publish","type":"post","link":"https:\/\/d1m0.com\/?p=675","title":{"rendered":"Oracle database &#8211; OL9.1"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p>Download 21.3 C from <\/p>\n\n\n\n<p><a href=\"https:\/\/www.oracle.com\/database\/technologies\/oracle21c-linux-downloads.html#license-lightbox\">https:\/\/www.oracle.com\/database\/technologies\/oracle21c-linux-downloads.html#license-lightbox<\/a><\/p>\n\n\n\n<p>set corect hostname   &#8211; <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>hostnamectl hostname dbs<\/code><\/pre>\n\n\n\n<p>add record in \/etc\/hosts &#8211;  local ip to dns name.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4\n::1         localhost localhost.localdomain localhost6 localhost6.localdomain6\n<strong>192.168.56.3 dbs<\/strong><\/code><\/pre>\n\n\n\n<p>disable selinux -&gt; restart<\/p>\n\n\n\n<p>kernel parameters sysctl and apply .<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>fs.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<\/code><\/pre>\n\n\n\n<p>set limits in \/etc\/security\/limits.d\/oracle.conf<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>oracle   soft   nofile    1024\noracle   hard   nofile    65536\noracle   soft   nproc    16384\noracle   hard   nproc    16384\noracle   soft   stack    10240\noracle   hard   stack    32868\noracle   hard   memlock    134217728\noracle   soft   memlock    134217728\noracle   soft   data    unlimited\noracle   hard   data    unlimited<\/code><\/pre>\n\n\n\n<p>Install and remove packages <\/p>\n\n\n\n<p>yum remove firewalld *firmware*<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>yum install bc bind-utils elfutils-libelf glibc glibc-devel ksh libaio libXrender libX11 libXau libXi libXtst libgcc libnsl libstdc++ libxcb libibverbs make policycoreutils policycoreutils-python-utils smartmontools sysstat unixODBC  libnsl2  libnsl2.i686 libxcrypt-compat xauth unzip wget telnet vim\n\n<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>wget ftp:\/\/ftp.pbone.net\/mirror\/archive.fedoraproject.org\/fedora\/linux\/releases\/35\/Everything\/x86_64\/os\/Packages\/c\/compat-libpthread-nonshared-2.34-7.fc35.x86_64.rpm\n\nwget ftp:\/\/ftp.pbone.net\/mirror\/ftp.centos.org\/8-stream\/AppStream\/x86_64\/os\/Packages\/compat-openssl10-1.0.2o-4.el8.x86_64.rpm\n\nyum local install compat-openssl10-1.0.2o-4.el8.x86_64.rpm compat-libpthread-nonshared-2.34-7.fc35.x86_64.rpm<\/code><\/pre>\n\n\n\n<p>Create groups; set pass <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>groupadd -g 54321 oinstall\ngroupadd -g 54322 dba\ngroupadd -g 54323 oper<\/code><\/pre>\n\n\n\n<p>useradd -u 54321 -g oinstall -G dba,oper oracle<\/p>\n\n\n\n<p> passwd oracle <\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Create oracle dir sctructure <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mkdir -p \/opt\/u01\/app\/oracle\/product\/21.0.0\/dbhome_1 \n\nchown -R oracle:oinstall \/u01 \n\nchmod -R 775 \/u01<\/code><\/pre>\n\n\n\n<p>mkdir -p \/home\/oracle\/scripts<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<pre class=\"wp-block-code\"><code>\ncat > \/home\/oracle\/scripts\/setEnv.sh &lt;&lt;EOF\n# Oracle Settings\nexport TMP=\/tmp\nexport TMPDIR=\\$TMP\n\nexport ORACLE_HOSTNAME=dbs\nexport ORACLE_UNQNAME=cdb1\nexport ORACLE_BASE=\/opt\/u01\/app\/oracle\nexport ORACLE_HOME=\\$ORACLE_BASE\/product\/21.0.0\/dbhome_1\nexport ORA_INVENTORY=\/opt\/u01\/app\/oraInvenotry\nexport ORACLE_SID=cdb1\nexport PDB_NAME=pdb1\n\n#HELP - oracle_hostname = machine hostname  \n#HELP - oracle_sid = oracle_uniqname !!\nexport CV_ASSUME_DISTID=OEL7.8\nexport PATH=\/usr\/sbin:\/usr\/local\/bin:\\$PATH\nexport PATH=\\$ORACLE_HOME\/bin:\\$PATH\n\nexport LD_LIBRARY_PATH=\\$ORACLE_HOME\/lib:\/lib:\/usr\/lib\nexport CLASSPATH=\\$ORACLE_HOME\/jlib:\\$ORACLE_HOME\/rdbms\/jlib\nEOF\n<\/code><\/pre>\n<\/div><\/div>\n\n\n\n<p>echo &#8220;. \/home\/oracle\/scripts\/setEnv.sh&#8221; &gt;&gt; \/home\/oracle\/.bash_profile<\/p>\n\n\n\n<p>add  <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code> alias ohome=\"cd $ORACLE_HOME\"  <\/code><\/pre>\n\n\n\n<p>in<\/p>\n\n\n\n<pre id=\"block-eb789218-6f89-4443-a461-a70bdca1762e\" class=\"wp-block-code\"><code> \/home\/oracle\/.bash_profile <\/code><\/pre>\n\n\n\n<p> sudo su &#8211; oracle <\/p>\n\n\n\n<p>unzip LINUX.X64_213000_db_home.zip -d \/opt\/u01\/app\/oracle\/product\/21.0.0\/dbhome_1\/ <\/p>\n\n\n\n<p>cd ohome<\/p>\n\n\n\n<p>cd \/lib\/stubs<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mv libc.so libc.so.hide\nmv libc.so.6 libc.so.6.hide<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>rm \/opt\/u01\/app\/oracle\/product\/21.0.0\/dbhome_1\/lib\/libjavavm.a\n\ncp \/opt\/u01\/app\/oracle\/product\/21.0.0\/dbhome_1\/javavm\/jdk\/jdk8\/lib\/libjavavm.a \/opt\/u01\/app\/oracle\/product\/21.0.0\/dbhome_1\/lib\/<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code><\/code><\/pre>\n\n\n\n<p>Use mobaXterm to start graphical installation as user oracle<br><br>cd ohome<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>.\/runInstaller<\/code><\/pre>\n\n\n\n<p><sup> date : 15.12.22<\/sup><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Download 21.3 C from https:\/\/www.oracle.com\/database\/technologies\/oracle21c-linux-downloads.html#license-lightbox set corect hostname &#8211; add record in \/etc\/hosts &#8211; local ip to dns name. disable selinux -&gt; restart kernel parameters sysctl and apply . set limits in \/etc\/security\/limits.d\/oracle.conf Install and remove packages yum remove firewalld *firmware* Create groups; set pass useradd -u 54321 -g oinstall -G dba,oper oracle passwd oracle &#8230;<\/p>\n<p><a href=\"https:\/\/d1m0.com\/?p=675\" class=\"more-link\">Continue reading &lsquo;Oracle database &#8211; OL9.1&rsquo; &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,1],"tags":[15,14,13],"class_list":["post-675","post","type-post","status-publish","format-standard","hentry","category-linux","category-no-category","tag-database","tag-linux","tag-oracle"],"_links":{"self":[{"href":"https:\/\/d1m0.com\/index.php?rest_route=\/wp\/v2\/posts\/675","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/d1m0.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/d1m0.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/d1m0.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/d1m0.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=675"}],"version-history":[{"count":10,"href":"https:\/\/d1m0.com\/index.php?rest_route=\/wp\/v2\/posts\/675\/revisions"}],"predecessor-version":[{"id":687,"href":"https:\/\/d1m0.com\/index.php?rest_route=\/wp\/v2\/posts\/675\/revisions\/687"}],"wp:attachment":[{"href":"https:\/\/d1m0.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=675"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/d1m0.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=675"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/d1m0.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}