Oracle静默安装

我不是女神ヾ 2022-05-28 02:13 325阅读 0赞

环境Centos7 mini：内存2G，oracle 12.2.0.1，VM虚拟机下

## 联网 ##

![70][]

# vi /etc/sysconfig/network-scripts/ifcfg-ens33

![70 1][]

TYPE=Ethernet
    PROXY_METHOD=none
    BROWSER_ONLY=no
    BOOTPROTO=static
    DEFROUTE=yes
    IPV4_FAILURE_FATAL=no
    IPV6INIT=yes
    IPV6_AUTOCONF=yes
    IPV6_DEFROUTE=yes
    IPV6_FAILURE_FATAL=no
    IPV6_ADDR_GEN_MODE=stable-privacy
    NAME=ens33
    UUID=5452944f-bc02-4ffd-aaae-8f6025c52643
    DEVICE=ens33
    ONBOOT=yes
    
    DNS1=114.114.114.114 IPADDR=192.168.2.50 PREFIX=24 GATEWAY=192.168.2.1 PEERDNS=no

重启网路连接

![70 2][]

# service network restart

测试下

![70 3][]

# ping baidu.com

编辑hosts文件

![70 4][]

# vi /etc/hosts

添加一行

![70 5][]

192.168.2.50 centos7

测试下

![70 6][]

ping centos7

## 准备 ##

更新下系统软件

![70 7][]

# yum -y update

配置/etc/sysctl.conf

![70 8][]

# vi /etc/sysctl.conf

内容如下

fs.file-max = 6815744  
    kernel.sem = 250 32000 100 128  
    kernel.shmmni = 4096  
    kernel.shmall = 1073741824  
    kernel.shmmax = 4398046511104  
    kernel.panic_on_oops = 1  
    net.core.rmem_default = 262144  
    net.core.rmem_max = 4194304  
    net.core.wmem_default = 262144  
    net.core.wmem_max = 1048576  
    net.ipv4.conf.all.rp_filter = 2  
    net.ipv4.conf.default.rp_filter = 2  
    fs.aio-max-nr = 1048576  
    net.ipv4.ip_local_port_range = 9000 65500

使配置生效

![70 9][]

# /sbin/sysctl -p

配置/etc/security/limits.d/20-nproc.conf

![70 10][]

追加内容如下

oracle   soft   nofile    1024  
    oracle   hard   nofile    65536  
    oracle   soft   nproc    16384  
    oracle   hard   nproc    16384  
    oracle   soft   stack    10240  
    oracle   hard   stack    32768  
    oracle   hard   memlock    134217728  
    oracle   soft   memlock    134217728

安装zip和unzip

![70 11][]

# yum install zip unzip

安装依赖

![70 12][]

yum install -y binutils \
    compat-libcap1 \
    compat-libstdc++-33 \
    compat-libstdc++-33.i686 \
    glibc \
    glibc.i686 \
    glibc-devel \
    glibc-devel.i686 \
    ksh \
    libaio \
    libaio.i686 \
    libaio-devel \
    libaio-devel.i686 \
    libX11 \
    libX11.i686 \
    libXau \
    libXau.i686 \
    libXi \
    libXi.i686 \
    libXtst \
    libXtst.i686 \
    libgcc \
    libgcc.i686 \
    libstdc++ \
    libstdc++.i686 \
    libstdc++-devel \
    libstdc++-devel.i686 \
    libxcb \
    libxcb.i686 \
    make \
    nfs-utils \
    net-tools \
    smartmontools \
    sysstat \
    unixODBC \
    unixODBC-devel  
     gcc \
     gcc-c++ \
     libXext \
     libXext.i686 \
     zlib-devel \
     zlib-devel.i686

创建用户和用户组

![70 13][]

# groupadd -g 1001  oinstall
    # groupadd -g 1002 dba 
    # groupadd -g 1003 oper
    # useradd -u 1001 -g oinstall -G dba,oper oracle
    # passwd oracle

关闭防火墙及selinux

![70 14][]

# vi /etc/selinux/config

SELINUX=disabled

![70 15][]

# systemctl stop firewalld
    # systemctl disable firewalld

创建目录修改权限

![70 16][]

# mkdir -p /u01/app/oracle/product/12.2.0.1/db_1
    # chown -R oracle:oinstall /u01
    # chmod 775 /u01

\#配置oracle环境变量

![70 17][]

#  vi /home/oracle/.bash_profile

内容如下

