您好,登錄后才能下訂單哦!
1、下載oracle 11g
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
2、系統(tǒng)環(huán)境
free -h
文件方式添加swap交接分區(qū)
dd if=/dev/zero of=/swapfile bs=1M count=2048 &&mkswap /swapfile &&swapon /swapfile
3、檢查系統(tǒng)沒有安裝的依賴包
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、設(shè)置linux內(nèi)核參數(shù)
修改/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靜態(tài)安裝文件db_install.rsp
./runInstaller -silent -responseFile /db_install.rsp
創(chuàng)建庫
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
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報,并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。