db12.2+asm安装(GI独立)换个方法安装

cat /etc/hosts


systemctl stop firewalld
systemctl disable firewalld

cat /etc/selinux/config

yum search oracle

yum install -y oracle-database-server-12cR2-preinstall.x86_64

yum search oracleasm

yum install -y kmod-oracleasm.x86_64

yum install -y oracleasm-support.x86_64

Id oracle

groupadd -g 54327 asmdba
groupadd -g 54328 asmoper
groupadd -g 54329 asmadmin

usermod -a -G asmdba oracle
id oracle

useradd -u 54331 -g oinstall -G dba,asmdba,asmoper,asmadmin,racdba grid
id grid

passwd oracle
passwd grid


oracleasm configure –i


oracleasm status
oracleasm init

lsblk

fdisk /dev/sdb


oracleasm createdisk CRS1 /dev/sdb1
oracleasm createdisk DATA1 /dev/sdc1
oracleasm createdisk FRA1 /dev/sdd1
oracleasm listdisks

mkdir -p /u01/app/oracle
mkdir -p /u01/app/oracle/product/12.2.0/db_home
mkdir -p /u01/app/grid
mkdir -p /u01/app/grid/12.2.0/grid_home


chown -R oracle:oinstall /u01
chown -R grid:oinstall /u01/app/grid
chmod -R 775 /u01

su – grid
vim .bash_profile

ORACLE_SID=+ASM; export ORACLE_SID
ORACLE_BASE=/u01/app/grid; export ORACLE_BASE
ORACLE_HOME=/u01/app/grid/12.2.0/grid_home; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
JAVA_HOME=/usr/bin/java; export JAVA_HOME
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN

PATH=.:$JAV{A}_{H}OME/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/local/bin
export PATH
. .bash_profile
env|grep ORA

多了一个目录，我的天呀

mkdir -p /u01/app/grid/12.2.0/grid_home
cd $ORACLE_HOME



./gridSetup.sh



















/u01/app/oraInventory/orainstRoot.sh










vim .bash_profile

ORACLE_HOSTNAME=db.local; export ORACLE_HOSTNAME
ORACLE_SID=prod; export ORACLE_SID
ORACLE_UNQNAME=prod; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_home; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
JAVA_HOME=/usr/bin/java; export JAVA_HOME
NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"; export NLS_DATE_FORMAT
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/local/bin
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib
export CLASSPATH
TEMP=/tmp ;export TMP
TMPDIR=$tmp ; export TMPDIR
umask 022

. .bash_profile
env|grep ORA































select name from v$controlfile;selectnamefromv$datafile;