开启辅助访问

Bo's Oracle Station

Bo's Oracle Station»社区 › 培训进行时（结课后图标变灰，但是欢迎继续发帖！） › 10006-11g管理类OCP认证班第四期（2017第二轮重开班） › 课程第2/3/4/5/6次（2017-02-28星期二, 2017-03-04星期 ...
返回列表 发新帖
查看: 2348|回复: 0

课程第2/3/4/5/6次（2017-02-28星期二, 2017-03-04星期六上下午和2017-03-05星期日晚上和2017-03-06星期一）

[复制链接]
botang

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2017-3-1 10:52:30 | 显示全部楼层 |阅读模式
本帖最后由 botang 于 2017-3-13 10:45 编辑

上完1Z0-052第2章：安装软件OUI
1Z0-051共12章（上完0章），1Z0-052共19章（上完1章），1Z0-053共21章（上完0章）
总共上完全部52章中的1章


课程中所作的事情:
1. 推完OCP机器
2. 验证OCP机器
以oracle用户执行:

  1. crs_stat -t
复制代码
  1. emctl status dbconsole
复制代码
3. 利用课程间隙，安装windows上的oracle 11gR2软件（仅安装软件，不建库）
4. 在windows上利用Net Manager配置网络的本地命名方式，并用PL/SQL Developer连接推完OCP机器
在PL/SQL Developer中执行（sys登录）
  1. select * from dba_users;
复制代码
5. 介绍1Z0-052课程幻灯的第2章

