【正文】 as begun. The daemons should exit soon.3 修改操作系統(tǒng)的ip設(shè)置debian的網(wǎng)絡(luò)配置文件為/etc/network/interfaces和/etc/hosts, 其他linux發(fā)行版及unix網(wǎng)絡(luò)配置文件位置可能并不一樣. 以節(jié)點(diǎn)rac1為例, 修改前/etc/network/interfaces文件內(nèi)容為:/etc/hosts文件內(nèi)容為: localhost rac1 rac2 rac1vip rac2vip rac1priv rac2priv The following lines are desirable for IPv6 capable hosts::1 ip6localhost ip6loopbackfe00::0 ip6localnetff00::0 ip6mcastprefixff02::1 ip6allnodesff02::2 ip6allroutersff02::3 ip6allhosts修改后: localhost rac1 rac2 rac1vip rac2vip rac1priv rac2priv The following lines are desirable for IPv6 capable hosts::1 ip6localhost ip6loopbackfe00::0 ip6localnetff00::0 ip6mcastprefixff02::1 ip6allnodesff02::2 ip6allroutersff02::3 ip6allhosts集群中所有節(jié)點(diǎn)的hosts文件應(yīng)該保持一致./etc/network/interfaces和/etc/hosts文件修改后可使用/etc/或者重啟操作系統(tǒng)使設(shè)置生效.啟動(dòng)crs, 設(shè)置oracle中ip地址相關(guān)的設(shè)置. 啟動(dòng)crs, 并關(guān)閉隨crs啟動(dòng)的應(yīng)用程序rac1:/u01/app/oracle/product/Startup will be queued to init within 90 seconds.由于oracle所有應(yīng)用設(shè)置為自動(dòng)啟動(dòng), 所以在crs啟動(dòng)時(shí)會(huì)試圖啟動(dòng)所有的服務(wù), 但是在對oracle相關(guān)的ip地址進(jìn)行設(shè)置時(shí)需要crs處于運(yùn)行狀態(tài)而數(shù)據(jù)庫, asm和node application處于停止?fàn)顟B(tài), , , , asm和node application. 使用oifcfg修改網(wǎng)卡設(shè)置, oifconfig可以被用來設(shè)置和查看網(wǎng)卡被oracle使用的方式.rac2:/u01/app/oracle/product/eth0 global publiceth1 global cluster_interconnectrac2:/u01/app/oracle/product/:publicrac2:/u01/app/oracle/product/eth0 eth0 eth1 rac2:/u01/app/oracle/product/rac2:/u01/app/oracle/product/eth0 eth1 rac2:/u01/app/oracle/product/eth0 global publiceth1 global cluster_interconnectrac2:/u01/app/oracle/product/:/:cluster_interconnectbash: ./lifcfg: No such file or directoryrac2:/u01/app/oracle/product/:/:cluster_interconnectrac2:/u01/app/oracle/product/eth0 global publiceth1 global cluster_interconnecteth1: global cluster_interconnectrac2:/u01/app/oracle/product/:cluster_interconnectrac2:/u01/app/oracle/product/eth0 global publiceth1 global cluster_interconnecteth1 global cluster_interconnecteth1: global cluster_interconnectrac2:/u01/app/oracle/product/:rac2:/u01/app/oracle/product/rac2:/u01/app/oracle/product/eth0 global publiceth1 global cluster_interconnectoifcfg iflist會(huì)顯示當(dāng)前使用的網(wǎng)卡及其子網(wǎng)設(shè)置, 而oifcfg getif global 則會(huì)顯示配置文件中的信息.5 修改vip地址rac2:/u01/app/oracle/product/rac2:/u01/app/oracle/product/ , 檢查這些文件中是否有指定原來ip的地方, 修改為更改后的ip地址, , rac2上的 . 啟動(dòng)node applications, asm, 數(shù)據(jù)庫rac2:/u01/app/oracle/product/rac2:/u01/app/oracle/product/rac2:/u01/app/oracle/product/rac2:/u01/app/oracle/product/rac2:/u01/app/oracle/product/rac2:/u01/app/oracle/product/ 來看看我們的成果:rac2:/u01/app/oracle/product/eth0 Link encap:Ethernet HWaddr 00:0C:29:0D:FE:0Finet addr: Bcast: Mask:UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1RX packets:142242 errors:0 dropped:0 overruns:0 frame:0TX packets:140057 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000RX bytes:83167889 ( MiB) TX bytes:87987399 ( MiB)Interrupt:19 Base address:0x1480eth0:1 Link encap:Ethernet HWaddr 00:0C:29:0D:FE:0Finet addr: Bcast: Mask:UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1Interrupt:19 Base address:0x1480eth1 Link encap:Ethernet HWaddr 00:0C:29:0D:FE:19inet addr: Bcast: Mask:UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1RX packets:29781 errors:0 dropped:0 overruns:0 frame:0TX packets:26710 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000RX bytes:19667330 ( MiB) TX bytes:11573375 ( MiB)Interrupt:16 Base address:0x1800lo Link encap:Local Loopbackinet addr: Mask:UP LOOPBACK RUNNING MTU:16436 Metric:1RX packets:21796 errors:0 dropped:0 overruns:0 frame:0TX packets:21796 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:0RX bytes:6238339 ( MiB) TX bytes:6238339 ( MiB)rac2:/u01/app/oracle/product/rac2:/u01/app/oracle/product/oraclerac2:~$ lsnrctl statLSNRCTL for Linux: Version Production on 23AUG2006 23:23:47Copyright (c) 1991, 2005, Oracle. All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))STATUS of the LISTENERAlias LISTENER_RAC2Version TNSLSNR for Linux: Version ProductionStart Date 23AUG2006 22:24:44Uptime 0 days 0 hr. 59 min. 3 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/product/Listener Log File /u01/app/oracle/product/Listening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)))Services Summary...Service +ASM has 1 instance(s).Instance +ASM2, status BLOCKED, has 1 handler(s) for this service...Service +ASM_XPT has 1 instance(s).Instance +ASM2, status BLOCKED, has 1 handler(s) for this service...Service PLSExtProc has 1 instance(s).Instance PLSExtProc, status UNKNOWN, has 1 handler(s) for this service...Service orcl has 2 instance(s).Instance orcl1, status READY, has 1 handler(s) for this service...Instance orcl2, status READY, has 2 handler(s) for this service...Service orclXDB has 2 instance(s).Instance orcl1, status READY, has 1 handler(s) for this service...Instance orcl2, status READY, has 1 handler(s) for this service...Service orcl_XPT has 2 instance(s).Instance orcl1, status READY, has 1 handler(s) for this service...Instance orcl2, status READY, has 2 handler(s) for this service...The mand pleted successfully以上操作大部分使用root進(jìn)行, 實(shí)時(shí)上, 使用svrctl進(jìn)行的操作可以使用root用戶完成也可以使用oracle用戶完成, 而修改vip則必須使用root用戶完成使用crs_stat ls可以查看各個(gè)資源的所有者, 屬組, 以及相應(yīng)的權(quán)限.三、 如何在RAC環(huán)境下修改Oracle字符集非RAC環(huán)境字符集修改　　 Oracle字符集問題總結(jié)　　 oracle字符集概念　　oracle字符集是一個(gè)字節(jié)數(shù)據(jù)的解釋的符號集合,有大小之分,有相互的包容關(guān)系。假如我們安裝64bit 的數(shù)據(jù)庫,我們就可以使用很大的內(nèi)存，我們幾乎不可能達(dá)到上限。這個(gè)問題影響到的主要是SGA 的大小。在操作系統(tǒng)中觀察page in/out 狀況，發(fā)現(xiàn)問題嚴(yán)重，應(yīng)該考