13518219792
1、下载oracle 11g
为祁东等地区用户提供了全套网页设计制作服务，及祁东网站建设行业解决方案。主营业务为成都网站建设、做网站、祁东网站设计，以传统方式定制建设网站，并提供域名空间备案等一条龙服务，秉承以专业、用心的态度为用户提供真诚的服务。我们深信只要达到每一位用户的要求，就会得到认可，从而选择与我们长期合作。这样，我们也可以走得更远！
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
2、系统环境
free -h
文件方式添加swap交接分区
dd if=/dev/zero of=/swapfile bs=1M count=2048 &&mkswap /swapfile &&swapon /swapfile
3、检查系统没有安装的依赖包
rpm -q make binutils gcc libaio glibc compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc glibc-common glibc-devel glibc-headers gcc-c++ libaio-devel libaio-devel libgcc libstdc++ libstdc++-devel sysstat unixODBC unixODBC-devel pdksh expat |grep not
4、设置linux内核参数
修改/etc/security/limits.conf、/etc/pam.d/login、/etc/profile、/home/.bashrc
#vi /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.wmem_max = 1048576
fs.aio-max-nr = 104857
使配置生效 #sysctl -p
#vi /etc/security/limits.con
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
#vi /etc/profile
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
#vi /home/.bashrc
export ORACLE_BASE=/data/oracle/product/
export ORACLE_HOME=/data/oracle/product/11.2/db_1
export ORACLE_SID=tohmain
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
5、建立用户组和文件夹
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle
mkdir -p /data/oracle/product/11.2
chown -R oracle.oinstall /data/oracle
mkdir -p /home/oracle
chown -R oracle.dba /home/oracle
5、编辑oracle静态安装文件db_install.rsp
./runInstaller -silent -responseFile /db_install.rsp
创建库
dbca -silent -createdatabase -responseFile /dbca.rsp
删除库
dbca -silent -deleteDatabase -sourceDB orcl -sid orcl -sysDBAUserName sys -sysDBAPassword password
Instant Client Downloads
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
http://blog.sina.com.cn/s/blog_4c98be4501010opf.html
