oracle rac12c安装不一样的方法

最新推荐文章于 2023-04-19 20:31:20 发布

每天努力一点点，哈哈

最新推荐文章于 2023-04-19 20:31:20 发布

阅读量175

点赞数

分类专栏： RAC相关

本文链接：https://blog.csdn.net/weixin_39568073/article/details/117956972

版权

RAC相关专栏收录该内容

20 篇文章 4 订阅

订阅专栏

用到的命令

hostnamectl
hostnamectl set-hostname rac1.lihao.local

vim /etc/hosts
# Public
192.168.56.101   rac1.lihao.local        rac1
192.168.56.102   rac2.lihao.local        rac2
# Private
192.168.1.101   rac1-priv.lihao.local   rac1-priv
192.168.1.102   rac2-priv.lihao.local   rac2-priv
# Virtual
192.168.56.103   rac1-vip.lihao.local    rac1-vip
192.168.56.104   rac2-vip.lihao.local    rac2-vip

vim /etc/racdns
# SCAN
192.168.56.105   rac-scan.lihao.local rac-scan
192.168.56.106   rac-scan.lihao.local rac-scan
192.168.56.107   rac-scan.lihao.local rac-scan

vim /etc/dnsmasq.conf
addn-hosts=/etc/racdns
vim /etc/resolv.conf
nameserver 127.0.0.1
chattr -i /etc/resolv.conf

systemctl enable dnsmasq.service
systemctl stop dnsmasq.service
systemctl start dnsmasq.service
systemctl status dnsmasq.service
netstat -tupln
kill -9 1237
nslookup rac-scan

vim /etc/selinux/config
systemctl stop firewalld
systemctl disable firewalld

systemctl enable chronyd
systemctl restart chronyd
chronyc -a 'burst 4/4'
chronyc -a makestep

yum install oracle-database-server-12cR2-preinstall -y
passwd oracle

mkdir -p /u01/app/12.2.0.1/grid
mkdir -p /u01/app/oracle/product/12.2.0.1/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01/

chown -R oracle:oinstall /ruanjian/
chmod -R 775 /ruanjian/

vim /home/oracle/.bash_profile
# Oracle Settings
export TMP=/tmp
export TMPDIR=$TMP

export ORACLE_HOSTNAME=rac1.lihao.local
export ORACLE_UNQNAME=CDBRAC
export ORACLE_BASE=/u01/app/oracle
export GRID_HOME=/u01/app/12.2.0.1/grid
export DB_HOME=$ORACLE_BASE/product/12.2.0.1/db_1
export ORACLE_HOME=$DB_HOME
export ORACLE_SID=cdbrac1
export ORACLE_TERM=xterm
export BASE_PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$BASE_PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

alias grid_env='. /home/oracle/grid_env'
alias db_env='. /home/oracle/db_env'

vim /home/oracle/grid_env
export ORACLE_SID=+ASM1
export ORACLE_HOME=$GRID_HOME
export PATH=$ORACLE_HOME/bin:$BASE_PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

vim /home/oracle/db_env
export ORACLE_SID=cdbrac1
export ORACLE_HOME=$DB_HOME
export PATH=$ORACLE_HOME/bin:$BASE_PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

grid_env
env|grep ORA
db_env

VBoxManage createhd --filename D:\linux\asm\asm1.vdi --size 20480 --format VDI --variant Fixed
VBoxManage createhd --filename D:\linux\asm\asm2.vdi --size 20480 --format VDI --variant Fixed
VBoxManage createhd --filename D:\linux\asm\asm3.vdi --size 20480 --format VDI --variant Fixed
VBoxManage createhd --filename D:\linux\asm\asm4.vdi --size 20480 --format VDI --variant Fixed

VBoxManage storageattach linux --storagectl "SATA" --port 1 --device 0 --type hdd --medium D:\linux\asm\asm1.vdi --mtype shareable
VBoxManage storageattach linux --storagectl "SATA" --port 2 --device 0 --type hdd --medium D:\linux\asm\asm2.vdi --mtype shareable
VBoxManage storageattach linux --storagectl "SATA" --port 3 --device 0 --type hdd --medium D:\linux\asm\asm3.vdi --mtype shareable
VBoxManage storageattach linux --storagectl "SATA" --port 4 --device 0 --type hdd --medium D:\linux\asm\asm4.vdi --mtype shareable

VBoxManage modifyhd D:\linux\asm\asm1.vdi --type shareable
VBoxManage modifyhd D:\linux\asm\asm2.vdi --type shareable
VBoxManage modifyhd D:\linux\asm\asm3.vdi --type shareable
VBoxManage modifyhd D:\linux\asm\asm4.vdi --type shareable

lsblock
fdisk /dev/sdb

vim /etc/scsi_id.config
/usr/lib/udev/scsi_id -g -u -d /dev/sdb1
/usr/lib/udev/scsi_id -g -u -d /dev/sdc1
/usr/lib/udev/scsi_id -g -u -d /dev/sdd1
/usr/lib/udev/scsi_id -g -u -d /dev/sde1

