select sid,serial# from v$session where username='TEST';
oracle.install.option = INSTALL_DB_SWONLY
ORACLE_HOSTNAME = WuXian-OraDB-GD139
UNIX_GROUP_NAME = oinstall
INVENTORY_LOCATION = /home/oracle/oracle/oraInventory
SELECTED_LANGUAGES = en
ORACLE_HOME = /home/oracle/oracle/product/11.2.0/db_1
ORACLE_BASE = /home/oracle/oracle
oracle.install.db.InstallEdition = EE
oracle.install.db.DBA_GROUP = oinstall
oracle.install.db.OPER_GROUP = oinstall
DECLINE_SECURITY_UPDATES = true
./runInstaller -ignoreSysPrereqs -silent -responseFile /home/oracle/oracle/database/response/db_install.rsp
netca /silent /responseFile /home/oracle/oracle/database/response/netca.rsp
/home/oracle/oracle/product/11.2.0/db_1/bin/netca /silent /responseFile /home/oracle/oracle/database/response/netca.rsp
/home/oracle/oracle/product/11.2.0/db_1/bin/dbca -silent -cloneTemplate -responseFile /home/oracle/oracle/database/response/dbca.rsp
1. /home/oracle/oracle/oraInventory/orainstRoot.sh
2. /home/oracle/oracle/product/11.2.0/db_1/root.sh
create table testUser(id char(12),name varchar2(50));
insert into testUser values('1234','luoyu');
create user test identified by test
com.oracle
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
#semaphors: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 75536
net.ipv4.ip_local_port_range = 10240 75000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=2621440
fs.aio-max-nr = 1048576
#use for oracle
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
#for oracle
session required pam_limits.so
#for oracle
if [ $USER = "oracle" ];then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
#for oracle
ORACLE_BASE=/home/oracle/oracle
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
ORACLE_SID=sdb
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH
scp jdk-6u45-linux-x64.bin root@192.168.102.199:/usr/java
scp jboss-as-7.1.0.Final.tar.gz root@192.168.102.199:/usr
scp linux.x64_11gR2_database_1of2.zip root@192.168.101.105:/home/oracle/oracle
jdk1.6.0_45
export JBOSS_HOME=/usr/jboss-as-7.1.0.Final
export JAVA_HOME=/usr/java/jdk1.6.0_45
export CLASSPATH=.:$JAVA_HOME/lib:$JAVA_HOME/jre/lib
export PATH=$JAVA_HOME/lib:$JAVA_HOME/jre/bin:$PATH:$HOME/bin:$PATH
export JAVA_TOOLS=$JAVA_HOME/lib/tools.jar
-A INPUT -m state --state NEW -m tcp -p tcp --dport 8080 -j ACCEPT
alter system kill session '27,2077';
alter system kill session '30,1509';
alter system kill session '64,737';