下载地址https://www.oracle.com/database/technologies/oracle26ai-linux-downloads.html1.安装环境准备1.1.查看物理内存/* by yours.tools - online tools website : yours.tools/zh/httpheader.html */ [rootaiserver ~]# free -m1.2.操作系统版本/* by yours.tools - online tools website : yours.tools/zh/httpheader.html */ [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 -m x86_64[rootaiserver ~]# cat /proc/version1.6.解析/etc/hosts[rootaiserver ~]# hostname aiserver cat /etc/hosts EOF 192.168.1.1 aiserver EOF1.7.关闭防火墙还有selinuxsystemctl status firewalld.service systemctl stop firewalld.service systemctl 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_profile export ORACLE_BASE/u01/app/oracle export ORACLE_HOME$ORACLE_BASE/product/23.26.1/dbhome_1 export ORACLE_SIDprod export PATH$ORACLE_HOME/bin:$PATH:$HOME/bin[oracleaiserver ~]$ source .bash_profile [oracleaiserver ~]$ env | grep ORACLE5.修改内核参数以下在root用户下操作cp /etc/sysctl.conf /etc/sysctl.conf.bak cat /etc/sysctl.conf EOF fs.file-max 6815744 kernel.sem 250 32000 100 128 kernel.shmmni 4096 kernel.shmall 751619276 kernel.shmmax 3006477107 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 fs.aio-max-nr 1048576 net.ipv4.ip_local_port_range 9000 65500 EOF kernel.shmall :物理内存的70% kernel.shmmnikernel.shmall/4 环境变量生效 sysctl --system6./etc/profile配置以下root用户操作cp /etc/profile /etc/profile.bak 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 vi /etc/pam.d/login session required pam_limits.so7.修改资源限制以下root用户操作cp /etc/security/limits.conf /etc/security/limits.conf.bak cat /etc/security/limits.conf EOF oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 EOF8.yum安装依赖[rootaiserver ~]# mount | grep sr0 mount /dev/cdrom /mnt echo [localREPO] /etc/yum.repos.d/my.repo echo namelocalhost8 /etc/yum.repos.d/my.repo echo baseurlfile:///mnt/BaseOS /etc/yum.repos.d/my.repo echo gpgcheck0 /etc/yum.repos.d/my.repo echo enabled1 /etc/yum.repos.d/my.repo echo [localREPO_APP] /etc/yum.repos.d/my.repo echo namelocalhost8_app /etc/yum.repos.d/my.repo echo baseurlfile:///mnt/AppStream /etc/yum.repos.d/my.repo echo gpgcheck0 /etc/yum.repos.d/my.repo echo 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_SWONLY UNIX_GROUP_NAMEoinstall INVENTORY_LOCATION/u01/app/oraInventory ORACLE_BASE/u01/app/oracle ORACLE_HOME/u01/app/oracle/product/23.26.1/dbhome_1 InstallEditionEE OSDBA_GROUPdba OSOPER_GROUPoper OSBACKUPDBA_GROUPdba OSDGDBA_GROUPdba OSKMDBA_GROUPdba OSRACDBA_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.rsp responseFileVersion/oracle/assistants/rspfmt_dbca_response_schema_v23.0.0 gdbNameprod sidprod databaseConfigTypeSI createAsContainerDatabasetrue numberOfPDBs2 pdbNameprod templateNameGeneral_Purpose.dbc oracleHomeUserPasswordoracle totalMemory1500 sysPasswordoracle systemPasswordoracle datafileDestination/u01/app/oracle/oradata characterSetAL32UTF8 nationalCharacterSetUTF8 databaseTypeOLTP 注意templateName、createAsContainerDatabase必須指定12.2.静默安装数据库[oracleaiserver ~]$ dbca -silent -createDatabase -responseFile /tmp/dbca.rsp