安装oracle 10.2.0.4 on CentOS 6 (64bit)
<DIV><A href="http://blog.chinaunix.nethttp://blog.chinaunix.net/attachment/201109/26/20687159_1317015166FPDV.png" target=_blank></A>最近在64位 linux 上安装了一个oracle 10g数据库，最大的感受是:</DIV><DIV> </DIV>
<DIV>1、所有问题都在网上能查到，离开互联网恐怕就完蛋了</DIV>
<DIV>2、安装前一定要看官方文档，切记！切记！否则如入地狱般</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>由于服务器配置是4C 16G内存，所以得安装64位操作系统才能充分使用硬件。</DIV>
<DIV> </DIV>
<DIV>介质下载</DIV>
<DIV>需要64位linux，找了找redhat不能随便下了，看了看oracle的 unbreakable linux，可能是账号有问题，也下不了。没办法想起了CentOS 6，找了几个能下的网站，在客户那以5M/s的速度一会就下完了，真快。</DIV>
<DIV>地址 <A href="http://blog.chinaunix.net/link.php?url=http://ftp.twaren.net%2FLinux%2FCentOS%2F6%2Fisos%2Fx86_64%2FCentOS-6.0-x86_64-bin-DVD1.iso" target=_blank>http://ftp.twaren.net/Linux/CentOS/6/isos/x86_64/CentOS-6.0-x86_64-bin-DVD1.iso</A> 4G，CentOS 6安装介质一共有两个iso文件，但是安装oracle 10g没用到另一个，浪费了一张DVD。</DIV>
<DIV> </DIV>
<DIV>oracle软件从官方地址直接下就行，<A href="http://blog.chinaunix.net/link.php?url=http://download.oracle.com%2Fotn%2Flinux%2Foracle10g%2F10201%2F10201_database_linux32.zip" target=_blank>http://download.oracle.com/otn/linux/oracle10g/10201/10201_database_linux32.zip</A> 638M。10.2.0.4的patch需要从support上下载，坑爹的是比原安装介质大不少 <A href="https://updates.oracle.com/Orion/Services/download/p8202632_10205_LINUX.zip?aru=12794232&patch_file=p8202632_10205_LINUX.zip" target=_blank>https://updates.oracle.com/Orion/Services/download/p8202632_10205_LINUX.zip?aru=12794232&patch_file=p8202632_10205_LINUX.zip</A> 1G</DIV>
<DIV> </DIV>
<DIV>官方安装前检查文档，一定先看几遍！</DIV>
<DIV>Requirements For Installing Oracle10gR2 On RHEL 5_OEL 5 (x86_64) </DIV>
<DIV><A href="http://blog.chinaunix.nethttp://blog.chinaunix.net/attachment/attach/20/68/71/5920687159323058b7629ce8556934bc285b20c455.rar" target=_blank><IMG src="http://blog.chinaunix.net/blog/image/attachicons/rar.gif" align=absMiddle border=0> a.rar </A> </DIV>
<DIV> </DIV>
<DIV>服务器型号是 浪潮机架式双路英信NF8560。</DIV>
<DIV> </DIV>
<DIV>安装CentOS 6着实让人不省心，虽然安装步骤简易很多，难在最后安装类型和rpm包的选择，弄不好没KDE，开机后进入命令行界面，或者执行startx后没有任务条且没终端窗口，无法退出！有时不知道选中了哪几个包，进入的图形界面跟windows xp很像，但是图形界面不支持网卡，习惯图形的我没招了。太灵活的选择，让普通用户无所适从，这就是linux这么多年一直干不过windows的原因。</DIV>
<DIV> </DIV>
<DIV>安装时选择中文界面方便。每回选的rpm包数都不一样，经过几番折腾终于能自动启动到图形界面了，上面熟悉的任务条，有管理工具、注销等下拉菜单，有终端就ok了。</DIV>
<DIV> </DIV>
<DIV>为安装oracle 10g，检查并设置服务器环境</DIV>
<DIV> </DIV>
<DIV>$ uname -a<BR>Linux dbserver 2.6.32-71.el6.x86_64 #1 SMP Fri May 20 03:51:51 BST 2011 x86_64 x86_64 x86_64 GNU/Linux</DIV>
<DIV> </DIV>
<DIV># dmidecode|grep 'Product'<BR> Product Name: NF8560<BR> Product Name: NF8560</DIV>
<DIV># lsb_release -a<BR>LSB Version: :core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch<BR>Distributor ID: CentOS<BR>Description: CentOS Linux release 6.0 (Final)<BR>Release: 6.0<BR>Codename: Final<BR></DIV>
<DIV># getconf LONG_BIT<BR>64</DIV>
<DIV><BR># cat /proc/meminfo<BR>MemTotal: 16318780 kB<BR>MemFree: 2072120 kB<BR>Buffers: 76556 kB<BR>Cached: 12791640 kB<BR>SwapCached: 0 kB<BR>Active: 3002100 kB<BR>Inactive: 10165604 kB<BR>Active(anon): 802752 kB<BR>Inactive(anon): 2071656 kB<BR>Active(file): 2199348 kB<BR>Inactive(file): 8093948 kB<BR>Unevictable: 0 kB<BR>Mlocked: 0 kB<BR>SwapTotal: 18563064 kB<BR>SwapFree: 18562336 kB<BR>Dirty: 16 kB<BR>Writeback: 0 kB<BR>AnonPages: 299720 kB<BR>Mapped: 2025564 kB<BR>Shmem: 2574760 kB<BR>Slab: 886836 kB<BR>SReclaimable: 512008 kB<BR>SUnreclaim: 374828 kB<BR>KernelStack: 7440 kB<BR>PageTables: 75272 kB<BR>NFS_Unstable: 0 kB<BR>Bounce: 0 kB<BR>WritebackTmp: 0 kB<BR>CommitLimit: 26722452 kB<BR>Committed_AS: 13524232 kB<BR>VmallocTotal: 34359738367 kB<BR>VmallocUsed: 318936 kB<BR>VmallocChunk: 34349587660 kB<BR>HardwareCorrupted: 0 kB<BR>AnonHugePages: 55296 kB<BR>HugePages_Total: 0<BR>HugePages_Free: 0<BR>HugePages_Rsvd: 0<BR>HugePages_Surp: 0<BR>Hugepagesize: 2048 kB<BR>DirectMap4k: 5376 kB<BR>DirectMap2M: 2082816 kB<BR>DirectMap1G: 14680064 kB<BR></DIV>
<DIV>cpu型号<BR># cat /proc/cpuinfo |grep name|cut -f2 -d:|uniq -c<BR> 48 Intel(R) Xeon(R) CPU E7- 4807 @ 1.87GHz</DIV>
<DIV> </DIV>
<DIV>修改网络配置</DIV>
<DIV>vi /etc/hosts<BR>增加</DIV>
<DIV>192.168.1.2 dbserver</DIV>
<DIV> </DIV>
<DIV>禁用防火墙</DIV>
<DIV>禁用selinux</DIV>
<DIV> </DIV>
<DIV>网卡信息<BR># dmesg |grep -i eth<BR>Intel(R) Gigabit Ethernet Network Driver - version 2.1.0-k2<BR>igb 0000:02:00.0: Intel(R) Gigabit Ethernet Network Connection<BR>igb 0000:02:00.0: eth0: (PCIe:2.5Gb/s:Width x1) 00:1b:21:af:cf:40<BR>igb 0000:02:00.0: eth0: PBA No: fafa03-0d6<BR>igb 0000:02:00.1: Intel(R) Gigabit Ethernet Network Connection<BR>igb 0000:02:00.1: eth1: (PCIe:2.5Gb/s:Width x1) 00:1b:21:af:cf:41<BR>igb 0000:02:00.1: eth1: PBA No: fafa03-0d6<BR>igb 0000:06:00.0: Intel(R) Gigabit Ethernet Network Connection<BR>igb 0000:06:00.0: eth2: (PCIe:2.5Gb/s:Width x4) 00:30:48:ff:93:2c<BR>igb 0000:06:00.0: eth2: PBA No: ffffff-0ff<BR>igb 0000:06:00.1: Intel(R) Gigabit Ethernet Network Connection<BR>igb 0000:06:00.1: eth3: (PCIe:2.5Gb/s:Width x4) 00:30:48:ff:93:2d<BR>igb 0000:06:00.1: eth3: PBA No: ffffff-0ff<BR>igb: eth0 NIC Link is Up 1000 Mbps Full Duplex, Flow Control: RX/TX<BR>ADDRCONF(NETDEV_UP): eth1: link is not ready<BR>ADDRCONF(NETDEV_UP): eth2: link is not ready<BR>ADDRCONF(NETDEV_UP): eth3: link is not ready<BR>eth0: no IPv6 routers present</DIV>
<DIV><BR># ifconfig<BR>eth0 Link encap:Ethernet HWaddr 00:1B:21:AF:CF:40<BR> inet addr:192.168.1.2 Bcast:10.255.255.255 Mask:255.255.255.0<BR> inet6 addr: fe80::21b:21ff:feaf:cf40/64 Scope:Link<BR> UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1<BR> RX packets:453718 errors:0 dropped:0 overruns:1 frame:0<BR> TX packets:155515 errors:0 dropped:0 overruns:0 carrier:0<BR> collisions:0 txqueuelen:1000<BR> RX bytes:151155641 (144.1 MiB) TX bytes:29829009 (28.4 MiB)<BR> Memory:faee0000-faf00000</DIV>
<DIV>eth1 Link encap:Ethernet HWaddr 00:1B:21:AF:CF:41<BR> UP BROADCAST MULTICAST MTU:1500 Metric:1<BR> RX packets:0 errors:0 dropped:0 overruns:0 frame:0<BR> TX packets:0 errors:0 dropped:0 overruns:0 carrier:0<BR> collisions:0 txqueuelen:1000<BR> RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)<BR> Memory:f9fe0000-fa000000</DIV>
<DIV>eth2 Link encap:Ethernet HWaddr 00:30:48:FF:93:2C<BR> UP BROADCAST MULTICAST MTU:1500 Metric:1<BR> RX packets:0 errors:0 dropped:0 overruns:0 frame:0<BR> TX packets:0 errors:0 dropped:0 overruns:0 carrier:0<BR> collisions:0 txqueuelen:1000<BR> RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)<BR> Memory:fafe0000-fb000000</DIV>
<DIV>eth3 Link encap:Ethernet HWaddr 00:30:48:FF:93:2D<BR> UP BROADCAST MULTICAST MTU:1500 Metric:1<BR> RX packets:0 errors:0 dropped:0 overruns:0 frame:0<BR> TX packets:0 errors:0 dropped:0 overruns:0 carrier:0<BR> collisions:0 txqueuelen:1000<BR> RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)<BR> Memory:faf60000-faf80000</DIV>
<DIV>lo Link encap:Local Loopback<BR> inet addr:127.0.0.1 Mask:255.0.0.0<BR> inet6 addr: ::1/128 Scope:Host<BR> UP LOOPBACK RUNNING MTU:16436 Metric:1<BR> RX packets:12250 errors:0 dropped:0 overruns:0 frame:0<BR> TX packets:12250 errors:0 dropped:0 overruns:0 carrier:0<BR> collisions:0 txqueuelen:0<BR> RX bytes:736370 (719.1 KiB) TX bytes:736370 (719.1 KiB)</DIV>
<DIV> </DIV>
<DIV>操作系统信息<BR><A href="mailto:root@dbserver" target=_blank>root@dbserver</A> ~]# cat /etc/issue<BR>CentOS Linux release 6.0 (Final)</DIV>
<DIV> </DIV>
<DIV>内存信息<BR># grep tal /proc/meminfo<BR>MemTotal: 16318780 kB<BR>SwapTotal: 18563064 kB<BR>VmallocTotal: 34359738367 kB<BR>HugePages_Total: 0<BR># free -mt<BR> total used free shared buffers cached<BR>Mem: 15936 13919 2016 0 75 12495<BR>-/+ buffers/cache: 1348 14587<BR>Swap: 18127 0 18127<BR>Total: 34064 13920 20143</DIV>
<DIV> </DIV>
<DIV>内核参数</DIV>
<DIV># vi /etc/sysctl.conf<BR>增加</DIV>
<DIV>kernel.shmall = 8388608<BR>kernel.shmmax = 17179869184<BR>kernel.shmmni = 4096<BR>kernel.sem = 250 32000 100 128<BR>fs.file-max = 65536<BR>net.ipv4.ip_local_port_range = 1024 65000<BR>net.core.rmem_default = 1048576<BR>net.core.rmem_max = 1048576<BR>net.core.wmem_default = 262144<BR>net.core.wmem_max = 262144</DIV>
<DIV> </DIV>
<DIV>修改系统限制<BR># vi /etc/security/limits.conf</DIV>
<DIV>增加<BR>oracle soft nproc 2047<BR>oracle hard nproc 16384<BR>oracle soft nofile 1024<BR>oracle hard nofile 65536</DIV>
<DIV> </DIV>
<DIV># vi /etc/pam.d/login</DIV>
<DIV>增加</DIV>
<DIV>session required pam_limits.so </DIV>
<DIV> </DIV>
<DIV>查看限制<BR># ulimit -a<BR>core file size (blocks, -c) 0<BR>data seg size (kbytes, -d) unlimited<BR>scheduling priority (-e) 0<BR>file size (blocks, -f) unlimited<BR>pending signals (-i) 127375<BR>max locked memory (kbytes, -l) 64<BR>max memory size (kbytes, -m) unlimited<BR>open files (-n) 1024<BR>pipe size (512 bytes, -p) 8<BR>POSIX message queues (bytes, -q) 819200<BR>real-time priority (-r) 0<BR>stack size (kbytes, -s) 10240<BR>cpu time (seconds, -t) unlimited<BR>max user processes (-u) 1024<BR>virtual memory (kbytes, -v) unlimited<BR>file locks (-x) unlimited</DIV>
<DIV> </DIV>
<DIV>profile文件<BR># cat /home/oracle/.bash_profile<BR># .bash_profile</DIV>
<DIV># Get the aliases and functions<BR>if [ -f ~/.bashrc ]; then<BR> . ~/.bashrc<BR>fi</DIV>
<DIV># User specific environment and startup programs</DIV>
<DIV>PATH=$PATH:$HOME/bin</DIV>
<DIV>export PATH</DIV>
<DIV>export ORACLE_BASE=/home/app/oracle<BR>export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1<BR>export ORACLE_OWNER=oracle<BR>export ORACLE_SID=orcl<BR>export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK</DIV>
<DIV>export ORACLE_TERM=xterm<BR>export PATH=/usr/sbin:$PATH<BR>export PATH=$ORACLE_HOME/bin:$PATH<BR>export LD_LIBRARY_PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin/<BR>export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib<BR>#ulimit -u 16384 -n 65536<BR>umask 022</DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-WEIGHT: bold; COLOR: #000000">if</SPAN> <SPAN style="FONT-WEIGHT: bold; COLOR: #7a0874">[</SPAN> <SPAN style="COLOR: #007800">$USER</SPAN> = <SPAN style="COLOR: #ff0000">"oracle"</SPAN> <SPAN style="FONT-WEIGHT: bold; COLOR: #7a0874">]</SPAN>; <SPAN style="FONT-WEIGHT: bold; COLOR: #000000">then</SPAN><BR> <SPAN style="FONT-WEIGHT: bold; COLOR: #000000">if</SPAN> <SPAN style="FONT-WEIGHT: bold; COLOR: #7a0874">[</SPAN> <SPAN style="COLOR: #007800">$SHELL</SPAN> = <SPAN style="COLOR: #ff0000">"/bin/ksh"</SPAN> <SPAN style="FONT-WEIGHT: bold; COLOR: #7a0874">]</SPAN>; <SPAN style="FONT-WEIGHT: bold; COLOR: #000000">then</SPAN><BR> <SPAN style="FONT-WEIGHT: bold; COLOR: #7a0874">ulimit</SPAN> <SPAN style="COLOR: #660033">-p</SPAN> <SPAN style="COLOR: #000000">16384</SPAN><BR> <SPAN style="FONT-WEIGHT: bold; COLOR: #7a0874">ulimit</SPAN> <SPAN style="COLOR: #660033">-n</SPAN> <SPAN style="COLOR: #000000">65536</SPAN><BR> <SPAN style="FONT-WEIGHT: bold; COLOR: #000000">else</SPAN><BR> <SPAN style="FONT-WEIGHT: bold; COLOR: #7a0874">ulimit</SPAN> <SPAN style="COLOR: #660033">-u</SPAN> <SPAN style="COLOR: #000000">16384</SPAN> <SPAN style="COLOR: #660033">-n</SPAN> <SPAN style="COLOR: #000000">65536</SPAN><BR> <SPAN style="FONT-WEIGHT: bold; COLOR: #000000">fi</SPAN><BR><SPAN style="FONT-WEIGHT: bold; COLOR: #000000">fi</SPAN></DIV>
<DIV><BR>$ date<BR>2011年 09月 24日 星期六 11:49:52 CST</DIV>
<DIV> </DIV>
<DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">以</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">oracle</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">用户登录，通过</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">U</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">盘将</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">10g</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">安装介质拷贝到</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">/home/app</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">下，解包</SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><SPAN lang=EN-US><FONT face="Times New Roman">$ </FONT></SPAN>gzip -dc <FONT face="Times New Roman">10201_database_linux_x86_64.cpio.gz </FONT>| cpio -idm</SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"></SPAN><SPAN lang=EN-US><FONT face="Times New Roman">$ gunzip p6810189_10204_Linux-x86-64.zip</FONT></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman"><SPAN lang=EN-US><FONT face="Times New Roman">$ cd database</FONT></SPAN></FONT></SPAN></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=DA style="FONT-FAMILY: Arial; mso-ansi-language: DA"><SPAN lang=EN-US><FONT face="Times New Roman">$</FONT></SPAN>./runInstaller –ignoreSysPrereqs</SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-ansi-language: DA">根据提示选择定制安装，然后通过系统检查后，选择只安装软件，在安装过程中可能会提示</SPAN><SPAN lang=DA style="mso-ansi-language: DA"><FONT face="Times New Roman">ins_emdb.mk</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-ansi-language: DA">编译错误：</SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-ansi-language: DA"><A href="http://blog.chinaunix.nethttp://blog.chinaunix.net/attachment/201109/26/20687159_1317015242SPa8.jpg" target=_blank><IMG src="http://blog.chinaunix.nethttp://blog.chinaunix.net/attachment/201109/26/20687159_1317015242SPa8.jpg" border=0 ; .load="imgResize(this, 650);"></A></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-ansi-language: DA">忽略，继续安装。后面</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-ansi-language: DA">安装补丁10.2.0.4，编译时就不会再出现错误了，全部OK。</SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-ansi-language: DA"></SPAN> </P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-ansi-language: DA">建库后调整：</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-ansi-language: DA"></P>
<DIV class=codeText id=codeText>
<OL class=dp-css style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 5px; MARGIN: 0px 1px 0px 0px; PADDING-TOP: 5px">
<LI><SPAN style="COLOR: #000000"><SPAN style="COLOR: #0000ff">alter</SPAN> <SPAN style="COLOR: #0000ff">database</SPAN> datafile 1 resize 600m<SPAN style="COLOR: #0000cc">;</SPAN> <BR></LI>
<LI><SPAN style="COLOR: #0000ff">alter</SPAN> <SPAN style="COLOR: #0000ff">database</SPAN> datafile 3 resize 400m<SPAN style="COLOR: #0000cc">;</SPAN> <BR></LI>
<LI><SPAN style="COLOR: #0000ff">alter</SPAN> <SPAN style="COLOR: #0000ff">database</SPAN> datafile 2 resize 4000m<SPAN style="COLOR: #0000cc">;</SPAN> <BR></LI>
<LI><SPAN style="COLOR: #0000ff">alter</SPAN> <SPAN style="COLOR: #0000ff">database</SPAN> tempfile 1 resize 4000m<SPAN style="COLOR: #0000cc">;</SPAN><BR></LI>
<LI><SPAN style="COLOR: #0000ff">alter</SPAN> <SPAN style="COLOR: #0000ff">tablespace</SPAN> undotbs1 <SPAN style="COLOR: #0000ff">add</SPAN> datafile <SPAN style="COLOR: #ff00ff">'/app/oradata/orcl/undotbs02.dbf'</SPAN> <SPAN style="COLOR: #0000ff">size</SPAN> 4g<SPAN style="COLOR: #0000cc">;</SPAN><BR></LI>
<LI><SPAN style="COLOR: #0000ff">alter</SPAN> <SPAN style="COLOR: #0000ff">database</SPAN> datafile 4 autoextend <SPAN style="COLOR: #ff0000">off</SPAN><SPAN style="COLOR: #0000cc">;</SPAN></SPAN></LI></OL></DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"> </P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"> </P></SPAN>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt">建库后，进行简单的测试，发现磁盘写性能相当强悍，由于是RAID10，添加undo文件时的top中看到写入速度能达到1000M/s！难道我看错了：</P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><A href="http://blog.chinaunix.nethttp://blog.chinaunix.net/attachment/201109/26/20687159_13170158224FbA.jpg" target=_blank><IMG src="http://blog.chinaunix.nethttp://blog.chinaunix.net/attachment/201109/26/20687159_13170158224FbA.jpg" border=0 ; .load="imgResize(this, 650);"></A></P></DIV>
<DIV> </DIV>
<DIV>不过通过insert table t1 select * from t1; 测试填充数据时，速度也能达到200M/s:</DIV>
<DIV><A href="http://blog.chinaunix.nethttp://blog.chinaunix.net/attachment/201109/26/20687159_1317016034N5El.jpg" target=_blank><IMG src="http://blog.chinaunix.nethttp://blog.chinaunix.net/attachment/201109/26/20687159_1317016034N5El.jpg" border=0 ; .load="imgResize(this, 650);"></A></DIV>
<DIV>比RAID5的40M/s 强多了。</DIV>
<DIV> </DIV>
<DIV>为了定期备份数据库，增加了一个计划任务，定期执行expdb.sh脚本：</DIV>
<DIV><BR># backup database<BR>export ORACLE_BASE=/u01<BR>export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1<BR>export ORACLE_OWNER=oracle<BR>export ORACLE_SID=abc<BR>export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK</DIV>
<DIV>export ORACLE_TERM=xterm<BR>export PATH=/usr/sbin:$PATH<BR>export PATH=$ORACLE_HOME/bin:$PATH<BR>export LD_LIBRARY_PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin/<BR>export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib</DIV>
<DIV>export time=`date +%Y%m%d`<BR></DIV>
<DIV>find /bak -name a*.dmp -mtime +15 -exec rm {} \;</DIV>
<DIV>exp xxx/xxx file=/bak/a$time.dmp log=/bak/a$time.log</DIV>
<DIV><FONT style="BACKGROUND-COLOR: #cce8cf"></FONT> </DIV>
<DIV><FONT style="BACKGROUND-COLOR: #cce8cf"></FONT> </DIV>
<DIV>遇到的一些问题及解决办法
<DIV><FONT style="BACKGROUND-COLOR: #cce8cf"></FONT> </DIV>
<DIV><FONT style="BACKGROUND-COLOR: #cce8cf">--------------------------------------------</FONT></DIV>
<DIV>简化并启用dbshut dbstart脚本</DIV>
<DIV> </DIV>
<DIV><FONT style="BACKGROUND-COLOR: #cce8cf">为了便于后期管理，调整dbstart、dbshut脚本，都在$ORACLE_HOME/bin 目录下</FONT></DIV>
<DIV>查找：</DIV>
<DIV>ORACLE_HOME_LISTNER</DIV>
<DIV> </DIV>
<DIV>将其改为： <BR>ORACLE_HOME_LISTNER=$ORACLE_HOME</DIV>
<DIV> </DIV>
<DIV><FONT style="BACKGROUND-COLOR: #cce8cf">修改/etc/oratab，将最后一行的N 改为Y</FONT> </DIV>
<DIV><FONT style="BACKGROUND-COLOR: #cce8cf">例如 orcl:/u01/product/10.2.0/db_1:Y</FONT></DIV>
<DIV><FONT style="BACKGROUND-COLOR: #cce8cf">顺便说一句，dbstart里面有启动侦听的命令，无须再执行lsnrctl start了。</FONT></DIV>
<DIV><FONT style="BACKGROUND-COLOR: #cce8cf"><BR> </DIV></FONT></DIV>
<DIV>--------------------------------------------</DIV>
<DIV>调大sga后，启动时报错 ORA-27125:unable to create shared memory segment</DIV>
<DIV>1.确定安装oracle所使用的用户组<BR>在oracle用户下执行命令id</DIV>
<DIV>可以看到oracle组dba id 501</DIV>
<DIV> </DIV>
<DIV>2.修改内核参数 <BR>echo 501 >/proc/sys/vm/hugetlb_shm_group</DIV>
<DIV>再启动不报错了。</DIV>
<DIV><BR>将上述命令加入到启动中 <BR>vi /etc/rc.local</DIV>
<DIV><BR>--------------------------------------------</DIV>
<DIV>安装过程出现报错</DIV>
<DIV>./oracle/product/10.2/ctx/lib/ins_ctx.mk'</DIV>
<DIV>glibc-devel需要32位的包，详细信息参考metalink文档ID 786995.1<BR>需要注意，安装这个包后，要退出安装界面，而不要点CONTINUE，否则在ins_ctx.mk可以编译成功，虽然的包仍然会报错。</DIV>
<DIV><BR>看看，还是rpm包的问题。</DIV>
<DIV> </DIV>
<DIV>--------------------------------------------</DIV>
<DIV>关于telnet的中文乱码<BR> 装了简体中文版的RHEL5,系统显示中文都没问题，但是telnet远程登录过来就有中文乱码。<BR>上网搜索，很多人说修改/etc/profile ，或者/etc/sysconfig/i18n。众说纷纭，都试了，都不好使。要么系统下变乱码，要么telnet下变乱码，中文文件名更是乱码。</DIV>
<DIV><BR>后来仔细思考，在系统配置上下工夫估计是错误的方向。难道是选用的telnet客户端不支持系统使用的编码？于是命令行下输入locale，查看系统编码，显示zh_CN.UTF-8。（如果</DIV>
<DIV>安装简体中文的RHEL5，则系统默认使用zh_CN.UTF-8编码。如果是英文，默认是zh_US.UTF-8编码。）<BR>而之前选用的netterm根本不支持utf-8编码。（据说最新的netterm支持utf-8了，但是没找到破解的，汗。。。）<BR>于是找其他的telnet客户端软件，后来找到了putty，那叫一个字，好！绿色免费又开源，好多人都用，相比收费的netterm，还支持UTF-8编码。<BR>官网地址：<A href="http://www.chiark.greenend.org.uk/~sgtatham/putty/" target=_blank>http://www.chiark.greenend.org.uk/~sgtatham/putty/</A>，点击download可以下载。<BR>putty使用方法：<BR>1.打开putty.exe,主界面中输入Host Name（主机名）和Port（端口号），Connection type选择telnet。</DIV>
<DIV>2.如果远程主机使用utf-8编码，这里需要修改utf-8编码:</DIV>
<DIV>在软件界面的左边树形菜单中，选择Window下的Translation,在出现的下拉菜单Receive data assumed </DIV>
<DIV>to be in which charecter set中，选择UTF-8编码。</DIV>
<DIV>3.回到session界面，可以保存本次设置，以后登录时可以使用此设置。</DIV>
<DIV>4.单击open，即可telnet到远程主机。中文不乱码了。 </DIV>
<DIV> </DIV>
<DIV>还是putty好使啊</DIV>
<DIV> </DIV>
<DIV>--------------------------------------------</DIV>
<DIV>ftp上来显示的时间与系统时间不一致，是因为默认情况下，vsftpd 是用GMT做为它的时间的，所以和系统的时间可能会不一致。修改也很简单： <BR># vi /etc/vsftpd/vsftpd.conf</DIV>
<DIV>在最后加入一行： <BR>use_localtime=YES</DIV>
<DIV>存盘后，重启vsftpd: <BR># service vsftpd restart</DIV>
<DIV> </DIV>
<DIV>--------------------------------------------<BR>重建em 参考本博客或metalink文档ID278100.1</DIV>
<DIV> </DIV>
<DIV>--------------------------------------------</DIV>
<DIV>缺少rpm包时，如果有条件上互联网可以执行<BR>#yum install glibc</DIV>
<DIV>或</DIV>
<DIV>#yum install libXo.so.2</DIV>
<DIV>它会自己下载去找相关的rpm包，省心多了.</DIV>
<DIV> </DIV>
<DIV>还可以：</DIV>
<DIV>yum install -y binutils compat-libstdc++ elfutils-libelf elfutils-libelf-devel glibc glibc-common glibc-devel gcc gcc-c++ libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel libXp<BR></DIV>
<DIV>--------------------------------------------</DIV>
<DIV><BR>vsftp 服务设置问题<BR>ftp 192.168.1.2时提示</DIV>
<DIV>500 OOPS: cannot change directory:/home/oracle，目录权限没有问题。最后找到一个解决办法：<BR># service vsftpd stop</DIV>
<DIV># setsebool -P ftpd_disable_trans 1<BR># service vsftpd restart</DIV>
<DIV> </DIV>
<DIV>如果出现： Could not change active booleans: Invalid boolean 再执行：</DIV>
<DIV># setsebool -P ftp_home_dir=1</DIV>
<DIV>当然还得再重启vsftp服务</DIV>
<DIV># service vsftpd restart</DIV>
<DIV> </DIV>
<DIV>--------------------------------------------</DIV>
<DIV>修复乱码问题(未验证)</DIV>
<DIV>如果启动 em（<a href="http://your_oracle" target="_blank">http://your_oracle</A> server ip_address:1158/em）出现乱码，那么按照以下方法修复</DIV>
<DIV>在网上下载zysong.ttf </DIV>
<DIV>(<a href="http://blogimg.chinaunix.net/blog/upfile2/090331105520.rar" target="_blank">http://blogimg.chinaunix.net/blog/upfile2/090331105520.rar</A>)字体文件，并将此文件解压放到 root的home目录下</DIV>
<DIV>修改java环境设置</DIV>
<DIV>cd $ORACLE_HOME/jdk/jre/lib</DIV>
<DIV>mv font.properties font.properties.bak</DIV>
<DIV>cp font.properties.zh_CN.Redhat font.properties<BR> <BR>cd $ORACLE_HOME/jre/1.4.2/lib</DIV>
<DIV>mv font.properties font.properties.bak</DIV>
<DIV>cp font.properties.zh_CN.Redhat font.properties<BR> </DIV>
<DIV>复制新的字体文件</DIV>
<DIV>mkdir -p /usr/share/fonts/zh_CN/TrueType/</DIV>
<DIV>cp ~/zysong.ttf /usr/share/fonts/zh_CN/TrueType/<BR> </DIV>
<DIV>清空缓存</DIV>
<DIV>rm $ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs/*.gif<BR></DIV>
<DIV><FONT color=#008000>提醒：以上修复乱码的方法从网上找的，未验证，我的解决方法是</FONT></DIV>
<DIV><FONT color=#008000>$ export LANG=C </FONT></DIV>
<DIV><FONT color=#008000>$ firefox</FONT></DIV>
<DIV><FONT color=#008000>然后输入 </FONT><a href="http://localhost:1158/em" target="_blank"><FONT color=#008000>http://localhost:1158/em</FONT></A></DIV>
<DIV> </DIV>
页:
[1]