Oracle+11gR2静默安装

1、1、检查系统：查看系统版本号： rootoracle-demo # uname -mx86_642、安装Oracle数据库需要的软件依赖包：rootoracle-demo # yum -y install binutils gcc gcc-c+ glibc glibc-common glibc-devel glibc-headers libaio libaio-devel libgcc libstdc+ libstdc+-devel make sysstat unixODBC unixODBC-devel numactl-devel elfutils-libelf elfutils-libel

2、f-devel compat-libstdc+ compat-libstdc+-33 xterm检查是否已安装。rootoracle-demo # rpm -q binutils gcc gcc-c+ glibc glibc-common glibc-devel glibc-headers libaio libaio-devel libgcc libstdc+ libstdc+-devel make sysstat unixODBC unixODBC-devel numactl-devel elfutils-libelf elfutils-libelf-devel compat-libstdc

3、+ compat-libstdc+-33 xtermpackage compat-libstdc+ is not installed会显示这个没安装，系统版本问题，可忽略，3、修改内核参数：rootoracle-demo # vim /etc/sysctl.conf追加以下内容fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmmax = 4294967295kernel.shmmni = 4096kernel.shmall = 268435456kernel.sem = 250 32000 100 128net.ipv4.ip_loca

4、l_port_range = 9000 65500net.core.rmem_default = 4194304net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576执行生效：rootoracle-demo # sysctl -pfs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmmax = 4294967295kernel.shmmni = 4096kernel.shmall = 268435456kernel.sem =

5、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 = 1048576rootoracle-demo #4、对oracle用户设置限制，提高软件运行性能：rootoracle-demo # vim /etc/security/limits.conf追加以下内容oracle soft nofile 1024oracle ha

6、rd nofile 65536oracle soft nproc 2047oracle hard nproc 16384oracle soft stack 10240rootoracle-demo # vi /etc/pam.d/login追加以下内容sessionrequired/lib64/security/pam_limits.so5、关闭防火墙和SELINUX，需要重启生效：rootoracle-demo # systemctl stop firewalld.service && systemctl disable firewalld.servicerootoracle

7、-demo # sed -i "s/SELINUX=enforcing/SELINUX=disabled/g" /etc/selinux/configrootoracle-demo # reboot6、创建运行oracle数据库的系统用户和用户组：用root账号登录，运行下面命令，创建所需的用户和用户组rootoracle-demo # groupadd -g 30001 oinstallrootoracle-demo # groupadd -g 30002 dbarootoracle-demo # groupadd -g 30003 operrootoracle-demo

8、 # useradd -u 31001 -g oinstall -G dba,oper oraclerootoracle-demo # echo "oracle" | passwd -stdin oracleChanging password for user oracle.passwd: all authentication tokens updated successfully.rootoracle-demo # id oracleuid=31001(oracle) gid=30001(oinstall) groups=30001(oinstall),30002(dba

9、),30003(oper)rootoracle-demo # groups oracleoracle : oinstall dba operrootoracle-demo # 7、创建oracle数据库的安装目录（分配权限）rootoracle-demo # mkdir -p /u01/app/oraclerootoracle-demo # mkdir -p /u01/app/oracle/product//db_1rootoracle-demo # mkdir -p /u01/app/oraInventoryrootoracle-demo # mkdir -p /u01/da

10、tabaserootoracle-demo # chown -R oracle:oinstall /u01rootoracle-demo # chmod -R 775 /u018、开启X server访问权限rootoracle-demo # xhost +9、安装pdksh-5.2.14-30.x86_64.rpmrootoracle-demo # rzrootoracle-demo # lsanaconda-ks.cfg Desktop Documents Downloads initial-setup-ks.cfg Music pdksh-5.2.14-30.x86_64.rpm Pic

11、tures Public Templates Videosrootoracle-demo # rpm -i -force -nodeps pdksh-5.2.14-30.x86_64.rpmwarning: pdksh-5.2.14-30.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 73307de6: NOKEYrootoracle-demo # rm pdksh-5.2.14-30.x86_64.rpm rm: remove regular file pdksh-5.2.14-30.x86_64.rpm? yrootoracle-demo

12、 #10、配置用户环境变量su - oracleoracleoracle-demo $ vim .bash_profile 追加以下内容export PS1="whoamihostname:"'$PWD$'export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product//db_1export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/us

13、r/libexport ORACLE_SID=TESTexport LANG="en_US.UTF-8"export ORACLE_TERM=xtermexport NLS_LANG=AMERICAN_AMERICA.AL32UTF8export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"执行马上生效：oracleoracle-demo $ . .bash_profile oracleoracle-demo:/home/oracle$exitlogout10、改hostrootoracle-demo # echo &q

14、uot;0 oracle-demo">> /etc/hosts11、上传文件到/u01/database/目录中并解压，可以用SFTP上传，步骤不详细说明。rootoracle-demo database# su - oracleLast login: Tue Apr 28 15:06:17 CST 2020 on pts/0oracleoracle-demo:/home/oracle$cd /u01/database/oracleoracle-demo:/u01/database$lsp13390677_112040_Linux-x86-64_1

15、of7.zip p13390677_112040_Linux-x86-64_2of7.ziporacleoracle-demo:/u01/database$unzip -q p13390677_112040_Linux-x86-64_1of7.zip oracleoracle-demo:/u01/database$unzip -q p13390677_112040_Linux-x86-64_2of7.zip oracleoracle-demo:/u01/database$rm p13390677_112040_Linux-x86-64_1of7.zip p13390677_112040_Lin

