By Allen, on February 6th, 2010%
#!/bin/bash
export ORACLE_SID=orcl
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
export ORACLE_OWNR=oracle
export PATH=$PATH:$ORACLE_HOME/bin
if [ ! -f $ORACLE_HOME/bin/dbstart -o ! -d $ORACLE_HOME ]
then
echo “Oracle startup: cannot start”
exit 1
fi
case “$1″ in
start)
# Oracle listener and instance startup
echo -n “Starting Oracle: ”
su $ORACLE_OWNR -c “$ORACLE_HOME/bin/lsnrctl start”
su $ORACLE_OWNR -c “$ORACLE_HOME/bin/dbstart $ORACLE_HOME”
su $ORACLE_OWNR -c “$ORACLE_HOME/bin/emctl start dbconsole”
su oracle -c “/u01/app/oracle/product/11.1.0/db_1/bin/emctl start dbconsole”
touch /var/lock/oracle
echo “OK”
;;
stop)
# Oracle listener and instance shutdown
echo . . . → Read More: ORACLE Startup and Shutdown Script
By Allen, on January 23rd, 2010%
There is no excerpt because this is a protected post.
By Allen, on January 16th, 2010%
其實sqldeveloper是一個好物…在不用錢的狀況下:P
如果需要把他改變成english的話…只需要按照下面的方式修改…
~/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf
把下列的設定加入到裏面去…
AddVMOption . . . → Read More: 更改sql developer 語系設定….
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
