企业官网建设流程全解析

静默安装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 [root@adg19c ~]# mkdir -p /data/oracle/product/19.3/dbhome_1 # 赋权 [root@adg19c ~]# chown -R oracle:oinstall /data/oracle [root@adg19c ~]# 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_SID=sjztncdb 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 [root@adg19c ~]# 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] name=base baseurl=file:///mnt enabled=1 gpgcheck=0 multilib_policy=all 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.option=INSTALL_DB_SWONLY UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/data/oracle/oraInventory ORACLE_BASE=/data/oracle ORACLE_HOME=/data/oracle/product/19.3/dbhome_1 oracle.install.db.InstallEdition=EE oracle.install.db.OSDBA_GROUP=dba oracle.install.db.OSOPER_GROUP=oper oracle.install.db.OSBACKUPDBA_GROUP=backupdba oracle.install.db.OSDGDBA_GROUP=dgdba oracle.install.db.OSKMDBA_GROUP=kmdba oracle.install.db.OSRACDBA_GROUP=racdba oracle.install.db.rootconfig.executeRootScript=true oracle.install.db.rootconfig.configMethod=ROOT $ORACLE_HOME/runInstaller -silent -force -noconfig -ignorePrereq -responseFile /home/oracle/19c_db_install.rsp Byxk@h3c.com! cat > 19c_netca.rsp <<EOF [GENERAL] RESPONSEFILE_VERSION="19.3" CREATE_TYPE="CUSTOM" [oracle.net.ca] INSTALLED_COMPONENTS={"server","net8","javavm"} INSTALL_TYPE=""typical"" LISTENER_NUMBER=1 LISTENER_NAMES={"LISTENER"} LISTENER_PROTOCOLS={"TCP;1521"} LISTENER_START=""LISTENER"" NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"} NSN_NUMBER=1 NSN_NAMES={"EXTPROC_CONNECTION_DATA"} NSN_SERVICE={"PLSExtProc"} NSN_PROTOCOLS={"TCP;HOSTNAME;1521"} EOF netca /silent /responsefile /home/oracle/19c_netca.rsp [root@oggres1948 data]# mkdir oradata [root@oggres1948 data]# chown oracle:oinstall oradata [root@oggres1948 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_SERVER=8 SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8