vim /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="sdb1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VBd2a945f2-6943dbc3", SYMLINK+="oracleasm/asm-disk1", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sdc1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB4a54e115-18c7e428", SYMLINK+="oracleasm/asm-disk2", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sdd1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB4ec5eda8-0ecf03e4", SYMLINK+="oracleasm/asm-disk3", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sde1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB77acf13e-2eb46775", SYMLINK+="oracleasm/asm-disk4", OWNER="oracle", GROUP="dba", MODE="0660"

/sbin/partprobe /dev/sdb1
/sbin/partprobe /dev/sdc1
/sbin/partprobe /dev/sdd1
/sbin/partprobe /dev/sde1

/sbin/udevadm test /block/sdb/sdb1
/sbin/udevadm control --reload-rules
ls -al /dev/oracleasm/*
ls -al /dev/sd*1

VBoxManage clonehd "D:\linux\linux\linux.vdi" "D:\linux\rac2\rac2.vdi"

VBoxManage storageattach rac2 --storagectl "SATA" --port 1 --device 0 --type hdd --medium D:\linux\asm\asm1.vdi --mtype shareable
VBoxManage storageattach rac2 --storagectl "SATA" --port 1 --device 0 --type hdd --medium D:\linux\asm\asm2.vdi --mtype shareable
VBoxManage storageattach rac2 --storagectl "SATA" --port 1 --device 0 --type hdd --medium D:\linux\asm\asm3.vdi --mtype shareable
VBoxManage storageattach rac2 --storagectl "SATA" --port 1 --device 0 --type hdd --medium D:\linux\asm\asm4.vdi --mtype shareable

hostnamectl set-hostname rac2.lihao.local
cd /etc/sysconfig/network-scripts/

vim /home/oracle/.bash_profile
export ORACLE_HOSTNAME=rac2.lihao.local
vim /home/oracle/grid_env
export ORACLE_SID=+ASM2
vim /home/oracle/db_env
export ORACLE_SID=cdbrac2

ping -c 3 rac1 
ping -c 3 rac1-priv 
ping -c 3 rac2 
ping -c 3 rac2-priv

unzip linuxx64_12201_grid_home.zip -d $ORACLE_HOME
cd $ORACLE_HOME
./gridSetup.sh
rac2.lihao.local
rac2-vip.lihao.local
dd if=/dev/zero of=/dev/sdb1 bs=1024 count=10
srvctl config database -d cdbrac
srvctl status database -d cdbrac

在这里插入图片描述

Hostnamectl

cat /etc/hosts

Public

192.168.56.101 rac1.lihao.local rac1
192.168.56.102 rac2.lihao.local rac2

Private

192.168.1.101 rac1-priv.lihao.local rac1-priv
192.168.1.102 rac2-priv.lihao.local rac2-priv

Virtual

192.168.56.103 rac1-vip.lihao.local rac1-vip
192.168.56.104 rac2-vip.lihao.local rac2-vip
在这里插入图片描述
vim /etc/racdns

SCAN

192.168.56.105 rac-scan.lihao.local rac-scan
192.168.56.106 rac-scan.lihao.local rac-scan
192.168.56.107 rac-scan.lihao.local rac-scan
在这里插入图片描述
vim /etc/dnsmasq.conf
addn-hosts=/etc/racdns

vim /etc/resolv.conf
nameserver 127.0.0.1

systemctl enable dnsmasq.service
systemctl start dnsmasq.service
systemctl status dnsmasq.service

netstat –tupln

nslookup rac-scan

vim /etc/selinux/config

systemctl stop firewalld
systemctl disable firewalld
在这里插入图片描述
systemctl enable chronyd
systemctl restart chronyd
chronyc -a ‘burst 4/4’
chronyc -a makestep

yum install oracle-database-server-12cR2-preinstall –y

passwd oracle

mkdir -p /u01/app/12.2.0.1/grid
mkdir -p /u01/app/oracle/product/12.2.0.1/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01/
在这里插入图片描述
chown -R oracle:oinstall /ruanjian/
chmod -R 775 /ruanjian/

vim /home/oracle/.bash_profile

vim /home/oracle/.bash_profile
# Oracle Settings
export TMP=/tmp
export TMPDIR=$TMP

export ORACLE_HOSTNAME=rac1.lihao.local
export ORACLE_UNQNAME=CDBRAC
export ORACLE_BASE=/u01/app/oracle
export GRID_HOME=/u01/app/12.2.0.1/grid
export DB_HOME=$ORACLE_BASE/product/12.2.0.1/db_1
export ORACLE_HOME=$DB_HOME
export ORACLE_SID=cdbrac1
export ORACLE_TERM=xterm
export BASE_PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$BASE_PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

alias grid_env='. /home/oracle/grid_env'
alias db_env='. /home/oracle/db_env'

在这里插入图片描述
vim /home/oracle/grid_env
export ORACLE_SID=+ASM1
export ORACLE_HOME= $GRID_HOME export PATH=$ ORACLE_HOME/bin: $BASE_PATH export LD_LIBRARY_PATH=$ ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH= $ORACLE_HOME/JRE:$ ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

vim /home/oracle/db_env
export ORACLE_SID=cdbrac1
export ORACLE_HOME=$DB_HOME
export PATH=$ORACLE_HOME/bin:$BASE_PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

在这里插入图片描述
grid_env
env|grep ORA
db_env

VBoxManage createhd --filename D:\linux\asm\asm1.vdi --size 20480 --format VDI --variant Fixed
VBoxManage createhd --filename D:\linux\asm\asm2.vdi --size 20480 --format VDI --variant Fixed
VBoxManage createhd --filename D:\linux\asm\asm3.vdi --size 20480 --format VDI --variant Fixed
VBoxManage createhd --filename D:\linux\asm\asm4.vdi --size 20480 --format VDI --variant Fixed
在这里插入图片描述

VBoxManage storageattach linux --storagectl “SATA” --port 1 --device 0 --type hdd --medium D:\linux\asm\asm1.vdi --mtype shareable
VBoxManage storageattach linux --storagectl “SATA” --port 2 --device 0 --type hdd --medium D:\linux\asm\asm2.vdi --mtype shareable
VBoxManage storageattach linux --storagectl “SATA” --port 3 --device 0 --type hdd --medium D:\linux\asm\asm3.vdi --mtype shareable
VBoxManage storageattach linux --storagectl “SATA” --port 4 --device 0 --type hdd --medium D:\linux\asm\asm4.vdi --mtype shareable
在这里插入图片描述

VBoxManage modifyhd D:\linux\asm\asm1.vdi --type shareable
VBoxManage modifyhd D:\linux\asm\asm2.vdi --type shareable
VBoxManage modifyhd D:\linux\asm\asm3.vdi --type shareable
VBoxManage modifyhd D:\linux\asm\asm4.vdi --type shareable

fdisk /dev/sdb

vim /etc/scsi_id.config
options=-g
在这里插入图片描述
/usr/lib/udev/scsi_id -g -u -d /dev/sdb1
/usr/lib/udev/scsi_id -g -u -d /dev/sdc1
/usr/lib/udev/scsi_id -g -u -d /dev/sdd1
/usr/lib/udev/scsi_id -g -u -d /dev/sde1

vim /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="sdb1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VBd2a945f2-6943dbc3", SYMLINK+="oracleasm/asm-disk1", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sdc1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB4a54e115-18c7e428", SYMLINK+="oracleasm/asm-disk2", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sdd1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB77acf13e-2eb46775", SYMLINK+="oracleasm/asm-disk3", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sde1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB4ec5eda8-0ecf03e4", SYMLINK+="oracleasm/asm-disk4", OWNER="oracle", GROUP="dba", MODE="0660"

在这里插入图片描述
/sbin/partprobe /dev/sdb1
/sbin/partprobe /dev/sdc1
/sbin/partprobe /dev/sdd1
/sbin/partprobe /dev/sde1

/sbin/udevadm test /block/sdb/sdb1

出现问题了，写返了

/sbin/udevadm control --reload-rules

修改吧
ls -al /dev/oracleasm/*
ls -al /dev/sd*1
在这里插入图片描述

VBoxManage clonehd “D:\linux\linux\linux.vdi” “D:\linux\rac2\rac2.vdi”

VBoxManage storageattach rac2 --storagectl "SATA" --port 1 --device 0 --type hdd --medium D:\linux\asm\asm1.vdi --mtype shareable
VBoxManage storageattach rac2 --storagectl "SATA" --port 1 --device 0 --type hdd --medium D:\linux\asm\asm2.vdi --mtype shareable
VBoxManage storageattach rac2 --storagectl "SATA" --port 1 --device 0 --type hdd --medium D:\linux\asm\asm3.vdi --mtype shareable
VBoxManage storageattach rac2 --storagectl "SATA" --port 1 --device 0 --type hdd --medium D:\linux\asm\asm4.vdi --mtype shareable

在这里插入图片描述

修改主机名
hostnamectl set-hostname rac2.lihao.local

修改IP

vim /home/oracle/.bash_profile

vim /home/oracle/grid_env

vim /home/oracle/db_env

ping -c 3 rac1
ping -c 3 rac1-priv

ping -c 3 rac2
ping -c 3 rac2-priv

ls -al /dev/oracleasm/*
在这里插入图片描述
确定它两个正常

已损坏，重新拉一个
unzip linuxx64_12201_grid_home.zip -d $ORACLE_HOME

重新安装，不能使用了，无法选择了

dd if=/dev/zero of=/dev/sdb1 bs=1024 count=100

安装好，电脑变慢了。还要安装数据库
在这里插入图片描述

/u01/app/oracle/product/12.2.0.1/db_1/root.sh

srvctl config database -d cdbrac

srvctl status database -d cdbrac

sqlplus / as sysdba

crsctl stat res -t

每天努力一点点，哈哈

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
oracle rac12c安装不一样的方法

用到的命令hostnamectlhostnamectl set-hostname rac1.lihao.localvim /etc/hosts# Public192.168.56.101 rac1.lihao.local rac1192.168.56.102 rac2.lihao.local rac2# Private192.168.1.101 rac1-priv.lihao.local rac1-priv192.168.1.102 rac
复制链接

扫一扫