Alert Log for 11G

從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 =’Diag Trace’;

VALUE
——————————————————————————–
/opt/oracle/diag/rdbms/orcl/orcl/trace

技術

daily system check and send mail

真的太懶了…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 re

__author__ = "AllenWang"
__copyright__ = "Copyright 2009, SYSTEM CHECK FOR MAIL REPORT Project"
__credits__ = "Allen Wang"
__license__ = "GPL"
__version__ = "1.0"
__maintainer__ = "Allen Wang"
__email__ = "allencswang@gmail.com"
__status__ = "Released"

def getstate(url, file):
    '''GET INFORMATION FROM NAGIOS WEB SITE'''
    #url = "http://nagios.XXXX.com/nagios/cgi-bin/status.cgi?hostgroup=dominoserver&amp;style=detail"
    #file = "system_state.txt"
    wp = urllib.urlopen(url)
    content = wp.read()

    fp = open(file,"w")
    fp.write(content)
    fp.close()
    return True

def replace(r_txt, r_url, data):
    '''FIX HTML LINK '''
    #r_url = 'http://nagios.XXXX.com/nagios/cgi-bin/status.cgi'
    #r_txt = 'status.cgi'
    pattern = re.compile(r_txt, re.IGNORECASE)

    fp = open("tmp", "w")
    for line in file(data):
        fp.write(pattern.sub(r_url, line))

    fp.close()
    os.rename("tmp",data)
    return True

def msend_html(server, strFrom, strTo, subject, file):
    '''SEND MAIL'''
    #Define these once; use them twice!
    #strFrom = 'allen.wang@XXXX.com'
    #strTo = 'allen.wang@XXXX.com'

    #Create the root message and fill in the from, to, and subject headers
    msgRoot = MIMEMultipart('related')
    msgRoot['Subject'] = subject
    msgRoot['From'] = strFrom
    msgRoot['To'] = strTo
    msgRoot.preamble = 'This is a multi-part message in MIME format.'

    #Encapsulate the plain and HTML versions of the message body in an
    #'alternative' part, so message agents can decide which they want to display.
    msgAlternative = MIMEMultipart('alternative')
    msgRoot.attach(msgAlternative)

    msgText = MIMEText('This is the alternative plain text message.')
    msgAlternative.attach(msgText)

    #We reference the image in the IMG SRC attribute by the ID we give it below
    fp = open(file, 'rb')
    msgText = MIMEText(fp.read(), 'html')
    msgAlternative.attach(msgText)
    fp.close()

    #This example assumes the image is in the current directory
    #fp = open('test.jpg', 'rb')
    #msgImage = MIMEImage(fp.read())
    #fp.close()

    #Send the email (this example assumes SMTP authentication is required)
    smtp = smtplib.SMTP()
    smtp.connect(server)
    #smtp.login('exampleuser', 'examplepass')
    smtp.sendmail(strFrom, strTo, msgRoot.as_string())
    smtp.quit()
    return True

def main():
    url = "http://nagios.XXXX.com/nagios/cgi-bin/status.cgi?hostgroup=dominoserver&amp;style=detail"
    file = "system_state.txt"
    r_url = 'http://nagios.XXXX.com/nagios'
    r_txt = "/nagios"
    getstate(url, file)
    replace(r_txt, r_url, file)
    r_url = 'http://nagios.XXXX.com/nagios/cgi-bin/status.cgi'
    r_txt = 'status.cgi'
    replace(r_txt, r_url, file)
    r_url = 'http://nagios.XXXX.com/nagios/cgi-bin/extinfo.cgi'
    r_txt = 'extinfo.cgi'
    replace(r_txt, r_url, file)
    localtime = time.strftime("%H:%M", time.localtime())
    subject = 'The mail system daily report at %s' % (localtime)
    msend_html('10.181.59.137', 'allen.wang@XXXX.com', 'allen.wang@XXXX.com', subject, file)
    os.remove(file)

if __name__ == '__main__':
    main()

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

#!/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 re

__author__ = "AllenWang"

__credits__ = "Allen Wang"

__license__ = "GPL"

__version__ = "1.0"

__maintainer__ = "Allen Wang"

__email__ = "allencswang@gmail.com"

