Archives

You are currently viewing archive for December 2008

12/30: linux > lspci

Category: Linux tips
Posted by: hajime osako
Category: MS tips
Posted by: hajime osako
Category: Web dev
Posted by: hajime osako
MySQL :: MySQL 5.1 Reference Manual :: 11.8.6 Fine-Tuning MySQL Full-Text Search

Modify ft_min_word_len and restart the service and re-create the index.

ft_stopword_file='' to disable stopwords.
Category: Oracle
Posted by: hajime osako
Linux版 Oracleをインストールしてみました。

$ORACLE_HOME/dbs にあるinit.oraをコピーします。
SIDがorcl の場合は
cp init.ora initorcl.ora
と init+SID名.ora を作成します。

Oracle Environment Variables

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=ORCL; export ORACLE_SID
NLS_LANG=AMERICAN_AMERICA.UTF8; export NLS_LANG
PATH=$PATH:$ORACLE_HOME/bin; export PATH

Category: Web dev
Posted by: hajime osako
Category: Web dev
Posted by: hajime osako
LOAD DATA LOCAL INFILE 'C:\\tmp\\temp.csv' IGNORE INTO TABLE `account` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n';
Category: Linux tips
Posted by: hajime osako
Category: Oracle
Posted by: hajime osako
【ハウツー】初心者必見! Oracle 10gをRHEL4にインストール(1) - インストール、その前に (2) インストール前の作業を確認する | エンタープライズ | マイコミジャーナル

* binutils-2.15.92.0.2-10.EL4
* compat-db-4.1.25-9
* control-center-2.8.0-12
* gcc-3.4.3-9.EL4
* gcc-c++-3.4.3-9.EL4
* glibc-2.3.4-2
* glibc-common-2.3.4-2
* gnome-libs-1.4.1.2.90-44.1
* libstdc++-3.4.3-9.EL4
* libstdc++-devel-3.4.3-9.EL4
* make-3.80-5
* pdksh-5.2.14-30
* sysstat-5.0.5-1
* xscreensaver-4.18-5.rhel4.2

# groupadd oinstall
# groupadd dba
# groupadd oper
# useradd -g oinstall -G dba,oper oracle
(might need to change the password)

/etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

/etc/pam.d/login
session required pam_limits.so

/etc/profile
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi

# mkdir -p /u01/app/oracle_sw_owner
# chown -R oracle:oinstall /u01
# chmod -R 775 /u01

/etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 2147483648 ←物理メモリサイズの1/2(バイト単位)
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144

# reboot

12/04: Java > jps

Category: Web dev
Posted by: hajime osako
Category: MS tips
Posted by: hajime osako