By Allen, on January 16th, 2010
從11g開始…AlertLog開始變成了XML的格式,目的是方便其他軟體來分析LOG File…
for 10G
$oracle_home\admin\SID\bdump\alert.log
for 11G
SQL> select value from v$diag_info where name =’Diag Alert’;
VALUE
——————————————————————————–
/opt/oracle/diag/rdbms/orcl/orcl/alert
SQL> select value from v$diag_info where name =’Diag Alert’;
VALUE
——————————————————————————–
/opt/oracle/diag/rdbms/orcl/orcl/alert
SQL> select value from v$diag_info where name . . . → Read More: Alert Log for 11G
By Allen, on January 11th, 2010
揮別2009
2010對於我來說…又是另一個十年的開始,
上一次是2000年…那時候並不覺得怎麼樣…大概因為年紀的增長..覺得時間過越來越快…
某種程度上也算是越來越害怕吧…XDD
新年新希望…
希望我有Mac . . . → Read More: 新年快樂…
By Allen, on December 29th, 2009
真的太懶了…XDD,基本上當系統多到一定程度的時候,就因該進化到異常管理與通知….
人在怎麼勤快,一定會有懶散的時候…
這時候就是想想辦法讓電腦幫我們檢查個個系統的狀態與回報的時候,
前提：你已經裝好Nagios….:P
因Nagios…沒有report的功能…所以我就用python做了一個把網頁轉寄出去的功能…以應付老闆XDD
#!/usr/bin/env python
#-*- coding: utf-8 -*-
”’
===== Check Spam Report Script =====
Log:
2009/12/20 10:42 ver 0.1 Create Script “The mail system daily check”
2009/12/20 15:40 ver 0.5 add css in the daily report
2010/01/04 14:00 ver 1.0 fix all html link in mail
====================================
”’
from subprocess import call
from email.MIMEMultipart import MIMEMultipart
from email.MIMEText import MIMEText
from email.MIMEImage import MIMEImage
import os
import sys
import urllib
import smtplib
import time
import . . . → Read More: daily system check and send mail
By Allen, on December 17th, 2009
在有些Linux下會發生RMAN就給你錯誤訊息….rman: can’t open . . . → Read More: rman error
By Allen, on December 17th, 2009
這幾天苦惱於如何將Oracle Client裝在Win7上…
在Google大神的幫助下,終於找到方法可以安裝,不過….
這個方法只是pass他的檢查機制…並不是原廠所出的軟體…
作法如下…
修改refhost.xml檔案
<!–Microsoft Windows . . . → Read More: Oracle Client for Win7 64bit
By Allen, on December 9th, 2009
今天寫了一個script來協助daily check…
沒用到太高級的方法,只是把事情搞定而已….
python,真是一個好物啊…:D
#!/usr/bin/env python
#-*- coding: utf-8 -*-
”’
===== Check Spam Report Script =====
Log:
2009/12/09 21:58 ver 1.0 Create Script
2009/12/10 13:30 ver 1.1 add localtime
2009/12/11 ver 1.5 add if spam reboot count is equal 0 send massage
2009/12/12 16:02 ver 2.0 The spam report state sent to system
2009/12/29 11:20 ver 2.1 improve send mail in python function
2010/02/02 11:00 ver 2.2 . . . → Read More: Check Spam Report
By Allen, on December 5th, 2009
稍早在網路上知道FreeBSD Released了…
也就順手把一台beta,升到released…
步驟如下,
setp 1
#cp /usr/share/examples/cvsup/stable-supfile /root/8release
#vi /root/8release
setp 2
*default host=cvsup.tw.FreeBSD.org
*default release=cvs . . . → Read More: FreeBSD 8 Released
By Allen, on November 23rd, 2009
There is no excerpt because this is a protected post.
By Allen, on November 17th, 2009
. . . → Read More: 祝我生日快樂！！
By Allen, on November 10th, 2009
主機爆炸好幾天了(約一個多月吧)XDD
剛剛把他先轉到Virtualbox上了…
因為之前VM與Virtualbox會打架….
而我又熱愛OPEN Source….
所以, 當然, 肯定是, Virtualbox….XDD
ps. . . . → Read More: 終於…
