Archive for February, 2008

最有创意的新春短信

Thursday, February 7th, 2008

erpdb warning:ORA-02008:Hi guy,don’t worry,thanks for your care,I’m all right and strong,happy new year,dbas.
jacky祝大家2008新年快乐，万事如意。恋爱的恋爱，结婚的结婚，造人的造人，当爹的当爹，P10的升P11，数据库坚如磐石，alidba纳斯达克上市。
2008 Be part of something BIG!!!

Posted in 生活八卦 | 4 Comments »

今天我干的事，确实很怪

Sunday, February 3rd, 2008

由于我自己做了大量的DML操作，我CANCEL掉了。发现v$locked_object里还有被自己LOCK住的进程，火大了。就干脆来了把猛的：
select ‘kill -9 ‘ || a.spid from v$process a ,v$session b
where a.addr=b.paddr and machine like ‘%crmtest%’ ；（crmtest是我的主机名）
然后莫名其妙的事情就发生了：
补充下：我的SID：CRMCN，ORACLE 9.2.0.4 LINUX
远程是可以访问，但是本地除了SYSDBA以外，所有的用户都无法连接，就hang在那里。
可以SELECT,UPDATE，但是无法进行COMMIT;
@>SELECT SPID FROM V$PROCESS WHERE ADDR IN (SELECT PADDR FROM V$SESSION WHERE type <> ‘USER’);SPID
————
3687
3691
3693
3695
3697
3699
3703
3707 8 rows selected.@>HOST
oracle@crmtest:/home/oracle>ps -ef | grep 3687
oracle 29759 29728 0 14:01 pts/9 00:00:00 grep 3687
oracle@crmtest:/home/oracle>
再来一次：
oracle@crmtest:/home/oracle>ps -ef | grep pmon
oracle 17660 1 0 [...]

Posted in 大话技术 | 1 Comment »

街头惊现alidba广告

Saturday, February 2nd, 2008

Posted in 生活八卦 | 2 Comments »

强悍的oracle 文档中的错误解释

Saturday, February 2nd, 2008

http://download.oracle.com/docs/cd/B19306_01/server.102/b14219/plsus.htm#PLS-00101
PLS-00101: reserved for future use

Cause: This error message is not used yet. (Heh, heh, that”s a joke, son.)

Action: none

Posted in 大话技术 | 2 Comments »

Next Entries »
DBA