formulahendry

1.安装环境准备1.1.查看物理内存[rootaiserver ~]# free -m1.2.操作系统版本[rootaiserver ~]# cat /etc/redhat-release1.3.操作系统内存[rootaiserver ~]# df -h /dev/shm/1.4.磁盘空间[rootaiserver ~]# df -TH[rootaiserver ~]# df -h /tmp/[rootaiserver ~]# df -h /u011.5.查看系统架构[rootaiserver ~]# uname -mx86_64[rootaiserver ~]# cat /proc/version1.6.解析/etc/hosts[rootaiserver ~]# hostnameaiservercat /etc/hosts EOF192.168.1.1 aiserverEOF1.7.关闭防火墙还有selinuxsystemctl status firewalld.servicesystemctl stop firewalld.servicesystemctl disable firewalld.servicesed -i s/SELINUXenforcing/SELINUXdisabled/ /etc/selinux/config2.创建用户和组查看是否安装有Oracle软件[rootaiserver ~]# more /etc/oraInst.loc查看是否已存在相关用户组[rootaiserver ~]# grep oinstall /etc/group[rootaiserver ~]# grep dba /etc/group[rootaiserver ~]# grep oper /etc/group[rootaiserver ~]# /usr/sbin/groupadd -g 54321 oinstall[rootaiserver ~]# /usr/sbin/groupadd -g 54322 dba[rootaiserver ~]# /usr/sbin/groupadd -g 54323 oper[rootaiserver ~]# /usr/sbin/useradd -u 54321 -g oinstall -G dba,oper oracle--修改密码为oracle[rootaiserver ~]# passwd oracle3.创建工作的目录[rootaiserver ~]# mkdir -p /u01/app/oracle[rootaiserver ~]# chown -R oracle:oinstall /u01/[rootaiserver ~]# chmod -R 775 /u01/app/oracle4.配置Oracle的环境变量[oracleaiserver ~]$ vi .bash_profileexport ORACLE_BASE/u01/app/oracleexport ORACLE_HOME$ORACLE_BASE/product/23.26.1/dbhome_1export ORACLE_SIDprodexport PATH$ORACLE_HOME/bin:$PATH:$HOME/bin[oracleaiserver ~]$ source .bash_profile[oracleaiserver ~]$ env | grep ORACLE5.修改内核参数以下在root用户下操作cp /etc/sysctl.conf /etc/sysctl.conf.bakcat /etc/sysctl.conf EOFfs.file-max 6815744kernel.sem 250 32000 100 128kernel.shmmni 4096kernel.shmall 751619276kernel.shmmax 3006477107kernel.panic_on_oops 1net.core.rmem_default 262144net.core.rmem_max 4194304net.core.wmem_default 262144net.core.wmem_max 1048576fs.aio-max-nr 1048576net.ipv4.ip_local_port_range 9000 65500EOFkernel.shmall :物理内存的70%kernel.shmmnikernel.shmall/4环境变量生效sysctl --system6./etc/profile配置以下root用户操作cp /etc/profile /etc/profile.bakcat /etc/profile EOFif [ $USER oracle ]; thenif [ $SHELL /bin/ksh ]; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fifiEOFvi /etc/pam.d/loginsession required pam_limits.so7.修改资源限制以下root用户操作cp /etc/security/limits.conf /etc/security/limits.conf.bakcat /etc/security/limits.conf EOForacle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536EOF8.yum安装依赖[rootaiserver ~]# mount | grep sr0mount /dev/cdrom /mntecho [localREPO] /etc/yum.repos.d/my.repoecho namelocalhost8 /etc/yum.repos.d/my.repoecho baseurlfile:///mnt/BaseOS /etc/yum.repos.d/my.repoecho gpgcheck0 /etc/yum.repos.d/my.repoecho enabled1 /etc/yum.repos.d/my.repoecho [localREPO_APP] /etc/yum.repos.d/my.repoecho namelocalhost8_app /etc/yum.repos.d/my.repoecho baseurlfile:///mnt/AppStream /etc/yum.repos.d/my.repoecho gpgcheck0 /etc/yum.repos.d/my.repoecho enabled1 /etc/yum.repos.d/my.repo[rootaiserver yum.repos.d]# yum repolist以下命令安装依赖包yum install bc \binutils \compat-openssl10 \elfutils-libelf \fontconfig \glibc \glibc-devel \ksh \libaio \libXrender \libX11 \libXau \libXi \libXtst \libgcc \libstdc \libxcb \libibverbs \libasan \liblsan \librdmacm \make \policycoreutils \policycoreutils-python-utils \smartmontools \sysstat -y9.解压软件授权、oracle用户下操作[oracleaiserver ~]$ mkdir -p /u01/app/oracle/product/23.26.1/dbhome_1oracle用户下操作[oracleaiserver ~]$ unzip /opt/LINUX.X64_2326100_db_home.zip -d $ORACLE_HOME10.静默安装Oracle数据库10.1.编辑rsp文件[oracleaiserver ~]$ cd $ORACLE_HOME/install/response[oracleaiserver response]$ cp db_install.rsp /tmpvi /tmp/db_install.rsp修改db_install.rsp文件中以下内容oracle.install.optionINSTALL_DB_SWONLYUNIX_GROUP_NAMEoinstallINVENTORY_LOCATION/u01/app/oraInventoryORACLE_BASE/u01/app/oracleORACLE_HOME/u01/app/oracle/product/23.26.1/dbhome_1InstallEditionEEOSDBA_GROUPdbaOSOPER_GROUPoperOSBACKUPDBA_GROUPdbaOSDGDBA_GROUPdbaOSKMDBA_GROUPdbaOSRACDBA_GROUPdbadbTypeGENERAL_PURPOSE10.2.静默安装Oracle软件[oracleaiserver ~]$ cd $ORACLE_HOME./runInstaller -silent -responseFile /tmp/db_install.rsp -ignorePrereq安装结束后需要以root用户执行以下两个脚本/u01/app/oracle/oraInventory/orainstRoot.sh/u01/app/oracle/product/23.26.1/dbhome_1/root.sh11.监听创建静默配置监听[oracleaiserver ~]$ netca -silent -responseFile $ORACLE_HOME/assistants/netca/netca.rsp12.dbca建库12.1.编辑dbca.rsp安装文件[oracleaiserver ~]$ cd $ORACLE_HOME/assistants/dbca[oracleaiserver dbca]$ cp dbca.rsp /tmp[oracleaiserver ~]$ vi /tmp/dbca.rspresponseFileVersion/oracle/assistants/rspfmt_dbca_response_schema_v23.0.0gdbNameprodsidproddatabaseConfigTypeSIcreateAsContainerDatabasetruenumberOfPDBs2pdbNameprodtemplateNameGeneral_Purpose.dbcoracleHomeUserPasswordoracletotalMemory1500sysPasswordoraclesystemPasswordoracledatafileDestination/u01/app/oracle/oradatacharacterSetAL32UTF8nationalCharacterSetUTF8databaseTypeOLTP注意templateName、createAsContainerDatabase必須指定12.2.静默安装数据库[oracleaiserver ~]$ dbca -silent -createDatabase -responseFile /tmp/dbca.rspimage境庸佑郝