March 2011 – Page 2

[PL/SQL Notes] PRAGMA AUTONOMOUS_TRANSACTION

自治事务，在PL/SQL语句内部执行。
在声明部分使用编译指示说明的，就标为自治，

Create or replace procedure Autonomous AS
    PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
  ...
    COMMIT; -- should be finished by commit/rollback, 
            -- or ora-6519 errno.
END Antomomouns

Create or replace procedure Autonomous AS

PRAGMA AUTONOMOUS_TRANSACTION;

BEGIN

...

COMMIT; -- should be finished by commit/rollback,

-- or ora-6519 errno.

END Antomomouns

嵌套块不可以声明为自治，
只有包中的单独子程序可以标记为自治，包本身不能标记自治。
or,PLS-710

java.io.FileNotFoundException: datamodeler.log on sqldeveloper

sqldeveloper reported warning on datamodeler.log.

after check on OS,the sqldeveloper failed to create logs for priviledge issues.

# cd /opt/sqldeveloper/sqldeveloper/
# mkdir -p extensions/oracle.datamodeler/log
#chown user_to_run_ide  extensions/oracle.datamodeler/log

# cd /opt/sqldeveloper/sqldeveloper/

# mkdir -p extensions/oracle.datamodeler/log

#chown user_to_run_ide extensions/oracle.datamodeler/log

[suse@suse-pc ~]$ sqldeveloper

Oracle SQL Developer
Copyright (c) 1997, 2011, Oracle and/or its affiliates. All rights reserved.

log4j:ERROR setFile(null,true) call failed.
java.io.FileNotFoundException: ../extensions/oracle.datamodeler/log/datamodeler.log (No such file or directory)
at java.io.FileOutputStream.openAppend(Native Method)
at java.io.FileOutputStream.&lt;init&gt;(FileOutputStream.java:177)
at java.io.FileOutputStream.&lt;init&gt;(FileOutputStream.java:102)
at org.apache.log4j.FileAppender.setFile(FileAppender.java:273)
at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:156)
at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:152)
at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:247)

[suse@suse-pc ~]$ sqldeveloper

Oracle SQL Developer

log4j:ERROR setFile(null,true) call failed.

java.io.FileNotFoundException: ../extensions/oracle.datamodeler/log/datamodeler.log (No such file or directory)

at java.io.FileOutputStream.openAppend(Native Method)

at java.io.FileOutputStream.<init>(FileOutputStream.java:177)

at java.io.FileOutputStream.<init>(FileOutputStream.java:102)

at org.apache.log4j.FileAppender.setFile(FileAppender.java:273)

at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:156)

at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:152)

at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:247)

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

RPMFusion not Available to Fedora 11 update

今天在家切到F11下面，配置pidgin
发现RPMFusion的repo已经不能用了，上官网一看，已经不再支持F11了。

于是考虑，是否需要把OS 升级到F14

****
3月10日 update,
经测试，F11的RPMFusion update仍然available…暂无upgrade os计划。

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.