ORA-03113 And ORA-03114 While Running Utlrp.sql
来源:互联网 发布:sql server union all 编辑:程序博客网 时间:2024/06/13 20:22
APPLIES TO:
Oracle Database - Enterprise Edition - Version 10.1.0.4 and laterInformation in this document applies to any platform.
SYMPTOMS
Receiving ORA-03113 while running utlrp.sql to validate invalid objects.
DECLARE
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
ERROR:
ORA-03114: not connected to ORACLE
In the alert.log ORA-07445 is reported.
ORA-07445: exception encountered: core dump [__GI_memcpy()+162] [SIGSEGV] [Address not mapped to object] [0x2B98F408D7] [] []
CHANGES
Database was changed from 32-bit word size to 64-bit word Size.
A word size change requires to run the utlirp.sql script as a necessary step for making sure to recompile compiled PL/SQL code to the new word size.
CAUSE
Bug 6619899 was raised for the issue but the bug was closed as "not a bug" with below reason.
Running the olap.sql prior to running the utlirp.sql resolved the problem of receiving the ORA-7445 error when running utlrp.sql.
When migrating from 32 bit to 64 bit all aw's need to be exported/imported or re-created.
The olap.sql script recreates the system aw's.
SOLUTION
Running olap.sql before running utlirp.sql will resolve the issue.
SQL> @?/olap/admin/olap.sql SYSAUX TEMP;
- ORA-03113 And ORA-03114 While Running Utlrp.sql
- RMAN-03002, RMAN-06059, ORA-19625 and ORA-27037 When Running RMAN Backup of Archivelogs
- Drop Materialized View with Fails with ORA-4020 and getting ORA-955 while Recreating MVIEW
- SQL Function for DB2 and ORA
- TNSNAMES.ORA, LISTENER.ORA and SQLNET.ORA
- TNSNAMES.ORA, LISTENER.ORA and SQLNET.ORA
- ORA-2097 and ORA-15014
- ORA-10458:ORA-01157:ORA-01110: and ORA-01668:
- ORA-03113,ORA-07445
- ORA-19809&&ORA-03113
- ORA-03113/03114 处理
- ORA
- ora
- ORA-13600, QSM-00775, ORA-06512 when running DBMS_ADVISOR
- ora-08102 and col_usage$
- utlrp.sql脚本
- ORA-03113 ORA-24324 ORA-01041
- ORA-24324 ORA-01041 ORA-03113
- 比较实用的网站(持续更新中)
- Elasticsearch2.4.X 搜索引擎框架 安装配置
- Windows下利用开源的FreeFileSync进行定期自动备份
- VS2013中多字节编码与Unicode码
- android的使用总结
- ORA-03113 And ORA-03114 While Running Utlrp.sql
- 演示Math
- 我的Golang学习记录
- python 微信公众平台开发
- 用DirectShow写一个“合并左右声道”的Filter实现小结
- linux centos7.2 下配置网络yum 的问题
- luci 学习相关的地址
- POI自定义表头(合并列)导出Excel工具类
- android 6.0调用拨打电话所出现的问题