#!/bin/bash#以root用戶運(yùn)行#注意修改第三行的ip為自己的ip地址echo "172.16.1.110 orcl orcl" >> /etc/hostscat >> /etc/sysconfig/network <<EOFnetwork=yeshostname=orclEOF

 #!/bin/bash#以root用戶運(yùn)行#內(nèi)核參數(shù)設(shè)置kernel.shmall=2097152其中16G物理內(nèi)存建議設(shè)為4194304類推8G應(yīng)為2097152#kernel.shmmax=4294967296一般設(shè)置為物理內(nèi)存的一半,8G:4294967296也可以全部用完8*1024*1024*1024yum install -y binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc glibc-common glibc-devel gcc gcc-c++ libaio-devel libaio libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel ksh numactl-devel zip unzipcat >> /etc/sysctl.conf <<EOFfs.file-max = 6815744fs.aio-max-nr = 1048576kernel.shmall = 2097152    kernel.shmmax = 4294967296  kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 4194304net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576EOFsysctl -p #使配置文件生效cat >> /etc/security/limits.conf <<EOForacle      soft  nproc      2047oracle      hard  nproc      16384oracle      soft  nofile     1024oracle      hard  nofile     65536EOFcat >> /etc/pam.d/login <<EOFsession  required   /lib/security/pam_limits.sosession  required   pam_limits.soEOFcat >> /etc/profile <<EOFif [ $USER = "oracle" ]; then  if [ $SHELL = "/bin/ksh" ]; then   ulimit -p 16384   ulimit -n 65536  else   ulimit -u 16384 -n 65536  fifiEOFgroupadd oinstallgroupadd dbauseradd -g oinstall -G dba oracle mkdir -p /u01/app/oracle/product/11.2.0/db_1mkdir -p /u01/app/oracle/oradatamkdir -p /u01/app/oraInventorymkdir -p /u01/app/oracle/fast_recovery_areachown -R oracle:oinstall /u01/app/oraclechown -R oracle:oinstall /u01/app/oraInventorychmod -R 755 /u01/app/oraclechmod -R 755 /u01/app/oraInventorysystemctl disable firewalldsystemctl stop firewalldsetenforce 0sed -i 's/=enforcing/=disabled/g' /etc/selinux/configmv p13390677_112040_Linux-x86-64_1of7.zip /home/oracle  mv p13390677_112040_Linux-x86-64_2of7.zip /home/oraclecp thiinstalloracle.sh /home/oracle/cp fouinstalloracle.sh /home/oracle/

 #!/bin/bash#以oracle用戶運(yùn)行，su - oraclecat >> .bash_profile <<EOFORACLE_BASE=/u01/app/oracleORACLE_HOME=/$ORACLE_BASE/product/11.2.0/db_1ORACLE_SID=orcl export NLS_LANG=AMERICAN_AMERICA.UTF8PATH=/$PATH:/$ORACLE_HOME/binexport ORACLE_BASE ORACLE_HOME ORACLE_SID PATHumask 022EOFsource .bash_profileunzip p13390677_112040_Linux-x86-64_1of7.zip unzip p13390677_112040_Linux-x86-64_2of7.zipchown -R oracle:oinstall databasecd database/responsecp db_install.rsp db_install.rsp.baksed -i "s/^oracle.install.option=/oracle.install.option=INSTALL_DB_SWONLY/g" db_install.rspsed -i "s/^ORACLE_HOSTNAME=/ORACLE_HOSTNAME= orcl/g" db_install.rspsed -i "s/^UNIX_GROUP_NAME=/UNIX_GROUP_NAME=oinstall/g" db_install.rspsed -i "s/^INVENTORY_LOCATION=/INVENTORY_LOCATION=//u01//app//oraInventory/g" db_install.rspsed -i "s/^SELECTED_LANGUAGES=en/SELECTED_LANGUAGES=en,zh_CN/g" db_install.rspsed -i "s/^ORACLE_HOME=/ORACLE_HOME=//u01//app//oracle//product//11.2.0//db_1/g" db_install.rspsed -i "s/^ORACLE_BASE=/ORACLE_BASE=//u01//app//oracle/g" db_install.rspsed -i "s/^oracle.install.db.InstallEdition=/oracle.install.db.InstallEdition=EE/g" db_install.rspsed -i "s/^oracle.install.db.DBA_GROUP=/oracle.install.db.DBA_GROUP=dba/g" db_install.rspsed -i "s/^oracle.install.db.OPER_GROUP=/oracle.install.db.OPER_GROUP=dba/g" db_install.rspsed -i "s/^DECLINE_SECURITY_UPDATES=/DECLINE_SECURITY_UPDATES=true/g" db_install.rspcd ..

sh /u01/app/oraInventory/orainstRoot.shsh /u01/app/oracle/product/11.2.0/db_1/root.sh

#/bin/bash#以oracle用戶運(yùn)行netca /silent /responseFile /home/oracle/database/response/netca.rsp #靜默方式配置監(jiān)聽ls $ORACLE_HOME/network/admin/  #正常情況下會(huì)自動(dòng)生成listener.ora sqlnet.oracd /home/oracle/database/responsecp dbca.rsp dbsed -i '78s/.*/GDBNAME= "orcl"/' dbca.rspsed -i '170s/.*/SID = "orcl"/' dbca.rspsed -i '211s/.*/SYSPASSWORD = "123456"/' dbca.rspsed -i '221s/.*/SYSTEMPASSWORD = "123456"/' dbca.rspsed -i '252s/.*/SYSMANPASSWORD = "123456"/' dbca.rspsed -i '262s/.*/DBSNMPPASSWORD = "123456"/' dbca.rspsed -i '360s/.*/DATAFILEDESTINATION=//u01//app//oracle//oradata/' dbca.rspsed -i '370s/.*/RECOVERYAREADESTINATION=//u01//app//oracle//fast_recovery_area/' dbca.rspsed -i '418s/.*/CHARACTERSET= "ZHS16GBK"/' dbca.rspsed -i '553s/.*/TOTALMEMORY= "3276"/' dbca.rsp  #值設(shè)置為物理內(nèi)存的60%dbca -silent -responseFile /home/oracle/database/response/dbca.rsp #開始靜默安裝，安裝結(jié)束后會(huì)提示100%，數(shù)據(jù)庫也跟著起來了ps -ef | grep ora_ | grep -v grep #檢測oracle進(jìn)程lsnrctl status 

 sqlplus / as sysdba #進(jìn)入數(shù)據(jù)庫select status from v$instance;　　#查看數(shù)據(jù)庫運(yùn)行狀態(tài)create user test identified by test; #創(chuàng)建數(shù)據(jù)庫用戶，連接時(shí)數(shù)據(jù)庫實(shí)例名為orcl，用戶名test密碼testgrant connect to test;grant resource to test;