16、ux-x86-64_2of7.zip rm: remove write-protected regular file p13390677_112040_Linux-x86-64_1of7.zip? yrm: remove write-protected regular file p13390677_112040_Linux-x86-64_2of7.zip? y12、配置oracle安装的rsp文件编辑静默安装脚本oracleoracle-demo:/u01/database$cd /u01/database/database/responseoracleoracle-demo:/u01/dat

17、abase/database/response$cp db_install.rsp db_install.rsp.bakoracleoracle-demo:/u01/database/database/response$vim db_install.rsp先清空文件内容，再追加以下内容，一开始只设置了部分参数，但是好奇怪没法安装，后面才指定模板所有选项。oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0oracle.install.option=INSTALL_D

18、B_SWONLYORACLE_HOSTNAME=oracle-demoUNIX_GROUP_NAME=oinstallINVENTORY_LOCATION=/u01/app/oraInventorySELECTED_LANGUAGES=enORACLE_HOME=/u01/app/oracle/product//db_1ORACLE_BASE=/u01/app/oracleoracle.install.db.InstallEdition=EEoracle.install.db.EEOptionsSelection=falseoracle.install.db.optionalC

19、omponents=oracle.rdbms.partitioning:.0,oracle.oraolap:.0,oracle.rdbms.dm:.0,oracle.rdbms.dv:.0,oracle.rdbms.lbac:.0,oracle.rdbms.rat:.0oracle.install.db.DBA_GROUP=dbaoracle.install.db.OPER_GROUP=dbaoracle.install.db.CLUSTER_NODES=oracle.install.db.isRA

20、COneInstall=oracle.install.db.racOneServiceName=oracle.install.db.config.starterdb.type=GENERAL_PURPOSEoracle.install.db.config.starterdb.globalDBName=TESToracle.install.db.config.starterdb.SID=TESToracle.install.db.config.starterdb.characterSet=AL32UTF8oracle.install.db.config.starterdb.memoryOptio

21、n=trueoracle.install.db.config.starterdb.memoryLimit=1500oracle.install.db.config.starterdb.installExampleSchemas=falseoracle.install.db.config.starterdb.enableSecuritySettings=trueoracle.install.db.config.starterdb.password.ALL=Alex_1518oracle.install.db.config.starterdb.password.SYS=oracle.install

22、.db.config.starterdb.password.SYSTEM=oracle.install.db.config.starterdb.password.SYSMAN=oracle.install.db.config.starterdb.password.DBSNMP=oracle.install.db.config.starterdb.control=DB_CONTROLoracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=oracle.install.db.config.starterdb.auto

23、matedBackup.enable=falseoracle.install.db.config.starterdb.automatedBackup.osuid=oracle.install.db.config.starterdb.automatedBackup.ospwd=oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGEoracle.install.db.config.starterdb.fileSystemStorage.dataLocation=oracle.install.db.config.start

24、erdb.fileSystemStorage.recoveryLocation=oracle.install.db.config.asm.diskGroup=oracle.install.db.config.asm.ASMSNMPPassword=MYORACLESUPPORT_USERNAME=MYORACLESUPPORT_PASSWORD=SECURITY_UPDATES_VIA_MYORACLESUPPORT=falseDECLINE_SECURITY_UPDATES=true/估计是bug，不设为true没法安装。PROXY_HOST=PROXY_PORT=PROXY_USER=PR

25、OXY_PWD=PROXY_REALM=COLLECTOR_SUPPORTHUB_URL=oracle.installer.autoupdates.option=oracle.installer.autoupdates.downloadUpdatesLoc=AUTOUPDATES_MYORACLESUPPORT_USERNAME=AUTOUPDATES_MYORACLESUPPORT_PASSWORD=oracleoracle-demo:/u01/database$cd /u01/database/databaseoracleoracle-demo:/u01/database/database

26、/response$./runInstaller -silent -ignorePrereq -responseFile /u01/database/database/response/db_install.rsp正常安装，成功后显示以下信息，需要在root用户下执行As a root user, execute the following script(s):1. /u01/app/oraInventory/orainstRoot.sh2. /u01/app/oracle/product//db_1/root.sh#新开了一个窗口执行rootoracle-demo # /u0

27、1/app/oraInventory/orainstRoot.shChanging permissions of /u01/app/oraInventoryAdding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /u01/app/oraInventory to oinstall.The execution of the script is complete.rootoracle-demo # /u01/app/oracle/pr

28、oduct//db_1/root.shCheck /u01/app/oracle/product//db_1/install/root_oracle-demo_2020-06-04_09-58-20.log for the output of root scriptrootoracle-demo #13、静默配置监听oracleoracle-demo:/u01/database/database/response$lsdbca.rsp db_install.rsp db_install.rsp.bak netca.rsporacleoracle-demo:/u0

29、1/database/database/response$cp netca.rsp netca.rsp.bakoracleoracle-demo:/u01/database/database/response$netca -silent -responseFile /u01/database/database/response/netca.rsp#查看下监听端口oracleoracle-demo:/u01/database/database/response$netstat -tnulp | grep 1521(Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.)tcp6 0 0 :1521 :* LISTEN 17922/tnsl