JBoss 7.1.1 JSP自動更新

參考：https://developer.jboss.org/message/723945#723945#723945

This 7.1.1 specific bug (https://issues.jboss.org/browse/AS7-4187) could be resolved with the following steps easily.

1. Please make sure to add
            <configuration>
                <jsp-configuration development="true"/>
            </configuration>
    in standalone.xml under <subsystem xmlns="urn:jboss:domain:web:1.1" default-virtual-server="default-host" native="false">          

2. Go to jboss-as-7.1.1.Final/modules/org/jboss/as/web/main
   Place the jboss-as-web-7.1.1.Final-RECOMPILE.jar in there. You can download from http://www.datafilehost.com/download-2cb9ff04.html

3. Open module.xml (jboss-as-7.1.1.Final/modules/org/jboss/as/web/main) and add the following line
        <!--resource-root path="jboss-as-web-7.1.1.Final.jar"/-->
        <resource-root path="jboss-as-web-7.1.1.Final-RECOMPILE.jar"/>

4. You are done. Enjoy.

使用SQL Server Migration Assistant for MySQL移轉資料

版本：v6.0.0

參考：http://blog.miniasp.com/post/2014/12/24/SQL-Server-Migration-Assistant-for-MySQL-Tips.aspx

1.

Linux MySQL設定

1.安裝
tar xvf MySQL-5.6.15-1.el6.x86_64.rpm-bundle.tar
rpm -Uvh MySQL*.rpm

2.啟動
service mysql start

3.改密碼
mysqladmin -u root password 密碼

Linux上MySQL 5.5設定Master-Slave

[Master]
1.修改設定檔
vim /etc/my.cnf

[mysqld]
server-id=1
log-bin=mysql-bin
#binlog-do-db=DB名稱 //指定DB複製

2.重啟server
service mysql restart

3.匯出資料庫
mysqldump -u 帳號 -p --master-data --all-databases > 名稱.sql

CentOS 7在Apache上做Tomcat Cluster

Apache設定

1.在conf/httpd.conf加上
LoadModule jk_module modules/mod_jk.so
JkWorkersFile conf/workers.properties
JkMount /* lbcontroller

(產生mod_jk.so參閱CentOS 7安裝Apache編譯mod_jk)

Oracle expdp, impdp用法

1.匯出(expdp)
expdp 帳號/密碼@主機 dumpfile=檔名.dmp DIRECTORY=data_pump_dir

指定table
expdp 帳號/密碼@主機 TABLES=table1,table2 dumpfile=檔名.dmp DIRECTORY=data_pump_dir

可用select * from dba_directories;查詢data_pump_dir位置

2.匯入(impdp)
impdp 帳號/密碼@主機 dumpfile=檔名.dmp directory=data_pump_dir

vim關閉搜尋反白

:noh
或
set nohlsearch

Linux網路資源

Red Hat Network Proxy Server
http://rhnproxy1.uvm.edu/

PostgreSQL RPM Repository (with Yum)
http://yum.postgresql.org/

OpenFOAM®  - The Open Source Computational Fluid Dynamics (CFD) Toolbox
http://www.openfoam.org/

安裝CentOS基本設定

1.修改主機名稱
vim /etc/sysconfig/network

2.網卡連線設定
vim /etc/sysconfig/network-scripts/ifcfg-eth0

3.網路卡配置
vim /etc/udev/rules.d/70-persistent-net.rules

4.SELinux設為寬放模式
vim /etc/selinux/config

5.設定開機啟動服務
chkconfig network on
chkconfig NetworkManager off
chkconfig iptables off

VNC Server設定

1.安裝
yum install tigervnc-server
(yum install pixman libXfont)

2.設定密碼
vncpasswd

3.修改參數
vim /etc/sysconfig/vncservers
VNCSERVERS="2:root"
VNCSERVERARGS[2]="-geometry 1024x768"

3.啟動server
service vncserver start

(連接port=5900+上面的數字)

解決Oracle expdp問題

ORA-39213: Metadata processing is not available

1.登入sqlplus
sqlplus / as sysdba

2.執行
SQL> execute dbms_metadata_util.load_stylesheets


ORA-39087:directory name DATA_PUMP_DIR is invalid

1.登入sqlplus
sqlplus / as sysdba

2.
SQL> GRANT read, write ON DIRECTORY data_pump_dir TO 帳號;