__status__ = "Released"

def getstate(url, file):

'''GET INFORMATION FROM NAGIOS WEB SITE'''

#url = "http://nagios.XXXX.com/nagios/cgi-bin/status.cgi?hostgroup=dominoserver&style=detail"

#file = "system_state.txt"

wp = urllib.urlopen(url)

content = wp.read()

fp = open(file,"w")

fp.write(content)

fp.close()

return True

def replace(r_txt, r_url, data):

'''FIX HTML LINK '''

#r_url = 'http://nagios.XXXX.com/nagios/cgi-bin/status.cgi'

#r_txt = 'status.cgi'

pattern = re.compile(r_txt, re.IGNORECASE)

fp = open("tmp", "w")

for line in file(data):

fp.write(pattern.sub(r_url, line))

fp.close()

os.rename("tmp",data)

return True

def msend_html(server, strFrom, strTo, subject, file):

'''SEND MAIL'''

#Define these once; use them twice!

#strFrom = 'allen.wang@XXXX.com'

#strTo = 'allen.wang@XXXX.com'

#Create the root message and fill in the from, to, and subject headers

msgRoot = MIMEMultipart('related')

msgRoot['Subject'] = subject

msgRoot['From'] = strFrom

msgRoot['To'] = strTo

msgRoot.preamble = 'This is a multi-part message in MIME format.'

#Encapsulate the plain and HTML versions of the message body in an

#'alternative' part, so message agents can decide which they want to display.

msgAlternative = MIMEMultipart('alternative')

msgRoot.attach(msgAlternative)

msgText = MIMEText('This is the alternative plain text message.')

msgAlternative.attach(msgText)

#We reference the image in the IMG SRC attribute by the ID we give it below

fp = open(file, 'rb')

msgText = MIMEText(fp.read(), 'html')

msgAlternative.attach(msgText)

fp.close()

#This example assumes the image is in the current directory

#fp = open('test.jpg', 'rb')

#msgImage = MIMEImage(fp.read())

#fp.close()

#Send the email (this example assumes SMTP authentication is required)

smtp = smtplib.SMTP()

smtp.connect(server)

#smtp.login('exampleuser', 'examplepass')

smtp.sendmail(strFrom, strTo, msgRoot.as_string())

smtp.quit()

return True

def main():

url = "http://nagios.XXXX.com/nagios/cgi-bin/status.cgi?hostgroup=dominoserver&style=detail"

file = "system_state.txt"

r_url = 'http://nagios.XXXX.com/nagios'

r_txt = "/nagios"

getstate(url, file)

replace(r_txt, r_url, file)

r_url = 'http://nagios.XXXX.com/nagios/cgi-bin/status.cgi'

r_txt = 'status.cgi'

replace(r_txt, r_url, file)

r_url = 'http://nagios.XXXX.com/nagios/cgi-bin/extinfo.cgi'

r_txt = 'extinfo.cgi'

replace(r_txt, r_url, file)

localtime = time.strftime("%H:%M", time.localtime())

subject = 'The mail system daily report at %s' % (localtime)

msend_html('10.181.59.137', 'allen.wang@XXXX.com', 'allen.wang@XXXX.com', subject, file)

os.remove(file)

if __name__ == '__main__':

main()

python 讚啦…
搞定收工…:P

技術

rman error

在有些Linux下會發生RMAN就給你錯誤訊息….rman: can’t open target

其原因是因為在Linux下有一個類似的程式叫作/usr/X11R6/bin/rman

所以你執行的根本就不是ORACLE的RMAN….XDD

修正方法把$ORACLE_HOME/bin的PATH放在/usr/X11R6/bin/之前即可…

export PATH=$ORACLE_HOME/bin:$PATH

這樣因該就可以開始快樂的RMAN了XDD

技術

Oracle Client for Win7 64bit

這幾天苦惱於如何將Oracle Client裝在Win7上…
在Google大神的幫助下,終於找到方法可以安裝,不過….
這個方法只是pass他的檢查機制…並不是原廠所出的軟體…

作法如下…

修改refhost.xml檔案
<!–Microsoft Windows 7–>
<OPERATING_SYSTEM>
<VERSION VALUE=”6.1″/>
</OPERATING_SYSTEM>
搞定…

