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 帳號;