静默安装Oracle19c数据库#防火墙 systemctl stop firewalld systemctl disable firewalld systemctl stop NetworkManager systemctl disable NetworkManager sed -i /^SELINUX/s#enforcing#disabled# /etc/selinux/config # 创建 dba和onstall两个用户组 groupadd -g 501 dba groupadd -g 502 oinstall groupadd -g 503 backupdba groupadd -g 504 dgdba groupadd -g 505 kmdba groupadd -g 506 racdba groupadd -g 507 oper # 创建oracle用户 useradd -u 503 -g oinstall -G dba,oper,backupdba,dgdba,kmdba,racdba oracle # 配置oracle用户密码 echo oracle|passwd --stdin oracle # 创建目录 [root adg19c ~]# mkdir -p /data/oracle/oraInventory [rootadg19c ~]# mkdir -p /data/oracle/product/19.3/dbhome_1 # 赋权 [rootadg19c ~]# chown -R oracle:oinstall /data/oracle [rootadg19c ~]# chmod -R 775 /data/oracle #环境变量 cat /home/oracle/.bash_profile EOF export TMP/tmp export TMPDIR\$TMP export ORACLE_BASE/data/oracle export ORACLE_HOME\$ORACLE_BASE/product/19.3/dbhome_1 export ORACLE_SIDsjztncdb 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/JRE:\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib umask 022 EOF [rootadg19c ~]# source /home/oracle/.bash_profile cat /etc/profile EOF if [ \$USER oracle ]; then if [ \$SHELL /bin/ksh ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi EOF cat /etc/sysctl.conf EOF kernel.shmall 4294967296 kernel.sem 5130 65280 510 256 kernel.shmmni 4096 kernel.shmmax 16242410 #support max TotalMemory 512GB net.ipv4.ip_local_port_range 9000 65500 net.core.rmem_default 1048576 net.core.rmem_max 4194304 net.core.wmem_default 262144 net.core.wmem_max 1048576 fs.file-max 6815744 fs.aio-max-nr 1048576 vm.swappiness 10 vm.dirty_background_ratio 20 vm.dirty_ratio 80 vm.dirty_expire_centisecs 500 vm.dirty_writeback_centisecs 100 net.ipv4.tcp_sack 0 net.ipv4.tcp_timestamps 0 net.ipv4.conf.default.rp_filter 0 net.ipv4.tcp_wmem 262144 net.ipv4.tcp_rmem 4194304 EOF 内存为 12G 时该值为 12*1024*1024*1024-1 12884901887 内存为 16G 时该值为 16*1024*1024*1024-1 17179869183 内存为 32G 时该值为 32*1024*1024*1024-1 34359738367 内存为 64G 时该值为 64*1024*1024*1024-1 68719476735 内存为 128G 时该值为 128*1024*1024*1024-1 137438953471 当内存为 12G 时 kernel.shmall 3145728 当内存为 16G 时 kernel.shmall 4194304 当内次为 32G 时 kernel.shmall 8388608 当内存为 64G 时 kernel.shmall 16777216 当内存为 128G 时 kernel.shmall 33554432 cat /etc/security/limits.conf EOF oracle soft nproc 16384 oracle hard nproc 16384 oracle soft nofile 65536 oracle hard nofile 65536 oracle soft memlock 3145728 oracle hard memlock 3145728 EOF cat /etc/pam.d/login EOF session required /lib64/security/pam_limits.so EOF cat /etc/yum.repos.d/local.repo EOF [base] namebase baseurlfile:///mnt enabled1 gpgcheck0 multilib_policyall EOF #安装依赖包 yum install -y bc binutils compat-libcap1 compat-libstdc elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libX11 libXau libXi libXtst libXrender libXrender-devel libgcc libstdc libstdc-devel libxcb make net-tools nfs-utils python python-configshell python-rtslib python-six targetcli smartmontools sysstat unzip cat 19c_db_install.rsp oracle.install.responseFileVersion/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0 oracle.install.optionINSTALL_DB_SWONLY UNIX_GROUP_NAMEoinstall INVENTORY_LOCATION/data/oracle/oraInventory ORACLE_BASE/data/oracle ORACLE_HOME/data/oracle/product/19.3/dbhome_1 oracle.install.db.InstallEditionEE oracle.install.db.OSDBA_GROUPdba oracle.install.db.OSOPER_GROUPoper oracle.install.db.OSBACKUPDBA_GROUPbackupdba oracle.install.db.OSDGDBA_GROUPdgdba oracle.install.db.OSKMDBA_GROUPkmdba oracle.install.db.OSRACDBA_GROUPracdba oracle.install.db.rootconfig.executeRootScripttrue oracle.install.db.rootconfig.configMethodROOT $ORACLE_HOME/runInstaller -silent -force -noconfig -ignorePrereq -responseFile /home/oracle/19c_db_install.rsp Byxkh3c.com! cat 19c_netca.rsp EOF [GENERAL] RESPONSEFILE_VERSION19.3 CREATE_TYPECUSTOM [oracle.net.ca] INSTALLED_COMPONENTS{server,net8,javavm} INSTALL_TYPEtypical LISTENER_NUMBER1 LISTENER_NAMES{LISTENER} LISTENER_PROTOCOLS{TCP;1521} LISTENER_STARTLISTENER NAMING_METHODS{TNSNAMES,ONAMES,HOSTNAME} NSN_NUMBER1 NSN_NAMES{EXTPROC_CONNECTION_DATA} NSN_SERVICE{PLSExtProc} NSN_PROTOCOLS{TCP;HOSTNAME;1521} EOF netca /silent /responsefile /home/oracle/19c_netca.rsp [rootoggres1948 data]# mkdir oradata [rootoggres1948 data]# chown oracle:oinstall oradata [rootoggres1948 data]# chmod 755 oradata #非CDB模式 dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName sjztncdb -sid sjztncdb -sysPassword Oracle$123 -systemPassword Oracle$123 -emConfiguration NONE -datafileDestination /data/oradata -storageType FS -characterSet AL32UTF8 #CDB模式 dbca -silent -createDatabase \ -templateName General_Purpose.dbc \ -responseFile NO_VALUE \ -gdbname sjztcdb \ -sid sjztcdb \ -createAsContainerDatabase TRUE \ -numberOfPDBs 1 \ -pdbName PDB1 \ -pdbAdminPassword Oracle123 \ -sysPassword Oracle123 \ -systemPassword Oracle123 \ -datafileDestination /u01/app/oracle/oradata \ -recoveryAreaDestination /u01/app/oracle/flash_recovery_area \ -redoLogFileSize 50 \ -storageType FS \ -characterset AL32UTF8 \ -nationalCharacterSet AL16UTF16 \ -sampleSchema TRUE \ -totalMemory 1024 \ -databaseType OLTP \ -emConfiguration NONE sqlnet.ora配置 SQLNET.ALLOWED_LOGON_VERSION_SERVER8 SQLNET.ALLOWED_LOGON_VERSION_CLIENT8