ps.如果在同一個目錄或是軟體有多個refhost.xml檔…都必須修改…

技術

Check Spam Report

今天寫了一個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 fix sendmail problem
====================================
'''
import smtplib
import sys
import time
import commands

__copyright__ = "Copyright 2009, Check Spam Report Script"  
__create_date__ = '2009/12/09 21:58'
__version__ = '2.2'
__author__ = 'Allen Wang'
__email__ = 'allencswang@gmail.com'
__credits__ = "Allen Wang"  
__license__ = "GPL"  
__maintainer__ = "Allen Wang"  
__status__ = "Released"  

def chklog(sent, chkcount, chktime):
    cmd = 'cat /var/log/maillog |grep "%s" |grep "%s" |wc -l' % (sent, chktime)
    localtime = time.strftime("%H:%M", time.localtime())
    logcount = commands.getoutput(cmd)
    if int(logcount) == 0:
        emsg(logcount,localtime)
    elif int(logcount) < int(chkcount):
        emsg(logcount,localtime)
    else:
        print 'Check time: %s' % (localtime)
        print 'Total sent %s spam report' % (logcount)
        send_state(logcount,localtime)

def emsg(logcount,localtime):
    print 'Check time: %s' % (localtime)
    print 'please check you spam server,because only sent %s spam mail report' % (logcount)
    localtime = time.strftime("%H:%M", time.localtime())
    send_boxsol(logcount,localtime)
    send_yageo(logcount,localtime)

def send_state(logcount,localtime):
    msg = 'check time:%s \nTotal sent %s spam report' % (localtime,logcount)
    subject = 'The Spam Report check state at %s, Total sent %s spam report' % (localtime,logcount)
    contacts = ['xxx@xxx.xxx']
    mail('xxx.xxx.xxx.xxx','xxx@xxx.xxx',contacts,subject,msg)
    
def send_boxsol(logcount,localtime):
    msg = 'The spam report have problem at %s,because only sent %s spam report to YAGEO users, please check... message from YAGEO Allen mobile:0920576298' % (localtime,logcount)
    subject = 'The Spam Report have problem, please check...'
    contacts =['xxx@xxx.xxx.xxx','xxx@xxx.xxx.xxx','xxx@xxx.xxx.xxx','xxx@xxx.xxx']
    mail('xxx.xxx.xxx.xxx','xxx@xxx.xxx',contacts,subject,msg)
    
def send_yageo(logcount,localtime):
    msg = 'The spam report have problem at %s,because only sent %s spam report to YAGEO users, please check...' % (localtime,logcount)
    subject = 'The Spam Report have problem, please check...'
    contacts = ["xxx@xxx.xxx.xxx","xxx@xxx.xxx.xxx","xxx@xxx.xxx","xxx@xxx.xxx"]
    mail('xxx.xxx.xxx.xxx','xxx@xxx.xxx',contacts,subject,msg)
    
def mail(serverURL=None, strFrom='', strTo='', subject='', text=''):
    #headers = "From: %s\r\nTo: %s\r\nSubject: %s\r\n\r\n" % (strFrom, strTo, subject)
    smtp = smtplib.SMTP()
    smtp.connect(serverURL)
    #smtp.login('exampleuser', 'examplepass')
    #smtp.sendmail(strFrom, strTo, message)
    for x in strTo:
    	headers = "From: %s\r\nTo: %s\r\nSubject: %s\r\n\r\n" % (strFrom, x, subject)
    	message = headers + text
	#print x
    	smtp.sendmail(strFrom, x, message)
    smtp.quit()

def main():
    chklog(sent,chkcount,chktime)

if __name__ == '__main__':
        sent = sys.argv[1]
        chkcount = sys.argv[2]
        chktime = sys.argv[3]
        main()

#!/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 fix sendmail problem

====================================

'''

import smtplib

import sys

import time

import commands

__create_date__ = '2009/12/09 21:58'

__version__ = '2.2'

__author__ = 'Allen Wang'

__email__ = 'allencswang@gmail.com'

__credits__ = "Allen Wang"

__license__ = "GPL"

__maintainer__ = "Allen Wang"

