Database Quick Installation Guide for Oracle Solaris on SPARC (64-Bit)
1、内存要求
# /usr/sbin/prtconf | grep "Memory size"
Memory size: 65536 Megabytes --这里是64GB。
# /usr/sbin/swap -l
swapfile dev swaplo blocks free
/dev/md/dsk/d2 85,2 16 131074976 131074976 --算下来大概有62GB,每个块等于512字节。
2、软件包要求
# pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibC SUNWlibm SUNWlibms SUNWsprot SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs SUNWxwfnt SUNWcsl
system SUNWarc Lint Libraries (usr)
system SUNWbtool CCS tools bundled with SunOS
system SUNWcsl Core Solaris, (Shared Libs)
system SUNWhea SunOS Header Files
system SUNWi15cs X11 ISO8859-15 Codeset Support
system SUNWi1cs X11 ISO8859-1 Codeset Support
system SUNWi1of ISO-8859-1 (Latin-1) Optional Fonts
system SUNWlibC Sun Workshop Compilers Bundled libC
system SUNWlibm Math & Microtasking Library Headers & Lint Files (Usr)
system SUNWlibms Math & Microtasking Libraries (Usr)
system SUNWsprot Solaris Bundled tools
system SUNWtoo Programming Tools
system SUNWxwfnt X Window System platform required fonts
3、创建用户和组
# mkdir -p /u01/app/oracle
# mkdir -p /u01/app/grid
# groupadd oinstall
# groupadd dba
# groupadd asmdba
# groupadd asmadmin
# useradd -g oinstall -G dba,asmdba,asmadmin -s /usr/bin/bash -d /u01/app/oracle oracle
# passwd oracle
# useradd -g oinstall -G dba,asmdba,asmadmin -s /usr/bin/bash -d /u01/app/grid grid
# passwd grid
# chown -R oracle:oinstall /u01
# chmod -R 775 /u01
# chown grid:oinstall /u01/app/grid
# chown oracle:oinstall /u01/app/oracle
4、配置内核参数
编辑vi /etc/profile 加入:
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
if [ -t 0 ]; then
stty intr ^C
fi
执行以下命令:
# projadd -U oracle -K "project.max-shm-memory=(priv,45g,deny)" user.oracle
# projmod -sK "project.max-sem-nsems=(priv,1024,deny)" user.oracle
# projmod -sK "project.max-sem-ids=(priv,256,deny)" user.oracle
# projmod -sK "project.max-shm-ids=(priv,256,deny)" user.oracle
# projmod -U oracle -sK "process.max-file-descriptor=(priv,65536,deny)" user.oracle
# projmod -U oracle -sK "project.max-msg-ids=(priv,256,deny)" user.oracle
编辑:vi /etc/system 加入如下内容
set noexec_user_stack=1
set semsys:seminfo_semmni=256
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=1024
set semsys:seminfo_semvmx=23767
set shmsys:shminfo_shmmax=55834574848
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=256
set shmsys:shminfo_shmset=10
set rlim_fd_max=65536
set rlim_fd_cur=65536
编辑 vi /etc/rc2.d/S99ndd 加入如下内容
ndd -set /dev/tcp tcp_smallest_anon_port 9000
ndd -set /dev/tcp tcp_largest_anon_port 65500
ndd -set /dev/udp udp_smallest_anon_port 9000
ndd -set /dev/udp udp_largest_anon_port 65500
然后执行以下命令:
#/usr/sbin/ndd -set /dev/tcp tcp_smallest_anon_port 9000
#/usr/sbin/ndd -set /dev/tcp tcp_largest_anon_port 65500
#/usr/sbin/ndd -set /dev/udp udp_smallest_anon_port 9000
#/usr/sbin/ndd -set /dev/udp udp_largest_anon_port 65500
#/usr/sbin/ndd /dev/tcp tcp_smallest_anon_port tcp_largest_anon_port
#/usr/sbin/ndd /dev/udp udp_smallest_anon_port udp_largest_anon_port
# mkdir -p /var/cores
# coreadm -g /var/cores/%f.%n.%p.%t.core -e global -e global-setid -e log -d process -d proc-setid
5、设置oracle用户环境变量
vi .profile
export ORACLE_SID=orcl
export ORACLE_BASE=/u01/app
export ORACLE_HOME=/u01/app/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=.:$PATH:$HOME/bin:$ORACLE_HOME/bin
export NLS_LANG='SIMPLIFIED CHINESE_CHINA.ZHS16GBK'
umask 022
stty erase ^h
ulimit -s 32768
ulimit -n 65536
6、设置grid用户环境变量
vi .profile
export ORACLE_SID=+ASM
export ORACLE_BASE=/u01/app
export ORACLE_HOME=/u01/app/grid
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=.:$PATH:$HOME/bin:$ORACLE_HOME/bin
export NLS_LANG='SIMPLIFIED CHINESE_CHINA.ZHS16GBK'
umask 022
stty erase ^h
ulimit -s 32768
ulimit -n 65536
7、最重要的一步,在solaris下面格式话磁盘
首先看一下,我们要装的服务器上面的磁盘:
# format
Searching for disks...done
c4t600000E00D1100000011098C000A0000d0: configured with capacity of 1431.93GB
c4t600000E00D1100000011098C000B0000d0: configured with capacity of 1431.93GB
c4t600000E00D1100000011098C000C0000d0: configured with capacity of 1431.93GB
c4t600000E00D1100000011098C000D0000d0: configured with capacity of 1431.93GB
c4t600000E00D1100000011098C000E0000d0: configured with capacity of 1431.93GB
c4t600000E00D1100000011098C000F0000d0: configured with capacity of 1431.93GB
c4t600000E00D1100000011098C00000000d0: configured with capacity of 4.98GB
c4t600000E00D1100000011098C00010000d0: configured with capacity of 4.98GB
c4t600000E00D1100000011098C00020000d0: configured with capacity of 198.98GB
c4t600000E00D1100000011098C00030000d0: configured with capacity of 198.98GB
c4t600000E00D1100000011098C00040000d0: configured with capacity of 1431.93GB
c4t600000E00D1100000011098C00050000d0: configured with capacity of 1431.93GB
c4t600000E00D1100000011098C00060000d0: configured with capacity of 1431.93GB
c4t600000E00D1100000011098C00070000d0: configured with capacity of 1431.93GB
c4t600000E00D1100000011098C00080000d0: configured with capacity of 1431.93GB
c4t600000E00D1100000011098C00090000d0: configured with capacity of 1431.93GB
c4t600000E00D1100000011098C00100000d0: configured with capacity of 1431.93GB
c4t600000E00D1100000011098C00110000d0: configured with capacity of 1431.93GB
AVAILABLE DISK SELECTIONS:
0. c0t0d0 <SUN300G cyl 46873 alt 2 hd 20 sec 625>
/pci@0,600000/pci@0/pci@8/pci@0/scsi@1/sd@0,0
1. c0t1d0 <SUN300G cyl 46873 alt 2 hd 20 sec 625>
/pci@0,600000/pci@0/pci@8/pci@0/scsi@1/sd@1,0
2. c1t0d0 <SUN300G cyl 46873 alt 2 hd 20 sec 625>
/pci@10,600000/pci@0/pci@8/pci@0/scsi@1/sd@0,0
3. c1t1d0 <SUN300G cyl 46873 alt 2 hd 20 sec 625>
/pci@10,600000/pci@0/pci@8/pci@0/scsi@1/sd@1,0
4. c4t600000E00D1100000011098C000A0000d0 <FUJITSU-ETERNUS_DXL-0000 cyl 62309 alt 2 hd 255 sec 189>
/scsi_vhci/ssd@g600000e00d1100000011098c000a0000
5. c4t600000E00D1100000011098C000B0000d0 <FUJITSU-ETERNUS_DXL-0000 cyl 62309 alt 2 hd 255 sec 189>
/scsi_vhci/ssd@g600000e00d1100000011098c000b0000
6. c4t600000E00D1100000011098C000C0000d0 <FUJITSU-ETERNUS_DXL-0000 cyl 62309 alt 2 hd 255 sec 189>
/scsi_vhci/ssd@g600000e00d1100000011098c000c0000
7. c4t600000E00D1100000011098C000D0000d0 <FUJITSU-ETERNUS_DXL-0000 cyl 62309 alt 2 hd 255 sec 189>
/scsi_vhci/ssd@g600000e00d1100000011098c000d0000
8. c4t600000E00D1100000011098C000E0000d0 <FUJITSU-ETERNUS_DXL-0000 cyl 62309 alt 2 hd 255 sec 189>
/scsi_vhci/ssd@g600000e00d1100000011098c000e0000
9. c4t600000E00D1100000011098C000F0000d0 <FUJITSU-ETERNUS_DXL-0000 cyl 62309 alt 2 hd 255 sec 189>
/scsi_vhci/ssd@g600000e00d1100000011098c000f0000
10. c4t600000E00D1100000011098C00000000d0 <FUJITSU-ETERNUS_DXL-0000 cyl 638 alt 2 hd 64 sec 256>
/scsi_vhci/ssd@g600000e00d1100000011098c00000000
11. c4t600000E00D1100000011098C00010000d0 <FUJITSU-ETERNUS_DXL-0000 cyl 638 alt 2 hd 64 sec 256>
/scsi_vhci/ssd@g600000e00d1100000011098c00010000
12. c4t600000E00D1100000011098C00020000d0 <FUJITSU-ETERNUS_DXL-0000 cyl 25470 alt 2 hd 64 sec 256>
/scsi_vhci/ssd@g600000e00d1100000011098c00020000
13. c4t600000E00D1100000011098C00030000d0 <FUJITSU-ETERNUS_DXL-0000 cyl 25470 alt 2 hd 64 sec 256>
/scsi_vhci/ssd@g600000e00d1100000011098c00030000
14. c4t600000E00D1100000011098C00040000d0 <FUJITSU-ETERNUS_DXL-0000 cyl 62309 alt 2 hd 255 sec 189>
/scsi_vhci/ssd@g600000e00d1100000011098c00040000
15. c4t600000E00D1100000011098C00050000d0 <FUJITSU-ETERNUS_DXL-0000 cyl 62309 alt 2 hd 255 sec 189>
/scsi_vhci/ssd@g600000e00d1100000011098c00050000
16. c4t600000E00D1100000011098C00060000d0 <FUJITSU-ETERNUS_DXL-0000 cyl 62309 alt 2 hd 255 sec 189>
/scsi_vhci/ssd@g600000e00d1100000011098c00060000
17. c4t600000E00D1100000011098C00070000d0 <FUJITSU-ETERNUS_DXL-0000 cyl 62309 alt 2 hd 255 sec 189>
/scsi_vhci/ssd@g600000e00d1100000011098c00070000
18. c4t600000E00D1100000011098C00080000d0 <FUJITSU-ETERNUS_DXL-0000 cyl 62309 alt 2 hd 255 sec 189>
/scsi_vhci/ssd@g600000e00d1100000011098c00080000
19. c4t600000E00D1100000011098C00090000d0 <FUJITSU-ETERNUS_DXL-0000 cyl 62309 alt 2 hd 255 sec 189>
/scsi_vhci/ssd@g600000e00d1100000011098c00090000
20. c4t600000E00D1100000011098C00100000d0 <FUJITSU-ETERNUS_DXL-0000 cyl 62309 alt 2 hd 255 sec 189>
/scsi_vhci/ssd@g600000e00d1100000011098c00100000
21. c4t600000E00D1100000011098C00110000d0 <FUJITSU-ETERNUS_DXL-0000 cyl 62309 alt 2 hd 255 sec 189>
/scsi_vhci/ssd@g600000e00d1100000011098c00110000
Specify disk (enter its number):
说明:
可以看见上面有18块磁盘是给数据库用的,磁阵划分:2*5G,2*199G,14*1432G。
2*5G 这个是在装rac的时候用来放OCR的。
2*199G 这个是用来放rredo的。
14*1432G 这个是用来放数据文件等等的。
8、分别格式化这个18个磁盘。
参考:http://blog.csdn.net/zq9017197/article/details/7335000
http://blog.csdn.net/zq9017197/article/details/7335003
# pwd
/dev/rdsk
# chown oracle:oinstall c4t600000E00D1100000011098C* #注意这里要给所有的裸设备修改权限,这样asm才能够识别。
# chmod 660 c4t600000E00D1100000011098C*
9、下面开始安装
1)安装grid infrastructure
2)安装database
3)创建ASM磁盘组asmca
4)创建数据库dbca