RAC IP 地址修改
生活随笔
收集整理的這篇文章主要介紹了
RAC IP 地址修改
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
RAC 修改IP:
192.168.3.201?? rac1?? ??? ?--> 192.168.2.201
192.168.3.203?? rac2?? ??? ?--> 192.168.2.203
192.168.0.201?? rac1-private
192.168.0.203?? rac2-private
192.168.3.202?? rac1-vip?? ?--> 192.168.2.202
192.168.3.204?? rac2-vip?? ?--> 192.168.2.204
1.關閉服務
./crs_stop -all
./crs_stop ora.DATA.dg
./crs_stop ora.RECOVERY.dg
NAME=ora.RECOVERY.dg
TYPE=ora.diskgroup.type
TARGET=OFFLINE
STATE=ONLINE on rac2
NAME=ora.asm
TYPE=ora.asm.type
TARGET=OFFLINE
STATE=ONLINE on rac2
--------------------------------------------------
[grid@rac1 bin]$ ./srvctl stop asm -n rac1
PRCR-1014 : 無法停止資源 ora.asm
PRCR-1065 : 無法停止資源 ora.asm
CRS-2673: 嘗試停止 'ora.asm' (在 'rac1' 上)
ORA-15097: 無法對連接有客戶機的 ASM 實例執行 SHUTDOWN
CRS-2675: 未能停止 'ora.asm' (在 'rac1' 上)
CRS-2675: 未能停止 'ora.asm' (在 'rac1' 上)
ORA-15097: 無法對連接有客戶機的 ASM 實例執行 SHUTDOWN
CRS-2675: 未能停止 'ora.asm' (在 'rac1' 上)
CRS-2675: 未能停止 'ora.asm' (在 'rac1' 上)
11gr2下,asm是cssd下面管理的要把cssd關掉查,才能關閉asm,在root用戶下,執行crs命令,關閉整個crs服務。
[root@rac1 init.d]# find / -name crsctl
/opt/rac/11.2.0/grid/bin/crsctl
[root@rac1 init.d]#/opt/rac/11.2.0/grid/bin/crsctl stop crs
eth0? 192.168.3.0? global? public
eth1? 192.168.0.0? global? cluster_interconnect
--刪除
[oracle@node1 bin]$ oifcfg delif -global eth0
--添加
[oracle@node1 bin]$ oifcfg setif -global eth0/192.168.2.0:public
5. 修改VIP
[root@rac1 bin]# ./srvctl modify nodeapps -n rac1 -A 192.168.2.202/255.255.255.0/eth0
[root@rac2 bin]# ./srvctl modify nodeapps -n rac2 -A 192.168.2.204/255.255.255.0/eth0
SCAN 名稱: rac-scan, 網絡: 1/192.168.2.0/255.255.255.0/eth0
SCAN VIP 名稱: scan1, IP: /192.168.3.205/192.168.3.205
You have new mail in /var/spool/mail/root
[root@rac1 bin]# ./srvctl stop scan_listener
[root@rac1 bin]# ./srvctl stop scan
[root@rac1 bin]# ./srvctl status scan
SCAN VIP scan1 已啟用
SCAN VIP scan1 未運行
[root@rac1 bin]# ./srvctl modify scan -n 192.168.2.205
[root@rac1 bin]# ./srvctl config scan
SCAN 名稱: 192.168.2.205, 網絡: 1/192.168.2.0/255.255.255.0/eth0
SCAN VIP 名稱: scan1, IP: /rac-scan/192.168.2.205
[root@rac1 bin]#
6.檢查狀態:
[root@rac1 bin]# ./crs_stat -t
Name?????????? Type?????????? Target??? State???? Host?????? ?
------------------------------------------------------------
ora.CRS.dg???? ora....up.type ONLINE??? ONLINE??? rac1?????? ?
ora.DATA.dg??? ora....up.type ONLINE??? ONLINE??? rac1?????? ?
ora....ER.lsnr ora....er.type ONLINE??? ONLINE??? rac1?????? ?
ora....N1.lsnr ora....er.type OFFLINE?? OFFLINE????????????? ?
ora....VERY.dg ora....up.type ONLINE??? ONLINE??? rac1?????? ?
ora.asm??????? ora.asm.type?? ONLINE??? ONLINE??? rac1?????? ?
ora.eons?????? ora.eons.type? ONLINE??? ONLINE??? rac1?????? ?
ora.gsd??????? ora.gsd.type?? ONLINE??? ONLINE??? rac1?????? ?
ora....network ora....rk.type ONLINE??? ONLINE??? rac1?????? ?
ora.oc4j?????? ora.oc4j.type? ONLINE??? ONLINE??? rac1?????? ?
ora.ons??????? ora.ons.type?? ONLINE??? ONLINE??? rac1?????? ?
ora....SM1.asm application??? ONLINE??? ONLINE??? rac1?????? ?
ora....C1.lsnr application??? ONLINE??? ONLINE??? rac1?????? ?
ora.rac1.gsd?? application??? ONLINE??? ONLINE??? rac1?????? ?
ora.rac1.ons?? application??? ONLINE??? ONLINE??? rac1?????? ?
ora.rac1.vip?? ora....t1.type ONLINE??? ONLINE??? rac1?????? ?
ora....SM2.asm application??? ONLINE??? ONLINE??? rac2?????? ?
ora....C2.lsnr application??? ONLINE??? ONLINE??? rac2?????? ?
ora.rac2.gsd?? application??? ONLINE??? ONLINE??? rac2?????? ?
ora.rac2.ons?? application??? ONLINE??? ONLINE??? rac2?????? ?
ora.rac2.vip?? ora....t1.type ONLINE??? ONLINE??? rac2?????? ?
ora.racdb.db?? ora....se.type ONLINE??? ONLINE??? rac1?????? ?
ora....ry.acfs ora....fs.type ONLINE??? ONLINE??? rac1?????? ?
ora.scan1.vip? ora....ip.type OFFLINE?? OFFLINE????????????? ?
You have new mail in /var/spool/mail/root
看到還有兩個服務沒有啟動,各自啟動:? ?
[root@rac1 bin]# ./crs_start ora.scan1.vip
嘗試啟動 `ora.scan1.vip` (在成員 `rac2` 上)
啟動 `ora.scan1.vip` (在成員 `rac2` 上) 成功。
[root@rac1 bin]# ./crs_start ora.scan2.vip
CRS-0210: Could not find resource 'ora.scan2.vip'.
查看還沒有啟動的服務全名:
[root@rac1 bin]# ./crs_stat
NAME=ora.CRS.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.DATA.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.LISTENER_SCAN1.lsnr
TYPE=ora.scan_listener.type
TARGET=OFFLINE
STATE=OFFLINE
NAME=ora.RECOVERY.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.asm
TYPE=ora.asm.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.eons
TYPE=ora.eons.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.gsd
TYPE=ora.gsd.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.net1.network
TYPE=ora.network.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.oc4j
TYPE=ora.oc4j.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.ons
TYPE=ora.ons.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.rac1.ASM1.asm
TYPE=application
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.rac1.LISTENER_RAC1.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.rac1.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.rac1.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.rac1.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.rac2.ASM2.asm
TYPE=application
TARGET=ONLINE
STATE=ONLINE on rac2
NAME=ora.rac2.LISTENER_RAC2.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE on rac2
NAME=ora.rac2.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on rac2
NAME=ora.rac2.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on rac2
NAME=ora.rac2.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=ONLINE on rac2
NAME=ora.racdb.db
TYPE=ora.database.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.registry.acfs
TYPE=ora.registry.acfs.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.scan1.vip
TYPE=ora.scan_vip.type
TARGET=ONLINE
STATE=ONLINE on rac2
再啟動沒啟動的服務
[root@rac1 bin]# ./crs_start ora.LISTENER_SCAN1.lsnr
嘗試啟動 `ora.LISTENER_SCAN1.lsnr` (在成員 `rac2` 上)
啟動 `ora.LISTENER_SCAN1.lsnr` (在成員 `rac2` 上) 成功。
[root@rac1 bin]# ./crs_stat -t
Name?????????? Type?????????? Target??? State???? Host?????? ?
------------------------------------------------------------
ora.CRS.dg???? ora....up.type ONLINE??? ONLINE??? rac1?????? ?
ora.DATA.dg??? ora....up.type ONLINE??? ONLINE??? rac1?????? ?
ora....ER.lsnr ora....er.type ONLINE??? ONLINE??? rac1?????? ?
ora....N1.lsnr ora....er.type ONLINE??? ONLINE??? rac2?????? ?
ora....VERY.dg ora....up.type ONLINE??? ONLINE??? rac1?????? ?
ora.asm??????? ora.asm.type?? ONLINE??? ONLINE??? rac1?????? ?
ora.eons?????? ora.eons.type? ONLINE??? ONLINE??? rac1?????? ?
ora.gsd??????? ora.gsd.type?? ONLINE??? ONLINE??? rac1?????? ?
ora....network ora....rk.type ONLINE??? ONLINE??? rac1?????? ?
ora.oc4j?????? ora.oc4j.type? ONLINE??? ONLINE??? rac1?????? ?
ora.ons??????? ora.ons.type?? ONLINE??? ONLINE??? rac1?????? ?
ora....SM1.asm application??? ONLINE??? ONLINE??? rac1?????? ?
ora....C1.lsnr application??? ONLINE??? ONLINE??? rac1?????? ?
ora.rac1.gsd?? application??? ONLINE??? ONLINE??? rac1?????? ?
ora.rac1.ons?? application??? ONLINE??? ONLINE??? rac1?????? ?
ora.rac1.vip?? ora....t1.type ONLINE??? ONLINE??? rac1?????? ?
ora....SM2.asm application??? ONLINE??? ONLINE??? rac2?????? ?
ora....C2.lsnr application??? ONLINE??? ONLINE??? rac2?????? ?
ora.rac2.gsd?? application??? ONLINE??? ONLINE??? rac2?????? ?
ora.rac2.ons?? application??? ONLINE??? ONLINE??? rac2?????? ?
ora.rac2.vip?? ora....t1.type ONLINE??? ONLINE??? rac2?????? ?
ora.racdb.db?? ora....se.type ONLINE??? ONLINE??? rac1?????? ?
ora....ry.acfs ora....fs.type ONLINE??? ONLINE??? rac1?????? ?
ora.scan1.vip? ora....ip.type ONLINE??? ONLINE??? rac2?????? ?
版本信息:
?? REDHAT AS5
? ORACLE 11G R2, 兩個節點。
1.修改/etc/host(rac1,rac2)
192.168.3.201?? rac1?? ??? ?--> 192.168.2.201
192.168.3.203?? rac2?? ??? ?--> 192.168.2.203
192.168.0.201?? rac1-private
192.168.0.203?? rac2-private
192.168.3.202?? rac1-vip?? ?--> 192.168.2.202
192.168.3.204?? rac2-vip?? ?--> 192.168.2.204
1.關閉服務
./crs_stop -all
./crs_stop ora.DATA.dg
./crs_stop ora.RECOVERY.dg
NAME=ora.RECOVERY.dg
TYPE=ora.diskgroup.type
TARGET=OFFLINE
STATE=ONLINE on rac2
NAME=ora.asm
TYPE=ora.asm.type
TARGET=OFFLINE
STATE=ONLINE on rac2
--------------------------------------------------
[grid@rac1 bin]$ ./srvctl stop asm -n rac1
PRCR-1014 : 無法停止資源 ora.asm
PRCR-1065 : 無法停止資源 ora.asm
CRS-2673: 嘗試停止 'ora.asm' (在 'rac1' 上)
ORA-15097: 無法對連接有客戶機的 ASM 實例執行 SHUTDOWN
CRS-2675: 未能停止 'ora.asm' (在 'rac1' 上)
CRS-2675: 未能停止 'ora.asm' (在 'rac1' 上)
ORA-15097: 無法對連接有客戶機的 ASM 實例執行 SHUTDOWN
CRS-2675: 未能停止 'ora.asm' (在 'rac1' 上)
CRS-2675: 未能停止 'ora.asm' (在 'rac1' 上)
11gr2下,asm是cssd下面管理的要把cssd關掉查,才能關閉asm,在root用戶下,執行crs命令,關閉整個crs服務。
[root@rac1 init.d]# find / -name crsctl
/opt/rac/11.2.0/grid/bin/crsctl
[root@rac1 init.d]#/opt/rac/11.2.0/grid/bin/crsctl stop crs
3.修改IP 并重啟網絡服務
????? 此步省略
eth0? 192.168.3.0? global? public
eth1? 192.168.0.0? global? cluster_interconnect
--刪除
[oracle@node1 bin]$ oifcfg delif -global eth0
--添加
[oracle@node1 bin]$ oifcfg setif -global eth0/192.168.2.0:public
?????????? (只要在一個節點修改即可)
5. 修改VIP
[root@rac1 bin]# ./srvctl modify nodeapps -n rac1 -A 192.168.2.202/255.255.255.0/eth0
[root@rac2 bin]# ./srvctl modify nodeapps -n rac2 -A 192.168.2.204/255.255.255.0/eth0
6.修改SCAN IP
SCAN 名稱: rac-scan, 網絡: 1/192.168.2.0/255.255.255.0/eth0
SCAN VIP 名稱: scan1, IP: /192.168.3.205/192.168.3.205
You have new mail in /var/spool/mail/root
[root@rac1 bin]# ./srvctl stop scan_listener
[root@rac1 bin]# ./srvctl stop scan
[root@rac1 bin]# ./srvctl status scan
SCAN VIP scan1 已啟用
SCAN VIP scan1 未運行
[root@rac1 bin]# ./srvctl modify scan -n 192.168.2.205
[root@rac1 bin]# ./srvctl config scan
SCAN 名稱: 192.168.2.205, 網絡: 1/192.168.2.0/255.255.255.0/eth0
SCAN VIP 名稱: scan1, IP: /rac-scan/192.168.2.205
[root@rac1 bin]#
6.檢查狀態:
[root@rac1 bin]# ./crs_stat -t
Name?????????? Type?????????? Target??? State???? Host?????? ?
------------------------------------------------------------
ora.CRS.dg???? ora....up.type ONLINE??? ONLINE??? rac1?????? ?
ora.DATA.dg??? ora....up.type ONLINE??? ONLINE??? rac1?????? ?
ora....ER.lsnr ora....er.type ONLINE??? ONLINE??? rac1?????? ?
ora....N1.lsnr ora....er.type OFFLINE?? OFFLINE????????????? ?
ora....VERY.dg ora....up.type ONLINE??? ONLINE??? rac1?????? ?
ora.asm??????? ora.asm.type?? ONLINE??? ONLINE??? rac1?????? ?
ora.eons?????? ora.eons.type? ONLINE??? ONLINE??? rac1?????? ?
ora.gsd??????? ora.gsd.type?? ONLINE??? ONLINE??? rac1?????? ?
ora....network ora....rk.type ONLINE??? ONLINE??? rac1?????? ?
ora.oc4j?????? ora.oc4j.type? ONLINE??? ONLINE??? rac1?????? ?
ora.ons??????? ora.ons.type?? ONLINE??? ONLINE??? rac1?????? ?
ora....SM1.asm application??? ONLINE??? ONLINE??? rac1?????? ?
ora....C1.lsnr application??? ONLINE??? ONLINE??? rac1?????? ?
ora.rac1.gsd?? application??? ONLINE??? ONLINE??? rac1?????? ?
ora.rac1.ons?? application??? ONLINE??? ONLINE??? rac1?????? ?
ora.rac1.vip?? ora....t1.type ONLINE??? ONLINE??? rac1?????? ?
ora....SM2.asm application??? ONLINE??? ONLINE??? rac2?????? ?
ora....C2.lsnr application??? ONLINE??? ONLINE??? rac2?????? ?
ora.rac2.gsd?? application??? ONLINE??? ONLINE??? rac2?????? ?
ora.rac2.ons?? application??? ONLINE??? ONLINE??? rac2?????? ?
ora.rac2.vip?? ora....t1.type ONLINE??? ONLINE??? rac2?????? ?
ora.racdb.db?? ora....se.type ONLINE??? ONLINE??? rac1?????? ?
ora....ry.acfs ora....fs.type ONLINE??? ONLINE??? rac1?????? ?
ora.scan1.vip? ora....ip.type OFFLINE?? OFFLINE????????????? ?
You have new mail in /var/spool/mail/root
看到還有兩個服務沒有啟動,各自啟動:? ?
[root@rac1 bin]# ./crs_start ora.scan1.vip
嘗試啟動 `ora.scan1.vip` (在成員 `rac2` 上)
啟動 `ora.scan1.vip` (在成員 `rac2` 上) 成功。
[root@rac1 bin]# ./crs_start ora.scan2.vip
CRS-0210: Could not find resource 'ora.scan2.vip'.
查看還沒有啟動的服務全名:
[root@rac1 bin]# ./crs_stat
NAME=ora.CRS.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.DATA.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.LISTENER_SCAN1.lsnr
TYPE=ora.scan_listener.type
TARGET=OFFLINE
STATE=OFFLINE
NAME=ora.RECOVERY.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.asm
TYPE=ora.asm.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.eons
TYPE=ora.eons.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.gsd
TYPE=ora.gsd.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.net1.network
TYPE=ora.network.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.oc4j
TYPE=ora.oc4j.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.ons
TYPE=ora.ons.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.rac1.ASM1.asm
TYPE=application
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.rac1.LISTENER_RAC1.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.rac1.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.rac1.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.rac1.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.rac2.ASM2.asm
TYPE=application
TARGET=ONLINE
STATE=ONLINE on rac2
NAME=ora.rac2.LISTENER_RAC2.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE on rac2
NAME=ora.rac2.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on rac2
NAME=ora.rac2.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on rac2
NAME=ora.rac2.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=ONLINE on rac2
NAME=ora.racdb.db
TYPE=ora.database.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.registry.acfs
TYPE=ora.registry.acfs.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.scan1.vip
TYPE=ora.scan_vip.type
TARGET=ONLINE
STATE=ONLINE on rac2
再啟動沒啟動的服務
[root@rac1 bin]# ./crs_start ora.LISTENER_SCAN1.lsnr
嘗試啟動 `ora.LISTENER_SCAN1.lsnr` (在成員 `rac2` 上)
啟動 `ora.LISTENER_SCAN1.lsnr` (在成員 `rac2` 上) 成功。
[root@rac1 bin]# ./crs_stat -t
Name?????????? Type?????????? Target??? State???? Host?????? ?
------------------------------------------------------------
ora.CRS.dg???? ora....up.type ONLINE??? ONLINE??? rac1?????? ?
ora.DATA.dg??? ora....up.type ONLINE??? ONLINE??? rac1?????? ?
ora....ER.lsnr ora....er.type ONLINE??? ONLINE??? rac1?????? ?
ora....N1.lsnr ora....er.type ONLINE??? ONLINE??? rac2?????? ?
ora....VERY.dg ora....up.type ONLINE??? ONLINE??? rac1?????? ?
ora.asm??????? ora.asm.type?? ONLINE??? ONLINE??? rac1?????? ?
ora.eons?????? ora.eons.type? ONLINE??? ONLINE??? rac1?????? ?
ora.gsd??????? ora.gsd.type?? ONLINE??? ONLINE??? rac1?????? ?
ora....network ora....rk.type ONLINE??? ONLINE??? rac1?????? ?
ora.oc4j?????? ora.oc4j.type? ONLINE??? ONLINE??? rac1?????? ?
ora.ons??????? ora.ons.type?? ONLINE??? ONLINE??? rac1?????? ?
ora....SM1.asm application??? ONLINE??? ONLINE??? rac1?????? ?
ora....C1.lsnr application??? ONLINE??? ONLINE??? rac1?????? ?
ora.rac1.gsd?? application??? ONLINE??? ONLINE??? rac1?????? ?
ora.rac1.ons?? application??? ONLINE??? ONLINE??? rac1?????? ?
ora.rac1.vip?? ora....t1.type ONLINE??? ONLINE??? rac1?????? ?
ora....SM2.asm application??? ONLINE??? ONLINE??? rac2?????? ?
ora....C2.lsnr application??? ONLINE??? ONLINE??? rac2?????? ?
ora.rac2.gsd?? application??? ONLINE??? ONLINE??? rac2?????? ?
ora.rac2.ons?? application??? ONLINE??? ONLINE??? rac2?????? ?
ora.rac2.vip?? ora....t1.type ONLINE??? ONLINE??? rac2?????? ?
ora.racdb.db?? ora....se.type ONLINE??? ONLINE??? rac1?????? ?
ora....ry.acfs ora....fs.type ONLINE??? ONLINE??? rac1?????? ?
ora.scan1.vip? ora....ip.type ONLINE??? ONLINE??? rac2?????? ?
[root@rac1 bin]#
參考資料:
http://www.doc88.com/p-994532134585.html
http://wenku.baidu.com/view/ebc6d2d728ea81c758f57841.html
總結
以上是生活随笔為你收集整理的RAC IP 地址修改的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: ORACLE 执行计划2
- 下一篇: 建立表/索引时的 存储参数:【PCTUS