oracle trace file [.trm] [.trc]

oracle version:11g

TRM Trace Files Getting Generated in 11g Database (Doc ID 750982.1)
Excessive Number Of Arc Trace Files Generated In 11g (Doc ID 754289.1)


Trace file in 11g belongs to ADR (Automatic Diagnostic Repository) you can manage it by using its Command Interpreter ADRCI:

http://download.oracle.com/docs/cd/E11882_01/server.112/e16536/adrci.htm#SUTIL700

It's possible to set the Purging Policy with the SET CONTROL statement:

http://download.oracle.com/docs/cd/E11882_01/server.112/e16536/adrci.htm#BGBEGAEB

You can purge Trace Files by using the PURGE statement:

http://download.oracle.com/docs/cd/E11882_01/server.112/e16536/adrci.htm#SUTIL1509

In addition, to remove Traces Files in the "CDMP_" directories, you may use the Type UTSCDMP as follow. For instance, to remove Trace files older than 1 hour in "CDMP_" directories:
adrci> purge -age 60 -type UTSCDMP


reference: https://forums.oracle.com/forums/thread.jspa?threadID=943615

How to fix exchange outlook connection issues over ipsec vpn

Juniper Firewall

show configuration security flow tcp-mss { ipsec-vpn { mss 1350; } 

show configuration security zones security-zone trust tcp-rst;

set security alg msrpc disable



reference:
1: http://www.itsyourip.com/Windows/how-to-fix-exchange-outlook-connection-issues-over-ipsec-vpn/
2: http://forums.juniper.net/t5/SRX-Services-Gateway/Outlook-2003-Email-Issue/td-p/39690

Windows MaxUserPort and TcpTimedWaitDelay adjust parameter

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters

dword
MaxUserPort = 65000
TcpTimedWaitDelay =30s

How to delete windows services

sc delete ServiceName

if ServiceName have space than

sc delete “Service Name”

JDK安裝及環境設定

JAVA下載
http://www.oracle.com/technetwork/java/javase/downloads/index.html
個人不喜歡RPM因此都是選tarball安裝

Unix：
1.將tarball放到想放的目錄如/usr/local/
2.解開tar zxvf jdk-{版號}-linux-i586.tar.gz
   就完成了.....
3. 設定環境變數BASH (修改/etc/profile)

export JAVA_HOME=/usr/local/jdk1.{版號}
export PATH=${PATH}:${JAVA_HOME}/bin

Windows:
1..........download
2...............install
3......................set path

that's all

Asus RT-N16 韌體救援

ASUS RT-N16

進入Recovery Mode方式: 壓住Restore鈕插入電源，進入recovery mode後電源燈號會以一秒頻率閃爍
這時候可以使用ping 192.168.1.1 確認
再使用光碟的修復程式重新上傳韌體

SQL Server 2008 install on Windows server 2008R2 Cluster Fail

問題描述:
在Windows Server 2008R2 環境下安裝 SQL Server 2008叢集會發生RequireKerberos=1 的錯誤訊息， SQL Server安裝失敗。

解決方式:
方法1: 改安裝SQL2008R2
方法2: 使用SQL2008 w/SPx (最新Service Pack為3)
目前SQL2008w/ServicePack微軟沒有釋出，因此需自行製作

方法2流程:
1. 將SQL2008 安裝程式複製到 D:\SQL2008_FULLSP3
2. 下載最新Service Pack(目前為SP3)
     http://www.microsoft.com/downloads/zh-tw/details.aspx?FamilyID=757bca07-7b52-46fb-ab92-476be9339442
3.將Service Pack解開
參數為 /x:D:\SQL2008_FULLSP3\PCU\
4.將PCU下的setup.exe & setup.rll 複製到 \SQL2008_FULLSP3下

5.將PCU下各種版本更新複製到 \SQL2008_FULLSP3下 BUT 要排除Microsoft.SQL.Chainer.PackageData.dll

使用ROBOCOPY 來源\PCU\X86 目的\  /XF: Microsoft.SQL.Chainer.PackageData.dll

6.修改X86(或其他平台)目錄下的defaultsetup.ini
加入PCUSOURCE=".\PCU"

7.現在應該可以正常安裝了

參考連結:
1. http://sharedderrick.blogspot.com/2010/01/sql-server-2008-with-sp1-slipstreaming.html
2. http://alexchuo.blogspot.com/2009/07/sql-server-2008-sp1.html
3. http://blogs.msdn.com/b/petersad/archive/2009/02/25/sql-server-2008-creating-a-merged-slisptream-drop.aspx