Oracle Management – Page 3

Use kfed to read ASM disk metadata

又有几时没有更新了，又挤着写东西
kfed可以read/merge，这样可以把一些Disk Metadata以一种可以读的方式展示出来。

养成好习惯还是要的。

[bee@hostname0db01 ~]$ kfed read 'o/192.168.3.23/N5_CD_06_hostname0cel07'
kfbh.endian:                          1 ; 0x000: 0x01
kfbh.hard:                          130 ; 0x001: 0x82
kfbh.type:                            1 ; 0x002: KFBTYP_DISKHEAD
kfbh.datfmt:                          1 ; 0x003: 0x01
kfbh.block.blk:                       0 ; 0x004: T=0 NUMB=0x0
kfbh.block.obj:              2147483696 ; 0x008: TYPE=0x8 NUMB=0x30
kfbh.check:                  2399392961 ; 0x00c: 0x8f03d4c1
kfbh.fcn.base:                        0 ; 0x010: 0x00000000
kfbh.fcn.wrap:                        0 ; 0x014: 0x00000000
kfbh.spare1:                          0 ; 0x018: 0x00000000
kfbh.spare2:                          0 ; 0x01c: 0x00000000
kfdhdb.driver.provstr:         ORCLDISK ; 0x000: length=8
kfdhdb.driver.reserved[0]:            0 ; 0x008: 0x00000000
kfdhdb.driver.reserved[1]:            0 ; 0x00c: 0x00000000
kfdhdb.driver.reserved[2]:            0 ; 0x010: 0x00000000
kfdhdb.driver.reserved[3]:            0 ; 0x014: 0x00000000
kfdhdb.driver.reserved[4]:            0 ; 0x018: 0x00000000
kfdhdb.driver.reserved[5]:            0 ; 0x01c: 0x00000000
kfdhdb.compat:                186646528 ; 0x020: 0x0b200000
kfdhdb.dsknum:                       48 ; 0x024: 0x0030
kfdhdb.grptyp:                        2 ; 0x026: KFDGTP_NORMAL
kfdhdb.hdrsts:                        3 ; 0x027: KFDHDR_MEMBER
kfdhdb.dskname: N5_CD_06_hostname0cel07 ; 0x028: length=23
kfdhdb.grpname:                  NORMAL ; 0x048: length=6
kfdhdb.fgname:           hostname0cel07 ; 0x068: length=14
kfdhdb.capname:                         ; 0x088: length=0
kfdhdb.crestmp.hi:             32951617 ; 0x0a8: HOUR=0x1 DAYS=0xa MNTH=0x3 YEAR=0x7db
kfdhdb.crestmp.lo:            773907456 ; 0x0ac: USEC=0x0 MSEC=0x39 SECS=0x22 MINS=0xb
kfdhdb.mntstmp.hi:             32951617 ; 0x0b0: HOUR=0x1 DAYS=0xa MNTH=0x3 YEAR=0x7db
kfdhdb.mntstmp.lo:            792303616 ; 0x0b4: USEC=0x0 MSEC=0x266 SECS=0x33 MINS=0xb
kfdhdb.secsize:                     512 ; 0x0b8: 0x0200
kfdhdb.blksize:                    4096 ; 0x0ba: 0x1000
kfdhdb.ausize:                  4194304 ; 0x0bc: 0x00400000
kfdhdb.mfact:                    454272 ; 0x0c0: 0x0006ee80
kfdhdb.dsksize:                    5120 ; 0x0c4: 0x00001400
kfdhdb.pmcnt:                         2 ; 0x0c8: 0x00000002
kfdhdb.fstlocn:                       1 ; 0x0cc: 0x00000001
kfdhdb.altlocn:                       2 ; 0x0d0: 0x00000002
kfdhdb.f1b1locn:                      0 ; 0x0d4: 0x00000000
kfdhdb.redomirrors[0]:                0 ; 0x0d8: 0x0000
kfdhdb.redomirrors[1]:                0 ; 0x0da: 0x0000
kfdhdb.redomirrors[2]:                0 ; 0x0dc: 0x0000
kfdhdb.redomirrors[3]:                0 ; 0x0de: 0x0000
kfdhdb.dbcompat:              186646528 ; 0x0e0: 0x0b200000
kfdhdb.grpstmp.hi:             32951617 ; 0x0e4: HOUR=0x1 DAYS=0xa MNTH=0x3 YEAR=0x7db
kfdhdb.grpstmp.lo:            766188544 ; 0x0e8: USEC=0x0 MSEC=0x2c7 SECS=0x1a MINS=0xb
kfdhdb.vfstart:                       0 ; 0x0ec: 0x00000000
kfdhdb.vfend:                         0 ; 0x0f0: 0x00000000
kfdhdb.spfile:                        0 ; 0x0f4: 0x00000000
kfdhdb.spfflg:                        0 ; 0x0f8: 0x00000000