. ~/.bashrc
    fi
    
    # User specific environment and startup programs
    
    PATH=$PATH:$HOME/.local/bin:$HOME/bin
    
    export PATH
    
    # Oracle Settings
    export TMP=/tmp  
    export TMPDIR=$TMP  
      
    export ORACLE_HOSTNAME=centos7  
    export ORACLE_UNQNAME=orcl
    export ORACLE_BASE=/u01/app/oracle  
    export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/db_1  
    export ORACLE_SID=orcl
      
    export PATH=/usr/sbin:$PATH  
    export PATH=$ORACLE_HOME/bin:$PATH
    
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
    export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

重启，切换oracle用户

![70 18][]

# reboot

![70 19][]

解压

![70 20][]

unzip linuxx64_12201_database.zip

## 安装 ##

编辑应答文件

![70 21][]

vi database/response/db_install.rsp

修改内容如下：

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.2.0  
    oracle.install.option=INSTALL_DB_SWONLY  
    UNIX_GROUP_NAME=oinstall  
    INVENTORY_LOCATION=/u01/app/oracle/oraInventory  
    ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1  
    ORACLE_BASE=/u01/app/oracle  
    oracle.install.db.InstallEdition=EE
    oracle.install.db.OSDBA_GROUP=dba
    oracle.install.db.OSOPER_GROUP=oper 
    oracle.install.db.OSBACKUPDBA_GROUP=dba  
    oracle.install.db.OSDGDBA_GROUP=dba  
    oracle.install.db.OSKMDBA_GROUP=dba  
    oracle.install.db.OSRACDBA_GROUP=dba  
    oracle.install.db.config.starterdb.type=GENERAL_PURPOSE  
    oracle.install.db.config.starterdb.globalDBName=orcl
    oracle.install.db.config.starterdb.SID=orcl
    oracle.install.db.config.starterdb.characterSet=AL32UTF8  
    SECURITY_UPDATES_VIA_MYORACLESUPPORT=false  
    DECLINE_SECURITY_UPDATES=true

安装\[注意应答文件需要绝对路径\]

![70 22][]

$ ./runInstaller -force -silent -noconfig -responseFile /home/oracle/database/response/db_install.rsp

使用root用户组执行脚本

![70 23][]

# /u01/app/oracle/oraInventory/orainstRoot.sh

![70 24][]

# /u01/app/oracle/product/12.2.0.1/db_1/root.sh

添加监听

![70 25][]

cat netca.rsp | grep -Ev "^#|^$"

![70 26][]

netca -silent -responsefile /home/oracle/database/response/netca.rsp

查看监听状态

![70 27][]

$ lsnrctl status

创建数据库

修改文件/home/oracle/database/response/dbca.rsp

内容如下

responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0  
    gdbName=orcl 
    sid=orcl
    databaseConfigType=SI  
    RACOneNodeServiceName=  
    policyManaged=false  
    createServerPool=false  
    serverPoolName=  
    cardinality=  
    force=false  
    pqPoolName=  
    pqCardinality=  
    createAsContainerDatabase=true  
    numberOfPDBs=1  
    pdbName=cdb1pdb  
    useLocalUndoForPDBs=true  
    pdbAdminPassword=  
    nodelist=  
    templateName=/u01/app/oracle/product/12.2.0.1/db_1/assistants/dbca/templates/General_Purpose.dbc  
    sysPassword=  
    systemPassword=  
    serviceUserPassword=  
    emConfiguration=  
    emExpressPort=5500  
    runCVUChecks=false  
    dbsnmpPassword=  
    omsHost=  
    omsPort=0  
    emUser=  
    emPassword=  
    dvConfiguration=false  
    dvUserName=  
    dvUserPassword=  
    dvAccountManagerName=  
    dvAccountManagerPassword=  
    olsConfiguration=false  
    datafileJarLocation={ORACLE_HOME}/assistants/dbca/templates/  
    datafileDestination={ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/  
    recoveryAreaDestination={ORACLE_BASE}/fast_recovery_area/{DB_UNIQUE_NAME}  
    storageType=FS  
    diskGroupName=  
    asmsnmpPassword=  
    recoveryGroupName=  
    characterSet=AL32UTF8  
    nationalCharacterSet=AL16UTF16  
    registerWithDirService=false  
    dirServiceUserName=  
    dirServicePassword=  
    walletPassword=  
    listeners=LISTENER  
    variablesFile=  
    variables=DB_UNIQUE_NAME=orcl,ORACLE_BASE=/u01/app/oracle,PDB_NAME=,DB_NAME=orcl,ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1,SID=orcl  
    initParams=undo_tablespace=UNDOTBS1,memory_target=796MB,processes=300,db_recovery_file_dest_size=2780MB,nls_language=AMERICAN,dispatchers=(PROTOCOL=TCP) (SERVICE=orclXDB),db_recovery_file_dest={ORACLE_BASE}/fast_recovery_area/{DB_UNIQUE_NAME},db_block_size=8192BYTES,diagnostic_dest={ORACLE_BASE},audit_file_dest={ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump,nls_territory=AMERICA,local_listener=LISTENER_ORCL,compatible=12.2.0,control_files=("{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl", "{ORACLE_BASE}/fast_recovery_area/{DB_UNIQUE_NAME}/control02.ctl"),db_name=orcl,audit_trail=db,remote_login_passwordfile=EXCLUSIVE,open_cursors=300  
    sampleSchema=false  
    memoryPercentage=40  
    databaseType=MULTIPURPOSE  
    automaticMemoryManagement=true  
    totalMemory=0

![70 28][]

![70 29][]

中间需要输入密码

$ dbca -silent -createDatabase  -responseFile  /home/oracle/database/response/dbca.rsp

![70 30][]

sqlplus / as sysdba

查看数据库状态

![70 31][]

select open_mode from v$database;

![70 32][]

安装完成

[70]: /images/20220528/0aa792fb3224417797299e0f6ed1407d.png
[70 1]: /images/20220528/6ea2001464a0494697eaa47bb40347a8.png
[70 2]: /images/20220528/0b1fe297bb0f4e1b93c1480942a4e1e5.png
[70 3]: /images/20220528/bd1c53d3c96a47c8b85a328abe2b0377.png
[70 4]: /images/20220528/ffa415495d414357854bc7af3b0b303f.png
[70 5]: /images/20220528/bd4e69bd3722446e944025f5a2646c4d.png
[70 6]: /images/20220528/0db87352cd0d4ad4ba55bc7a4285ecbb.png
[70 7]: /images/20220528/1b093fd4a41e4f349794de0a46851116.png
[70 8]: /images/20220528/d1a223c54d6e49c1b7c4fc21298de80c.png
[70 9]: /images/20220528/dbdf789450724d1a8db3aca4ce4e11c4.png
[70 10]: /images/20220528/548988429ee844b0b7c5c02776985f62.png
[70 11]: /images/20220528/5cca066ecfe94f438b330fcbb405fd80.png
[70 12]: /images/20220528/9bc26aa8c6614841b137223f34a3e162.png
[70 13]: /images/20220528/98b81d702e504bb6bc25018c9555e1f3.png
[70 14]: /images/20220528/da0f8967665f4bdf9e8f31fa46005ba2.png
[70 15]: /images/20220528/5005921778554525845b1b04848bf043.png
[70 16]: /images/20220528/2b78fe4cc4134bae8a72d19afffbc1f2.png
[70 17]: /images/20220528/8c3d73510dac4a99970d3ac63169ad36.png
[70 18]: /images/20220528/6a866903182240749795a721228cad50.png
[70 19]: /images/20220528/84a717e2840b4307b56660b34fc02b23.png
[70 20]: /images/20220528/e61249784e8443d5b1a09bd92f673cc7.png
[70 21]: /images/20220528/e8810308f5344cd7a4245b134ecb0a75.png
[70 22]: /images/20220528/4ebf519c26d248a8a31da34f195f3a25.png
[70 23]: /images/20220528/91ffc8e615f240328645ee963fe34e78.png
[70 24]: /images/20220528/072267a5171d436799f84f1c853810f0.png
[70 25]: /images/20220528/fef1b953fa974c12b77f31e611aae9fd.png
[70 26]: /images/20220528/4a079f5606b44aeaaf63edd3f33b6d2c.png
[70 27]: /images/20220528/fc3017da59254852a5d6be94c8791bc6.png
[70 28]: /images/20220528/3c0d86cbbfcf468f99d5a909607ff723.png
[70 29]: /images/20220528/aa7adfe9aab24ce5b028ed59d1222dac.png
[70 30]: /images/20220528/531699d202664c1da64e0d370b54312f.png
[70 31]: /images/20220528/9d5316b987bf40fbb907a5df62d0f6de.png
[70 32]: /images/20220528/b8a619a142ac4820af0843dbf1746f0c.png