{"id":6587,"date":"2017-03-29T19:42:07","date_gmt":"2017-03-29T11:42:07","guid":{"rendered":"http:\/\/rmohan.com\/?p=6587"},"modified":"2017-03-29T19:42:07","modified_gmt":"2017-03-29T11:42:07","slug":"oracle-asm-12c-on-linux","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=6587","title":{"rendered":"Oracle ASM 12c on Linux"},"content":{"rendered":"<p>How to setup Oracle ASM 12c on Linux<br \/>\nSoftware used:-<br \/>\n1.VMWARE 10<br \/>\n2.Redhat enterprise linux 6.5(64 bit)<br \/>\n3.Oracle database 12C (64 bit)<br \/>\n4.Oracle Grid infrastructure 12c(64 bit)<\/p>\n<p>What to Setup:-<\/p>\n<p>1. Setup oracle grid infrastructure for standalone server &#8220;ASM&#8221;<br \/>\n2. Setup oracle Database<\/p>\n<p>Update \/etc\/sysctl.conf<br \/>\n[root@server1]# vi \/etc\/sysctl.conf<br \/>\nScroll to the bottom and add the following:<\/p>\n<p>fs.file-max = 6815744<br \/>\nkernel.sem = 250 32000 100 128<br \/>\nkernel.shmmni = 4096<br \/>\nkernel.shmall = 1073741824<br \/>\nkernel.shmmax = 4398046511104<br \/>\nnet.core.rmem_default = 262144<br \/>\nnet.core.rmem_max = 4194304<br \/>\nnet.core.wmem_default = 262144<br \/>\nnet.core.wmem_max = 1048576<br \/>\nfs.aio-max-nr = 1048576<br \/>\nnet.ipv4.ip_local_port_range = 9000 65500<br \/>\n:wq<\/p>\n<p>Run the following command to change the current kernel parameters.<br \/>\n\/sbin\/sysctl -p<\/p>\n<p>Update \/etc\/security\/limits.conf<br \/>\n[root@server1]# vi \/etc\/security\/limits.conf<br \/>\nScroll to the bottom and above the \u201c# End of file\u201d line, add:<\/p>\n<p>oracle\u00a0\u00a0 soft\u00a0\u00a0 nofile\u00a0\u00a0\u00a0 1024<br \/>\noracle\u00a0\u00a0 hard\u00a0\u00a0 nofile\u00a0\u00a0\u00a0 65536<br \/>\noracle\u00a0\u00a0 soft\u00a0\u00a0 nproc\u00a0\u00a0\u00a0 16384<br \/>\noracle\u00a0\u00a0 hard\u00a0\u00a0 nproc\u00a0\u00a0\u00a0 16384<br \/>\noracle\u00a0\u00a0 soft\u00a0\u00a0 stack\u00a0\u00a0\u00a0 10240<br \/>\noracle\u00a0\u00a0 hard\u00a0\u00a0 stack\u00a0\u00a0\u00a0 32768<\/p>\n<p>:wq<\/p>\n<p>Amend the &#8220;\/etc\/security\/limits.d\/90-nproc.conf&#8221; file as described below.<br \/>\n# Change this<br \/>\n*\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 soft\u00a0\u00a0\u00a0 nproc\u00a0\u00a0\u00a0 1024<\/p>\n<p># To this<br \/>\n* &#8211; soft\u00a0\u00a0\u00a0 nproc\u00a0\u00a0\u00a0 16384<\/p>\n<p>**IMPORTANT: Make sure selinux is disabled.<\/p>\n<p>Packages required for oracle database installation:-<\/p>\n<p>[root@server1] yum -y install binutils-2.17.50.0.6<br \/>\n[root@server1] yum -y install compat-libstdc++-33-3.2.3 (*)<br \/>\n[root@server1] yum -y install elfutils-libelf-0.125<br \/>\n[root@server1] yum -y install elfutils-libelf-devel-0.125 (*)<br \/>\n[root@server1] yum -y install gcc-4.1.2<br \/>\n[root@server1] yum -y install gcc-c++-4.1.2 (*)<br \/>\n[root@server1] yum -y install glibc-2.5-24<br \/>\n[root@server1] yum -y install glibc-common-2.5<br \/>\n[root@server1] yum -y install glibc-devel-2.5<br \/>\n[root@server1] yum -y install glibc-headers-2.5<br \/>\n[root@server1] yum -y install ksh-20060214 (*)<br \/>\n[root@server1] yum -y install libaio-0.3.106<br \/>\n[root@server1] yum -y install libaio-devel-0.3.106<br \/>\n[root@server1] yum -y install libgcc-4.1.2<br \/>\n[root@server1] yum -y install libgomp-4.1.2<br \/>\n[root@server1] yum -y install libstdc++-4.1.2<br \/>\n[root@server1] yum -y install libstdc++-devel-4.1.2<br \/>\n[root@server1] yum -y install make-3.81<br \/>\n[root@server1] yum -y install numactl-devel-0.9.8.i386 (*)<br \/>\n[root@server1] yum -y install sysstat-7.0.2 (*)<\/p>\n<p>Check the kernel version:-<br \/>\n[root@server1 var]# uname -r<br \/>\n2.6.32-358.el6.x86_64<\/p>\n<p>Now we would require to install the rpm&#8217;s required for asm installation<br \/>\nthese are the packages required for asm.<\/p>\n<p>&#8211;oracleasm<br \/>\n&#8211;oracleasm-support<br \/>\n&#8211;oracleasmlib<br \/>\nthe last 2 packages can be found from the following link<br \/>\nhttp:\/\/www.oracle.com\/technetwork\/server-storage\/linux\/asmlib\/rhel6-1940776.html<\/p>\n<p>oracle kmod-oracleasm rpm download link for el6<br \/>\nhttp:\/\/public-yum.oracle.com\/repo\/OracleLinux\/OL6\/latest\/x86_64\/getPackage\/kmod-oracleasm-2.0.6.rh1-2.el6.x86_64.rpm<\/p>\n<p>[root@server3 ~]# rpm -Uvh oracleasm-support-2.1.8-1.el6.x86_64.rpm<br \/>\n[root@server3 ~]# rpm -Uvh kmod-oracleasm-2.0.6.rh1-2.el6.x86_64.rpm<br \/>\n[root@server3 ~]# rpm -Uvh oracleasmlib-2.0.4-1.el6.x86_64.rpm<\/p>\n<p>Create groups:-<br \/>\n[root@server3 tmp]# groupadd -g 1000 oinstall<br \/>\n[root@server3 tmp]# groupadd -g 1200 dba<br \/>\n[root@server3 tmp]# useradd -g oinstall -G dba -d \/home\/oracle oracle<\/p>\n<p>Create directory structures:-<br \/>\n[root@server3 u01]# mkdir -p \/u01\/app\/oracle\/product\/12.1.0\/grid<br \/>\n[root@server3 u01]# mkdir -p \/u01\/app\/oracle\/product\/12.1.0\/db_1<\/p>\n<p>Assigning proper permission:-<br \/>\n[root@server3 u01]# chown -Rf oracle:oinstall \/u01\/<br \/>\n[root@server3 u01]# chmod -Rf 775 \/u01\/<\/p>\n<p>Set up the oracle user environment<br \/>\nFor oracle user:-<br \/>\n[root@server1 var]# su &#8211; oracle<\/p>\n<p>[oracle@server1]#vi .bash_profile<br \/>\n#export PATH<br \/>\n# Oracle Settings<br \/>\nTMP=\/tmp; export TMP<br \/>\nTMPDIR=$TMP; export TMPDIR<br \/>\nORACLE_HOSTNAME=server3.soumya.com; export ORACLE_HOSTNAME<br \/>\nORACLE_UNQNAME=orcl; export ORACLE_UNQNAME<br \/>\nORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE<br \/>\nGRID_HOME=\/u01\/app\/oracle\/product\/12.1.0\/grid; export GRID_HOME<br \/>\nDB_HOME=$ORACLE_BASE\/product\/12.1.0\/db_1; export DB_HOME<br \/>\nORACLE_HOME=$DB_HOME; export ORACLE_HOME<br \/>\nORACLE_SID=orcl; export ORACLE_SID<br \/>\nORACLE_TERM=xterm; export ORACLE_TERM<br \/>\nBASE_PATH=\/usr\/sbin:$PATH; export BASE_PATH<br \/>\nPATH=$ORACLE_HOME\/bin:$BASE_PATH; export PATH<br \/>\nLD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib;<br \/>\nLD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH<br \/>\nCLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATHH<br \/>\nif [ $USER = &#8220;oracle&#8221; ]; then<br \/>\nif [ $SHELL = &#8220;\/bin\/ksh&#8221; ]; then<br \/>\nulimit -p 16384<br \/>\nulimit -n 65536<br \/>\nelse<br \/>\nulimit -u 16384 -n 65536<br \/>\nfi<br \/>\nfi<\/p>\n<p>alias grid_env=&#8217;. \/home\/oracle\/grid_env&#8217;<br \/>\nalias db_env=&#8217;. \/home\/oracle\/db_env&#8217;<\/p>\n<p>:wq(save &amp; exit)<\/p>\n<p>[oracle@server1 ~]$ . .bash_profile<\/p>\n<p>Create a file called &#8220;\/home\/oracle\/db_env&#8221; with the following contents :-<\/p>\n<p>[oracle@server1 ~]$vi \/home\/oracle\/db_env<\/p>\n<p>ORACLE_SID=orcl; export ORACLE_SID<br \/>\nORACLE_HOME=$DB_HOME; export ORACLE_HOME<br \/>\nPATH=$ORACLE_HOME\/bin:$BASE_PATH; export PATH<br \/>\nLD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH<br \/>\nCLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATH<\/p>\n<p>:wq(save &amp; exit)<\/p>\n<p>Create a file called &#8220;\/home\/oracle\/grid_env&#8221; with the following contents:-<\/p>\n<p>[oracle@server1 ~]$vi \/home\/oracle\/gid_env<br \/>\nORACLE_SID=+ASM; export ORACLE_SID<br \/>\nORACLE_HOME=$GRID_HOME; export ORACLE_HOME<br \/>\nPATH=$ORACLE_HOME\/bin:$BASE_PATH; export PATH<br \/>\nLD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH<br \/>\nCLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATH<\/p>\n<p>:wq(save &amp; exit)<\/p>\n<p>[oracle@server1 ~]$ chmod 775 \/home\/oracle\/db_env<br \/>\n[oracle@server1 ~]$ chmod 775 \/home\/oracle\/grid_env<\/p>\n<p>Now you will be able to switch environments between oracle and asm instance as follows.<br \/>\n[oracle@server3 ~]$ db_env<br \/>\n[oracle@server3 ~]$ echo $ORACLE_SID<br \/>\norcl<br \/>\n[oracle@server3 ~]$ echo $ORACLE_HOME<br \/>\n\/u01\/app\/oracle\/product\/12.1.0\/db_1<br \/>\n[oracle@server3 ~]$ grid_env<br \/>\n[oracle@server3 ~]$ echo $ORACLE_HOME<br \/>\n\/u01\/app\/oracle\/product\/12.1.0\/grid<br \/>\n[oracle@server3 ~]$ echo $ORACLE_SID<br \/>\n+ASM<\/p>\n<p>Now\u00a0 we will add 3 disks using vmware.<br \/>\nSo open vmware workstation and go to settings and add hard disk from there,add 3 different disks size of atleast 10GB each.<\/p>\n<p>[root@server1]# echo &#8220;- &#8211; -&#8220;&gt; \/sys\/class\/scsi_host\/host0\/scan<\/p>\n<p>******<br \/>\nP.S. if the above command doesnt show the newly added disk try this<br \/>\n[root@server1]#grep mpt \/sys\/class\/scsi_host\/host?\/proc_name<br \/>\n\/sys\/class\/scsi_host\/host2\/proc_name:mptspi<\/p>\n<p>then run this<br \/>\n[root@server1]# echo &#8220;- &#8211; -&#8220;&gt; \/sys\/class\/scsi_host\/host2\/scan<br \/>\n******<\/p>\n<p>using the above command we can avoid rebooting the machine to\u00a0 mount the hard disks.<\/p>\n<p>[root@server1 ~]# fdisk \/dev\/sdb<br \/>\nDevice contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel<br \/>\nBuilding a new DOS disklabel with disk identifier 0xa4bd7fb9.<br \/>\nChanges will remain in memory only, until you decide to write them.<br \/>\nAfter that, of course, the previous content won&#8217;t be recoverable.<\/p>\n<p>Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)<\/p>\n<p>WARNING: DOS-compatible mode is deprecated. It&#8217;s strongly recommended to<br \/>\nswitch off the mode (command &#8216;c&#8217;) and change display units to<br \/>\nsectors (command &#8216;u&#8217;).<\/p>\n<p>Command (m for help): n<br \/>\nCommand action<br \/>\ne\u00a0\u00a0 extended<br \/>\np\u00a0\u00a0 primary partition (1-4)<br \/>\np<br \/>\nPartition number (1-4): 1<br \/>\nFirst cylinder (1-261, default 1):<br \/>\nUsing default value 1<br \/>\nLast cylinder, +cylinders or +size{K,M,G} (1-261, default 261):<br \/>\nUsing default value 261<\/p>\n<p>Command (m for help): w<br \/>\nThe partition table has been altered!<\/p>\n<p>Calling ioctl() to re-read partition table.<br \/>\nSyncing disks.<\/p>\n<p>[root@server1 ~]# fdisk \/dev\/sdc<br \/>\n[root@server1 ~]# fdisk \/dev\/sdd<\/p>\n<p>[root@server1 dev]# fdisk -l<br \/>\nDisk \/dev\/sda: 64.4 GB, 64424509440 bytes<br \/>\n255 heads, 63 sectors\/track, 7832 cylinders<br \/>\nUnits = cylinders of 16065 * 512 = 8225280 bytes<br \/>\nSector size (logical\/physical): 512 bytes \/ 512 bytes<br \/>\nI\/O size (minimum\/optimal): 512 bytes \/ 512 bytes<br \/>\nDisk identifier: 0x0006f980<\/p>\n<p>Device Boot\u00a0\u00a0\u00a0\u00a0\u00a0 Start\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 End\u00a0\u00a0\u00a0\u00a0\u00a0 Blocks\u00a0\u00a0 Id\u00a0 System<br \/>\n\/dev\/sda1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5737\u00a0\u00a0\u00a0 46080000\u00a0\u00a0 83\u00a0 Linux<br \/>\n\/dev\/sda2\u00a0\u00a0 *\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5737\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6885\u00a0\u00a0\u00a0\u00a0 9216000\u00a0\u00a0 83\u00a0 Linux<br \/>\n\/dev\/sda3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6885\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7458\u00a0\u00a0\u00a0\u00a0 4608000\u00a0\u00a0 83\u00a0 Linux<br \/>\n\/dev\/sda4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7458\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7833\u00a0\u00a0\u00a0\u00a0 3009536\u00a0\u00a0\u00a0 5\u00a0 Extended<br \/>\n\/dev\/sda5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7459\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7731\u00a0\u00a0\u00a0\u00a0 2188288\u00a0\u00a0 82\u00a0 Linux swap \/ Solaris<br \/>\n\/dev\/sda6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7731\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7833\u00a0\u00a0\u00a0\u00a0\u00a0 818176\u00a0\u00a0 83\u00a0 Linux<\/p>\n<p>Disk \/dev\/sdb: 2147 MB, 2147483648 bytes<br \/>\n255 heads, 63 sectors\/track, 261 cylinders<br \/>\nUnits = cylinders of 16065 * 512 = 8225280 bytes<br \/>\nSector size (logical\/physical): 512 bytes \/ 512 bytes<br \/>\nI\/O size (minimum\/optimal): 512 bytes \/ 512 bytes<br \/>\nDisk identifier: 0x44ac96a0<\/p>\n<p>Device Boot\u00a0\u00a0\u00a0\u00a0\u00a0 Start\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 End\u00a0\u00a0\u00a0\u00a0\u00a0 Blocks\u00a0\u00a0 Id\u00a0 System<br \/>\n\/dev\/sdb1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 261\u00a0\u00a0\u00a0\u00a0 2096451\u00a0\u00a0 83\u00a0 Linux<\/p>\n<p>Disk \/dev\/sdc: 2147 MB, 2147483648 bytes<br \/>\n255 heads, 63 sectors\/track, 261 cylinders<br \/>\nUnits = cylinders of 16065 * 512 = 8225280 bytes<br \/>\nSector size (logical\/physical): 512 bytes \/ 512 bytes<br \/>\nI\/O size (minimum\/optimal): 512 bytes \/ 512 bytes<br \/>\nDisk identifier: 0x004b1011<\/p>\n<p>Device Boot\u00a0\u00a0\u00a0\u00a0\u00a0 Start\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 End\u00a0\u00a0\u00a0\u00a0\u00a0 Blocks\u00a0\u00a0 Id\u00a0 System<br \/>\n\/dev\/sdc1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 261\u00a0\u00a0\u00a0\u00a0 2096451\u00a0\u00a0 83\u00a0 Linux<\/p>\n<p>Disk \/dev\/sdd: 2147 MB, 2147483648 bytes<br \/>\n255 heads, 63 sectors\/track, 261 cylinders<br \/>\nUnits = cylinders of 16065 * 512 = 8225280 bytes<br \/>\nSector size (logical\/physical): 512 bytes \/ 512 bytes<br \/>\nI\/O size (minimum\/optimal): 512 bytes \/ 512 bytes<br \/>\nDisk identifier: 0xf5898159<\/p>\n<p>Device Boot\u00a0\u00a0\u00a0\u00a0\u00a0 Start\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 End\u00a0\u00a0\u00a0\u00a0\u00a0 Blocks\u00a0\u00a0 Id\u00a0 System<br \/>\n\/dev\/sdd1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 261\u00a0\u00a0\u00a0\u00a0 2096451\u00a0\u00a0 83\u00a0 Linux<\/p>\n<p>Give proper ownership and permissions to the new partition:-<br \/>\nchown -Rf oracle:oinstall \/dev\/sdb1<br \/>\nchown -Rf oracle:oinstall \/dev\/sdc1<br \/>\nchown -Rf oracle:oinstall \/dev\/sdd1<\/p>\n<p>chmod -Rf 664 \/dev\/sdb1<br \/>\nchmod -Rf 664 \/dev\/sdc1<br \/>\nchmod -Rf 664 \/dev\/sdd1<\/p>\n<p>Now configure ASM and create ASM disks:-<\/p>\n<p>[root@server1 ~]# \/etc\/init.d\/oracleasm configure<br \/>\nConfiguring the Oracle ASM library driver.<\/p>\n<p>This will configure the on-boot properties of the Oracle ASM library<br \/>\ndriver.\u00a0 The following questions will determine whether the driver is<br \/>\nloaded on boot and what permissions it will have.\u00a0 The current values<br \/>\nwill be shown in brackets (&#8216;[]&#8217;).\u00a0 Hitting &lt;ENTER&gt; without typing an<br \/>\nanswer will keep that current value.\u00a0 Ctrl-C will abort.<\/p>\n<p>Default user to own the driver interface []: oracle<br \/>\nDefault group to own the driver interface []: oinstall<br \/>\nStart Oracle ASM library driver on boot (y\/n) [n]: y<br \/>\nScan for Oracle ASM disks on boot (y\/n) [y]: y<br \/>\nWriting Oracle ASM library driver configuration: done<br \/>\nInitializing the Oracle ASMLib driver: [\u00a0 OK\u00a0 ]<br \/>\nScanning the system for Oracle ASMLib disks: [\u00a0 OK\u00a0 ]<\/p>\n<p>To create ASM disks:-<br \/>\n[root@server1 ~]#\/etc\/init.d\/oracleasm createdisk VOL1 \/dev\/sdb1<br \/>\n[root@server1 ~]#\/etc\/init.d\/oracleasm createdisk VOL2 \/dev\/sdc1<br \/>\n[root@server1 ~]#\/etc\/init.d\/oracleasm createdisk VOL3 \/dev\/sdd1<\/p>\n<p>Now we will install grid infrastructure software.<br \/>\nGive proper permission to the software folder.<\/p>\n<p>[root@server1 ] chown -Rf oracle:oinstall \/u01\/linuxamd64_12102_grid_1of2.zip<br \/>\nroot@server1 ] chown -Rf oracle:oinstall \/u01\/linuxamd64_12102_grid_2of2.zip<\/p>\n<p>[root@server1 u01]# unzip linuxamd64_12102_grid_1of2.zip<br \/>\n[root@server1 u01]# unzip linuxamd64_12102_grid_2of2.zip<br \/>\n[root@server1 u01]#su &#8211; oracle<br \/>\n[oracle@server1 u01]$ cd grid\/<br \/>\n[oracle@server1 grid]$ sh runInstaller<\/p>\n<p>Select &#8220;install and configure grid infrastructure for a standalone server&#8221; -&gt; Next -&gt; select 3 Disks from candidate disk option rest option will be unchanged\u00a0 -&gt;<br \/>\nselect &#8220;use same password for these accounts &#8221; and provide password -&gt; specify os groups OSDBA-oinstall,<br \/>\nOSOPER-oinstall, OSASM-oinstall -&gt; Select Install location &#8220;oracle base- \/u01\/app\/oracle &#8221; , &#8220;software location- \/u01\/app\/oracle\/product\/12.1.0\/grid&#8221; -&gt; Next and<br \/>\nstart the installation.&gt; execute &#8220;\/u01\/app\/oracle\/product\/12.1.0\/grid\/root.sh&#8221; script from root user from another terminal.<\/p>\n<p>I got this error while installing grid infrastructure.To fix this steps are below:-<br \/>\n**INFO: Read: ORA-00845: MEMORY_TARGET not supported on this system<\/p>\n<p>To increase the size<br \/>\n# mount -o remount,size=3G \/dev\/shm<br \/>\nVerify the size<br \/>\n# df -h<br \/>\nTo make permanent changes to your file system update your fstab<br \/>\n# vi \/etc\/fstab<br \/>\ntmpfs\u00a0 \/dev\/shm\u00a0 tmpfs\u00a0 defaults,size=3G\u00a0 0 0<\/p>\n<p>[root@server1 u01]#<\/p>\n<p>[grid@server3 app]$ sqlplus\u00a0 \/ as sysasm<br \/>\nSQL&gt; select instance_name from v$instance;<\/p>\n<p>INSTANCE_NAME<br \/>\n&#8212;&#8212;&#8212;&#8212;&#8212;-<br \/>\n+ASM<\/p>\n<p>Now we will setup oracle database .<\/p>\n<p>[oracle@server1 u01]$ cd \/u01\/database\/<br \/>\n[oracle@server3 u01]$ sh runInstaller<\/p>\n<p>select &#8220;Create &amp; configure a database&#8221; -&gt; Server Class -&gt; Single instance database installation -&gt; Advanced Installa -&gt; Next -&gt;Enterprise edition -&gt;<br \/>\nSelect &#8220;oracle base- \/u01\/app\/oracle &#8221; , &#8220;software location- \/u01\/app\/oracle\/product\/12.1.0\/db_1&#8221; -&gt; select &#8220;general purpose&#8221; -&gt; Global database<br \/>\nname- orcl , SID name &#8211; orcl -&gt; Next -&gt; select &#8221; Oracle automatic storage management&#8221;-&gt; Next -&gt;Next -&gt;Next-&gt; select &#8221; use same password for all accounts&#8221;-&gt;<br \/>\nNext -&gt; Next -&gt; Install<\/p>\n<p>Done!!!&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to setup Oracle ASM 12c on Linux Software used:- 1.VMWARE 10 2.Redhat enterprise linux 6.5(64 bit) 3.Oracle database 12C (64 bit) 4.Oracle Grid infrastructure 12c(64 bit)<\/p>\n<p>What to Setup:-<\/p>\n<p>1. Setup oracle grid infrastructure for standalone server &#8220;ASM&#8221; 2. Setup oracle Database<\/p>\n<p>Update \/etc\/sysctl.conf [root@server1]# vi \/etc\/sysctl.conf Scroll to the bottom and add the [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6587"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6587"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6587\/revisions"}],"predecessor-version":[{"id":6588,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6587\/revisions\/6588"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6587"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6587"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6587"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}