{"id":1557,"date":"2018-02-14T22:40:04","date_gmt":"2018-02-15T01:40:04","guid":{"rendered":"https:\/\/zmsolution.laraclaud.com.br\/?p=1557"},"modified":"2018-02-14T22:40:04","modified_gmt":"2018-02-15T01:40:04","slug":"oracle-12c-grid-infrastructure-for-standalone-server-on-oracle-linux-7","status":"publish","type":"post","link":"http:\/\/zmsolution.com\/oracle-12c-grid-infrastructure-for-standalone-server-on-oracle-linux-7\/","title":{"rendered":"Oracle 12c Grid Infrastructure for a Standalone Server on Oracle Linux 7"},"content":{"rendered":"

Nesse artigos ,vou\u00a0 mostra passo a passo como instalar o Oracle Grid infrastrutura 12.2 for a Standalone Server .<\/strong><\/p>\n

Instalando pacotes<\/u><\/strong><\/p>\n

yum install binutils -y\r\nyum install compat-libcap1 -y\r\nyum install compat-libstdc++-33 -y\r\nyum install compat-libstdc++-33.i686 -y\r\nyum install glibc -y\r\nyum install glibc.i686 -y\r\nyum install glibc-devel -y\r\nyum install glibc-devel.i686 -y\r\nyum install ksh -y\r\nyum install libaio -y\r\nyum install libaio.i686 -y\r\nyum install libaio-devel -y\r\nyum install libaio-devel.i686 -y\r\nyum install libX11 -y\r\nyum install libX11.i686 -y\r\nyum install libXau -y\r\nyum install libXau.i686 -y\r\nyum install libXi -y\r\nyum install libXi.i686 -y\r\nyum install libXtst -y\r\nyum install libXtst.i686 -y\r\nyum install libgcc -y\r\nyum install libgcc.i686 -y\r\nyum install libstdc++ -y\r\nyum install libstdc++.i686 -y\r\nyum install libstdc++-devel -y\r\nyum install libstdc++-devel.i686 -y\r\nyum install libxcb -y\r\nyum install libxcb.i686 -y\r\nyum install make -y\r\nyum install nfs-utils -y\r\nyum install net-tools -y\r\nyum install smartmontools -y\r\nyum install sysstat -y\r\nyum install unixODBC -y\r\nyum install unixODBC-devel \u2013y\r\nyum install binutils -y\r\nyum install compat-libstdc++-33 -y\r\nyum install compat-libstdc++-33.i686 -y\r\nyum install gcc -y\r\nyum install gcc-c++ -y\r\nyum install glibc -y\r\nyum install glibc.i686 -y\r\nyum install glibc-devel -y\r\nyum install glibc-devel.i686 -y\r\nyum install ksh -y\r\nyum install libgcc -y\r\nyum install libgcc.i686 -y\r\nyum install libstdc++ -y\r\nyum install libstdc++.i686 -y\r\nyum install libstdc++-devel -y\r\nyum install libstdc++-devel.i686 -y\r\nyum install libaio -y\r\nyum install libaio.i686 -y\r\nyum install libaio-devel -y\r\nyum install libaio-devel.i686 -y\r\nyum install libXext -y\r\nyum install libXext.i686 -y\r\nyum install libXtst -y\r\nyum install libXtst.i686 -y\r\nyum install libX11 -y\r\nyum install libX11.i686 -y\r\nyum install libXau -y\r\nyum install libXau.i686 -y\r\nyum install libxcb -y\r\nyum install libxcb.i686 -y\r\nyum install libXi -y\r\nyum install libXi.i686 -y\r\nyum install make -y\r\nyum install sysstat -y\r\nyum install unixODBC -y\r\nyum install unixODBC-devel -y\r\nyum install zlib-devel -y\r\nyum install zlib-devel.i686 \u2013y\r\nyum install\u00a0 tigervnc-server\r\n\r\n<\/pre>\n
Altere o arquivo \/etc\/sysctl.conf<\/strong><\/p>\n
vi \/etc\/sysctl.conf<\/p>\n
fs.file-max = 6815744\r\nkernel.sem = 250 32000 100 128\r\nkernel.shmmni = 4096\r\nkernel.shmall = 5242880\r\nkernel.shmmax = 10737418240\r\nkernel.panic_on_oops = 1\r\nnet.core.rmem_default = 262144\r\nnet.core.rmem_max = 4194304\r\nnet.core.wmem_default = 262144\r\nnet.core.wmem_max = 1048576\r\nnet.ipv4.conf.all.rp_filter = 2\r\nnet.ipv4.conf.default.rp_filter = 2\r\nfs.aio-max-nr = 1048576\r\nnet.ipv4.ip_local_port_range = 9000 65500<\/pre>\n
Altere o arquivo\u00a0limits.conf<\/strong><\/p>\n
vi \u00a0\/etc\/security\/limits.conf\r\n\r\n# Oracle configuration - zmsolution\r\n\r\n@oinstall\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 soft\u00a0\u00a0 nproc\u00a0\u00a0\u00a0\u00a0\u00a0 16384\r\n@oinstall\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hard\u00a0\u00a0 nproc\u00a0\u00a0\u00a0\u00a0\u00a0 16384\r\n@oinstall\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 soft\u00a0\u00a0 nofile\u00a0\u00a0\u00a0\u00a0 8192\r\n@oinstall\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hard\u00a0\u00a0 nofile\u00a0\u00a0\u00a0\u00a0 65536\r\n@oinstall\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 soft\u00a0\u00a0 stack\u00a0 \u00a0\u00a0\u00a0\u00a010240\r\n@oinstall\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hard\u00a0\u00a0 stack\u00a0\u00a0\u00a0\u00a0\u00a0 32768\r\n@oinstall\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hard\u00a0\u00a0 memlock\u00a0\u00a0\u00a0 134217728\r\n@oinstall\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 soft\u00a0\u00a0 memlock\u00a0\u00a0\u00a0 134217728\r\n\r\n@root\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 soft nproc\u00a0 4096\r\n@root\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hard nproc\u00a0 16384\r\n@root\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 soft nofile 8192\r\n@root\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0hard nofile 65536<\/pre>\n
Criei os novos usu\u00e1rios e grupos<\/strong><\/p>\n
groupadd -g 1300 dba\r\ngroupadd -g 1301 oper\r\ngroupadd -g 1000 oinstall\r\ngroupadd -g 1200 asmadmin\r\ngroupadd -g 1201 asmdba\r\ngroupadd -g 1202 asmoper\r\n\r\nuseradd -u 1100 -g oinstall -G dba,oper,asmadmin,asmdba,asmoper\u00a0 grid\r\nuseradd -u 1101 -g oinstall -G dba,oper,asmadmin,asmdba,asmoper\u00a0 oracle<\/pre>\n
Altere as senhas<\/strong><\/p>\n
passwd grid\r\npasswd oracle<\/pre>\n
Edite o arquivo<\/strong> \u00a0\/etc\/hosts<\/p>\n
vi\u00a0 \/etc\/hosts\r\n\r\n127.0.0.1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0localhost.localdomain\u00a0\u00a0 localhost\r\n192.168.56.101 zmsol1.localdomain zmsol1<\/pre>\n
Desabiltando o SELINUX<\/strong><\/p>\n
Altere o arquivo \/etc\/selinux\/config\r\n\r\nvi \/etc\/selinux\/config\r\nSELINUX=permissive<\/pre>\n
Desabilite o firewall<\/strong><\/p>\n
systemctl stop firewalld\r\nsystemctl disable firewalld\r\n\r\n<\/pre>\n
Make sure NTP (Chrony on OL7\/RHEL7) is enabled.<\/strong><\/p>\n
systemctl enable chronyd.service\r\nsystemctl start chronyd.service<\/pre>\n
Crie os Direct\u00f3rios<\/p>\n
mkdir -p \/u01\/app\/oraInventory\r\nchown -R grid:oinstall \/u01\/app\/oraInventory\r\nchmod -R 775 \/u01\/app\/oraInventory\r\nchmod -R 775 \/u01\/\r\nmkdir -p \/u01\/app\/oracle\/product\/12.2.0.1\/grid\r\nmkdir -p \/u01\/app\/oracle\/product\/12.2.0.1\/db_1\r\nmkdir -p \/u01\/app\/oracle\/product\/11.2.0.4\/db_1\r\nchown -R grid:oinstall \/u01\r\nchmod -R 775 \/u01\/<\/pre>\n
Instalando o ASM<\/strong><\/p>\n
[root@zmsol1 Packages]# rpm -Uvh .\/oracleasm-support-2.1.8-3.1.el7.x86_64.rpm\r\nPreparing...\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ################################# [100%]\r\nUpdating \/ installing...\r\n\u00a0\u00a0 1:oracleasm-support-2.1.8-3.1.el7\u00a0 #################################[100%]<\/pre>\n
Note: Forwarding request to ‘systemctl enable oracleasm.service’.<\/p>\n
Created symlink from \/etc\/systemd\/system\/multi-user.target.wants\/oracleasm.service to \/usr\/lib\/systemd\/system\/oracleasm.service.<\/p>\n
[root@zmsol1 Packages]#\r\n[root@zmsol1 install]# rpm -Uvh oracleasmlib-2.0.12-1.el7.x86_64.rpm\r\nPreparing...\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ################################# [100%]\r\nUpdating \/ installing...\r\n\u00a01:oracleasmlib-2.0.12-1.el7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ################################# [100%][root@zmsol1 install]#\r\n\r\n<\/pre>\n
Configurando o ASM\u00a0<\/strong><\/p>\n
[root@zmsol1 install]# \/etc\/init.d\/oracleasm configure\r\nConfiguring the Oracle ASM library driver.\r\nThis will configure the on-boot properties of the Oracle ASM library\r\ndriver.\u00a0 The following questions will determine whether the driver is\r\nloaded on boot and what permissions it will have.\u00a0 The current values\r\nwill be shown in brackets ('[]').\u00a0 Hitting <ENTER> without typing an\r\nanswer will keep that current value.\u00a0 Ctrl-C will abort.\r\nDefault user to own the driver interface []: grid\r\nDefault group to own the driver interface []: asmadmin\r\nStart Oracle ASM library driver on boot (y\/n) [n]: y\r\nScan for Oracle ASM disks on boot (y\/n) [y]: y\r\nWriting Oracle ASM library driver configuration: done\r\nInitializing the Oracle ASMLib driver:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [\u00a0 OK\u00a0 ]\r\nScanning the system for Oracle ASMLib disks:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [\u00a0 OK\u00a0 ]<\/pre>\n
Formatando o disco para o ASM<\/strong><\/p>\n
[root@zmsol1 install]#\r\n[root@zmsol1 install]# fdisk \/dev\/sdb\r\nWelcome to fdisk (util-linux 2.23.2).\r\n\r\nChanges will remain in memory only, until you decide to write them.\r\nBe careful before using the write command.\r\nDevice does not contain a recognized partition table\r\nBuilding a new DOS disklabel with disk identifier 0x031293c4.\r\n\r\nCommand (m for help): n\r\nPartition type:\r\n\u00a0\u00a0 p\u00a0\u00a0 primary (0 primary, 0 extended, 4 free)\r\n\u00a0\u00a0 e\u00a0\u00a0 extended\r\nSelect (default p): p\r\nPartition number (1-4, default 1): 1\r\nFirst sector (2048-65064319, default 2048):\r\nUsing default value 2048\r\nLast sector, +sectors or +size{K,M,G} (2048-65064319, default 65064319):\r\nUsing default value 65064319\r\nPartition 1 of type Linux and of size 31 GiB is set\r\n\r\nCommand (m for help): w\r\nThe partition table has been altered!\r\nCalling ioctl() to re-read partition table.\r\nSyncing disks.<\/pre>\n
Criando o asm disk<\/strong><\/p>\n
[root@zmsol1 install]#\r\n\/etc\/init.d\/oracleasm createdisk DG1_DISK1_30GB\u00a0 \u00a0\/dev\/sdb1\r\n[root@zmsol1 install]# \/etc\/init.d\/oracleasm createdisk DG1_DISK1_30GB\u00a0\u00a0 \/dev\/sdb1\r\nMarking disk \"DG1_DISK1_30GB\" as an ASM disk:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [\u00a0 OK\u00a0 ]\r\n[root@zmsol1 install]# \/etc\/init.d\/oracleasm scandisks\r\nScanning the system for Oracle ASMLib disks:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 [\u00a0 OK\u00a0 ]\r\n[root@zmsol1 install]# \/etc\/init.d\/oracleasm listdisks\r\nDG1_DISK1_30GB<\/pre>\n
[root@zmsol1 install]#<\/p>\n
\"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\" \"\"<\/p>\n
[root@zmsol1 rpm]# \/u01\/app\/oraInventory\/orainstRoot.sh\r\nChanging permissions of \/u01\/app\/oraInventory.\r\nAdding read,write permissions for group.\r\nRemoving read,write,execute permissions for world.\r\nChanging groupname of \/u01\/app\/oraInventory to oinstall.\r\nThe execution of the script is complete.\r\n[root@zmsol1 rpm]# \/u01\/app\/oracle\/product\/12.2.0.1\/grid\/root.sh\r\nPerforming root user operation.\r\n\r\nThe following environment variables are set as:\r\n\u00a0\u00a0\u00a0 ORACLE_OWNER= grid\r\n\u00a0\u00a0\u00a0 ORACLE_HOME=\u00a0 \/u01\/app\/oracle\/product\/12.2.0.1\/grid\r\nEnter the full pathname of the local bin directory: [\/usr\/local\/bin]:\r\n\u00a0\u00a0 Copying dbhome to \/usr\/local\/bin ...\r\n\u00a0\u00a0 Copying oraenv to \/usr\/local\/bin ...\r\n\u00a0\u00a0 Copying coraenv to \/usr\/local\/bin ...\r\nCreating \/etc\/oratab file...\r\nEntries will be added to the \/etc\/oratab file as needed by\r\nDatabase Configuration Assistant when a database is created\r\nFinished running generic part of root script.\r\nNow product-specific root actions will be performed.\r\nUsing configuration parameter file: \/u01\/app\/oracle\/product\/12.2.0.1\/grid\/crs\/install\/crsconfig_params\r\nThe log of current session can be found at:\r\n\u00a0 \/u01\/app\/oracle\/crsdata\/zmsol1\/crsconfig\/roothas_2017-09-20_10-28-10PM.log\r\n2017\/09\/20 22:28:12 CLSRSC-363: User ignored prerequisites during installation\r\nLOCAL ADD MODE\r\nCreating OCR keys for user 'grid', privgrp 'oinstall'..\r\nOperation successful.\r\nLOCAL ONLY MODE\r\nSuccessfully accumulated necessary OCR keys.\r\nCreating OCR keys for user 'root', privgrp 'root'..\r\nOperation successful.\r\nCRS-4664: Node zmsol1 successfully pinned.\r\n2017\/09\/20 22:28:21 CLSRSC-330: Adding Clusterware entries to file 'oracle\r\nohasd.service'\r\nCRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on\r\n'zmsol1'\r\nCRS-2673: Attempting to stop 'ora.evmd' on 'zmsol1'\r\nCRS-2677: Stop of 'ora.evmd' on 'zmsol1' succeeded\r\nCRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'zmsol1'\r\nhas completed\r\nCRS-4133: Oracle High Availability Services has been stopped.\r\nCRS-4123: Oracle High Availability Services has been started.\r\nzmsol1\u00a0\u00a0\u00a0\u00a0 2017\/09\/20 22:29:31\u00a0\u00a0\u00a0\u00a0 \/u01\/app\/oracle\/product\/12.2.0.1\/grid\/cdata\/zmsol1\/backup_20170920_222931.olr\u00a0\u00a0\u00a0\u00a0 0\r\n2017\/09\/20 22:29:32 CLSRSC-327: Successfully configured Oracle Restart for a standalone server<\/pre>\n
\"\"<\/p>\n
no pr\u00f3ximo artigo instalaremos o rdbms.<\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
Nesse artigos ,vou\u00a0 mostra passo a passo como instalar o Oracle Grid infrastrutura 12.2 for a Standalone Server . Instalando pacotes yum install binutils -y yum install compat-libcap1 -y yum install compat-libstdc++-33 -y yum install compat-libstdc++-33.i686 -y yum install glibc -y yum install glibc.i686 -y yum install glibc-devel -y yum install glibc-devel.i686 -y yum install ksh -y yum install libaio -y yum install libaio.i686 -y yum install libaio-devel -y yum install libaio-devel.i686 -y yum install[…]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[21],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts\/1557"}],"collection":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/comments?post=1557"}],"version-history":[{"count":0,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts\/1557\/revisions"}],"wp:attachment":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/media?parent=1557"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/categories?post=1557"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/tags?post=1557"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}