[bee@hostname0db01 ~]$ kfed read 'o/192.168.3.23/N5_CD_06_hostname0cel07'

kfbh.endian: 1 ; 0x000: 0x01

kfbh.hard: 130 ; 0x001: 0x82

kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD

kfbh.datfmt: 1 ; 0x003: 0x01

kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0

kfbh.block.obj: 2147483696 ; 0x008: TYPE=0x8 NUMB=0x30

kfbh.check: 2399392961 ; 0x00c: 0x8f03d4c1

kfbh.fcn.base: 0 ; 0x010: 0x00000000

kfbh.fcn.wrap: 0 ; 0x014: 0x00000000

kfbh.spare1: 0 ; 0x018: 0x00000000

kfbh.spare2: 0 ; 0x01c: 0x00000000

kfdhdb.driver.provstr: ORCLDISK ; 0x000: length=8

kfdhdb.driver.reserved[0]: 0 ; 0x008: 0x00000000

kfdhdb.driver.reserved[1]: 0 ; 0x00c: 0x00000000

kfdhdb.driver.reserved[2]: 0 ; 0x010: 0x00000000

kfdhdb.driver.reserved[3]: 0 ; 0x014: 0x00000000

kfdhdb.driver.reserved[4]: 0 ; 0x018: 0x00000000

kfdhdb.driver.reserved[5]: 0 ; 0x01c: 0x00000000

kfdhdb.compat: 186646528 ; 0x020: 0x0b200000

kfdhdb.dsknum: 48 ; 0x024: 0x0030

kfdhdb.grptyp: 2 ; 0x026: KFDGTP_NORMAL

kfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBER

kfdhdb.dskname: N5_CD_06_hostname0cel07 ; 0x028: length=23

kfdhdb.grpname: NORMAL ; 0x048: length=6

kfdhdb.fgname: hostname0cel07 ; 0x068: length=14

kfdhdb.capname: ; 0x088: length=0

kfdhdb.crestmp.hi: 32951617 ; 0x0a8: HOUR=0x1 DAYS=0xa MNTH=0x3 YEAR=0x7db

kfdhdb.crestmp.lo: 773907456 ; 0x0ac: USEC=0x0 MSEC=0x39 SECS=0x22 MINS=0xb

kfdhdb.mntstmp.hi: 32951617 ; 0x0b0: HOUR=0x1 DAYS=0xa MNTH=0x3 YEAR=0x7db

kfdhdb.mntstmp.lo: 792303616 ; 0x0b4: USEC=0x0 MSEC=0x266 SECS=0x33 MINS=0xb

kfdhdb.secsize: 512 ; 0x0b8: 0x0200

kfdhdb.blksize: 4096 ; 0x0ba: 0x1000

kfdhdb.ausize: 4194304 ; 0x0bc: 0x00400000

kfdhdb.mfact: 454272 ; 0x0c0: 0x0006ee80

kfdhdb.dsksize: 5120 ; 0x0c4: 0x00001400

kfdhdb.pmcnt: 2 ; 0x0c8: 0x00000002

kfdhdb.fstlocn: 1 ; 0x0cc: 0x00000001

kfdhdb.altlocn: 2 ; 0x0d0: 0x00000002

kfdhdb.f1b1locn: 0 ; 0x0d4: 0x00000000

kfdhdb.redomirrors[0]: 0 ; 0x0d8: 0x0000

kfdhdb.redomirrors[1]: 0 ; 0x0da: 0x0000

kfdhdb.redomirrors[2]: 0 ; 0x0dc: 0x0000

kfdhdb.redomirrors[3]: 0 ; 0x0de: 0x0000

kfdhdb.dbcompat: 186646528 ; 0x0e0: 0x0b200000

kfdhdb.grpstmp.hi: 32951617 ; 0x0e4: HOUR=0x1 DAYS=0xa MNTH=0x3 YEAR=0x7db

kfdhdb.grpstmp.lo: 766188544 ; 0x0e8: USEC=0x0 MSEC=0x2c7 SECS=0x1a MINS=0xb

kfdhdb.vfstart: 0 ; 0x0ec: 0x00000000

kfdhdb.vfend: 0 ; 0x0f0: 0x00000000

kfdhdb.spfile: 0 ; 0x0f4: 0x00000000

kfdhdb.spfflg: 0 ; 0x0f8: 0x00000000

Source Code Archives of O-Press Books

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.

ERROR: no PST quorum in group: required 2, found 0

今天在Xdata上犯了个小错误。。上午忙活了半天
几个DG一直没办法MOUNT，显示问题很难看。只觉得是disk missing 又没说具体哪个disk，
然后 mount force也不顶用。

SQL&gt;   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

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太多用来过滤的，于是只好改了回来。。

 asm_diskstring           = "/o/*/PCW_CD_01*"
 ...
 ALTER SYSTEM SET asm_diskstring='/o/*/*' SCOPE=BOTH SID='*';

