Monthly Archives: May 2007
Oracle startup/shutdown trigger
主要是用来监视veritas在进行cold backup的时候是否已经shutdown然后startup数据库. veritas 由其它的 team 进行管理. 注意: shutdown abort 不会被trigger记录. 原因: all session get killed this time.SQL> create table t01 (when date,what varchar2(50),who varchar2(50));Table created.SQL> create or replace trigger a_startup after startup on database 2 begin 3 insert into t01 … Continue reading
DBD::Oracle::st fetchrow warning: (err=0, errstr=undef, state=undef)
问题: DBD::Oracle::st fetchrow warning: (err=0, errstr=undef, state=undef) at test.pl line 65. 1. 首先google到一个: http://coding.derkeiler.com/Archive/Perl/perl.dbi.users/2005-12/, 进去是一堆的DBD::Oracle问题和答案. 2. 可以看到DBD::Oracle的作者Tim.Bunce 关于这个问题的解答: http://coding.derkeiler.com/Archive/Perl/perl.dbi.users/2005-12/msg00205.html ..That was fixed in 1.16. The Changes file says:Fixed setting of $DBI::err to 0 triggering PrintWarn in DBI >= 1.41.… 3. … Continue reading
Today’s Task
又是平凡的一天… -cold backup script (sun + oracle 10g).-cold backup daily check scripts -update disk mount point monitoring scripts -data fix SQL script from developer -daily report checking -SAP daily check 1 hour
老庞闲话 