没有合适的资源?快使用搜索试试~ 我知道了~
01-第3部分 安装配置Oracle数据库服务器.docx
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 111 浏览量
2023-02-06
17:20:08
上传
评论
收藏 2.53MB DOCX 举报
温馨提示
试读
87页
01-第3部分 安装配置Oracle数据库服务器.docx
资源推荐
资源详情
资源评论
Error! Unknown document property name.
Error! Unknown document property name.
目 录
文档版本 Error! Unknown
document property name. (Error!
Unknown document property
name.)
Error! Unknown document
property name.
i
目 录
9 安装配置数据库服务器 ..............................................................................................................9-1
9.1 数据库安装流程 ...........................................................................................................................................9-2
9.2 准备数据库软件版本 ...................................................................................................................................9-2
9.3 配置数据库安装环境 ...................................................................................................................................9-3
9.3.1 创建用户组和用户..............................................................................................................................9-3
9.3.2 创建安装目录......................................................................................................................................9-4
9.3.3 设置环境变量......................................................................................................................................9-5
9.3.4 检查操作系统参数..............................................................................................................................9-6
9.3.5 检查磁盘组和逻辑卷..........................................................................................................................9-6
9.3.6 检查逻辑卷属性..................................................................................................................................9-9
9.4 主节点上安装 Oracle 数据库 ......................................................................................................................9-9
9.4.1 安装数据库软件..................................................................................................................................9-9
9.4.2 创建数据库监听................................................................................................................................9-19
9.4.3 创建数据库实例................................................................................................................................9-24
9.5 主节点上安装检验 .....................................................................................................................................9-42
9.5.1 启动监听............................................................................................................................................9-42
9.5.2 检查数据库版本................................................................................................................................9-43
9.5.3 启动数据库........................................................................................................................................9-44
9.5.4 检查数据库表空间............................................................................................................................9-45
9.5.5 停止监听............................................................................................................................................9-46
9.5.6 停止数据库........................................................................................................................................9-46
9.6 数据库优化 .................................................................................................................................................9-47
9.7 数据库优化后检验 .....................................................................................................................................9-51
9.8 备节点上安装 Oracle 数据库 ....................................................................................................................9-51
9.9 备节点上安装检验 .....................................................................................................................................9-54
9.10 双机上安装 HA Oracle Agent..................................................................................................................9-54
10 创建 INFOX 应用数据库 .......................................................................................................10-1
10.1 准备数据库脚本 .......................................................................................................................................10-2
10.2 上传数据库脚本 .......................................................................................................................................10-2
10.3 执行数据库脚本 .......................................................................................................................................10-2
Error! Unknown document property name.
Error! Unknown document property name.
目 录
文档版本 Error! Unknown
document property name. (Error!
Unknown document property
name.)
Error! Unknown document
property name.
ii
10.4 安装数据的常见问题 ...............................................................................................................................10-4
10.4.1 设置 Oracle Inventory 目录时告警.................................................................................................10-4
10.4.2 设置 Oracle 的 Base 目录时有警告 ...............................................................................................10-4
10.4.3 创建实例时报错 ORA-12801/00018/06512...................................................................................10-5
10.4.4 创建实例时报错..............................................................................................................................10-6
Error! Unknown document property name.
Error! Unknown document property name.
插图目录
文档版本 Error! Unknown
document property name. (Error!
Unknown document property
name.)
Error! Unknown document
property name.
iii
插图目录
图 9-1 Oracle 数据库安装流程图 .......................................................................................................................9-2
图 9-2 Oracle Universal Installer: Select Installation Method ...........................................................................9-10
图 9-3 Oracle Universal Installer: Select Installation Type ...............................................................................9-11
图 9-4 Oracle Universal Installer: Specify Home Details ..................................................................................9-12
图 9-5 Oracle Universal Installer: Product-Specific Prerequisite Checks..........................................................9-13
图 9-6 Oracle Universal Installer: Select Configuration Option ........................................................................9-14
图 9-7 Oracle Universal Installer: Privileged Operating System Groups ..........................................................9-15
图 9-8 Oracle Universal Installer: Summary......................................................................................................9-16
图 9-9 Oracle Universal Installer: Install ...........................................................................................................9-17
图 9-10 Execute Configuration Scripts ..............................................................................................................9-18
图 9-11 Oracle Universal Installer: End of Installation......................................................................................9-19
图 9-12 Oracle Net Configuration Assistant: Welcome.....................................................................................9-20
图 9-13 Oracle Net Configuration Assistant: Listener Configuration, Listener.................................................9-20
图 9-14 Oracle Net Configuration Assistant: Listener Configuration, Listener Name......................................9-21
图 9-15 Oracle Net Configuration Assistant: Listener Configuration, Select Protocols....................................9-22
图 9-16 Oracle Net Configuration Assistant: Listener Configuration, TCP/IP Protocol ...................................9-22
图 9-17 Oracle Net Configuration Assistant: Listener Configuration, More Listeners .....................................9-23
图 9-18 Oracle Net Configuration Assistant: Welcom.......................................................................................9-24
图 9-19 Database Configuration Assistant: Welcome........................................................................................9-25
图 9-20 Database Configuration Assistant, Step 1 of 15: Operations................................................................9-26
图 9-21 Database Configuration Assistant, Step 2 of 15: Database Templates .................................................9-27
图 9-22 Database Configuration Assistant, Step 3 of 15: Database Identification ............................................9-28
图 9-23 Database Configuration Assistant, Step 4 of 15: Management Options...............................................9-29
图 9-24 Database Configuration Assistant, Step 5 of 15: Database Credentials(1)...........................................9-29
图 9-25 Database Configuration Assistant, Step 6 of 15: Storage Options........................................................9-30
Error! Unknown document property name.
Error! Unknown document property name.
插图目录
文档版本 Error! Unknown
document property name. (Error!
Unknown document property
name.)
Error! Unknown document
property name.
iv
图 9-26 Database Configuration Assistant, Step 7 of 15: Database File Locations...........................................9-31
图 9-27 Database Configuration Assistant, Step 8 of 15: Recovery Configuration...........................................9-32
图 9-28 Database Configuration Assistant, Step 9 of 15: Database Connection ...............................................9-32
图 9-29 Database Configuration Assistant, Step 6 of 8: Initialization Parameters ............................................9-33
图 9-30 Database Configuration Assistant, Step 10 of 14: Initialization Parameters-Sizing.............................9-34
图 9-31 Database Configuration Assistant, Step 10 of 14: Initialization Parameters-Character Sets................9-35
图 9-32 Database Configuration Assistant, Step 10 of 14: Initialization Parameters-Connection Mode ..........9-35
图 9-33 Database Configuration Assistant, Step 11 of 14: Security Settings ....................................................9-36
图 9-34 Database Configuration Assistant, Step 12 of 14: Automatic Maintenance Tasks...............................9-37
图 9-35 Database Configuration Assistant, Step 13 of 14: Database Storage....................................................9-38
图 9-36 Database Configuration Assistant, Step 14 of 14: Creation Options ....................................................9-39
图 9-37 Summary ...............................................................................................................................................9-40
图 9-38 Database Configuration Assistant(1) ....................................................................................................9-41
图 9-39 Database Configuration Assistant(2) ....................................................................................................9-42
图 10-1 Error ......................................................................................................................................................10-4
图 10-2 warning..................................................................................................................................................10-5
图 10-3 创建实例时报错..................................................................................................................................10-5
图 10-4 Edit Datafile ..........................................................................................................................................10-7
Error! Unknown document property name.
Error! Unknown document property name.
表格目录
文档版本 Error! Unknown
document property name. (Error!
Unknown document property
name.)
Error! Unknown document
property name.
v
表格目录
表 9-1 Oracle 数据库用户组和用户规划 ...........................................................................................................9-3
表 9-2 磁盘阵列逻辑卷规划..............................................................................................................................9-7
表 9-3 Initialization Parameters-Menory 参考配置...........................................................................................9-33
表 9-4 Database Storage 配置说明....................................................................................................................9-38
表 9-5 db_cache_size 配置说明 ........................................................................................................................9-47
表 9-6 sga_max_size 配置说明 .........................................................................................................................9-48
表 9-7 pga_aggregate_target 配置说明 .............................................................................................................9-49
剩余86页未读,继续阅读
资源评论
猫一样的女子245
- 粉丝: 101
- 资源: 2万+
下载权益
C知道特权
VIP文章
课程特权
开通VIP
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功