ORACLE 数据库安装配置规范
第 1 页
目录
一、安装配置规范 ...........................................................................................................................1
1.1．ORACLE 安装版本要求..................................................................................................1
1.2．操作系统要求...................................................................................................................1
最小平台要求....................................................................................................................1
内核要求............................................................................................................................1
1.3．用户、组...........................................................................................................................1
1.4．文件系统、目录...............................................................................................................2
1.5．数据库字符集...................................................................................................................3
1.6．数据库命名规范...............................................................................................................3
1.7．数据库文件存放...............................................................................................................3
二、安装前的检查和设置 ...............................................................................................................3
3.1．关闭 NetworkManager .....................................................................................................3
3.2．关闭防火墙.......................................................................................................................4
3.3．关闭 selinux：..................................................................................................................4
3.4．包要求...............................................................................................................................4
3.5．配置 oracle 安装 shell 限制 ...........................................................................................7
3.5.1. /etc/security/limits.conf............................................................................................7
3.5.2. /etc/pam.d/login .......................................................................................................7
3.5.3. /etc/profile ................................................................................................................8
3.6．配置内核参数...................................................................................................................8
3.7．环境变量设置...................................................................................................................8
三、安装 Database Software ..........................................................................................................9
5.1．开始安装...........................................................................................................................9
5.2．安装截图...........................................................................................................................9
六 安装最新 PSU 版本 ..........................................................................................................18
七 创建数据磁盘组................................................................................................................18
四、创建实例 .................................................................................................................................22
4.1．运行命令.........................................................................................................................22
4.2．安装截图.........................................................................................................................22
五、参数优化 .................................................................................................................................33
5.1．运维部分.........................................................................................................................33
5.1.1 密码策略.................................................................................................................33
5.1.2 审计策略................................................................................................................33
5.1.3 CPU 资源管理........................................................................................................33
5.1.4 关闭延迟段创建....................................................................................................34
5.1.5 直接路径读............................................................................................................34
5.1.6 优化参数 SCN 部分..............................................................................................34
5.1.7 共享内存的 kgh policy..........................................................................................34
5.1.8 内存抖动参数........................................................................................................35
5.1.9 开启 DDL 记录操作 .............................................................................................35
5.2．内存参数优化.................................................................................................................35
5.3．在线日志调整.................................................................................................................36
剩余37页未读，继续阅读
资源评论
