Encounter ORA-03113 Error when create spfile from pfile

最新推荐文章于 2023-12-25 10:24:23 发布

原创最新推荐文章于 2023-12-25 10:24:23 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#session #sql

RAC 专栏收录该内容

47 篇文章

订阅专栏

本文记录了一次使用Oracle数据库时尝试从普通初始化参数文件创建SPFILE过程中遇到的ORA-03113错误，并展示了错误发生时的相关日志及跟踪文件。

SQL> create spfile='+DATA0411/spfile' from pfile='/u01/app/base/admin/racstr/scripts/init.ora';
create spfile='+DATA0411/spfile' from pfile='/u01/app/base/admin/racstr/scripts/init.ora'
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 30023
Session ID: 348 Serial number: 1071

alter log:

Dumping diagnostic data in directory=[cdmp_20120414202358], requested by (instance=1, osid=30575), summary=[incident=45941].
Sat Apr 14 20:23:59 2012
Sweep [inc][45941]: completed
Sweep [inc2][45941]: completed

[cdccrs@node1 trace]$ ll
total 288
-rw-r----- 1 cdccrs dba    642 Apr 14 20:28 alert.log
-rw-r----- 1 cdccrs dba    211 Apr 14 20:28 alert_racstr1.log
drwxr-xr-x 2 cdccrs dba  36864 Apr 14 20:28 cdmp_20120414202845
-rw-r----- 1 cdccrs dba   4249 Apr 14 20:28 racstr1_dia0_21407.trc
-rw-r----- 1 cdccrs dba    558 Apr 14 20:28 racstr1_dia0_21407.trm
-rw-r----- 1 cdccrs dba   1767 Apr 14 20:28 racstr1_diag_21397.trc
-rw-r----- 1 cdccrs dba    266 Apr 14 20:28 racstr1_diag_21397.trm
-rw-r----- 1 cdccrs dba 209180 Apr 14 20:28 racstr1_ora_30951.trc
-rw-r----- 1 cdccrs dba  12030 Apr 14 20:28 racstr1_ora_30951.trm