oracle 11g rac install(linux_x64+udev+asm)

1、NTP時間服務(wù)器配置例嘱，2節(jié)點狡逢，使用root用戶

cd /etc/sysconfig;sed -i '/OPTIONS/ s/-u/-x -u/g' ntpd;service ntpd restart

2、hosts文件更改拼卵，2節(jié)點奢浑，使用root用戶

cat >> /etc/hosts << EOF

#-----public ip-----#

x.x.x.1? testdb1-pub

x.x.x.2? testdb2-pub

#-----private ip-----#

192.168.x.1? testdb1-pri

192.168.x.2? testdb2-pri

#-----virtual ip-----#

x.x.x.3? testdb1-vip

x.x.x.4? testdb2-vip

#-----scan ip------#

x.x.x.5? testdb-scan

EOF

3、創(chuàng)建grid用戶以及oracle用戶2腋腮，節(jié)點雀彼，使用root賬戶

GROUP01=oinstall;GROUP02=dba;GROUP03=oper;GROUP04=asmadmin;GROUP05=asmdba;GROUP06=asmoper;GROUP07=orawh

USER01=grid;PASSWD01='xxx';USER02=oracle;PASSWD02='xxx';USER03=orawh;PASSWD03='xxx'

groupadd -g 1001 $GROUP01;groupadd -g 1002 $GROUP02;groupadd -g 1003 $GROUP03;groupadd -g 1004 $GROUP04;groupadd -g 1005 $GROUP05;groupadd -g 1006 $GROUP06;groupadd -g 1007 $GROUP07

useradd -g $GROUP01 -G $GROUP02,$GROUP04,$GROUP05,$GROUP06 -u 1001 $USER01 -d /home/${USER01};echo "${PASSWD01}" | passwd --stdin $USER01

useradd -g $GROUP01 -G $GROUP02,$GROUP03,$GROUP05 -u 1002 $USER02 -d /home/${USER02};echo "${PASSWD02}" | passwd --stdin $USER02

useradd -g $GROUP07 -G $GROUP02 -u 1003 $USER03 -d /home/${USER03};echo "${PASSWD03}" | passwd --stdin $USER03

su - grid -c 'cat >> /home/grid/.bash_profile<< EOF

echo "您好壤蚜，您正在通過grid賬戶登錄系統(tǒng)，此賬戶具有集群權(quán)限详羡，監(jiān)控已經(jīng)啟動仍律，請注意操作風(fēng)險嘿悬！"

EOF'

su - oracle -c 'cat >> /home/oracle/.bash_profile<< EOF

echo "您好实柠，您正在通過oracle賬戶登錄系統(tǒng)，此賬戶具有數(shù)據(jù)庫權(quán)限善涨，監(jiān)控已經(jīng)啟動窒盐，請注意操作風(fēng)險！"

EOF'

su - orawh -c 'cat >> /home/orawh/.bash_profile<< EOF

echo "您好钢拧，您正在通過orawh賬戶登錄系統(tǒng)蟹漓，此賬戶具有數(shù)據(jù)庫權(quán)限，監(jiān)控已經(jīng)啟動源内，請注意操作風(fēng)險葡粒！"

EOF'

USER="oracle"

cp /home/${USER}/.bash_profile /home/${USER}/.bash_profile.bak

cat << 'E'OF >> /home/${USER}/.bash_profile

IPADDR=`ifconfig bond0 | grep "inet addr" | awk '{print $2}' | awk -F ':' '{ print $2}'`

PWD=`pwd`

export PS1='${USER}|${IPADDR}|${PWD}>'

stty erase ^H

EOF

USER="grid"

cp /home/${USER}/.bash_profile /home/${USER}/.bash_profile.bak

cat << 'E'OF >> /home/${USER}/.bash_profile

IPADDR=`ifconfig bond0 | grep "inet addr" | awk '{print $2}' | awk -F ':' '{ print $2}'`

PWD=`pwd`

export PS1='${USER}|${IPADDR}|${PWD}>'

stty erase ^H

EOF

USER="orawh"

cp /home/${USER}/.bash_profile /home/${USER}/.bash_profile.bak

cat << 'E'OF >> /home/${USER}/.bash_profile

IPADDR=`ifconfig bond0 | grep "inet addr" | awk '{print $2}' | awk -F ':' '{ print $2}'`

PWD=`pwd`

export PS1='${USER}|${IPADDR}|${PWD}>'

stty erase ^H

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

export PATH=/usr/sbin:$PATH

export PATH=$ORACLE_HOME/bin:$PATH

export ORACLE_SID=tadb1

EOF

