{"id":3140,"date":"2016-07-29T17:02:04","date_gmt":"2016-07-29T15:02:04","guid":{"rendered":"https:\/\/adrhc.go.ro\/wordpress\/?p=3140"},"modified":"2017-05-10T15:01:13","modified_gmt":"2017-05-10T13:01:13","slug":"centos-and-oracle","status":"publish","type":"post","link":"https:\/\/adrhc.go.ro\/blog\/centos-and-oracle\/","title":{"rendered":"CentOS and Oracle"},"content":{"rendered":"<pre class=\"brush:bash shell;toolbar: false\">\r\n# https:\/\/wiki.centos.org\/HowTos\/Oracle12onCentos7\r\n\r\n# rsync -cEhikLmrtz --progress --delete-after KIT\/Oracle\/linuxamd64_12102_database_se2_* root@172.16.148.136:\/root\/KIT\r\n# scp KIT\/Oracle\/linuxamd64_12102_database_se2_* root@172.16.148.137:\/root\/KIT\r\n\r\n# run as root ...\r\ngroupadd oinstall\r\ngroupadd dba\r\nuseradd -g oinstall -G dba oracle\r\npasswd oracle\r\n\r\n# For Intel N3150 CPU I changed the original \"kernel.shmmax = 1987162112\" like below.\r\necho \"# oracle kernel parameters\r\nfs.aio-max-nr = 1048576\r\nfs.file-max = 6815744\r\nkernel.shmall = 2097152\r\nkernel.shmmax = 4093800448\r\nkernel.shmmni = 4096\r\nkernel.sem = 250 32000 100 128\r\nnet.ipv4.ip_local_port_range = 9000 65500\r\nnet.core.rmem_default = 262144\r\nnet.core.rmem_max = 4194304\r\nnet.core.wmem_default = 262144\r\nnet.core.wmem_max = 1048586\" >> \/etc\/sysctl.conf\r\n\r\n# Check and apply the oracle kernel parameters:\r\n# -p Load in sysctl settings from the file specified or \/etc\/sysctl.conf if none given. \r\n#    Specifying - as filename means reading data from standard input.\r\n# -a Display all values currently available.\r\nsysctl -p\r\nsysctl -a\r\n\r\n# Specify limits for oracle user in the \/etc\/security\/limits.conf\r\necho \"# limits for oracle user\r\noracle soft nproc 2047\r\noracle hard nproc 16384\r\noracle soft nofile 1024\r\noracle hard nofile 65536\" >> \/etc\/security\/limits.conf\r\n\r\nyum install -y zip unzip\r\nunzip KIT\/linuxamd64_12102_database_se2_1of2.zip -d \/stage\/\r\nunzip KIT\/linuxamd64_12102_database_se2_2of2.zip -d \/stage\/\r\nchown -R oracle:oinstall \/stage\/\r\n\r\n# Create \/u01 directory for Oracle software and \/u02 for database files.\r\nmkdir \/u01\r\nmkdir \/u02\r\nchown -R oracle:oinstall \/u01\r\nchown -R oracle:oinstall \/u02\r\nchmod -R 775 \/u01\r\nchmod -R 775 \/u02\r\nchmod g+s \/u01\r\nchmod g+s \/u02\r\n\r\n# Check required packages are installed:\r\nyum list binutils.x86_64 compat-libcap1.x86_64 gcc.x86_64 gcc-c++.x86_64 glibc.i686 glibc.x86_64 glibc-devel.i686 glibc-devel.x86_64 ksh compat-libstdc++-33 libaio.i686 libaio.x86_64 libaio-devel.i686 libaio-devel.x86_64 libgcc.i686 libgcc.x86_64 libstdc++.i686 libstdc++.x86_64 libstdc++-devel.i686 libstdc++-devel.x86_64 libXi.i686 libXi.x86_64 libXtst.i686 libXtst.x86_64 make.x86_64 sysstat.x86_64\r\n\r\n# Install missing required packages:\r\nyum install -y binutils.x86_64 compat-libcap1.x86_64 gcc.x86_64 gcc-c++.x86_64 glibc.i686 glibc.x86_64 glibc-devel.i686 glibc-devel.x86_64 ksh compat-libstdc++-33 libaio.i686 libaio.x86_64 libaio-devel.i686 libaio-devel.x86_64 libgcc.i686 libgcc.x86_64 libstdc++.i686 libstdc++.x86_64 libstdc++-devel.i686 libstdc++-devel.x86_64 libXi.i686 libXi.x86_64 libXtst.i686 libXtst.x86_64 make.x86_64 sysstat.x86_64\r\n\r\n# Also install the \"X Window System\" package group (already included with GNOME, KDE, MATE, XFCE, Cinnamon).\r\nyum groupinstall -y \"X Window System\"\r\n\r\n# the only one working (after second boot) with CentOS on VMWare 12.1.0 on ASRock with Intel N3150\r\n# login with oracle user created above\r\nsudo yum -y groups install \"MATE Desktop\"\r\necho \"exec \/usr\/bin\/mate-session\" > ~\/.xinitrc\r\nstartx\r\n# open a command prompt with oracle user and run:\r\n\/stage\/database\/runInstaller\r\n\r\n...\r\n# see Oracle Installer Screens at https:\/\/wiki.centos.org\/HowTos\/Oracle12onCentos7#head-539cfe4ae2bd6f126de557cbfc5d7d7a99826c04\r\n...\r\n\r\n# Firewall (run as root)\r\nfirewall-cmd --get-active-zones\r\nfirewall-cmd --zone=public --add-port=1521\/tcp --add-port=5500\/tcp --add-port=5520\/tcp --add-port=3938\/tcp --permanent\r\nfirewall-cmd --reload\r\nfirewall-cmd --list-ports\r\n\r\n# Oracle Environment\r\n# Login as oracle user and add the following values to the \/home\/oracle\/.bash_profile\r\nTMPDIR=$TMP; export TMPDIR\r\nORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE\r\nORACLE_HOME=$ORACLE_BASE\/product\/12.1.0\/dbhome_1; export ORACLE_HOME\r\nORACLE_SID=orcl; export ORACLE_SID\r\nPATH=$ORACLE_HOME\/bin:$PATH; export PATH\r\nLD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib:\/usr\/lib64; export LD_LIBRARY_PATH\r\nCLASSPATH=$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATH\r\n# Reload the bash_profile to apply the new settings:\r\n. .bash_profile\r\n\r\n# Login to the database\r\nsqlplus system@orcl\r\n\r\n# Manage database with Oracle Enterprise Manager:\r\nhttps:\/\/&lt;hostname>:5500\/em\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p># https:\/\/wiki.centos.org\/HowTos\/Oracle12onCentos7 # rsync -cEhikLmrtz &#8211;progress &#8211;delete-after KIT\/Oracle\/linuxamd64_12102_database_se2_* root@172.16.148.136:\/root\/KIT # scp KIT\/Oracle\/linuxamd64_12102_database_se2_* root@172.16.148.137:\/root\/KIT # run as root &#8230; groupadd oinstall groupadd dba useradd -g oinstall -G dba oracle passwd oracle # For Intel N3150 CPU I changed the original &#8220;kernel.shmmax [&hellip;]<\/p>\n<div class=\"link-more\"><a href=\"https:\/\/adrhc.go.ro\/blog\/centos-and-oracle\/#more-3140\" class=\"more-link\">Continue reading &#10142; <span class=\"screen-reader-text\">CentOS and Oracle<\/span><\/a><\/div>","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38,6,8,11,37],"tags":[],"class_list":["post-3140","post","type-post","status-publish","format-standard","hentry","category-centos","category-configuration","category-howto","category-linux","category-redhat"],"_links":{"self":[{"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/posts\/3140","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/comments?post=3140"}],"version-history":[{"count":0,"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/posts\/3140\/revisions"}],"wp:attachment":[{"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/media?parent=3140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/categories?post=3140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adrhc.go.ro\/blog\/wp-json\/wp\/v2\/tags?post=3140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}