没有合适的资源?快使用搜索试试~ 我知道了~
晶澳太阳能Oracle EBS ERP升级项目-系统升级及平台迁移详细方案c
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 24 浏览量
2024-02-26
19:52:25
上传
评论
收藏 5.02MB DOC 举报
温馨提示
晶澳太阳能Oracle EBS ERP升级项目_系统升级及平台迁移详细方案c
资源推荐
资源详情
资源评论
EBS UPGRADE+MIGRATION PLATFORM
详细方案
作者:
创建日期: 2018-07-29
最后更新: 2024-02-26
控制码:
版本: 1.0
审批签字:
项目经理
项目经理
文档控制
修改记录
4
日期
作者
版本
修改参考
2018-07-29
1.0
No Previous Document
审阅
姓名
职位
分发
拷贝
姓名
地点
1
Library Master
Project Library
2
3
4
目录
1 系统升级简介..........................................................................................................................1
1.1 系统现状........................................................................................................................1
1.2 系统升级目标................................................................................................................1
2 系统升级技术方案..................................................................................................................2
2.1 参考Notes .....................................................................................................................2
3 升级前准备..............................................................................................................................3
3.1 暂挂计划请求和数据库Job..........................................................................................3
3.2 备份并删除dblink........................................................................................................3
4 导出数据库-HP.......................................................................................................................5
4.1 安装前置补丁................................................................................................................5
4.2 创建导出目录................................................................................................................6
4.3 生成目标数据库创建脚本............................................................................................6
4.4 记录Advanced Queue设置 ........................................................................................7
4.5 Create parameter file for tables with long columns...............................................7
4.6 在spatial indexes中移除rebuild index 参数 ............................................................7
4.7 步Text索引....................................................................................................................8
4.8 其他导出前工作............................................................................................................9
4.9 源环境数据库导出......................................................................................................11
4.10 导出long columns....................................................................................................12
4.11 Export tables with XML type columns ................................................................12
5 安装11gR2数据库软件和12.2.0-Linux ...............................................................................14
5.1 perating Systems Requirements(DB和APP都要执行) .........................................14
5.2 应用服务器上安装12.2.0............................................................................................17
5.3 数据库服务器上安装数据库软件..............................................................................32
6 导入新数据库-Linux............................................................................................................45
6.1 创建数据库..................................................................................................................45
6.2 源库和目标库对比组件..............................................................................................46
6.3 设置CTXSYS parameter ...........................................................................................46
6.4 禁用数据自动统计功能..............................................................................................46
6.5 关闭数据库备份..........................................................................................................47
6.6 创建导入参数文件......................................................................................................47
6.7 Import triggers into the target database ................................................................49
6.8 导入OLAP analytical workspaces ..........................................................................49
6.9 目标环境回收system用户的权限 .............................................................................50
6.10 目标数据库导入后升级操作....................................................................................50
6.11 运行autoconfig.........................................................................................................51
6.12 Gather statistics for SYS schema...........................................................................54
6.13 Create ConText and AZ objects ............................................................................54
6.14 Import tables with XML type columns................................................................54
6.15 编译无效对象............................................................................................................55
6.16 重建XLA packages ..................................................................................................55
6.17 维护应用数据库对象................................................................................................55
6.18 Create DQM indexes ..............................................................................................56
7 12.2.0升级前置操作..............................................................................................................57
7.1 扩表空间......................................................................................................................57
7.2 失效引起冲突的客户化触发器..................................................................................59
7.3 安装Application DBA (AD) Tasks..........................................................................60
7.4 应用层准备..................................................................................................................60
7.5 统计收集......................................................................................................................63
7.6 Disable AOL Audit Trail (conditional) ..................................................................64
7.7 ETCC检查安装数据库补丁.......................................................................................64
8 应用升级12.2.0......................................................................................................................68
8.1 12.0.6环境关闭应用....................................................................................................68
8.2 数据库参数文件设置..................................................................................................68
8.3 修改密码错误登陆次数..............................................................................................68
8.4 修改所有profile的密码复杂度验证..........................................................................68
8.5 安装12.2 AD补丁 .......................................................................................................69
8.6 安装12.2 preinstall补丁............................................................................................70
8.7 合并preinstall的patch和12.2.0 补丁........................................................................71
8.8 Run the American English upgrade patch driver ................................................71
8.9 配置EBS12.2.0 instanc...............................................................................................72
8.10 移植1594274.1里面application层补丁...................................................................72
8.11 Enabling Online Patching ......................................................................................75
8.12 Complie Invalid objects..........................................................................................77
8.13 重新运行Online Patching.......................................................................................77
9 升级12.2.7..............................................................................................................................79
9.1 安装最新AD&TXK patch (参考:1617461.1) ...................................................79
9.2 autocfg 配置 ...............................................................................................................79
9.3 安装最新RUP 12.2.7 ..................................................................................................80
9.4 安装Online Help补丁................................................................................................80
9.5 安装中文补丁..............................................................................................................81
9.6 恢复计划请求..............................................................................................................81
9.7 恢复job ........................................................................................................................82
9.8 enable 客户化的trigger.............................................................................................82
9.9 启动应用......................................................................................................................82
9.10 删除废弃的Product Schema...................................................................................82
9.11 删除dangling synonyms ........................................................................................82
9.12 adadmin管理应用....................................................................................................82
9.13 同步文件系统............................................................................................................83
9.14 统计数据收集模式....................................................................................................83
1
1 系统升级简介
1.1 系统现状
客户EBS系统信息如下:
EBS应用版本:12.0.6
平台:HP-UX B.11.31 U ia64
EBS数据库版本:10.2.0.3.0
平台:HP-UX B.11.31 U ia64
数据库大小:900G
1.2 系统升级目标
EBS应用版本:12.2.7
平台:由hp迁移到Linux 7
EBS数据库版本:11.2.0.4
平台:由hp迁移到Linux 7
剩余86页未读,继续阅读
资源评论
xdpcxq1029
- 粉丝: 1298
- 资源: 282
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功