4、ASM共享磁盤設(shè)置膜钓，2節(jié)點嗽交，使用root賬戶

emcpadm renamepseudo -s emcpowero -t emcpowerf

cd /etc/udev/rules.d;touch 99-oracle-asmdisks.rules

scsi_id -g -u -d? /dev/emcpowerx

echo 'KERNEL=="emcpower?", BUS=="*", PROGRAM=="scsi_id -g -u -d? /dev/$name",RESULT=="360060160a7b03400e770b68b9bb6e511", NAME="asmdisk1_200G", OWNER="grid", GROUP="asmadmin", MODE="0660"' >> 99-oracle-asmdisks.rules

/sbin/udevadm control --reload-rules;/sbin/start_udev

5、創(chuàng)建/u01文件系統(tǒng)颂斜，2節(jié)點夫壁，使用root賬戶

SZ="99G";VG="appvg";LV="applv";MN="/u01";mkdir -p /u01

pvcreate /dev/emcpowera;vgcreate appvg /dev/emcpowera;lvcreate -L ${SZ} -n ${LV} ${VG}

mkfs -t ext4? /dev/${VG}/${LV}

mount -t ext4 /dev/mapper/${VG}-${LV} $MN

cp /etc/fstab /etc/fstab.bak

echo "/dev/mapper/${VG}-${LV} /u01 ext4 defaults 0 0" >> /etc/fstab

mkdir -p /u01/app/11.2.0/grid;mkdir -p /u01/app/grid;mkdir -p /u01/app/oracle

chown -R grid:oinstall /u01;chown -R oracle:oinstall /u01/app/oracle

chmod -R 775 /u01/app/grid;chmod -R 775 /u01/app/11.2.0/grid;chmod -R 775 /u01/app/oracle

6、sysctl及l(fā)imit配置沃疮，2節(jié)點盒让，使用root賬戶

cat >> /etc/security/limits.conf << EOF

#user "grid" limits

grid soft nproc 2047

grid hard nproc 16384

grid soft nofile 1024

grid hard nofile 65536

grid soft stack 10240

#user oracle limits

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft stack 10240

EOF

#修改內(nèi)核參數(shù)

sed -i 's/kernel.shmmax/#kernel.shmmax/g' /etc/sysctl.conf

sed -i 's/kernel.shmall/#kernel.shmall/g' /etc/sysctl.conf

cat >> /etc/sysctl.conf << EOF

#Modified Kernel parameter

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 4294967295

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

EOF

sysctl -p

#修改節(jié)點1的grid用戶的環(huán)境變量

su - grid -c 'cat >> /home/grid/.bash_profile<< EOF

#user "grid" Environment variables

export ORACLE_SID=+ASM1

export ORACLE_BASE=/u01/app/grid

export ORACLE_HOME=/u01/app/11.2.0/grid

export NLS_DATE_FORMAT="yy-mm-dd HH24:MI:SS"

export PATH=\$ORACLE_HOME/bin:\$PATH

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

stty erase ^H

#user Prompt

echo ORACLE_BASE=\$ORACLE_BASE

echo ORACLE_HOME=\$ORACLE_HOME

echo ORACLE_SID=\$ORACLE_SID

EOF'

#修改節(jié)點2的grid用戶的環(huán)境變量

su - grid -c 'cat >> /home/grid/.bash_profile<< EOF

#user "grid" Environment variables

export ORACLE_SID=+ASM2

export ORACLE_BASE=/u01/app/grid

export ORACLE_HOME=/u01/app/11.2.0/grid

export NLS_DATE_FORMAT="yy-mm-dd HH24:MI:SS"

export PATH=\$ORACLE_HOME/bin:\$PATH

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

stty erase ^H

#user Prompt

echo ORACLE_BASE=\$ORACLE_BASE

echo ORACLE_HOME=\$ORACLE_HOME

echo ORACLE_SID=\$ORACLE_SID

EOF'

#修改節(jié)點1的oracle用戶的環(huán)境變量

su - oracle -c 'cat>> /home/oracle/.bash_profile<< EOF

#user "oracle" Environment variables

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

export ORACLE_SID=hisdb1

export ORACLE_TERM=xterm

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

export NLS_DATE_FORMAT="yy-mm-dd HH24:MI:SS"

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

stty erase ^H

#user Prompt

echo ORACLE_BASE=\$ORACLE_BASE

echo ORACLE_HOME=\$ORACLE_HOME

echo ORACLE_SID=\$ORACLE_SID

EOF'

#修改節(jié)點2的oracle用戶的環(huán)境變量

su - oracle -c 'cat>> /home/oracle/.bash_profile<< EOF

