上个月,应该算是一个较为忙碌的工作月。其中:
1 公事的一DBA同事离职,所有的数据库这块全部压到我1个人的身上,要看的库多了,任务重了,有些库也只能做到粗犷式管理了;
2 出差2次,月初1次到上海,月末1次同样到上海;2次差旅虽说都是现场实施Oracle数据库环境的搭建,但都不是很顺利,究其原因:①项目前期同客户需求、准备工作都很有问题。如去之前,问项目组人员是实施RAC的数据库还是配置单实例的库,告知于我是单实例的库,结果一到客户现场方知是实施RAC的数据库;②个人的技术经验匮乏的短板也暴露的很明显了,尤其是存储方面的知识;
3 快速记录这2次出差上海解决问题的方法:
① 月初去上海某客户遇到的问题,客户环境采用Dell R910单台服务器,存储采用Dell MD 3200。在阵列的管理界面将存储映射到主机时,发现找不到主机,原因:犯的是低级错误,Dell MD 3200 支持级联扩展存储,误将主机的SAS卡插到阵列上的SAS OUT扩展口上,而应该将其连接到阵列上的SAS IN口。其次,在做好阵列之后,重启主机、阵列之后,发现主机依然无法找到对应的LUN,解决方法:注释掉/etc/udev/rules.d/90-dm.rules配置文件。
②第2次去上海另1客户实施RAC时,同样碰到存储的问题。只是这次的主机是2台IBM X3650M3,存储是IBM System Storage DS3500磁盘阵列柜。在阵列上做好LUN并映射到主机后,还是不能正常发现存储设备,解决办法是安装IBM提供的RDAC补丁包。下述,记录安装RDAC软件包的过程,该软件包需要到IBM官方网站下载对应的操作系统版本和阵列型号的补丁。
–
[root@node1 ~]# cd linuxrdac-09.03.0C05.0638/ [root@node1 linuxrdac-09.03.0C05.0638]# ll total 1780 -r-xr-xr-x 1 root root 73 Apr 18 04:31 bootMpp26p.sh drwxr-xr-x 2 root root 4096 Apr 18 04:31 dracutsetup -r-xr-xr-x 1 root root 3808 Apr 18 04:31 genfileattributes -r--r--r-- 1 root root 2603 Apr 18 04:31 genuniqueid.c -r--r--r-- 1 root root 2603 Apr 18 04:31 hbaCheck -r--r--r-- 1 root root 15136 Apr 18 04:31 License.txt -r-xr-xr-x 1 root root 6592 Apr 18 04:31 lsvdev -r--r--r-- 1 root root 22991 Apr 18 04:31 Makefile -r--r--r-- 1 root root 150075 Apr 18 04:31 mppCmn_s2tos3.c -r--r--r-- 1 root root 21321 Apr 18 04:31 mppCmn_SysInterface.c -r--r--r-- 1 root root 814 Apr 18 04:31 mpp.conf -r--r--r-- 1 root root 520094 Apr 18 04:31 MPP_hba.c -r-xr-xr-x 1 root root 5155 Apr 18 04:31 mppiscsi_umountall drwxr-xr-x 2 root root 4096 Apr 18 04:31 mpp_linux_headers drwxr-xr-x 2 root root 4096 Apr 18 04:31 mpp_linux_sys_headers -r--r--r-- 1 root root 57111 Apr 18 04:31 mppLnx26p_sysdep.c -r--r--r-- 1 root root 175028 Apr 18 04:31 mppLnx26p_upper.c -r--r--r-- 1 root root 206555 Apr 18 04:31 mppLnx26p_vhba.c -r--r--r-- 1 root root 185100 Apr 18 04:31 mppLnx26p_vhbaio.c -r--r--r-- 1 root root 95675 Apr 18 04:31 mppLnx26p_vhbalib.c -r--r--r-- 1 root root 21610 Apr 18 04:31 mppLnx26p_vhbamisc.c -r--r--r-- 1 root root 33709 Apr 18 04:31 mppLnx26p_vhbaproc.c -r--r--r-- 1 root root 120597 Apr 18 04:31 mppLnx26p_vhbatask.c -r--r--r-- 1 root root 1805 Apr 18 04:31 mpp_rcscript.REDHAT -r--r--r-- 1 root root 1903 Apr 18 04:31 mpp_rcscript.SUSE -r-xr-xr-x 1 root root 28522 Apr 18 04:31 mppSupport -r--r--r-- 1 root root 24245 Apr 18 04:31 Readme.txt -rw-r--r-- 1 root root 5559 Apr 18 04:31 setupDriver.REDHAT -r--r--r-- 1 root root 8984 Apr 18 04:31 setupDriver.SUSE -r--r--r-- 1 root root 261 Apr 18 04:31 setupMpp26p.sh drwxr-xr-x 2 root root 4096 Apr 18 04:31 utility [root@node1 linuxrdac-09.03.0C05.0638]# make make[1]: Entering directory `/usr/src/kernels/2.6.18-194.el5-x86_64' CC [M] /root/linuxrdac-09.03.0C05.0638/MPP_hba.o CC [M] /root/linuxrdac-09.03.0C05.0638/mppLnx26p_upper.o CC [M] /root/linuxrdac-09.03.0C05.0638/mppLnx26p_sysdep.o CC [M] /root/linuxrdac-09.03.0C05.0638/mppCmn_s2tos3.o CC [M] /root/linuxrdac-09.03.0C05.0638/mppCmn_SysInterface.o CC [M] /root/linuxrdac-09.03.0C05.0638/mppLnx26p_vhbamisc.o CC [M] /root/linuxrdac-09.03.0C05.0638/mppLnx26p_vhbatask.o CC [M] /root/linuxrdac-09.03.0C05.0638/mppLnx26p_vhba.o CC [M] /root/linuxrdac-09.03.0C05.0638/mppLnx26p_vhbaproc.o CC [M] /root/linuxrdac-09.03.0C05.0638/mppLnx26p_vhbalib.o CC [M] /root/linuxrdac-09.03.0C05.0638/mppLnx26p_vhbaio.o /root/linuxrdac-09.03.0C05.0638/mppLnx26p_vhbaio.c: In function a€?__mppLnx_scsi_donea€?: /root/linuxrdac-09.03.0C05.0638/mppLnx26p_vhbaio.c:3691: warning: label a€?donea€? defined but not used LD [M] /root/linuxrdac-09.03.0C05.0638/mppUpper.o LD [M] /root/linuxrdac-09.03.0C05.0638/mppVhba.o Building modules, stage 2. MODPOST CC /root/linuxrdac-09.03.0C05.0638/mppUpper.mod.o LD [M] /root/linuxrdac-09.03.0C05.0638/mppUpper.ko CC /root/linuxrdac-09.03.0C05.0638/mppVhba.mod.o LD [M] /root/linuxrdac-09.03.0C05.0638/mppVhba.ko make[1]: Leaving directory `/usr/src/kernels/2.6.18-194.el5-x86_64' make[1]: Entering directory `/usr/src/kernels/2.6.18-194.el5-x86_64' Building modules, stage 2. MODPOST make[1]: Leaving directory `/usr/src/kernels/2.6.18-194.el5-x86_64' gcc -I/root/linuxrdac-09.03.0C05.0638 -I/root/linuxrdac-09.03.0C05.0638/mpp_linux_headers/ -I/root/linuxrdac-09.03.0C05.0638/mpp_linux_sys_headers/ -c ./utility/mppUtil.c -o mppUtil.o /bin/bash ./genfileattributes bld gcc -I/root/linuxrdac-09.03.0C05.0638 -I/root/linuxrdac-09.03.0C05.0638/mpp_linux_headers/ -I/root/linuxrdac-09.03.0C05.0638/mpp_linux_sys_headers/ -c ./utility/mppUtil26p_sysdep.c -o mppUtilSysdep.o gcc mppUtil.o mppUtilSysdep.o -o mppUtil gcc -o genuniqueid genuniqueid.c [root@node1 linuxrdac-09.03.0C05.0638]# make install make[1]: Entering directory `/root/linuxrdac-09.03.0C05.0638' make[2]: Entering directory `/usr/src/kernels/2.6.18-194.el5-x86_64' Building modules, stage 2. MODPOST make[2]: Leaving directory `/usr/src/kernels/2.6.18-194.el5-x86_64' make[2]: Entering directory `/usr/src/kernels/2.6.18-194.el5-x86_64' Building modules, stage 2. MODPOST make[2]: Leaving directory `/usr/src/kernels/2.6.18-194.el5-x86_64' /bin/bash ./genfileattributes bld gcc -I/root/linuxrdac-09.03.0C05.0638 -I/root/linuxrdac-09.03.0C05.0638/mpp_linux_headers/ -I/root/linuxrdac-09.03.0C05.0638/mpp_linux_sys_headers/ -c ./utility/mppUtil26p_sysdep.c -o mppUtilSysdep.o gcc mppUtil.o mppUtilSysdep.o -o mppUtil Checking Host Adapter Configuration... Detected 1 Emulex Host Adapter Port(s) on the system Please wait while we modify the system configuration files. Your kernel version is 2.6.18-194.el5 Preparing to install MPP driver against this kernel version... Generating module dependencies... Creating new MPP initrd image... You must now edit your boot loader configuration file, /boot/grub/menu.lst, to add a new boot menu, which uses mpp-2.6.18-194.el5.img as the initrd image. Now Reboot the system for MPP to take effect. The new boot menu entry should look something like this (note that it may vary with different system configuration): ... title Red Hat Linux (2.6.18-194.el5) with MPP support root (hd0,5) kernel /vmlinuz-2.6.18-194.el5 ro root=LABEL=RH9 initrd /mpp-2.6.18-194.el5.img ... MPP driver package has been successfully installed on your system. make[1]: Leaving directory `/root/linuxrdac-09.03.0C05.0638' [root@node1 linuxrdac-09.03.0C05.0638]#
4 问题得以解决,也深知自己存在的问题!送给自己一句话以自勉:革命尚未成功,同志仍需努力!