asm_diskstring = "/o/*/PCW_CD_01*"

...

ALTER SYSTEM SET asm_diskstring='/o/*/*' SCOPE=BOTH SID='*';

然后mount就一切顺利了。。。看来有时候小细节不能忽视啊。。

about limits.conf

昨天有一个节点突然登录不上了，本以为是节点压力太大，后来发现root倒是能登。
居然是user limitation了…

之前没遇过，呵呵

[bee@db01 tmp]# ssh db04
Read from remote host db04: Connection reset by peer
Connection to db04 closed.
[root@db04 ~]# su - bee
su: cannot set user id: Resource temporarily unavailable

[bee@db01 tmp]# ssh db04

Read from remote host db04: Connection reset by peer

Connection to db04 closed.

[root@db04 ~]# su - bee

su: cannot set user id: Resource temporarily unavailable

于是查一下子看到了问题,资源上限了～～难得

[root@db04 ~]# ps -U bee | wc -l
2433
[root@db04 ~]# lsof| grep bee | wc -l
61138

[root@db04 ~]# ps -U bee | wc -l

2433

[root@db04 ~]# lsof| grep bee | wc -l

61138

[root@db04 ~]# w -f
 23:53:54 up 23 days,  6:16, 17 users,
 load average: 795.44, 794.94, 794.84
USER     TTY        LOGIN@   IDLE   JCPU   PCPU WHAT
bee     pts/0     17Nov10  5days  4.94s  0.01s sshd: bee [priv]
bee     pts/1     01Nov10  6days  2:53   2:53  sh
bee     pts/2     18Nov10 50:48   0.68s  0.68s -bash
bee     pts/3     01Nov10  6days 17.60s  0.01s sshd: bee [priv]
bee     pts/4     01Nov10 23days  2.70s  2.68s vmstat 2
bee     pts/5     01Nov10 23days  3:13m  3:13m top
bee     pts/6     01Nov10 21days  0.37s  0.01s sshd: bee [priv]
bee     pts/7     01Nov10 21days  0.33s  0.01s sshd: bee [priv]
bee     pts/8     01Nov10 21days  0.34s  0.01s sshd: bee [priv]
bee     pts/9     01Nov10 21days  0.04s  0.04s -bash
bee     pts/10    01Nov10 21days  0.06s  0.06s -bash
bee     pts/11    01Nov10 22days  0.01s  0.01s -bash
bee     pts/13    Mon08    2days  2.50s  0.01s sshd: bee [priv]
bee     pts/14    03Nov10 21days  0.02s  0.02s -bash
bee     pts/15    02Nov10 22days  0.02s  0.02s -bash
bee     pts/16    02Nov10 21days  0.03s  0.03s -bash
root    pts/18    23:21    0.00s  0.07s  0.03s -bash

[root@db04 ~]# w -f

23:53:54 up 23 days, 6:16, 17 users,

load average: 795.44, 794.94, 794.84

USER TTY LOGIN@ IDLE JCPU PCPU WHAT

bee pts/0 17Nov10 5days 4.94s 0.01s sshd: bee [priv]

bee pts/1 01Nov10 6days 2:53 2:53 sh

bee pts/2 18Nov10 50:48 0.68s 0.68s -bash

bee pts/3 01Nov10 6days 17.60s 0.01s sshd: bee [priv]

bee pts/4 01Nov10 23days 2.70s 2.68s vmstat 2

bee pts/5 01Nov10 23days 3:13m 3:13m top

bee pts/6 01Nov10 21days 0.37s 0.01s sshd: bee [priv]

bee pts/7 01Nov10 21days 0.33s 0.01s sshd: bee [priv]

bee pts/8 01Nov10 21days 0.34s 0.01s sshd: bee [priv]

bee pts/9 01Nov10 21days 0.04s 0.04s -bash

bee pts/10 01Nov10 21days 0.06s 0.06s -bash

bee pts/11 01Nov10 22days 0.01s 0.01s -bash

bee pts/13 Mon08 2days 2.50s 0.01s sshd: bee [priv]

bee pts/14 03Nov10 21days 0.02s 0.02s -bash

bee pts/15 02Nov10 22days 0.02s 0.02s -bash

bee pts/16 02Nov10 21days 0.03s 0.03s -bash

root pts/18 23:21 0.00s 0.07s 0.03s -bash

[root@db04 ~]# cat /etc/security/limits.conf 

#######  Oracle ##############
bee           soft    nproc   2047
bee           hard    nproc   16384
bee           soft    nofile  1024
bee           hard    nofile  65536

[root@db04 ~]# cat /etc/security/limits.conf

####### Oracle ##############

bee soft nproc 2047

bee hard nproc 16384

bee soft nofile 1024

bee hard nofile 65536