#user "oracle" Environment variables

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

export ORACLE_SID=hisdb2

export ORACLE_TERM=xterm

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

export NLS_DATE_FORMAT="yy-mm-dd HH24:MI:SS"

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

stty erase ^H

#user Prompt

echo ORACLE_BASE=\$ORACLE_BASE

echo ORACLE_HOME=\$ORACLE_HOME

echo ORACLE_SID=\$ORACLE_SID

EOF'

#安裝必要的程序軟件

yum -y groupinstall 'X Window System'

yum -y install unzip

#grid用戶建立互信關(guān)系

#節(jié)點1

su - grid

ssh-keygen -t rsa

ssh-keygen -t dsa

cd /home/grid/.ssh

cat id_rsa.pub >> authorized_keys

cat id_dsa.pub >> authorized_keys

#節(jié)點2

su - grid

ssh-keygen -t rsa

ssh-keygen -t dsa

#節(jié)點1

scp? authorized_keys grid@10.1.141.37:/home/grid/.ssh

#節(jié)點2

cd /home/grid/.ssh

cat id_rsa.pub >> authorized_keys

cat id_dsa.pub >> authorized_keys

scp? authorized_keys grid@10.1.141.36:/home/grid/.ssh

#節(jié)點1和節(jié)點2

ssh? hisdb1 date

ssh? hisdb2 date

ssh? hisdb1-pri date

ssh? hisdb2-pri date

#oracle用戶建立互信關(guān)系

#節(jié)點1

su - oracle

ssh-keygen -t rsa

ssh-keygen -t dsa

cd /home/oracle/.ssh

cat id_rsa.pub >> authorized_keys

cat id_dsa.pub >> authorized_keys

#節(jié)點2

su - oracle

ssh-keygen -t rsa

ssh-keygen -t dsa

#節(jié)點1

scp authorized_keys oracle@10.1.141.37:/home/oracle/.ssh

#節(jié)點2

cd /home/oracle/.ssh

cat id_rsa.pub >> authorized_keys

cat id_dsa.pub >> authorized_keys

scp authorized_keys oracle@10.1.141.36:/home/oracle/.ssh

#節(jié)點1和節(jié)點2

ssh? hisdb1 date

ssh? hisdb2 date

ssh? hisdb1-pri date

ssh? hisdb2-pri date

yum install -y libaio

yum install -y libaio-devel

yum install -y compat-libstdc++-33

yum install -y elfutils-devel

yum install -y glibc-devel

yum install -y gcc-c++

yum install -y libstdc++-devel

yum install -y sysstat

yum install -y smartmontools

yum install -y compat-libcap1

cd ./grid/rpm

yum install -y cvuqdisk-1.0.9-1.rpm

cd ./grid

./runcluvfy.sh stage -pre crsinst -n hisdb1,hisdb2 -fixup -verbose

#oracle配置

#使能空表導(dǎo)出

alter system set deferred_segment_creation = FALSE;

#修改數(shù)據(jù)庫的游標(biāo)

alter system set open_cursors=1500 scope=both;

#修改快照文件路徑

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+SYSTEM/hisdb/snapcf_hisdb.f';

創(chuàng)建weihu只讀賬戶，擁有select any table/dictionary權(quán)限

create user weihu identified by thfund_weihu01;

grant connect to weihu;

grant select any table to weihu;

grant select any dictionary to weihu;

#創(chuàng)建thsys用戶司蔬，具備dba權(quán)限

create user thsys identified by thfund_thsys01;

grant connect,resource,dba to thsys;

revoke unlimited tablespace from thsys;

#創(chuàng)建業(yè)務(wù)只讀賬戶seluser

create user seluser identified by thfund_seluser2016;

grant connect to seluser;

grant select any table to seluser;

#創(chuàng)建netgain用戶

create user netgain identified by thfund_netgain2016;

grant connect to netgain;

grant select any table to netgain;

grant select any dictionary to netgain;

#創(chuàng)建通用角色general_role

create role general_role;

grant alter session to general_role;

grant create cluster to general_role;

grant create database link to general_role;

grant create procedure to general_role;

grant create sequence to general_role;

grant create session to general_role;

grant create table to general_role;

grant create trigger to general_role;

grant create view to general_role;

grant create synonym to general_role;

grant debug connect session to general_role;

grant create materialized view? to general_role;

#創(chuàng)建目錄

create directory BACKUP as '/backup';

grant read,write on directory BACKUP to user;

#設(shè)置weihu邑茄、sys、system用戶使用上述profile

alter user sys profile DEFAULT;

alter user seluser profile DEFAULT;

