OCP_08

1.GI+ASM


10 --asm 
11 --GI+asm
RAC---&gtGI, (db software)---db one instance / RAC , dbca/netca

--------------------------------------------
1.add disk 
fdisk /dev/sdb
mkfs.ext3 /dev/sdb1
mount /dev/sdb1 /u03
二选一
 cat /etc/fstab 
/dev/sdb1              /u03                     ext3    defaults        0 0 
cat /etc/rc.local 
mount /dev/sdb1 /u03

2.
注意：因之前平台上安装了ORACLE,所以有很多步骤省略了没有做（装oracle软件的前的环境配置都需要配）

rpm包

本地yum

--------ASM RPM 
http://www.oracle.com/technetwork/server-storage/linux/downloads/rhel5-084877.html
uname -r
2.6.18-164.el5


oracleasm-2.6.18-164.el5-2.0.5-1.el5.i686.rpm --此包一定要和内核版本一致
rpm -ivh *.rpm
warning: oracleasm-2.6.18-164.el5-2.0.5-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
   1:oracleasm-support      ########################################### [ 33%]
   2:oracleasm-2.6.18-164.el########################################### [ 67%]
   3:oracleasmlib           ########################################### [100%]


--oracle(db) , grid (GI)
--create user, group
groupadd -g 1020 asmadmin
groupadd -g 1021 asmdba
groupadd -g 1022 asmoper
useradd -g oinstall -G dba,asmadmin,asmdba,asmoper grid


vi /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240




grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
grid soft stack 10240


--create direcotry
mkdir -p /u03/app/grid
mkdir -p /u03//app/11.2.0/grid
chown -R grid:oinstall /u03
chmod -R 775 /u03


oracleasm configure -i
Configuring the Oracle ASM library driver.


This will configure the on-boot properties of the Oracle ASM library
driver.  The following questions will determine whether the driver is
loaded on boot and what permissions it will have.  The current values
will be shown in brackets ('[]').  Hitting without typing an
answer will keep that current value.  Ctrl-C will abort.


Default user to own the driver interface []: grid
Default group to own the driver interface []: oinstall
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done



模拟测试，需要两块网卡


#public ip
192.168.1.199 gi
#private ip 
192.168.198.132 gi_pri
#vip
192.168.1.253 gi_vip
#scan ip
192.168.1.252 gi_sca


--enable core file creation 
/etc/profile
ulimit -S -c unlimited > /dev/null 2>&1
/etc/sysctl.conf
kernel.core_uses_pid = 1
fs.suid_dumpable=1




---关闭ntpd
service ntpd stop 
Shutting down ntpd: [FAILED]
[root@lidandan app]# chkconfig --list| grep   ntpd 
ntpd            0:off   1:off   2:off   3:off   4:off   5:off   6:off




crsctl check ctss


------------------
配置信任关系


两台机器分别：
ssh-keygen  -t dsa
ssh-keygen  -t rsa


cat ~/.ssh/id_rsa.pub  > ~/.ssh/authorized_keys
cat ~/.ssh/id_dsa.pub  >> ~/.ssh/authorized_keys


cat ~/.ssh/id_rsa.pub  > ~/.ssh/authorized_keys
cat ~/.ssh/id_dsa.pub  >> ~/.ssh/authorized_keys


在一台机器上： 
--242
scp  ~/.ssh/authorized_keys grid@192.168.1.199:~


--199


cat ~/authorized_keys  >> ~/.ssh/authorized_keys


scp  ~/.ssh/authorized_keys grid@192.168.1.242:~


-------------------------------------------------------
[root@gi ~]# oracleasm configure -i
Configuring the Oracle ASM library driver.


This will configure the on-boot properties of the Oracle ASM library
driver.  The following questions will determine whether the driver is
loaded on boot and what permissions it will have.  The current values
will be shown in brackets ('[]').  Hitting without typing an
answer will keep that current value.  Ctrl-C will abort.


Default user to own the driver interface [grid]: 
Default group to own the driver interface [oinstall]: 
Start Oracle ASM library driver on boot (y/n) [y]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
You have new mail in /var/spool/mail/root


[root@gi dev]# oracleasm  init
Creating /dev/oracleasm mount point: /dev/oracleasm
Loading module "oracleasm": oracleasm
Mounting ASMlib driver filesystem: /dev/oracleasm
[root@gi dev]# oracleasm  createdisk data /dev/sdb2
Writing disk header: done
Instantiating disk: done


oracleasm listdisks
oracleasm  scandisks




[root@gi disks]# pwd
/dev/oracleasm/disks
[root@gi disks]# ls
DATA




GI


os GI(LISTENER)  DB SOFTWARE , DBCA NETCA


grid --&gt delete , add  


oracle --&gtLISTENER delete 
grid ---&gt add




install db software 
dbca


-----------------------------------------------------------------------------


ASM
1.install rpm
 1:oracleasm-support
 2:oracleasm-2.6.18-164.el ---一定要和内核匹配（uname -r ）
 3:oracleasmlib  


2. oracleasm configure -i ---指定用户和组
   oracleasm  init
   oracleasm  createdisk data /dev/sdb1  --asmdisk
   oracleasm  createdisk data1 /dev/sdb2 --asmdisk
   oracleasm  createdisk data2 /dev/sdc ---asmdisk 
   oracleasm listdisks
   oracleasm scandisks  ---RAC,在一个节点，其他节点需要执行此命令扫描出来
   


3. add asm diskgroup


*建议将table和index放在一个diskgroup里，不要分太多diskgroup。


DATA_DG--table,index,redologfile, controfile


add ,重新平衡


FRA_DG--archivelog,redologfile, controfile
--add asm disk
--create diskgroup
oracleasm createdisk data2 '/dev/sdb4'
oracleasm querydisk -p data2
grid user:asmca


--create new diskgroup
create diskgroup fra  external redundancy disk 'ORCL:DATA2'


*RAC环境，命令方式，在一个节点加好后，在其他节点手工mount,alter diskgroup fra mount; ASM_DISKGROUPS = data,fra 
(图形化不需要)


--old diskgroup add asmdisk
alter diskgroup data add disk 'ORCL:DATA3';
alter diskgroup  data rebalance power 5;
vs
alter diskgroup data add disk 'ORCL:DATA3' rebalance power 5;


asm instance ;
export ORACLE_SID=+ASM
sqlplus / as sysasm
shutdown immediate;
startup;




desc v$asm_diskgroup;
desc v$asm_disk;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29500582/viewspace-1097157/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29500582/viewspace-1097157/