wiki.janforman.com

User Tools

Site Tools

You are here: start » oracle » install
oracle:install

Differences

This shows you the differences between two versions of the page.


—oracle:install [2021/02/23 16:07] (current) – created - external edit 127.0.0.1
Line 1: Line 1:
 +====== Oracle ASM ======
 +[[https://www.oracle.com/linux/downloads/linux-asmlib-rhel7-downloads.html]]
 +[[https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/kmod-oracleasm-2.0.8-28.0.1.el7.x86_64.rpm]]
  
 +<code>yum install sg3_utils -y</code>
 +
 +[[https://docs.oracle.com/en/database/oracle/oracle-database/12.2/tdprc/preparing-your-cluster.html]]
 +
 +[[http://wiki.janforman.com/proxmox#set_ulimit|Set OS Limits]]
 +
 +<code>
 +/usr/sbin/groupadd -g 1000 oinstall
 +/usr/sbin/groupadd -g 1001 dba
 +/usr/sbin/groupadd -g 1002 asmdba
 +
 +/usr/sbin/useradd -u 1100 –g oinstall -G dba,asmdba -d /home/grid -r grid
 +/usr/sbin/useradd -u 1200 –g oinstall -G dba,asmdba -d /home/oracle -r oracle
 +
 +# grid
 +ORACLE_HOME=/u01/app/12.1.0/grid; export ORACLE_HOME
 +mkdir -p /u01/app/12.1.0/grid
 +chown -R grid:oinstall /u01/app/12.1.0/grid
 +
 +# db
 +mkdir -p /u01/app/oracle/
 +chown -R oracle:oinstall /u01/app/oracle/
 +chmod -R 775 /u01/app/oracle/
 +</code>
 +
 +You can use an Oracle home directory created in the local file system, for example, /u01/app/oracle/product/12.1.0/dbhome_1. The same directory must exist on every node in the cluster. You do not have to create these directories before installation. By default, the installer suggests a subdirectory of the Oracle base directory for the Oracle home.
 +
 +====== Time Synchronization ======
 +ntp must use -x option (don't go back in time)\\
 +/etc/ntp.conf
 +<code>slewalways yes</code>
 +
 +====== Create loopback raw files (not required) ======
 +<code>
 +mkdir /asmfs
 +dd if=/dev/zero of=/asmfs/disk1 bs=1024k count=30000
 +dd if=/dev/zero of=/asmfs/disk2 bs=1024k count=30000
 +dd if=/dev/zero of=/asmfs/disk3 bs=1024k count=30000
 +
 +chown -R grid:asmdba /asmfs
 +chmod -R 660 /asmfs
 +</code>
 +
 +/etc/init.d/loopback
 +<code>
 +#!/bin/bash
 +#
 +# chkconfig: 2345 18 18
 +# description: Loopback
 +
 +case "$1" in
 +  start)
 +/sbin/losetup /dev/loop1 /asmfs/disk1
 +/sbin/losetup /dev/loop2 /asmfs/disk2
 +/sbin/losetup /dev/loop3 /asmfs/disk3
 +raw /dev/raw/raw1 /dev/loop1
 +raw /dev/raw/raw2 /dev/loop2
 +raw /dev/raw/raw3 /dev/loop3
 +chown -R oracle:oinstall /dev/raw/*
 +touch /var/lock/subsys/loopback
 +;;
 +  stop)
 +/sbin/losetup -d /dev/loop1
 +/sbin/losetup -d /dev/loop2
 +/sbin/losetup -d /dev/loop3
 +;;
 +esac
 +</code>
 +
 +
 +<code>
 +chown -R oracle:oinstall /dev/raw/*
 +fdisk create partition
 +oracleasm createdisk < disk label > /dev/mapper/< alias >< partition >
 +</code>
 +
 +====== Oratab ======
 +<code>
 +SID:/u01/app/oracle/product/11.2.0/dbhome_1:Y
 ++ASM:/u01/app/oracle/product/11.2.0/grid:N
 +</code>
 +
 +====== Discover ASM in RAC ======
 +<code>
 +/etc/init.d/oracleasm scandisks
 +/etc/init.d/oracleasm listdisks
 +</code>
 +
 +====== Resize ASM ======
 +<code>
 +/etc/init.d/oracleasm listdisks
 +/etc/init.d/oracleasm createdisk VOLx /dev/raw/raw2
 +ALTER DISKGROUP DATA ADD DISK 'ORAPL:VOLx';
 +</code>
 +
 +====== Oracle bash profile ======
 +<code>
 +# User specific environment and startup programs
 +
 +PATH=$PATH:$HOME/bin:/opt/oracle/product/12.1.0/dbhome_1/bin
 +
 +export PATH
 +export ORACLE_HOME=/opt/oracle/product/12.1.0/dbhome_1
 +export ORACLE_SID=ORAPL
 +</code>
 +
 +====== Turn off audit ======
 +<code>ALTER SYSTEM SET AUDIT_TRAIL=NONE SCOPE=SPFILE;</code>
 +
 +====== SAN ======
 +Use the 512B sector size when exporting volumes to initiators. If you need to export
 +LUNs with a 4KB sector size, use Oracle or third-party-provided ASMLIB support
 +packages. 
oracle/install.txt · Last modified: 2021/02/23 16:07 by Jan Forman

Page Tools