alter user netgain profile DEFAULT;

alter user system profile THFUND_PROFILE;

alter user weihu profile THFUND_PROFILE;

alter user thsys profile THFUND_PROFILE;

#數(shù)據(jù)庫審計設(shè)置

alter system set audit_sys_operations=true scope=spfile;

alter system set audit_trail=db scope=spfile;

#修改DEFAUTL profile

ALTER PROFILE DEFAULT LIMIT

PASSWORD_LIFE_TIME UNLIMITED

PASSWORD_GRACE_TIME 7

FAILED_LOGIN_ATTEMPTS 10

PASSWORD_LOCK_TIME UNLIMITED

PASSWORD_VERIFY_FUNCTION NULL;

#修改賬戶的密碼

alter user weihu identified by thfund_weihu01;

alter user system identified by thfund_system01;

alter user thsys identified by thfund_thsys01;

alter user sys identified by thfund_sys2016;

alter user netgain identified by thfund_netgain2016;

alter user seluser identified by thfund_seluser2016;

#升級Opatch

su - root

mv /u01/app/11.2.0/grid/OPatch /u01/app/11.2.0/grid/OPatchbak

mv /u01/app/oracle/product/11.2.0/db_1/OPatch /u01/app/oracle/product/11.2.0/db_1/OPatchbak

cp /tmp/p6880880_112000_Linux-x86-64.zip /u01/app/11.2.0/grid

cd /u01/app/11.2.0/grid/

chown grid:oinstall p6880880_112000_Linux-x86-64.zip

unzip p6880880_112000_Linux-x86-64.zip

chown -R grid:oinstall OPatch

cd OPatch

./opatch version

cp /tmp/p6880880_112000_Linux-x86-64.zip /u01/app/oracle/product/11.2.0/db_1

cd /u01/app/oracle/product/11.2.0/db_1/

chown oracle:oinstall p6880880_112000_Linux-x86-64.zip

unzip p6880880_112000_Linux-x86-64.zip

chown -R oracle:oinstall OPatch

cd OPatch

./opatch version

cd /u01/app/oracle/product/11.2.0/db_1/OPatch/ocm/bin

/u01/app/oracle/product/11.2.0/db_1/OPatch/ocm/bin/emocmrsp

#升級grid db

su - oracle

$ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME

su - root

$ORACLE_HOME/OPatch/opatch auto /tmp/21523375 -ocmrf $ORACLE_HOME/OPatch/ocm/bin/ocm.rsp

su - oracle

cd $ORACLE_HOME/rdbms/admin

sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> STARTUP

SQL> @catbundle.sql psu apply

SQL> QUIT

cd $ORACLE_HOME/rdbms/admin

sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> @utlrp.sql

#升級檢查

su - grid

$ORACLE_HOME/OPatch/opatch lsinv

su - oracle

sqlplus / as sysdba

set line 150

col ACTION_TIME for a30

col ACTION for a8

col NAMESPACE for a8

col VERSION for a10

col BUNDLE_SERIES for a5

col COMMENTS for a20

select * from dba_registry_history;

#修改數(shù)據(jù)文件的大小

alter database datafile '+SYSTEM/hisdb/datafile/users.259.916684405' resize 10G;

alter database datafile '+SYSTEM/hisdb/datafile/undotbs1.258.916684405' resize 10G;

alter database datafile '+SYSTEM/hisdb/datafile/sysaux.257.916684405' resize 10G;

alter database datafile '+SYSTEM/hisdb/datafile/system.256.916684403' resize 10G;

alter database datafile '+SYSTEM/hisdb/datafile/undotbs2.265.916684539' resize 10G;

最后編輯于：2017.12.11 03:53:03

?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請聯(lián)系作者