__status__ = "Released"

def chklog(sent, chkcount, chktime):

cmd = 'cat /var/log/maillog |grep "%s" |grep "%s" |wc -l' % (sent, chktime)

localtime = time.strftime("%H:%M", time.localtime())

logcount = commands.getoutput(cmd)

if int(logcount) == 0:

emsg(logcount,localtime)

elif int(logcount) < int(chkcount):

emsg(logcount,localtime)

else:

print 'Check time: %s' % (localtime)

print 'Total sent %s spam report' % (logcount)

send_state(logcount,localtime)

def emsg(logcount,localtime):

print 'Check time: %s' % (localtime)

print 'please check you spam server,because only sent %s spam mail report' % (logcount)

localtime = time.strftime("%H:%M", time.localtime())

send_boxsol(logcount,localtime)

send_yageo(logcount,localtime)

def send_state(logcount,localtime):

msg = 'check time:%s \nTotal sent %s spam report' % (localtime,logcount)

subject = 'The Spam Report check state at %s, Total sent %s spam report' % (localtime,logcount)

contacts = ['xxx@xxx.xxx']

mail('xxx.xxx.xxx.xxx','xxx@xxx.xxx',contacts,subject,msg)

def send_boxsol(logcount,localtime):

msg = 'The spam report have problem at %s,because only sent %s spam report to YAGEO users, please check... message from YAGEO Allen mobile:0920576298' % (localtime,logcount)

subject = 'The Spam Report have problem, please check...'

contacts =['xxx@xxx.xxx.xxx','xxx@xxx.xxx.xxx','xxx@xxx.xxx.xxx','xxx@xxx.xxx']

mail('xxx.xxx.xxx.xxx','xxx@xxx.xxx',contacts,subject,msg)

def send_yageo(logcount,localtime):

msg = 'The spam report have problem at %s,because only sent %s spam report to YAGEO users, please check...' % (localtime,logcount)

subject = 'The Spam Report have problem, please check...'

contacts = ["xxx@xxx.xxx.xxx","xxx@xxx.xxx.xxx","xxx@xxx.xxx","xxx@xxx.xxx"]

mail('xxx.xxx.xxx.xxx','xxx@xxx.xxx',contacts,subject,msg)

def mail(serverURL=None, strFrom='', strTo='', subject='', text=''):

#headers = "From: %s\r\nTo: %s\r\nSubject: %s\r\n\r\n" % (strFrom, strTo, subject)

smtp = smtplib.SMTP()

smtp.connect(serverURL)

#smtp.login('exampleuser', 'examplepass')

#smtp.sendmail(strFrom, strTo, message)

for x in strTo:

headers = "From: %s\r\nTo: %s\r\nSubject: %s\r\n\r\n" % (strFrom, x, subject)

message = headers + text

#print x

smtp.sendmail(strFrom, x, message)

smtp.quit()

def main():

chklog(sent,chkcount,chktime)

if __name__ == '__main__':

sent = sys.argv[1]

chkcount = sys.argv[2]

chktime = sys.argv[3]

main()

技術

FreeBSD 8 Released

稍早在網路上知道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 tag=RELENG_8_0
ps.http://ftp.giga.net.tw/cvsup.php <<---CVSUP更新狀態. setp3 #make installworld && make installkernel #mergemaster #reboot Done...:P

技術

釋放VIM的威力

c9s用Perl寫了一個幫助調整安裝的程式….

超讚~~！！

# cpan Vimana
# vimana search [keyword] [keyword]
# vimana info xml.vim
# vimana install xml.vim

紀錄一下…

Vim Hacks from Lin Yo-An

http://c9s.blogspot.com/2009/08/vim-hacks-coscup.html

技術

Python compile

#!/usr/bin/python    
import py_compile
import sys

file=raw_input("Please enter your file name")
py_compile.compile(file)
sys.exit()

#!/usr/bin/python

import py_compile

import sys

file=raw_input("Please enter your file name")

py_compile.compile(file)

sys.exit()

技術

about tsclient vnc protocol

如果在Tsclient 找不到 VNC 可用,記得先裝一下下面的軟體.

sudo apt-get install xtightvncviewer

1	sudo apt-get install xtightvncviewer

