核心内容摘要
这次带你深入浅出 Redis 大 key！
下载地址https://www.oracle.com/database/technologies/oracle26ai-linux-downloads.html
安装环境准备
1.
查看物理内存/* by yours.tools - online tools website : yours.tools/zh/httpheader.html */ [rootaiserver ~]# free -m
1.
操作系统版本/* by yours.tools - online tools website : yours.tools/zh/httpheader.html */ [rootaiserver ~]# cat /etc/redhat-release
1.
操作系统内存[rootaiserver ~]# df -h /dev/shm/
1.
磁盘空间[rootaiserver ~]# df -TH [rootaiserver ~]# df -h /tmp/ [rootaiserver ~]# df -h /u
011.
查看系统架构[rootaiserver ~]# uname -m x86_64[rootaiserver ~]# cat /proc/version
1.
解析/etc/hosts[rootaiserver ~]# hostname aiserver cat /etc/hosts EOF
192.
168.
1 aiserver EOF
1.
关闭防火墙还有selinuxsystemctl status firewalld.service systemctl stop firewalld.service systemctl disable firewalld.servicesed -i s/SELINUXenforcing/SELINUXdisabled/ /etc/selinux/config
创建用户和组查看是否安装有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 oracle
创建工作的目录[rootaiserver ~]# mkdir -p /u01/app/oracle [rootaiserver ~]# chown -R oracle:oinstall /u01/ [rootaiserver ~]# chmod -R 775 /u01/app/oracle
配置Oracle的环境变量[oracleaiserver ~]$ vi .bash_profile export ORACLE_BASE/u01/app/oracle export ORACLE_HOME$ORACLE_BASE/product/
23.
2
1/dbhome_1 export ORACLE_SIDprod export PATH$ORACLE_HOME/bin:$PATH:$HOME/bin[oracleaiserver ~]$ source .bash_profile [oracleaiserver ~]$ env | grep ORACLE
修改内核参数以下在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.ipv
ip_local_port_range 9000 65500 EOF kernel.shmall :物理内存的70% kernel.shmmnikernel.shmall/4 环境变量生效 sysctl --system
/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.so
修改资源限制以下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 EOF
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 -y
解压软件授权、oracle用户下操作[oracleaiserver ~]$ mkdir -p /u01/app/oracle/product/
23.
2
1/dbhome_1oracle用户下操作[oracleaiserver ~]$ unzip /opt/LINUX.X64_2326100_db_home.zip -d $ORACLE_HOME
静默安装Oracle数据库
10.
编辑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.
2
1/dbhome_1 InstallEditionEE OSDBA_GROUPdba OSOPER_GROUPoper OSBACKUPDBA_GROUPdba OSDGDBA_GROUPdba OSKMDBA_GROUPdba OSRACDBA_GROUPdbadbTypeGENERAL_PURPOSE
10.
静默安装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.
2
1/dbhome_1/root.sh
监听创建静默配置监听[oracleaiserver ~]$ netca -silent -responseFile $ORACLE_HOME/assistants/netca/netca.rsp
dbca建库
12.
编辑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_v
23.
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.