AIX5.3裸设备上安装ORACLE10g

AIX5.3裸设备上安装ORACLE10g

 

一、检查系统信息

# oslevel -r   5300-11   # prtconf | grep -i mem   Memory Size: 23648 MB Good Memory Size: 23648 MB + mem0?????????????????????????????????????????? Memory # lsattr -El mem0   # bootinfo -K 64 #lsps –a #lsps –s

二、查看软件包和安装补丁

# lslpp -l |grep bos.adt   # lslpp -l |grep -i xlc.rte   # lslpp -l |grep -i xlc   # lslpp -l |grep -i bos.perf   Aix上的oracle10g需要下面的软件包   Bos.adt.base   Bos.adt.lib   Bos.adt.libm   Bos.pref.libperfstat   Bos.perf.perfstat   Bos.perf.proctools   Xlc.aix50.rte   xlC.rte   下面查看补丁   # instfix -ik IY58143   # instfix -ik IY59386   # instfix -ik IY60930   # instfix -ik IY66513   # instfix -ik IY70159   # instfix -ik IY68989  

三、建立用户和组

建立用户组和用户 Groups:oinstall、dba   Users:oracle

四、配置环境变量文件

vi .profile     ORACLE_BASE=/oracle   ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db1   ORACLE_SID=iseal   PATH=$PATH:$ORACLE_HOME/bin   export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH   export DBCA_CONFIG=/home/oracle/raw_mp

五、使用现有vg创建逻辑卷

#lsvg dbvg 看到PP SIZE:512 megabyte(s) 即512M，下面的1就是1PP也就是512M # mklv -y 'control01' -t 'raw' dbvg 1 control01 # mklv -y 'control02' -t 'raw' dbvg 1 control02 # mklv -y 'control03' -t 'raw' dbvg 1 control03 # mklv -y 'redo01' -t 'raw' dbvg 2 redo01 #? mklv -y 'redo02' -t 'raw' dbvg 2 redo02 # mklv -y 'redo03' -t 'raw' dbvg 2 redo03 # mklv -y 'sysaux' -t 'raw' dbvg 3 sysaux #? mklv -y 'system' -t 'raw' dbvg 3 system # mklv -y 'temp' -t 'raw' dbvg 10 temp # mklv -y 'undotbs' -t 'raw' dbvg 10 undotbs # mklv -y 'users' -t 'raw' dbvg 60 users # mklv -y 'spfile' -t 'raw' dbvg 1 Spfile

六、创建裸设备和oracle数据文件的映射文件

su - oracle cd ~ mkdir? /oracle/oradata/iseal cat raw_mp control1=/oracle/oradata/iseal/control01.ctl control2=/oracle/oradata/iseal/control02.ctl control3=/oracle/oradata/iseal/control03.ctl redo1_1=/oracle/oradata/iseal/redo01.log redo1_2=/oracle/oradata/iseal/redo02.log redo1_3=/oracle/oradata/iseal/redo03.log sysaux=/oracle/oradata/iseal/sysaux01.dbf system=/oracle/oradata/iseal/system01.dbf temp=/oracle/oradata/iseal/temp01.dbf undotbs=/oracle/oradata/iseal/undotbs01.dbf users=/oracle/oradata/iseal/users01.dbf spfile=/oracle/product/10.2.0/db1/dbs/spfileiseal.ora 需要注意：并非所有的标识DBCA都能识别出来，比如之前的redo02_1重做日志文件，DBCA就不会自动识别，任然需要手动来添加。

七、配置裸设备权限

root执行   # chown oracle:oinstall /dev/rcontrol01 #? chown oracle:oinstall /dev/rcontrol02 # chown oracle:oinstall /dev/rcontrol03 # chown oracle:oinstall /dev/rredo01 # chown oracle:oinstall /dev/rredo02 # chown oracle:oinstall /dev/rredo03 # chown oracle:oinstall /dev/rsysaux # chown oracle:oinstall /dev/rsystem # chown oracle:oinstall /dev/rspfile # chown oracle:oinstall /dev/rtemp # chown oracle:oinstall /dev/rundotbs # chown oracle:oinstall /dev/rusers #cd /dev # ls -l |grep oracle crw-rw----??? 1 oracle?? oinstall???? 80,? 4 Sep 29 11:07 rcontrol01 crw-rw----??? 1 oracle?? oinstall???? 80,? 5 Sep 29 11:08 rcontrol02 crw-rw----??? 1 oracle?? oinstall???? 80,? 6 Sep 29 11:08 rcontrol03 crw-rw----??? 1 oracle?? oinstall???? 80,? 7 Sep 29 11:09 rredo01 crw-rw----??? 1 oracle?? oinstall???? 80,? 8 Sep 29 11:09 rredo02 crw-rw----??? 1 oracle?? oinstall???? 80,? 9 Sep 29 11:10 rredo03 crw-rw----??? 1 oracle?? oinstall???? 80, 10 Sep 29 11:11 rsysaux crw-rw----??? 1 oracle?? oinstall???? 80, 11 Sep 29 11:11 rsystem crw-rw----??? 1 oracle?? oinstall???? 80, 12 Sep 29 11:12 rtemp crw-rw----??? 1 oracle?? oinstall???? 80, 13 Sep 29 11:12 rundotbs crw-rw----??? 1 oracle?? oinstall???? 80, 14 Sep 29 11:13 rusers crw-rw----??? 1 oracle?? oinstall???? 80, 16 Sep 29 11:38 rspfile  

八、给裸设置创建链接（用r开头的设备）

#su – oracle $ ln -s /dev/rcontrol01 /oracle/oradata/iseal/control01.ctl $ ln -s /dev/rcontrol02 /oracle/oradata/iseal/control02.ctl $ ln -s /dev/rcontrol03 /oracle/oradata/iseal/control03.ctl $ ln -s /dev/rredo01 /oracle/oradata/iseal/redo01.log $ ln -s /dev/rredo02 /oracle/oradata/iseal/redo02.log $ ln -s /dev/rredo03 /oracle/oradata/iseal/redo03.log $ ln -s /dev/rsysaux /oracle/oradata/iseal/sysaux01.dbf $ ln -s /dev/rsystem /oracle/oradata/iseal/system01.dbf $ ln -s /dev/rtemp /oracle/oradata/iseal/temp01.dbf $ ln -s /dev/rundotbs /oracle/oradata/iseal/undotbs01.dbf $ ln -s /dev/rusers /oracle/oradata/iseal/users01.dbf $ ln -s /dev/rspfile /oracle/product/10.2.0/db1/dbs/spfileiseal.ora

九、DBCA建库

存储选项中选第三项，RAC设备 选择创建的raw_mp文件 后面跟普通的创建数据库步骤一样。