建站
咨詢
售后
建站咨詢
新聞中心
下邊有完整的附件
創(chuàng)新互聯(lián)是專業(yè)的古丈網(wǎng)站建設(shè)公司，古丈接單;提供成都網(wǎng)站制作、網(wǎng)站設(shè)計(jì),網(wǎng)頁設(shè)計(jì),網(wǎng)站設(shè)計(jì),建網(wǎng)站,PHP網(wǎng)站建設(shè)等專業(yè)做網(wǎng)站服務(wù);采用PHP框架,可快速的進(jìn)行古丈網(wǎng)站開發(fā)網(wǎng)頁制作和功能擴(kuò)展;專業(yè)做搜索引擎喜愛的網(wǎng)站,專業(yè)的做網(wǎng)站團(tuán)隊(duì),希望更多企業(yè)前來合作!
完整 文檔以及操作流程如下
[root@rac01 ~]# cd OracleLinux-R6-U6-Server-x86_64-dvd/
[root@rac01 OracleLinux-R6-U6-Server-x86_64-dvd]# ls
EFI GPL LoadBalancer README-en.html RELEASE-NOTES-x86_64-en.html ResilientStorage Server
EULA HighAvailability media.repo RELEASE-NOTES-en RELEASE-NOTES-x86-en RPM-GPG-KEY supportinfo
eula.en_US images Packages RELEASE-NOTES-en.html RELEASE-NOTES-x86-en.html RPM-GPG-KEY-oracle TRANS.TBL
eula.py isolinux README-en RELEASE-NOTES-x86_64-en repodata ScalableFileSystem UEK3
[root@rac01 OracleLinux-R6-U6-Server-x86_64-dvd]# cd Packages/
[root@rac01 Packages]# cd /etc/yum.repos.d/
[root@rac01 yum.repos.d]# ls
public-yum-ol6.repo
[root@rac01 yum.repos.d]# rm -rf *
[root@rac01 yum.repos.d]# vi local.repo
[kingsql]
name=This is kingsql repo
baseurl=file:///rpm/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY
[root@rac01 yum.repos.d]# mkdir -p /rpm
[root@rac01 yum.repos.d]# cd /rpm
[root@rac01 rpm] cp /root/OracleLinux-R6-U6-Server-x86_64-dvd/Packages/* /rpm/
rpm -ivh vsftpd-2.2.2-12.el6_5.1.x86_64.rpm
rpm -ivh deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm
rpm -ivh python-deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm
rpm -ivh libxml2-2.7.6-14.el6_5.2.x86_64.rpm
rpm -ivh libxml2-python-2.7.6-14.el6_5.2.x86_64.rpm
rpm -ivh createrepo-0.9.9-22.el6.noarch.rpm
rpm -ivh ksh-20120801-21.el6.x86_64.rpm
[root@rac01 rpm]# createrepo ./
Spawning worker 0 with 3848 pkgs
Workers Finished
Gathering worker results
Saving Primary metadata
Saving file lists metadata
Saving other metadata
Generating sqlite DBs
Sqlite DBs complete
[root@rac01 rpm]#
[root@rac01 rpm]# yum clean all kill -9 結(jié)束進(jìn)程的
[root@rac01 rpm]# yum makecache
[root@rac01 rpm]#yum install libXp* xterm* unixODBC* sysstat* make* libstdc++* libgomp* libgcc* libaio* kernel-headers* glibc* gcc* elfutils* binutils* bind bind-devel bind-chroot caching-nameserver compat-libcap1* compat-libstdc++-33* openssh* xdpyinfo vi unzip
[root@rac01 rpm]#yum install libXp* xterm* unixODBC* sysstat* make* libstdc++* libgomp* libgcc* libaio* kernel-headers*
glibc* gcc* elfutils* binutils* bind bind-devel bind-chroot caching-nameserver compat-libcap1* compat-libstdc++-33* openssh*
xdpyinfo vi unzip
yum install oracle-database-server-11gR2-preinstall -y
--------------------------------------------------------------------------------------------
首先選擇網(wǎng)卡是橋接網(wǎng)絡(luò)僅主機(jī)靜態(tài)的并且把 DNS 網(wǎng)絡(luò)寫上
vi /etc/sysconfig/network-scripts/ifcfg-eth2 編輯兩個節(jié)點(diǎn)的 DNS 配置 兩個 dns
vi /etc/named.conf
options {
listen-on port 53 { any; };
directory "/var/named";
dump-file "/var/named/data/cache_dump.db";
statistics-file "/var/named/data/named_stats.txt";
memstatistics-file "/var/named/data/named_mem_stats.txt";
allow-query { any; };
recursion yes;
dnssec-enable yes;
dnssec-validation yes;
/* Path to ISC DLV key */
bindkeys-file "/etc/named.iscdlv.key";
managed-keys-directory "/var/named/dynamic";
};
logging {
channel default_debug {
file "data/named.run";
severity dynamic;
};
};
zone "." IN {
type hint;
file "/dev/null";
};
zone "kingsql.org" IN {
type master;
file "kingsql.org.zone";
};
zone "56.168.192.in-addr.arpa" {
type master;
file "192.168.56.rev";
};
--------------------------------------------------------------------------------------------
[root@rac01 named]# cd /var/named
[root@rac01 named]# pwd
/var/named
[root@rac01 named]# vi kingsql.org.zone
$TTL 1D
@ IN SOA kingsql.org. hostmaster.kingsql.org. (
0 ; serial
1D ; refresh
1H ; retry
1W ; expire
3H ) ; minimum
@ IN NS ns1.kingsql.org.
ns1 IN A 192.168.56.101 自己實(shí)際網(wǎng)絡(luò)
ns2 IN A 192.168.56.101
cluster-scan IN A 192.168.56.156
cluster-scan IN A 192.168.56.157
cluster-scan IN A 192.168.56.158
--------------------------------------------------------------------------------------------
[root@rac01 named]# vi 192.168.56.rev
$TTL 1D
@ IN SOA kingsql.org. hostmaster.kingsql.org. (
0 ; serial
1D ; refresh
1H ; retry
1W ; expire
3H ) ; minimum
@ IN NS ns1.kingsql.org.
ns1 IN A 192.168.56.101
ns2 IN A 192.168.56.101
156 IN PTR cluster-scan.kingsql.org.
157 IN PTR cluster-scan.kingsql.org.
158 IN PTR cluster-scan.kingsql.org.
--------------------------------------------------------------------------------------------
service network restart
cat /etc/resolv.conf
chkconfig named on
service named start
nslookup cluster-scan.kingsql.org
nslookup 192.168.56.156
nslookup 192.168.56.157
nslookup 192.168.56.158
-------------------------------------------------------------------------------------------- 不配 DNS 一下
[root@rac01 ~]# chkconfig iptables off
[root@rac01 ~]# service iptables stop
[root@rac01 ~]# vi /etc/selinux/config
groupadd -g 1000 oinstall
groupadd -g 1200 asmadmin
groupadd -g 1201 asmdba
groupadd -g 1202 asmoper
groupadd -g 1300 dba
groupadd -g 1301 oper
useradd -m -u 1100 -g oinstall -G asmadmin,asmdba,asmoper,dba -d /home/grid -s /bin/bash -c "Grid Infrastructure Owner" grid
useradd -m -u 1101 -g oinstall -G dba,oper,asmdba -d /home/oracle -s /bin/bash -c "Oracle Software Owner" oracle
passwd grid
passwd oracle
mkdir -p /u01/app/grid
mkdir -p /u01/app/11.2.4/grid
chown -R grid:oinstall /u01
mkdir -p /u01/app/oracle
chown oracle:oinstall /u01/app/oracle
chmod -R 775 /u01
----------------------------------------------------------------------------------------------
su - oracle
[oracle@rac1 ~]$ vi .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.4/dbhome_1
export ORACLE_SID=kingsql
export ORACLE_TERM=xterm
export PATH=/usr/sbin:$PATH
export PATH=/u01/app/ogg:$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=/u01/app/ogg:$ORACLE_HOME/lib:/lib:/usr/lib:$LD_LIBRARY_PATH
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export
export ORACLE_UNQNAME=kingsql
if [ $USER = "oracle" ] || [ $USER = "grid" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
-----------------------------------------------------------------------------------------------
su - grid
[grid@rac1 ~]$ vi .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/11.2.4/grid
export ORACLE_SID=+ASM1
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
if [ $USER = "oracle" ] || [ $USER = "grid" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
export
----------------------------------------------------------------------------------------------
su - root
vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
[root@rac01 ~]# /sbin/sysctl -p
----------------------------------------------------------------------------------------------
[root@rac01 ~]# vi /etc/security/limits.conf
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
[root@rac01 ~]# vi /etc/pam.d/login
session required pam_limits.so
root@rac01 ~]# vi /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.56.101 rac01
192.168.56.102 rac02
192.168.56.111 rac01-vip
192.168.56.112 rac02-vip
192.168.1.222 rac01-priv
192.168.1.231 rac02-priv
192.168.56.158 cluster-scan
192.168.56.158 rac-cluster-scan 以上網(wǎng)址自己根據(jù)自己網(wǎng)址更改
[root@rac01 ~]# vi /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.56.105 rac01
192.168.56.106 rac02
192.168.56.111 rac01-vip
192.168.56.112 rac02-vip
192.168.1.221 rac01-priv
192.168.1.238 rac02-priv
192.168.56.158 cluster-scan 以上網(wǎng)址自己根據(jù)自己網(wǎng)址更改
[root@rac1 ~]# service ntpd stop
關(guān)閉 ntpd ： [ 失敗 ]
[root@rac1 ~]# chkconfig ntpd off
[root@rac1 ~]# mv /etc/ntp.conf /etc/ntp.conf.original
[root@rac1 ~]# rm -rf /var/run/ntpd.pid
[root@rac01 ~]# shutdown -h now 關(guān)機(jī) 虛擬機(jī)創(chuàng)建磁盤 （磁盤設(shè)置成共享模式）
一個 12g 一個 30g 兩塊磁盤
-------------------------------------------------------------------------------------------- 、
[root@rac01 ~]# fdisk -l
查磁盤號
[root@rac1 ~]# /sbin/scsi_id -u -g /dev/sdb
1ATA_VBOX_HARDDISK_VB1274608b-98003b66
[root@rac1 ~]# /sbin/scsi_id -u -g /dev/sdc
1ATA_VBOX_HARDDISK_VBbf237514-f3435ff0
[root@rac1 ~]# /sbin/scsi_id -u -g /dev/sdd
1ATA_VBOX_HARDDISK_VBc894130b-2f10eef0
[root@rac1 ~]# /sbin/scsi_id -u -g /dev/sde
1ATA_VBOX_HARDDISK_VB58f6ed82-b0dc76dc
[root@rac1 ~]# /sbin/scsi_id -u -g /dev/sdf
1ATA_VBOX_HARDDISK_VB0e0cbf34-6238f247
[root@rac1 ~]# /sbin/scsi_id -u -g /dev/sdg
1ATA_VBOX_HARDDISK_VB98788216-29530089
rac1 編寫文件然后 copy 到其他節(jié)點(diǎn)
/etc/udev/rules.d/99-oracle-asmdevices.rules
[root@rac01 ~]# vi /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="", NAME="asm-disk1", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="", NAME="asm-disk2", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="1ATA_VBOX_HARDDISK_VB1274608b-98003b66",NAME="asm-disk1", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="1ATA_VBOX_HARDDISK_VBbf237514-f3435ff0", SYMLINK+="asm-disk2", OWNER="grid", GROUP="asmadmin", MODE="0660"
// 這里是用 2 種方式綁定的 UDEV ，可以選擇其中一個即可，不要完全照抄
[root@rac1 ~]# scp /etc/udev/rules.d/99-oracle-asmdevices.rules rac02:/etc/udev/rules.d/99-oracle-asmdevices.rules
[root@rac01 ~]# start_udev
Starting udev: [ OK ]
[root@rac01 ~]# ls -l /dev/asm*
brw-rw---- 1 grid asmadmin 8, 16 5 月 17 12:09 /dev/asm-diskb
lrwxrwxrwx 1 root root 3 5 月 17 12:09 /dev/asm-diskc -> sdc
[root@rac01 ~]# mv p13390677_112040_Linux-x86-64_3of7.zip /home/grid/
--------------------------------------------------------------------------------------------
su - grid
--------------------------------------------------------------------------------------------
[grid@rac01 ~]$ unzip p13390677_112040_Linux-x86-64_3of7.zip
[grid@rac01 ~]$ cd grid/
[grid@rac01 grid]$ ls
install response runInstaller sshsetup welcome.html
readme.html rpm runcluvfy.sh stage
[grid@rac01 grid]$ cd rpm/
[grid@rac01 rpm]$ ls
cvuqdisk-1.0.9-1.rpm
--------------------------------------------------------------------------------------------
[grid@rac01 rpm]$ su root
Password:
[root@rac1 ~]# rpm -ivh /home/grid/grid/rpm/cvuqdisk-1.0.9-1.rpm
Preparing... ########################################### [100%]
Using default group oinstall to install package
1:cvuqdisk ########################################### [100%]
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
su - grid
[grid@rac01 grid]$ ./runInstaller
腳本二運(yùn)行時間較長
[root@rac01 ~]# /opt/ora11g/oraInventory/orainstRoot.sh 執(zhí)行腳本 需要在 rac01 執(zhí)行完 第一條腳本后，在 rac02 在執(zhí)行第一個腳本
[root@rac02 ~]# /opt/ora11g/oraInventory/orainstRoot.sh
[root@rac01 ~]# /opt/ora11g/11.2.4/grid/root.sh 執(zhí)行腳本 需要在 rac01 執(zhí)行完 第二條腳本后，在 rac02 在執(zhí)行第二個腳本
[root@rac02 ~]# /opt/ora11g/11.2.4/grid/root.sh
[root@rac01 ~]# su - grid
[grid@rac01 ~]$ crsctl status res -t
[grid@rac01 ~]$ ping cluster-scan
[root@rac01 ~]# ping rac01-vip
[grid@rac01 grid]$ asmca 創(chuàng)建磁盤組
--------------------------------------------------------------------------------------------
[root@rac01 ~]# su - oracle
[oracle@rac01 ~]$
[oracle@rac01 ~]$ ls
--------------------------------------------------------------------------------------------
p13390677_112040_Linux-x86-64_1of7.zip p13390677_112040_Linux-x86-64_2of7.zip
[oracle@rac01 ~]$ unzip p13390677_112040_Linux-x86-64_1of7.zip
[oracle@rac01 ~]$ unzip p13390677_112040_Linux-x86-64_2of7.zip
--------------------------------------------------------------------------------------------
[oracle@rac01 database]$ ./runInstaller
--------------------------------------------------------------------------------------------
[root@rac01 ~]# /opt/ora11g/oracle/product/11.2.4/dbhome_1/root.sh
--------------------------------------------------------------------------------------------
[oracle@rac01 ~]$ dbca
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
[
[grid@rac01 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE rac01
ora.LISTENER.lsnr
ONLINE ONLINE rac01
ora.OCR.dg
ONLINE ONLINE rac01
ora.asm
ONLINE ONLINE rac01 Started
ora.gsd
OFFLINE OFFLINE rac01
ora.net1.network
ONLINE ONLINE rac01
ora.ons
ONLINE ONLINE rac01
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac01
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rac01
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rac01
ora.cvu
1 ONLINE ONLINE rac01
ora.kingsql.db
1 ONLINE ONLINE rac01 Open
ora.oc4j
1 ONLINE ONLINE rac01
ora.rac01.vip
1 ONLINE ONLINE rac01
ora.scan1.vip
1 ONLINE ONLINE rac01
ora.scan2.vip
1 ONLINE ONLINE rac01
ora.scan3.vip
1 ONLINE ONLINE rac01
[grid@rac01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue May 15 00:59:29 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> show parameter db_unique
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string +ASM
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
+ASM1
SQL> quit
OEL安裝DNS文檔1.docx
名稱欄目：OEL安裝RAC配置DNS文檔
轉(zhuǎn)載來于：http://www.dlmjj.cn/article/ijjhdd.html
