I’m now reading <Oracle9i PL/SQL Programming> (by Scott Urman)
which is too old that I cannot find souce code from www.osborne.com.
Just found from the following link. Also a good place to find aids for old books from Oracle Press.
CIDR
Today when run into Xdata Doc, on configuration of cellinit.ora,
showed the IP address for each DB that conn to Xdata cell, formatted in CIDR.
|
1 |
ipaddress1=192.168.50.23/24 |
The CIDR format stands for the Classless Inter-Domain Routing ,note.
NUMA
学着点….
又更新一下给乃们RSS订阅者s
MTXrun | unknown script ‘context.lua’ or ‘mtx-context.lua’
今天突然想起来更新ConTeXt,—其实也不是非常突然，因为两年没更新了…然后就随便看了下
直接更新报错，于是索性全新安装，然后在context编译文件时出错
|
1 |
MTXrun | unknown script 'context.lua' or 'mtx-context.lua' |
Solution,
run
|
1 |
luatools --generate |
ERROR: no PST quorum in group: required 2, found 0
今天在Xdata上犯了个小错误。。 上午忙活了半天
几个DG一直没办法MOUNT，显示问题很难看。只觉得是disk missing 又没说具体哪个disk，
然后 mount force也不顶用。
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
SQL> ALTER DISKGROUP high MOUNT force NOTE: cache registered group HIGH number=1 incarn=0x9679682f NOTE: cache began mount (first) of group HIGH number=1 incarn=0x9679682f Sun Dec 26 22:01:38 2010 ERROR: no PST quorum in group: required 2, found 0 NOTE: cache dismounting (not clean) group 1/0x9679682F (HIGH) NOTE: dbwr not being msg'd to dismount NOTE: lgwr not being msg'd to dismount NOTE: cache dismounted group 1/0x9679682F (HIGH) NOTE: cache ending mount (fail) of group HIGH number=1 incarn=0x9679682f NOTE: cache deleting context for group HIGH 1/0x9679682f GMON dismounting group 1 at 31 for pid 29, osid 19112 ERROR: diskgroup HIGH was not mounted ORA-15032: not all alterations performed ORA-15017: diskgroup "HIGH" cannot be mounted ORA-15063: ASM discovered an insufficient number of disks for diskgroup "HIGH" ERROR: ALTER DISKGROUP high MOUNT force |
找了半天发现是重启instance时候不小心，discovery_string改掉了，
是我以前本用来建OCRVD时候，DG太多用来过滤的，于是只好改了回来。。
|
1 2 3 |
asm_diskstring = "/o/*/PCW_CD_01*" ... ALTER SYSTEM SET asm_diskstring='/o/*/*' SCOPE=BOTH SID='*'; |
然后mount就一切顺利了。。。看来有时候小细节不能忽视啊。。