6. 准备安装最后一台机器（catalog机器），为了演示从裸机开始安装，请预习以下的kickstart文件：

  1. #####
  2. ##### Name: workstationmain.cfg for rhel5
  3. ##### Type: Kickstart Configuration File
  4. ##### Depends on: parts of botang-config-push
  5. ##### Version: BCP-PARTS-TAG20101021-V9.21
  6. #####

  8. ##########################################################################
  9. #
  10. # sample workstation install script
  11. # RHEL4
  12. # $Id: workstation.cfg,v 1.1.2.3 2007/10/10 19:35:18 mcurry Exp $
  13. # RHCX: Customize keyboard, lang, langsupport, mouse, time, and DEVICE
  14. # (both %pre and %post) as appropriate
  15. #
  16. ##########################################################################

  18. ####
  19. #### 1 Main Begin
  20. ### 1.1 Text,Key,Keyboard,Lang,Net Begin
  21. ###

  23. text
  24. key --skip
  25. keyboard us
  26. lang en_US
  27. langsupport --default en_US en_US
  28. network --bootproto dhcp
  29. nfs --server=192.168.0.254 --dir=/var/ftp/pub
  30. # url --url ftp://server1.example.com/pub

  32. ### 1.1 Text,Key,Keyborad,Lang,Net End
  33. ### 1.2 Partition Begin
  34. ###

  36. # Partition 19028M
  37. %include /tmp/partitioning

  39. ###
  40. ### 1.2 Partition End
  41. ### 1.3 Timezone,X,passwd,security,bootloader Begin
  42. ###

  44. #mouse genericps/2 --emulthree
  45. #mouse generic3ps/2
  46. #mouse genericwheelusb --device input/mice
  47. timezone Asia/Shanghai --utc
  48. #timezone US/Central --utc
  49. #timezone US/Mountain --utc
  50. #timezone US/Pacific --utc

  52. # When probed, some monitors return strings that wreck havoc (not
  53. # Pennington) with the installer. You can indentify this condition
  54. # by an early failure of the workstation kickstart just prior to when
  55. # it would ordinarily raise the installer screen after probing. There
  56. # will be some nasty python spew.
  57. # In this situation, comment the xconfig line below, then uncomment
  58. # the skipx line. Next, uncomment the lines beneath #MY X IS BORKED
  59. xconfig --resolution=1280x1024 --depth=16 --startxonboot
  60. #skipx
  61. rootpw redhat
  62. authconfig --useshadow --enablemd5
  63. firewall --disabled
  64. bootloader
  65. reboot

  67. ###
  68. ### 1.3 Timezone,X,passwd,security,bootloader End
  69. #### 1 Main End
  70. #### 2 Paclages Begin
  71. ####

  73. %packages
  74. @ GNOME Desktop Environment
  75. @ X Window System
  76. @ Printing Support
  77. # KDE is huge...install it if you wish
  78. #@ KDE
  79. @ Development Libraries
  80. @ Development Tools
  81. #@ Windows File Server
  82. #@ Web Server
  83. elinks
  84. openssh
  85. openssh-server
  86. openssh-clients
  87. vim-enhanced
  88. samba-common
  89. samba-client
  90. gimp
  91. gimp-data-extras
  92. enscript
  93. libcap
  94. ntp
  95. coreutils
  96. elfutils
  97. elfutils-libelf
  98. gimp-print-plugin
  99. gnome-icon-theme
  100. gstreamer
  101. gstreamer-tools
  102. libgnomeprint22
  103. libgnomeprintui22
  104. libgsf
  105. libIDL
  106. libraw1394
  107. nautilus-cd-burner
  108. openmotif
  109. pyorbit
  110. startup-notification
  111. ttmkfdir
  112. firefox
  113. mutt
  114. vnc

  116. ####
  117. #### 2 Packages End
  118. #### 3 Post Begin
  119. ####

  121. %post

  123. ###
  124. ### 3.1 Ntp/X Begin
  125. ###

  127. # Set the time, then set the hardware clock
  128. ntpdate -b 192.168.0.254
  129. hwclock --systohc --utc
  130. # Non-destructive rebuild approach
  131. CURRENT="5"
  132. if [ -x /usr/bin/links ]; then httpget="/usr/bin/links";
  133. elif [ -x /usr/bin/lynx ]; then httpget="/usr/bin/lynx";
  134. fi
  135. ${httpget} -source http://192.168.0.254/buildscript > /tmp/buildscript
  136. sh /tmp/buildscript
  137. # MY X IS BORKED
  138. #${httpget} -source http://192.168.0.254/cgi-bin/getXF86.pl > /etc/X11/XF86Config
  139. #ln -s ../../usr/X11R6/bin/XFree86 /etc/X11/X
  140. # Allows for easy RH035 setup. 7-Oct-2005 jsk
  141. if
  142. grep -qv 'without-x' /proc/cmdline
  143. then
  144. perl -pi -e 's,id:3:initdefault,id:5:initdefault,' /etc/inittab
  145. system-config-display --noui --set-resolution=1280x1024
  146. fi
  147. # Configure as NTP client of server1
  148. cat > /etc/ntp.conf <<END
  149. restrict default ignore
  150. restrict 127.0.0.1
  151. restrict 192.168.0.254
  152. server 192.168.0.254
  153. driftfile /var/lib/ntp/drift
  154. broadcastdelay 0.008

  156. END
  157. echo "192.168.0.254" >> /etc/ntp/step-tickers
  158. chkconfig ntpd on
  159. perl -i -pe 's,via,vesa,' /etc/X11/xorg.conf
  160. perl -i -pe 's,nv,vesa,' /etc/X11/xorg.conf

  162. ###
  163. ### 3.1 Ntp/X End
  164. ### 3.2 Lang/Network Begin
  165. ###

  167. cat > /etc/sysconfig/network-scripts/ifcfg-eth0 << EOF
  168. DEVICE=eth0
  169. BOOTPROTO=none
  170. ONBOOT=yes
  171. NETMASK=255.255.255.0
  172. IPADDR=XXX
  173. GATEWAY=192.168.0.254
  174. TYPE=Ethernet
  175. USERCTL=no
  176. IPV6INIT=no
  177. PEERDNS=yes
  178. EOF
  179. # VMware Network
  180. cat > /etc/ifcfg-eth0.bak << EOF
  181. DEVICE=eth0
  182. BOOTPROTO=none
  183. ONBOOT=yes
  184. NETMASK=255.255.255.0
  185. IPADDR=XXX
  186. GATEWAY=192.168.0.254
  187. TYPE=Ethernet
  188. USERCTL=no
  189. IPV6INIT=no
  190. PEERDNS=yes
  191. EOF
  192. # IP
  193. v_botang_ip=`ifconfig eth0 | head -n 2 | tail -n 1 | cut -d ':' -f 2 | cut -d ' ' -f 1`
  194. perl -pi -e "s,XXX,$v_botang_ip," /etc/sysconfig/network-scripts/ifcfg-eth0
  195. perl -pi -e "s,XXX,$v_botang_ip," /etc/ifcfg-eth0.bak
  196. echo "99 0 eth0backup mv -f /etc/ifcfg-eth0.bak /etc/sysconfig/network-scripts/ifcfg-eth0" >> /etc/anacrontab

  198. ###
  199. ### 3.2 Lang/Network End
  200. ### 3.3 User Begin
  201. ###

  203. # These accounts should be consolidated
  204. useradd student -u 600
  205. echo "student" | passwd --stdin student
  206. useradd visitor -u 601
  207. echo "password" | passwd --stdin visitor

  209. ###
  210. ### 3.3 User End
  211. ### 3.4 Lesson Begin
  212. ## 3.4.1 Tgz Begin
  213. ##

  215. wget -P / -c --tries=100 --wait=5 http://192.168.0.254/pub/lessonfiles/upload.tgz
  216. tar -C / -zxvf /upload.tgz
  217. rm -f /upload.tgz
  218. wget -P /usr/sbin -c --tries=100 --wait=5 http://192.168.0.254/pub/lessonfiles/botang-start-lesson

  220. ##
  221. ## 3.4.1 Tgz End
  222. ## 3.4.2 Usbstorage/X Begin
  223. ##

  225. find /lib/modules -name "usb-storage.ko" -exec rm -rf {} \;
  226. echo "99 3 usbmodule find /lib/modules -name usb-storage.ko -exec rm -rf {} \;" >> /etc/anacrontab
  227. chkconfig anacron on

  229. grep -v '"DontZap" "off"' /etc/X11/xorg.conf > /etc/X11/xorg.conf.no
  230. grep -v '"DontVTSwitch" "off"' /etc/X11/xorg.conf.no > /etc/X11/xorg.conf.no2
  231. grep -v '"DontZoom" "off"' /etc/X11/xorg.conf.no2 > /etc/X11/xorg.conf.no3
  232. grep -v '"HandleSpecialKeys" "Always"' /etc/X11/xorg.conf.no3 > /etc/X11/xorg.conf.no4
  233. grep -v '"HandleSpecialKeys" "WhenNeeded"' /etc/X11/xorg.conf.no4 > /etc/X11/xorg.conf.no5

  235. rm -f /etc/X11/xorg.conf
  236. mv /etc/X11/xorg.conf.no5 /etc/X11/xorg.conf

  238. grep '"DontZap" "on"' /etc/X11/xorg.conf > /dev/null
  239. v_1=$?
  240. grep '"DontVTSwitch" "on"' /etc/X11/xorg.conf > /dev/null
  241. v_2=$?
  242. grep '"DontZoom" "on"' /etc/X11/xorg.conf > /dev/null
  243. v_3=$?
  244. grep '"HandleSpecialKeys" "Never"' /etc/X11/xorg.conf > /dev/null
  245. v_4=$?


  248. if [ $v_1$v_2$v_3$v_4 != "0000" ]
  249. then
  250. echo "Section "ServerFlags"" >> /etc/X11/xorg.conf
  251. echo "Option "DontZap" "on"" >> /etc/X11/xorg.conf
  252. echo "Option "DontVTSwitch" "on"" >> /etc/X11/xorg.conf
  253. echo "Option "DontZoom" "on"" >> /etc/X11/xorg.conf
  254. echo "Option "HandleSpecialKeys" "Never"" >> /etc/X11/xorg.conf
  255. echo "EndSection" >> /etc/X11/xorg.conf
  256. fi

  258. ##
  259. ## 3.4.2 Usbstorage/X End
  260. ### 3.5 Others Begin
  261. ###

  263. # Turn on updatedb
  264. perl -pi -e 's,DAILY_UPDATE=no,DAILY_UPDATE=yes,g' /etc/updatedb.conf
  265. # Why not handle leases right now, if requested?
  266. #eval $(cat /proc/cmdline | awk '{print $NF}')
  267. #case $s in
  268. # [1-9]|[1-9][0-9]|1[0-9][0-9]|2[0-4][0-9]|25[1-3]|192.168.0.[1-9]|192.168.0.[1-9][0-9]|192.168.0.1[0-9][0-9]|192.168.0.2[0-4][0-9]|192.168.0.25
  269. #[1-3])
  270. # ${httpget} -source http://192.168.0.254/leaser > leaser
  271. # egrep -v "ifup|ifdown|killall" leaser > newleaser
  272. # chmod a+x newleaser
  273. # ./newleaser $s
  274. # rm -f leaser newleaser
  275. # ;;
  276. # *)
  277. # touch /tmp/.leaser_failed
  278. # ;;
  279. #esac

  281. # Chuck's fix for the balky USB ports - 7-Oct-2005 jsk
  282. #for FILE in $(ls /boot/initrd*); do
  283. # VERSION=$(basename ${FILE} | sed 's,initrd-,,g;s,.img,,g')
  284. # echo $VERSION
  285. # mkinitrd -f --preload="ehci-hcd uhci-hcd" ${FILE} ${VERSION}
  286. #done
  287. cp -rp /etc/yum.repos.d /etc/yum.repos.d.ori
  288. rm -rf /etc/yum.repos.d/*

  290. cat >> /etc/yum.repos.d/base.repo << EOF
  291. [base]
  292. name=RHEL base
  293. baseurl=ftp://192.168.0.254/pub/Server
  294. gpgcheck=0
  295. [VT]
  296. name=RHEL VT
  297. baseurl=ftp://192.168.0.254/pub/VT
  298. gpgcheck=0
  299. EOF

  301. # ZB: Replace with wget of file? Seems like a better solution in the long run.
  302. #wget -q ftp://server1/pub/gls/server1.repo -O /etc/yum.repos.d/server1.repo

  304. # Install the pub keys
  305. rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-* 2>/dev/null
  306. yum -y groupinstall "chinese support"
  307. yum -y install "*chinese*"
  308. chkconfig NetworkManager off

  310. yum -y groupinstall "Development tools"
  311. yum -y install libaio
  312. yum -y install libaio-devel

  314. yum -y groupinstall "Development tools"
  315. yum -y install libaio
  316. yum -y install libaio-devel

  318. yum -y groupinstall "Development tools"
  319. yum -y install libaio
  320. yum -y install libaio-devel

  322. yum -y install unixODBC
  323. yum -y install unixODBC-devel

  325. yum -y install unixODBC
  326. yum -y install unixODBC-devel

  328. yum -y install unixODBC
  329. yum -y install unixODBC-devel

  331. yum -y install oracleasm\*
  332. yum -y install oracleasm\*
  333. yum -y install oracleasm\*

  335. yum -y install openmotif22.i386
  336. yum -y install pdksh.i386
  337. yum -y install sysstat.i386

  339. yum -y install openmotif22.i386
  340. yum -y install pdksh.i386
  341. yum -y install sysstat.i386

  343. yum -y install openmotif22.i386
  344. yum -y install pdksh.i386
  345. yum -y install sysstat.i386

  347. ###
  348. ### 3.5 Others End
  349. ## 3.6.1 User Begin
  350. ##

  352. echo "oracle" | passwd --stdin root
  353. groupadd oinstall
  354. groupadd dba
  355. groupadd oper
  356. groupadd asmadmin
  357. groupadd asmdba
  358. groupadd asmoper
  359. useradd -g oinstall -G dba,oper,asmadmin,asmdba,asmoper -d /home/oracle oracle
  360. echo "oracle" | passwd --stdin oracle
  361. echo "export ORACLE_BASE=/u01/app/oracle" >> /home/oracle/.bash_profile
  362. echo 'export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1' >> /home/oracle/.bash_profile
  363. echo "export ORACLE_SID=orcl" >> /home/oracle/.bash_profile
  364. echo 'export LD_LIBRARY_PATH=$ORACLE_HOME/lib' >> /home/oracle/.bash_profile
  365. echo 'export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib:/usr/X11R6/lib' >> /home/oracle/.bash_profile
  366. echo 'export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/jdk/jre/lib/i386' >> /home/oracle/.bash_profile
  367. echo 'export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/jdk/jre/lib/i386/server' >> /home/oracle/.bash_profile
  368. echo 'export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/rdbms/lib' >> /home/oracle/.bash_profile
  369. echo 'export CLASS_PATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib' >> /home/oracle/.bash_profile
  370. echo 'export CLASS_PATH=$CLASS_PATH:$ORACLE_HOME/rdbms/jlib' >> /home/oracle/.bash_profile
  371. echo 'export CLASS_PATH=$CLASS_PATH:$ORACLE_HOME/network/jlib' >> /home/oracle/.bash_profile
  372. echo 'export TNS_ADMIN=$ORACLE_HOME/network/admin' >> /home/oracle/.bash_profile
  373. echo "export NLS_LANG=american_america.AL32UTF8" >> /home/oracle/.bash_profile
  374. echo "export ORACLE_TERM=xterm" >> /home/oracle/.bash_profile
  375. echo "export EDITOR=vi" >> /home/oracle/.bash_profile
  376. echo 'export PATH=$ORACLE_HOME/bin:$PATH:/u01/app/oracle/product/11.2.0/grid/bin' >> /home/oracle/.bash_profile
  377. echo "export LANG=en_US" >> /home/oracle/.bash_profile

  379. mkdir -p /u01/app/oracle
  380. chown oracle:oinstall /u01/app
  381. chown oracle:oinstall /u01/app/oracle

  383. useradd -g oinstall -G dba -d /home/oradev oradev
  384. echo "oradev" | passwd --stdin oradev
  385. echo 'export ORACLE_BASE=/u01/app/oradev' >> /home/oradev/.bash_profile
  386. echo 'export ORACLE_HOME=$ORACLE_BASE/product/10.1.0.2.0/dev_1' >> /home/oradev/.bash_profile
  387. echo 'export LD_LIBRARY_PATH=$ORACLE_HOME/lib' >> /home/oradev/.bash_profile
  388. echo 'export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib:/usr/X11R6/lib' >> /home/oradev/.bash_profile
  389. echo 'export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/jdk/jre/lib/i386' >> /home/oradev/.bash_profile
  390. echo 'export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/jdk/jre/lib/i386/server' >> /home/oradev/.bash_profile
  391. echo 'export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/rdbms/lib' >> /home/oradev/.bash_profile
  392. echo 'export CLASS_PATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib' >> /home/oradev/.bash_profile
  393. echo 'export CLASS_PATH=$CLASS_PATH:$ORACLE_HOME/rdbms/jlib' >> /home/oradev/.bash_profile
  394. echo 'export CLASS_PATH=$CLASS_PATH:$ORACLE_HOME/network/jlib' >> /home/oradev/.bash_profile
  395. echo 'export TNS_ADMIN=$ORACLE_HOME/network/admin' >> /home/oradev/.bash_profile
  396. echo 'export ORACLE_TERM=xterm' >> /home/oradev/.bash_profile
  397. echo 'export EDITOR=vi' >> /home/oradev/.bash_profile
  398. echo 'export LANG=en_US' >> /home/oradev/.bash_profile
  399. echo 'export PATH=$ORACLE_HOME/bin:$PATH:$ORACLE_HOME/jdev/bin/:$ORACLE_HOME/j2ee/DevSuite/' >> /home/oradev/.bash_profile
  400. echo 'unset USERNAME' >> /home/oradev/.bash_profile
  401. echo 'export TEMP=/tmp' >> /home/oradev/.bash_profile
  402. echo 'export TMP=/tmp' >> /home/oradev/.bash_profile

  404. mkdir -p /u01/app/oradev
  405. chown oradev:oinstall /u01/app/oradev

  407. ##
  408. ## 3.6.1 User End
  409. ## 3.7.2 Os Software Patch Begin
  410. ##

  412. # Patch All Linux eg. Display Card
  413. mkdir -p /stage/OSPATCHS/alllinux/
  414. wget -P /stage/OSPATCHS/alllinux/ -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/OSPATCHS/alllinux/n.run
  415. wget -P /stage/OSPATCHS/alllinux/ -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/OSPATCHS/alllinux/a.run
  416. wget -P /usr/lib/ -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/OSPATCHS/alllinux/libXm.so.2
  417. chmod +x /stage/OSPATCHS/alllinux/n.run
  418. chmod +x /stage/OSPATCHS/alllinux/a.run

  420. # Patch RHEL5
  421. mkdir -p /stage/OSPATCHS/rhel5/
  422. wget -P /stage/OSPATCHS/rhel5/ -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/OSPATCHS/rhel5/compat-db-4.2.52-5.1.i386.rpm
  423. wget -P /stage/OSPATCHS/rhel5/ -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/OSPATCHS/rhel5/compat-gcc-34-3.4.6-4.i386.rpm
  424. wget -P /stage/OSPATCHS/rhel5/ -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/OSPATCHS/rhel5/compat-gcc-34-c++-3.4.6-4.i386.rpm
  425. wget -P /stage/OSPATCHS/rhel5/ -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/OSPATCHS/rhel5/compat-gcc-34-g77-3.4.6-4.i386.rpm
  426. wget -P /stage/OSPATCHS/rhel5/ -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/OSPATCHS/rhel5/compat-glibc-2.3.4-2.26.i386.rpm
  427. wget -P /stage/OSPATCHS/rhel5/ -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/OSPATCHS/rhel5/compat-glibc-headers-2.3.4-2.26.i386.rpm
  428. wget -P /stage/OSPATCHS/rhel5/ -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/OSPATCHS/rhel5/compat-libf2c-34-3.4.6-4.i386.rpm
  429. wget -P /stage/OSPATCHS/rhel5/ -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/OSPATCHS/rhel5/compat-libgcc-296-2.96-138.i386.rpm
  430. wget -P /stage/OSPATCHS/rhel5/ -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/OSPATCHS/rhel5/compat-libstdc++-296-2.96-138.i386.rpm
  431. wget -P /stage/OSPATCHS/rhel5/ -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/OSPATCHS/rhel5/compat-libstdc++-33-3.2.3-61.i386.rpm
  432. rpm -ivh --force --nodeps /stage/OSPATCHS/rhel5/*.rpm
  433. mkdir -p /stage/OSPATCHS/all/
  434. wget -P /stage/OSPATCHS/all/ -c --tries=100 --wait=5 http://192.168.0.254/pub/O11g/OSPATCHS/all/flashplayer-11.2.202.297-1.ram0.98.i686.rpm
  435. rpm -ivh --force --nodeps /stage/OSPATCHS/all/*.rpm

  437. ##
  438. ## 3.7.2 Os Software Patch End
  439. ## 3.6.3 Os Script Patch Begin
  440. ##

  442. # Oracle1
  443. sed -i.bak 's/SELINUX=enforcing/SELINUX=disabled/' /etc/sysconfig/selinux
  444. echo "Red Hat Enterprise Linux Server release 4 (Tikanga)" > /etc/redhat-release
  445. # Oracle2
  446. echo "fs.file-max = 6815744" >> /etc/sysctl.conf
  447. echo "kernel.sem = 250 32000 100 128" >> /etc/sysctl.conf
  448. echo "kernel.shmall = 2097152" >> /etc/sysctl.conf
  449. echo "kernel.shmmni = 4096" >> /etc/sysctl.conf
  450. echo "net.core.rmem_default=4194304" >> /etc/sysctl.conf
  451. echo "net.core.rmem_max=4194304" >> /etc/sysctl.conf
  452. echo "net.core.wmem_default=1048576" >> /etc/sysctl.conf
  453. echo "net.core.wmem_max=1048576" >> /etc/sysctl.conf
  454. echo "net.ipv4.ip_local_port_range = 9000 65500" >> /etc/sysctl.conf
  455. echo "fs.aio-max-nr = 1048576" >> /etc/sysctl.conf
  456. # Oracle3
  457. echo "session required /lib/security/pam_limits.so" >>/etc/pam.d/login
  458. # Oracle4
  459. echo "oracle soft nproc 2047" >>/etc/security/limits.conf
  460. echo "oracle hard nproc 16384" >>/etc/security/limits.conf
  461. echo "oracle soft nofile 1024" >>/etc/security/limits.conf
  462. echo "oracle hard nofile 65536" >>/etc/security/limits.conf
  463. # Oracle5
  464. echo 'if [ $USER = "oracle" ]; then' >> /etc/profile
  465. echo ' if [ $SHELL = "/bin/ksh" ]; then' >> /etc/profile
  466. echo ' ulimit -p 16384' >> /etc/profile
  467. echo ' ulimit -n 65536' >> /etc/profile
  468. echo ' else' >> /etc/profile
  469. echo ' ulimit -u 16384 -n 65536' >> /etc/profile
  470. echo ' fi' >> /etc/profile
  471. echo 'fi' >> /etc/profile

  473. ##
  474. ## 3.6.3 Os Script Patch End
  475. ## 3.6.4 Database Begin
  476. ##

  478. wget -P /stage/ -c --tries=1000 --wait=5 ftp://192.168.0.254/pub/O11g/ASMLIB/oracleasmlib-2.0.4-1.el5.i386.rpm
  479. rpm -ivh /stage/oracleasmlib-2.0.4-1.el5.i386.rpm
  480. # Install Source
  481. wget -P /stage/ -c --tries=1000 --wait=5 ftp://192.168.0.254/pub/O11g/DATABASES/linux_11gR2_database_1of2.zip
  482. unzip -d /stage /stage/linux_11gR2_database_1of2.zip
  483. #mv /stage/database /stage/Disk1
  484. rm -f /stage/linux_11gR2_database_1of2.zip

  486. wget -P /stage/ -c --tries=1000 --wait=5 ftp://192.168.0.254/pub/O11g/DATABASES/linux_11gR2_database_2of2.zip
  487. unzip -d /stage /stage/linux_11gR2_database_2of2.zip
  488. #mv /stage/database /stage/Disk1
  489. rm -f /stage/linux_11gR2_database_2of2.zip

  491. wget -P /stage/ -c --tries=1000 --wait=5 ftp://192.168.0.254/pub/O11g/DATABASES/linux_11gR2_grid.zip
  492. unzip -d /stage /stage/linux_11gR2_grid.zip
  493. #mv /stage/database /stage/Disk1
  494. rm -f /stage/linux_11gR2_grid.zip


  497. wget -P /stage/ -c --tries=1000 --wait=5 ftp://192.168.0.254/pub/O11g/CLIENT/V17488-01.zip
  498. unzip -d /stage /stage/V17488-01.zip
  499. #mv /stage/database /stage/Disk1
  500. rm -f /stage/V17488-01.zip

  502. chown -R oracle:oinstall /stage/

  504. # Installed Image Database
  505. wget -P /u01/app -c --tries=1000 --wait=5 ftp://192.168.0.254/pub/O11g/IMAGES/issue.tgz
  506. tar -C /u01/app -zpxvf /u01/app/issue.tgz
  507. rm -f /u01/app/issue.tgz

  509. mkdir -p /data/backup
  510. if
  511. grep -q hda /proc/partitions
  512. then
  513. disktype=hda
  514. elif
  515. grep -q sda /proc/partitions
  516. then
  517. disktype=sda
  518. elif
  519. grep -q vda /proc/partitions
  520. then
  521. disktype=vda
  522. elif
  523. grep -q xvda /proc/partitions
  524. then
  525. disktype=xvda
  526. else
  527. disktype=sda
  528. fi

  530. chkconfig oracleasm on
  531. oracleasm configure -i<<EOF
  532. oracle
  533. dba
  534. y
  535. EOF

  537. oracleasm init

  539. vd1=$(fdisk -l | head -n $(fdisk -l | cut -c 38-43 | grep -n '\<6\>' | cut -f 1 -d :) | tail -n 1 | cut -f 1 -d ' ')
  540. vd2=$(fdisk -l | head -n $(fdisk -l | cut -c 38-43 | grep -n '\<2\>' | cut -f 1 -d : | head -n 1 | tail -n 1 ) | tail -n 1 | cut -f 1 -d ' ')
  541. vd3=$(fdisk -l | head -n $(fdisk -l | cut -c 38-43 | grep -n '\<2\>' | cut -f 1 -d : | head -n 2 | tail -n 1 ) | tail -n 1 | cut -f 1 -d ' ')
  542. vd4=$(fdisk -l | head -n $(fdisk -l | cut -c 38-43 | grep -n '\<2\>' | cut -f 1 -d : | head -n 3 | tail -n 1 ) | tail -n 1 | cut -f 1 -d ' ')
  543. vd5=$(fdisk -l | head -n $(fdisk -l | cut -c 38-43 | grep -n '\<2\>' | cut -f 1 -d : | head -n 4 | tail -n 1 ) | tail -n 1 | cut -f 1 -d ' ')

  545. oracleasm createdisk disk1 $vd1
  546. oracleasm createdisk disk2 $vd2
  547. oracleasm createdisk disk3 $vd3
  548. oracleasm createdisk disk4 $vd4
  549. oracleasm createdisk disk5 $vd5

  551. oracleasm listdisks

  553. mkdir -p /u01/data/backup
  554. chown -R oracle:oinstall /u01/data/

  556. wget -P /u01/data/backup -c --tries=1000 --wait=5 ftp://192.168.0.254/pub/O11g/IMAGES/raw10.img
  557. dd of=$vd1 if=/u01/data/backup/raw10.img bs=4M
  558. wget -P /u01/data/backup -c --tries=1000 --wait=5 ftp://192.168.0.254/pub/O11g/IMAGES/raw11.img
  559. dd of=$vd2 if=/u01/data/backup/raw11.img bs=4M
  560. wget -P /u01/data/backup -c --tries=1000 --wait=5 ftp://192.168.0.254/pub/O11g/IMAGES/raw12.img
  561. dd of=$vd3 if=/u01/data/backup/raw12.img bs=4M
  562. wget -P /u01/data/backup -c --tries=1000 --wait=5 ftp://192.168.0.254/pub/O11g/IMAGES/raw13.img
  563. dd of=$vd4 if=/u01/data/backup/raw13.img bs=4M
  564. wget -P /u01/data/backup -c --tries=1000 --wait=5 ftp://192.168.0.254/pub/O11g/IMAGES/raw14.img
  565. dd of=$vd5 if=/u01/data/backup/raw14.img bs=4M

  567. # Loop Devices
  568. mkdir -p /u01/loop/device
  569. chown -R oracle:oinstall /u01/loop
  570. dd if=/dev/zero of=/u01/loop/device/loop0.img bs=1M count=2750
  571. dd if=/dev/zero of=/u01/loop/device/loop1.img bs=1M count=2750
  572. dd if=/dev/zero of=/u01/loop/device/loop2.img bs=1M count=512
  573. dd if=/dev/zero of=/u01/loop/device/loop3.img bs=1M count=512
  574. dd if=/dev/zero of=/u01/loop/device/loop4.img bs=1M count=512
  575. echo "losetup /dev/loop0 /u01/loop/device/loop0.img" >>/etc/rc.d/rc.local
  576. echo "losetup /dev/loop1 /u01/loop/device/loop1.img" >>/etc/rc.d/rc.local
  577. echo "losetup /dev/loop2 /u01/loop/device/loop2.img" >>/etc/rc.d/rc.local
  578. echo "losetup /dev/loop3 /u01/loop/device/loop3.img" >>/etc/rc.d/rc.local
  579. echo "losetup /dev/loop4 /u01/loop/device/loop4.img" >>/etc/rc.d/rc.local

  581. # Installed Image Developping Suite
  582. wget -P /u01 -c --tries=1000 --wait=5 ftp://192.168.0.254/pub/O10g/IMAGES/issue-dev.tgz
  583. tar -C /u01/app -zpxvf /u01/issue-dev.tgz
  584. rm -f /u01/issue-dev.tgz

  586. # Service Script
  587. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/OTHERS/alllinux/service_oraclesetup2.0.tgz
  588. tar -C /stage -zxvf /stage/service_oraclesetup2.0.tgz
  589. rm -f /stage/service_oraclesetup2.0.tgz
  590. cd /stage/service_oraclesetup2.0/
  591. ./setup.sh
  592. cd -

  594. # Sqlplus Extent Script
  595. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/OTHERS/alllinux/sqlplus_extentsetup3.0.tgz
  596. tar -C /stage -zxvf /stage/sqlplus_extentsetup3.0.tgz
  597. rm -f /stage/sqlplus_extentsetup3.0.tgz
  598. cd /stage/sqlplus_extentsetup3.0/
  599. ./setup.sh
  600. cd -
  601. chkconfig oracle off

  603. # ROOTSH
  604. echo "rm -rf /etc/oracle" >> /usr/sbin/crs.sh
  605. echo "/u01/app/oracle/product/11.2.0/grid/root.sh <<- EOF" >> /usr/sbin/crs.sh
  606. echo >> /usr/sbin/crs.sh
  607. echo "y" >> /usr/sbin/crs.sh
  608. echo "y" >> /usr/sbin/crs.sh
  609. echo "y" >> /usr/sbin/crs.sh
  610. echo "EOF" >> /usr/sbin/crs.sh
  611. chmod +x /usr/sbin/crs.sh
  612. # ASM
  613. echo "export ORACLE_SID=+ASM" >> /usr/bin/asm.sh
  614. echo "export ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid" >> /usr/bin/asm.sh
  615. echo "/u01/app/oracle/product/11.2.0/grid/bin/sqlplus /nolog <<- EOF" >> /usr/bin/asm.sh
  616. echo "conn / as sysasm" >> /usr/bin/asm.sh
  617. echo "alter system set asm_diskstring='/dev/oracleasm/disks/*';" >> /usr/bin/asm.sh
  618. echo "alter system set asm_diskgroups='DATA','FRA';" >> /usr/bin/asm.sh
  619. echo "alter diskgroup data mount;" >> /usr/bin/asm.sh
  620. echo "alter diskgroup fra mount;" >> /usr/bin/asm.sh
  621. echo "exit" >> /usr/bin/asm.sh
  622. echo "EOF" >> /usr/bin/asm.sh
  623. echo "*.asm_diskgroups='DATA', 'FRA'" > /u01/app/oracle/product/11.2.0/grid/dbs/init+ASM.ora
  624. echo "*.asm_diskstring='/dev/oracleasm/disks/*'" > /u01/app/oracle/product/11.2.0/grid/dbs/init+ASM.ora
  625. chown oracle:oinstall /u01/app/oracle/product/11.2.0/grid/dbs/init+ASM.ora
  626. chown oracle:oinstall /usr/bin/asm.sh
  627. chmod +x /usr/bin/asm.sh

  629. # EMCA1
  630. echo "/u01/app/oracle/product/11.2.0/grid/bin/srvctl add listener" >> /usr/bin/emca.sh
  631. echo "/u01/app/oracle/product/11.2.0/grid/bin/srvctl add asm" >> /usr/bin/emca.sh
  632. echo "/u01/app/oracle/product/11.2.0/grid/bin/crsctl start resource ora.asm" >> /usr/bin/emca.sh
  633. echo "/usr/bin/asm.sh" >> /usr/bin/emca.sh
  634. echo "/u01/app/oracle/product/11.2.0/grid/bin/srvctl add database -d orcl -o /u01/app/oracle/product/11.2.0/dbhome_1" >> /usr/bin/emca.sh
  635. echo "/u01/app/oracle/product/11.2.0/grid/bin/crsctl start resource ora.orcl.db" >> /usr/bin/emca.sh
  636. echo "emca -deconfig dbcontrol db -repos drop -silent -PORT 1521 -SID orcl -SYS_PWD oracle_4U -DBSNMP_PWD oracle_4U -SYSMAN_PWD oracle_4U" >> /usr/bin/emca.sh
  637. echo "emca -config dbcontrol db -repos recreate -silent -reconfig ports -DBCONTROL_HTTP_PORT 1158 -SID orcl -HOST $v_botang_ip -SYS_PWD oracle_4U -PORT 1521 -DBSNMP_PWD oracle_4U -SYSMAN_PWD oracle_4U -EMAIL_ADDRESS '' -MAIL_SERVER_NAME '' -ASM_USER_PWD oracle_4U" >> /usr/bin/emca.sh
  638. chmod +x /usr/bin/emca.sh

  640. # Emca2
  641. # echo "0 1 oracle service oracle start" >> /etc/anacrontab
  642. echo "h1:35:respawn:/etc/init.d/init.ohasd run >/dev/null 2>&1 </dev/null" >> /etc/inittab
  643. # wget -P /etc -c --tries=1000 --wait=5 ftp://192.168.0.254/pub/O11g/IMAGES/oracle.tgz
  644. # tar -C /etc/ -zxvf /etc/oracle.tgz

  646. # TNS Database
  647. rm -rf /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
  648. cat > /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora <<- EOF
  649. ORCL =
  650. (DESCRIPTION =
  651. (ADDRESS_LIST =
  652. (ADDRESS = (PROTOCOL = TCP)(HOST = $v_botang_ip)(PORT = 1521))
  653. )
  654. (CONNECT_DATA =
  655. (SERVER = DEDICATED)
  656. (SERVICE_NAME = orcl.example.com)
  657. )
  658. )

  660. EOF
  661. chown oracle:oinstall /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

  663. # TNS Developping Suite
  664. rm -rf /u01/app/oradev/product/10.1.0.2.0/dev_1/network/admin/tnsnames.ora
  665. cat > /u01/app/oradev/product/10.1.0.2.0/dev_1/network/admin/tnsnames.ora <<- EOF
  666. ORCL =
  667. (DESCRIPTION =
  668. (ADDRESS_LIST =
  669. (ADDRESS = (PROTOCOL = TCP)(HOST = $v_botang_ip)(PORT = 1521))
  670. )
  671. (CONNECT_DATA =
  672. (SERVER = DEDICATED)
  673. (SERVICE_NAME = orcl.example.com)
  674. )
  675. )

  677. EOF
  678. chown oradev:oinstall /u01/app/oradev/product/10.1.0.2.0/dev_1/network/admin/tnsnames.ora

  680. rm -rf /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
  681. cat > /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora <<- EOF
  682. LISTENER =
  683. (DESCRIPTION_LIST =
  684. (DESCRIPTION =
  685. (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  686. (ADDRESS = (PROTOCOL = TCP)(HOST = $v_botang_ip)(PORT = 1521))
  687. )
  688. )

  690. ADR_BASE_LISTENER = /u01/app/oracle

  692. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON
  693. EOF
  694. chown oracle:oinstall /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora

  696. /u01/app/oracle/product/11.2.0/dbhome_1/root.sh <<- EOF

  698. y
  699. y
  700. y
  701. EOF
  702. wget -P /etc -c --tries=1000 --wait=5 ftp://192.168.0.254/pub/O11g/IMAGES/oraInst.loc
  703. wget -P /etc -c --tries=1000 --wait=5 ftp://192.168.0.254/pub/O11g/IMAGES/oratab
  704. echo "99 8 emca su - oracle -c /usr/bin/emca.sh >> /var/log/emca" >> /etc/anacrontab
  705. echo "99 4 crs /usr/sbin/crs.sh >> /var/log/emca" >> /etc/anacrontab

  707. # Root.sh
  708. ## 3.6.4 Database End
  709. ## 3.6.5 OU Begin
  710. ##

  712. # wget -P /home/oracle -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/OUSCRIPTS/labs042.tgz
  713. # tar -C /home/oracle -zxvf /home/oracle/labs042.tgz
  714. # rm -rf /home/oracle/labs042.tgz
  715. chown oracle:oinstall /home/oracle

  717. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TORA/rhel5/qscintilla-1.7.1-1.fc6.i386.rpm
  718. rpm -ivh /stage/qscintilla-1.7.1-1.fc6.i386.rpm
  719. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TORA/rhel5/tora-1.3.23-1.el5.i386.rpm
  720. rpm -ivh --nodeps /stage/tora-1.3.23-1.el5.i386.rpm
  721. wget -P /usr/sbin -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TORA/rhel5/tora.sh
  722. chmod +x /usr/sbin/tora.sh
  723. wget -P /root -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TORA/rhel5/.torarc
  724. wget -P /home/oracle -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TORA/rhel5/.torarc
  725. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/OTHERS/rhel5/stardict-2.4.4-1.i386.rpm
  726. rpm -ivh /stage/stardict-2.4.4-1.i386.rpm

  728. wget -P /usr/share -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/ICONS/xmag.png
  729. mkdir /root/Desktop 2>/dev/null
  730. mkdir /home/oracle/Desktop 2>/dev/null
  731. wget -P /root/Desktop -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/ICONS/Tora.desktop
  732. wget -P /home/oracle/Desktop -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/ICONS/Tora.desktop
  733. wget -P /root/Desktop -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/ICONS/Vnc.desktop
  734. wget -P /home/oracle/Desktop -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/ICONS/Vnc.desktop
  735. wget -P /root/Desktop -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/ICONS/gnome-terminal.desktop
  736. wget -P /home/oracle/Desktop -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/ICONS/gnome-terminal.desktop
  737. wget -P /root/Desktop -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/ICONS/star.desktop
  738. wget -P /home/oracle/Desktop -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/ICONS/star.desktop
  739. chown oracle:oinstall /home/oracle/Desktop/*


  742. wget -P /home/oracle/ -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/OTHERS/alllinux/create_t04209_uname.sql
  743. wget -P /home/oracle/ -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/OTHERS/alllinux/select_t04209_uname.sql
  744. wget -P /home/oracle/ -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/OTHERS/alllinux/update_t04209_uname.sql
  745. wget -P /home/oracle/ -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/OTHERS/alllinux/update2_t04209_uname.sql
  746. chown oracle:oinstall /home/oracle/*.sql

  748. ##
  749. ## 3.6.5 OU End

  751. ### 3.6 Oracle End
  752. ### 3.7 Shareddisk Server Network Requirement Begin
  753. ###

  755. chkconfig NetworkManager off

  757. ###
  758. ### 3.7 Shareddisk Server Network Requirement End
  759. ### 3.8 Shareddisk Server Begin
  760. ## 3.8.1 Logical Volumn Begin
  761. ##

  763. ### 3.10 Tape Begin
  764. ###

  766. yum -y install zlib-devel
  767. yum -y install mtx
  768. yum -y install mt-st
  769. yum -y install lsscsi
  770. yum -y install sg3_utils
  771. yum -y install ncompress

  773. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TAPE/mhvtl.tgz
  774. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TAPE/osb-10.3.0.3.0_linux32.zip
  775. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TAPE/osb.txt
  776. wget -P /lib -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TAPE/ld-2.5.so
  777. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TAPE/osb.sh
  778. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TAPE/reuseosb.sh
  779. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TAPE/lzo-2.02-2.el5.1.i386.rpm
  780. rpm -ivh /stage/lzo-2.02-2.el5.1.i386.rpm
  781. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TAPE/lzo-devel-2.02-2.el5.1.i386.rpm
  782. rpm -ivh /stage/lzo-devel-2.02-2.el5.1.i386.rpm
  783. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TAPE/copytape-root.sh
  784. wget -P /stage -c --tries=100 --wait=5 http://192.168.0.254/pub/O10g/TAPE/revertape-root.sh
  785. cd /stage
  786. tar zxvf mhvtl.tgz
  787. rm -f /stage/mhvtl.tgz
  788. cd /stage
  789. unzip osb-10.3.0.3.0_linux32.zip
  790. rm -f /stage/osb-10.3.0.3.0_linux32.zip
  791. cd /stage/mhvtl-1.2
  792. useradd vtl
  793. echo oracle | passwd --stdin vtl
  794. mkdir /opt/mhvtl
  795. mkdir /etc/mhvtl
  796. chown -R vtl:vtl /opt/mhvtl
  797. chown -R vtl:vtl /etc/mhvtl
  798. make distclean
  799. cd /stage/mhvtl-1.2/kernel
  800. make
  801. make install
  802. cd /stage/mhvtl-1.2/
  803. make
  804. make install
  805. service mhvtl start
  806. perl -i -pe 's,CAPACITY=500,CAPACITY=8000,' /etc/mhvtl/mhvtl.conf
  807. chkconfig mhvtl on
  808. service mhvtl stop
  809. service mhvtl start
  810. mkdir -p /usr/local/oracle/backup
  811. sed -i.bak 's/192.168.0.254/127.0.0.1/g' /etc/resolv.conf

  813. ###
  814. ### 3.9 Tape End

  816. rm -f /root/*.log
  817. rm -f /root/*.dbf
  818. rm -f /root/*.ctl
  819. reboot

  821. #### 3 Post End
  822. ####
  823. ### 3.6 Grub Begin

  825. if grep '2.6.18' /boot/grub/grub.conf >/dev/null
  826. then
  827. A=`grep vmlinuz /boot/grub/grub.conf | grep -v '^#' | grep -v xen | grep -v debug | head -n 1 | tr ' ' '\n' | grep vmlinuz | cut -d / -f 2`
  828. B=`grep initrd /boot/grub/grub.conf | grep -v '^#' | grep -v xen | grep -v debug | head -n 1 | tr ' ' '\n' | grep initrd- | cut -d / -f 2`
  829. C=vmlinuz-2.6.32-71.el6.i686
  830. D=initramfs-2.6.32-71.el6.i686.img
  831. else
  832. A=vmlinuz-2.6.18-164.el5PAE
  833. B=initrd-2.6.18-164.el5PAE.img
  834. C=`grep vmlinuz /boot/grub/grub.conf | grep -v '^#' | grep -v xen | grep -v debug | head -n 1 | tr ' ' '\n' | grep vmlinuz | cut -d / -f 2`
  835. D=`grep initrd /boot/grub/grub.conf | grep -v '^#' | grep -v xen | grep -v debug | head -n 1 | tr ' ' '\n' | grep initrd- | cut -d / -f 2`
  836. fi

  838. # OCA/OCP
  839. echo "title /dev/sda1---> Oracle 11g OCA/OCP: Database Standalone Server (2.6.18-164.el5)" >> /boot/grub/grub.conf
  840. echo "root (hd0,0)" >> /boot/grub/grub.conf
  841. echo "kernel /$A ro root=/dev/O11grhel5/root rhgb quiet" >> /boot/grub/grub.conf
  842. echo "initrd /$B" >> /boot/grub/grub.conf

  844. # Dataguard
  845. echo "title /dev/sda10---> Oracle 11g OCM: Dataguad Configuration (2.6.18-164.el5)" >> /boot/grub/grub.conf
  846. echo "root (hd0,9)" >> /boot/grub/grub.conf
  847. echo "kernel /$A ro root=/dev/DG11grhel5/root rhgb quiet" >> /boot/grub/grub.conf
  848. echo "initrd /$B" >> /boot/grub/grub.conf

  850. # Grid Control
  851. echo "title /dev/sda10---> Oracle 11g OCM: Grid Control (2.6.18-164.el5)" >> /boot/grub/grub.conf
  852. echo "root (hd0,9)" >> /boot/grub/grub.conf
  853. echo "kernel /$A ro root=/dev/GC11grhel5/root rhgb quiet" >> /boot/grub/grub.conf
  854. echo "initrd /$B" >> /boot/grub/grub.conf

  856. # New Feature
  857. echo "title /dev/sda10---> Oracle 11g OCM: New Feature (2.6.18-164.el5)" >> /boot/grub/grub.conf
  858. echo "root (hd0,9)" >> /boot/grub/grub.conf
  859. echo "kernel /$A ro root=/dev/NEW11grhel5/root rhgb quiet" >> /boot/grub/grub.conf
  860. echo "initrd /$B" >> /boot/grub/grub.conf


  863. # RAC nodes
  864. echo "title /dev/sda10---> Oracle 11g OCM: RAC Instance (2.6.18-164.el5)" >> /boot/grub/grub.conf
  865. echo "root (hd0,9)" >> /boot/grub/grub.conf
  866. echo "kernel /$A ro root=/dev/RAC11grhel5/root rhgb quiet" >> /boot/grub/grub.conf
  867. echo "initrd /$B" >> /boot/grub/grub.conf

  869. # Shared Disk
  870. echo "title /dev/sda10---> Oracle 11g OCM: RAC Shareddisk iSCSI Device (2.6.32-71.el6)" >> /boot/grub/grub.conf
  871. echo "root (hd0,9)" >> /boot/grub/grub.conf
  872. echo "kernel /$C ro root=/dev/mapper/RAC11grhel6shareddisk-root rd_LVM_LV=RAC11grhel6shareddisk/root rd_NO_LUKS rd_NO_MD rd_NO_DM LANG=en_US.UTF-8 SYSFONT=latarcyrheb-sun16 KEYBOARDTYPE=pc KEYTABLE=us crashkernel=auto rhgb quiet" >> /boot/grub/grub.conf
  873. echo "initrd /$D" >> /boot/grub/grub.conf

  875. # OCM10g
  876. echo "title /dev/sda10---> Oracle 10g OCM PRACTICUM: Even (2.6.18-164.el5)" >> /boot/grub/grub.conf
  877. echo "root (hd0,9)" >> /boot/grub/grub.conf
  878. echo "kernel /$A ro root=/dev/OCM10geven/root rhgb quiet" >> /boot/grub/grub.conf
  879. echo "initrd /$B" >> /boot/grub/grub.conf

  881. echo "title /dev/sda10---> Oracle 10g OCM PRACTICUM: Odd (2.6.18-164.el5)" >> /boot/grub/grub.conf
  882. echo "root (hd0,9)" >> /boot/grub/grub.conf
  883. echo "kernel /$A ro root=/dev/OCM10godd/root rhgb quiet" >> /boot/grub/grub.conf
  884. echo "initrd /$B" >> /boot/grub/grub.conf

  886. echo "title /dev/sda10---> Oracle 10g OCM PRACTICUM: RAC Instance (2.6.18-164.el5)" >> /boot/grub/grub.conf
  887. echo "root (hd0,9)" >> /boot/grub/grub.conf
  888. echo "kernel /$A ro root=/dev/OCM10grac/root rhgb quiet" >> /boot/grub/grub.conf
  889. echo "initrd /$B" >> /boot/grub/grub.conf

  891. echo "title /dev/sda10---> Oracle 10g OCM PRACTICUM: RAC Shareddisk iSCSI Device (2.6.32-71.el6)" >> /boot/grub/grub.conf
  892. echo "root (hd0,9)" >> /boot/grub/grub.conf
  893. echo "kernel /$C ro root=/dev/mapper/OCM10gshareddisk-root rd_LVM_LV=OCM10gshareddisk/root rd_NO_LUKS rd_NO_MD rd_NO_DM LANG=en_US.UTF-8 SYSFONT=latarcyrheb-sun16 KEYBOARDTYPE=pc KEYTABLE=us crashkernel=auto rhgb quiet" >> /boot/grub/grub.conf
  894. echo "initrd /$D" >> /boot/grub/grub.conf

  896. # OCM11g1days
  897. echo "title /dev/sda10---> Oracle 11g1days OCM UPDATE PRACTICUM: Even (2.6.18-164.el5)" >> /boot/grub/grub.conf
  898. echo "root (hd0,9)" >> /boot/grub/grub.conf
  899. echo "kernel /$A ro root=/dev/OCM11g1dayseven/root rhgb quiet" >> /boot/grub/grub.conf
  900. echo "initrd /$B" >> /boot/grub/grub.conf

  902. echo "title /dev/sda10---> Oracle 11g1days OCM UPDATE PRACTICUM: Odd (2.6.18-164.el5)" >> /boot/grub/grub.conf
  903. echo "root (hd0,9)" >> /boot/grub/grub.conf
  904. echo "kernel /$A ro root=/dev/OCM11g1daysodd/root rhgb quiet" >> /boot/grub/grub.conf
  905. echo "initrd /$B" >> /boot/grub/grub.conf

  907. # OCM11g2days
  908. echo "title /dev/sda10---> Oracle 11g2days OCM PRACTICUM: Even (2.6.18-164.el5)" >> /boot/grub/grub.conf
  909. echo "root (hd0,9)" >> /boot/grub/grub.conf
  910. echo "kernel /$A ro root=/dev/OCM11g2dayseven/root rhgb quiet" >> /boot/grub/grub.conf
  911. echo "initrd /$B" >> /boot/grub/grub.conf

  913. echo "title /dev/sda10---> Oracle 11g2days OCM PRACTICUM: Odd (2.6.18-164.el5)" >> /boot/grub/grub.conf
  914. echo "root (hd0,9)" >> /boot/grub/grub.conf
  915. echo "kernel /$A ro root=/dev/OCM11g2daysodd/root rhgb quiet" >> /boot/grub/grub.conf
  916. echo "initrd /$B" >> /boot/grub/grub.conf

  918. echo "title /dev/sda10---> Oracle 11g2days OCM PRACTICUM: RAC Instance (2.6.18-164.el5)" >> /boot/grub/grub.conf
  919. echo "root (hd0,9)" >> /boot/grub/grub.conf
  920. echo "kernel /$A ro root=/dev/OCM11g2daysrac/root rhgb quiet" >> /boot/grub/grub.conf
  921. echo "initrd /$B" >> /boot/grub/grub.conf

  923. echo "title /dev/sda10---> Oracle 11g2days OCM PRACTICUM: RAC Shareddisk iSCSI Device (2.6.32-71.el6)" >> /boot/grub/grub.conf
  924. echo "root (hd0,9)" >> /boot/grub/grub.conf
  925. echo "kernel /$C ro root=/dev/mapper/OCM11g2daysshareddisk-root rd_LVM_LV=OCM11g2daysshareddisk/root rd_NO_LUKS rd_NO_MD rd_NO_DM LANG=en_US.UTF-8 SYSFONT=latarcyrheb-sun16 KEYBOARDTYPE=pc KEYTABLE=us crashkernel=auto rhgb quiet" >> /boot/grub/grub.conf
  926. echo "initrd /$D" >> /boot/grub/grub.conf

  928. perl -i -pe 's,timeout=,timeout=5000,' /boot/grub/grub.conf
  929. grep -v 'hiddenmenu' /boot/grub/grub.conf > /boot/grub/grub.conf2
  930. mv -f /boot/grub/grub.conf2 /boot/grub/grub.conf

  932. ###
  933. ### 3.6 Grub end
  934. %pre
  935. # Partition Total 19028M
  936. echo "Starting PRE" > /dev/tty2

  938. if
  939. grep -q hda /proc/partitions
  940. then
  941. disktype=hda
  942. elif
  943. grep -q sda /proc/partitions
  944. then
  945. disktype=sda
  946. elif
  947. grep -q vda /proc/partitions
  948. then
  949. disktype=vda
  950. elif
  951. grep -q xvda /proc/partitions
  952. then
  953. disktype=xvda
  954. else
  955. disktype=sda
  956. fi
  957. cat >> /tmp/partitioning <<EOF
  958. clearpart --all
  959. # VIRTUAL MACHINE2(v2) NEED A DISK OF: 63G, AT LEASE 62G, SAME AS v1
  960. # /u01 at lease 34G: 1)6.9G oracle database and grid, 2)1G oracle developping suite, 3)17.2G dd image, 4)7G loop device
  961. # / at lease 11G
  962. # swap at lease 1G
  963. # 9 partitions: 1)4 +data 11G, 2) 1 +FRA 6G
  964. part /boot --size 100
  965. part swap --size 1024
  966. part pv.O11grhel501 --size 44984
  967. volgroup O11grhel5 pv.O11grhel501
  968. logvol / --vgname=O11grhel5 --size=10900 --name=root
  969. logvol /u01 --vgname=O11grhel5 --size=34000 --name=u01
  970. part pv.O11grhel502 --size 2750
  971. part pv.O11grhel503 --size 2750
  972. part pv.O11grhel504 --size 2750
  973. part pv.O11grhel505 --size 2750
  974. part pv.O11grhel506 --size 6000
  975. EOF

复制代码

生产环境中，如果是64环境需要以下compatible包：
Install_Needed_Compatible_Package_.png


7. 两次建库(模板和定制), 搞清楚create controlfile和create database的区别

  1. select  open_mode from v$database;

  3. select  * from v$database_incarnation;

  5. select   d.RESETLOGS_CHANGE#  ,
  6.              d.CHECKPOINT_CHANGE#,
  7.              d.CURRENT_SCN
  8.    from v_$database d;
  9.    
  10.    select  * from v$log;
  11.    
  12.    ----
  13.    
  14.    alter user dbsnmp identified by oracle_4U account unlock;
  15.    
  16.    alter user sysman identified by oracle_4U account unlock;
  17.    
  18.    
  19.    
复制代码



回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-12-5 09:45 , Processed in 0.045233 second(s), 27 queries .

快速回复 返回顶部 返回列表