脚本及安装文件在nas里有
1.创建用户.
id oracle
groupadd -g 1000 oinstall
groupadd -g 1001 dba
useradd -u 1101 -g oinstall -G dba oracle
2.编辑环境变量
vi /etc/security/limits.conf
oracle soft nproc 65536
oracle hard nproc 65536
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft memlock 2183886080
oracle hard memlock 2183886080
3.交换区
dd if=/dev/zero of=/var/swap bs=1M count=8192
mkswap /var/swap
swapon /var/swap
4.解压
chown -R oracle:oinstall soft/
unzip p13390_1-1.zip
unzip p13390_1-2.zip
unzip p13390_2-1.zip
unzip p13390_2-2.zip
5.设置环境变量
su - oracle
export ORACLE_BASE=/home/oracle/app
export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1
6.安装
＃＃ /home/oracle/soft/database/response/db_install.rsp
DECLINE_SECURITY_UPDATES一定要设置成true
./runInstaller -ignoreSysPrereqs -silent -responseFile /home/oracle/soft/database/response/db_install.rsp oracle.install.option=INSTALL_DB_SWONLY INVENTORY_LOCATION=/home/oracle/database/oraInventory ORACLE_BASE=$ORACLE_BASE ORACLE_HOME=$ORACLE_HOME ORACLE_HOME_NAME=OraDb11gHome1 UNIX_GROUP_NAME=oinstall oracle.install.db.InstallEdition=EE oracle.install.db.EEOptionsSelection=false oracle.install.db.DBA_GROUP=dba oracle.install.db.OPER_GROUP=oinstall oracle.install.db.DBA_GROUP=dba oracle.install.db.DGDBA_GROUP=dba oracle.install.db.KMDBA_GROUP=dba oracle.install.db.BACKUPDBA_GROUP=dba
7.在root下执行完成后的脚本
1. /home/oracle/database/oraInventory/orainstRoot.sh
2. /home/oracle/app/oracle/product/11.2.0/dbhome_1/root.sh
8.修改环境变量
export ORACLE_BASE=/home/oracle/app
export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1
export ORACLE_HOME_LISTNER=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=oao
export PATH=.:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORA_CRS_HOME/bin:${PATH}:$HOME/bin
export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin
export ORACLE_TERM=xterm
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS10=$ORACLE_HOME/nls/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export CLASSPATH=$ORACLE_HOME/JRE
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export THREADS_FLAG=native
export TEMP=/tmp
export TMPDIR=/tmp
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export LC_ALL="C"
export SQLPATH=/home/oracle/app/login
alias sqlplus='rlwrap sqlplus'
alias alert='cd /opt/oracle/admin/corehf/bdump'
alias oh='cd $ORACLE_HOME'
alias sq='sqlplus / as sysdba’
9.打补丁
unzip p6880880_112000_Linux-x86-64.zip
mv /u01/app/oracle/product/11.2.0/dbhome_1/OPatch /u01/app/oracle/product/11.2.0/dbhome_1/OPatch.orig
cp -r OPatch/ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch
unzip p19769489_112040_Linux-x86-64.zip
cd 19769489
opatch apply
10.修改数据库参数
附件pp 注意修改并创建需要的目录
/etc/sysctl.config
vm.swappiness = 0
net.ipv4.neigh.default.gc_stale_time=120
net.ipv4.conf.all.rp_filter=0
net.ipv4.conf.default.rp_filter=0
net.ipv4.conf.default.arp_announce = 2
net.ipv4.conf.all.arp_announce=2
net.ipv4.tcp_syncookies = 1
net.ipv4.tcp_synack_retries = 2
net.ipv4.conf.lo.arp_announce=2
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default =262144
net.core.rmem_max = 4194304
net.core.wmem_default =262144
net.core.wmem_max =2097152
net.ipv4.ip_local_port_range = 9000 65500
fs.aio-max-nr=4194304
vm.min_free_kbytes=524288
vm.nr_hugepages = 4100
kernel.shmall = 4294967296
kernel.shmmax = 4398046511104
net.ipv4.tcp_tw_reuse = 1
net.ipv4.tcp_tw_recycle = 1
net.ipv4.tcp_fin_timeout = 3
net.ipv4.tcp_keepalive_time = 120
net.ipv4.tcp_max_tw_buckets = 5000
net.ipv4.tcp_max_syn_backlog = 8192
改文件限制
11.创建contrl文件
$ vi $DISTRIB/db_create.rsp
#--------------------------------------------------------------------
#以下参数不要更改
[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
#以下参数必须设置
[CREATEDATABASE]
GDBNAME = "ORCL.LK"
TEMPLATENAME = "General_Purpose.dbc"
#以下参数不设置则使用默认值,建议设置
CHARACTERSET = "ZHS16GBK"
TOTALMEMORY = "1024"
#--------------------------------------------------------------------
2) dbca静默建库, 大概3-4分钟:
种子数据库和控制文件位于$ORACLE_HOME/assistants/dbca/templates/下, 即Seed_Database.dfb和Seed_Database.ctl文件, 实际上建库就是基于通过rman恢复种子数据库和控制文件来实现的.
$ $ORACLE_HOME/bin/dbca -silent -responseFile $DISTRIB/db_create.rsp
12.创建监听
$ORACLE_HOME/bin/netca /silent /responsefile /home/oracle/soft/database/response/netca.rsp
ll $ORACLE_HOME/network/admin/*.ora
lsnrctl status
12.方便的脚本