技術

Backup_SVN.py

#!/usr/bin/env python
#-*- coding:  utf-8 -*-
'''
============================================
LOG
Date:2009/09/24
Add Threading Process
Date:2009/11/10
Add Check PATH, if you forget enter '/'
============================================
'''
import threading
import Queue
import os
import sys
import time

__author__ = "AllenWang"
__copyright__ = "Copyright 2009, SVN Backup Script"
__credits__ = "Allen Wang"
__license__ = "GPL"
__version__ = "1.0"
__maintainer__ = "Allen Wang"
__email__ = "allencswang@gmail.com"
__status__ = "Released"

queue = Queue.Queue()

def chkpath(_chk):
    i = len(_chk) -1
    if _chk[i] in '/':
        pass
    else:
        _chk = _chk + '/'
    return _chk

def Processlet():
    while True:
        _exc = queue.get()
        print 'Processing: ' + _exc + "\n"
        os.system(_exc)
        queue.task_done()

def svnbk(day, _backuplist, _backupdir):
    for i in range(len(_backuplist)):
        _svnpath = _svndir+_backuplist[i]
        _exc =  '/usr/local/bin/svnadmin dump -q '+ _svnpath + ' | gzip -9>' + _backupdir + day + 'svn' +'_'+ _backuplist[i] + '.gz'
        queue.put(_exc)

    queue.join()

def svn(_svndir, _backupdir):
    for i in range(2):
        t = threading.Thread(target=Processlet)
        t.setDaemon(True)
        t.start()

    day = time.strftime("%m%d%Y",time.localtime())
    _backuplist = os.listdir(chkpath(_svndir))
    svnbk(day, _backuplist, chkpath(_svndir), chkpath(_backupdir))

def main():
    svn(_svndir, _backupdir)

if __name__ == '__main__':
    try:
        _svndir = sys.argv[1]
        _backupdir = sys.argv[2]
        main()

    except:
        print 'Usage: Backup_SVN.py [SVN Folder] [Backup Folder]'

#!/usr/bin/env python

#-*- coding: utf-8 -*-

'''

============================================

LOG

Date:2009/09/24

Add Threading Process

Date:2009/11/10

Add Check PATH, if you forget enter '/'

============================================

'''

import threading

import Queue

import os

import sys

import time

__author__ = "AllenWang"

__credits__ = "Allen Wang"

__license__ = "GPL"

__version__ = "1.0"

__maintainer__ = "Allen Wang"

__email__ = "allencswang@gmail.com"

__status__ = "Released"

queue = Queue.Queue()

def chkpath(_chk):

i = len(_chk) -1

if _chk[i] in '/':

pass

else:

_chk = _chk + '/'

return _chk

def Processlet():

while True:

_exc = queue.get()

print 'Processing: ' + _exc + "\n"

os.system(_exc)

queue.task_done()

def svnbk(day, _backuplist, _backupdir):

for i in range(len(_backuplist)):

_svnpath = _svndir+_backuplist[i]

_exc = '/usr/local/bin/svnadmin dump -q '+ _svnpath + ' | gzip -9>' + _backupdir + day + 'svn' +'_'+ _backuplist[i] + '.gz'

queue.put(_exc)

queue.join()

def svn(_svndir, _backupdir):

for i in range(2):

t = threading.Thread(target=Processlet)

t.setDaemon(True)

t.start()

day = time.strftime("%m%d%Y",time.localtime())

_backuplist = os.listdir(chkpath(_svndir))

svnbk(day, _backuplist, chkpath(_svndir), chkpath(_backupdir))

def main():

svn(_svndir, _backupdir)

if __name__ == '__main__':

try:

_svndir = sys.argv[1]

_backupdir = sys.argv[2]

main()

except:

print 'Usage: Backup_SVN.py [SVN Folder] [Backup Folder]'

Chuan-Shun Wang’s Blog

「求知若飢，虛心若愚。」（Stay hungry. Stay foolish.）

技術

Alert Log for 11G

daily system check and send mail

rman error

Oracle Client for Win7 64bit

Check Spam Report

FreeBSD 8 Released

釋放VIM的威力

Python compile

about tsclient vnc protocol

Backup_SVN.py