人面猴
序言：七十年代末俊啼，一起剝皮案震驚了整個濱河市肺缕，隨后出現(xiàn)的幾起案子，更是在濱河造成了極大的恐慌吨些，老刑警劉巖搓谆，帶你破解...
沈念sama閱讀 216,372評論 6贊 498
死咒
序言：濱河連續(xù)發(fā)生了三起死亡事件，死亡現(xiàn)場離奇詭異豪墅，居然都是意外死亡泉手，警方通過查閱死者的電腦和手機，發(fā)現(xiàn)死者居然都...
沈念sama閱讀 92,368評論 3贊 392
救了他兩次的神仙讓他今天三更去死
文/潘曉璐我一進店門偶器，熙熙樓的掌柜王于貴愁眉苦臉地迎上來斩萌，“玉大人缝裤，你說我怎么就攤上這事〖绽桑” “怎么了憋飞？”我有些...
開封第一講書人閱讀 162,415評論 0贊 353
道士緝兇錄：失蹤的賣姜人
文/不壞的土叔我叫張陵，是天一觀的道長姆吭。經(jīng)常有香客問我榛做，道長，這世上最難降的妖魔是什么内狸？我笑而不...
開封第一講書人閱讀 58,157評論 1贊 292
?港島之戀（遺憾婚禮）
正文為了忘掉前任检眯，我火速辦了婚禮，結(jié)果婚禮上昆淡，老公的妹妹穿的比我還像新娘锰瘸。我一直安慰自己，他們只是感情好昂灵，可當(dāng)我...
茶點故事閱讀 67,171評論 6贊 388
惡毒庶女頂嫁案：這布局不是一般人想出來的
文/花漫我一把揭開白布避凝。她就那樣靜靜地躺著，像睡著了一般眨补。火紅的嫁衣襯著肌膚如雪管削。梳的紋絲不亂的頭發(fā)上，一...
開封第一講書人閱讀 51,125評論 1贊 297
城市分裂傳說
那天渤涌，我揣著相機與錄音佩谣，去河邊找鬼。笑死实蓬，一個胖子當(dāng)著我的面吹牛茸俭，可吹牛的內(nèi)容都是我干的。我是一名探鬼主播安皱，決...
沈念sama閱讀 40,028評論 3贊 417
雙鴛鴦連環(huán)套：你想象不到人心有多黑
文/蒼蘭香墨我猛地睜開眼调鬓，長吁一口氣：“原來是場噩夢啊……” “哼！你這毒婦竟也來了酌伊？” 一聲冷哼從身側(cè)響起腾窝，我...
開封第一講書人閱讀 38,887評論 0贊 274
萬榮殺人案實錄
序言：老撾萬榮一對情侶失蹤，失蹤者是張志新（化名）和其女友劉穎居砖，沒想到半個月后虹脯，有當(dāng)?shù)厝嗽跇淞掷锇l(fā)現(xiàn)了一具尸體，經(jīng)...
沈念sama閱讀 45,310評論 1贊 310
?護林員之死
正文獨居荒郊野嶺守林人離奇死亡奏候，尸身上長有42處帶血的膿包…… 初始之章·張勛以下內(nèi)容為張勛視角年9月15日...
茶點故事閱讀 37,533評論 2贊 332
?白月光啟示錄
正文我和宋清朗相戀三年循集，在試婚紗的時候發(fā)現(xiàn)自己被綠了。大學(xué)時的朋友給我發(fā)了我未婚夫和他白月光在一起吃飯的照片蔗草。...
茶點故事閱讀 39,690評論 1贊 348
活死人
序言：一個原本活蹦亂跳的男人離奇死亡咒彤，死狀恐怖疆柔，靈堂內(nèi)的尸體忽然破棺而出，到底是詐尸還是另有隱情镶柱，我是刑警寧澤旷档，帶...
沈念sama閱讀 35,411評論 5贊 343
?日本核電站爆炸內(nèi)幕
正文年R本政府宣布，位于F島的核電站歇拆，受9級特大地震影響鞋屈，放射性物質(zhì)發(fā)生泄漏。R本人自食惡果不足惜查吊，卻給世界環(huán)境...
茶點故事閱讀 41,004評論 3贊 325
男人毒藥：我在死后第九天來索命
文/蒙蒙一谐区、第九天我趴在偏房一處隱蔽的房頂上張望。院中可真熱鬧逻卖，春花似錦、人聲如沸昭抒。這莊子的主人今日做“春日...
開封第一講書人閱讀 31,659評論 0贊 22
一樁弒父案，背后竟有這般陰謀
文/蒼蘭香墨我抬頭看了看天上的太陽灭返。三九已至盗迟，卻和暖如春，著一層夾襖步出監(jiān)牢的瞬間熙含，已是汗流浹背罚缕。一陣腳步聲響...
開封第一講書人閱讀 32,812評論 1贊 268
情欲美人皮
我被黑心中介騙來泰國打工，沒想到剛下飛機就差點兒被人妖公主榨干…… 1. 我叫王不留怎静，地道東北人邮弹。一個月前我還...
沈念sama閱讀 47,693評論 2贊 368
代替公主和親
正文我出身青樓，卻偏偏與公主長得像蚓聘，于是被迫代替她去往敵國和親腌乡。傳聞我的和親對象是個殘疾皇子，可洞房花燭夜當(dāng)晚...
茶點故事閱讀 44,577評論 2贊 353

oracle 11g rac install(linux_x64+udev+asm)

推薦閱讀更多精彩內(nèi)容