使用DBCA创建模板时报“ora-03114:not connect to ORACLE ”,我查看alert.log中记录的报错为“ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [0x356C25B] [] [] [] []”具体alert.log中摘录如下:
Wed Oct 24 10:03:46 2007
Successful mount of redo thread 1, with mount id 1652623870
Wed Oct 24 10:03:46 2007
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Wed Oct 24 10:05:48 2007
Errors in file e:\oracle\product\10.1.0\admin\pszx_db\udump\pstc_ora_52992.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [0x356C25B] [] [] [] []trc文件摘录如下:
Dump file e:\oracle\product\10.1.0\admin\thsgh\udump\thsgh_ora_52992.trc
Wed Oct 24 10:05:47 2007
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Oracle Database 10g Release 10.1.0.2.0 - Production
Windows XP Version V5.1 Service Pack 2
CPU : 1 - type 586
Process Affinity: 0x00000000
Memory (A/P) : PH:227M/991M, PG:1568M/2390M, VA:1731M/2047M
Instance name: thsghRedo thread mounted by this instance: 1Oracle process number: 13Windows thread id: 52992, image: ORACLE.EXE (SHAD)
*** ACTION NAME:(0000007 STARTED16) 2007-10-24 10:05:47.031
*** MODULE NAME:(backup full datafile: ) 2007-10-24 10:05:47.031
*** SERVICE NAME:() 2007-10-24 10:05:47.031
*** SESSION ID:(162.3) 2007-10-24 10:05:47.031
*** 2007-10-24 10:05:47.031
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [0x356C25B] [] [] [] []
Current SQL statement for this session:
declare
done boolean;
concur boolean;
pieceno binary_integer;
handle varchar2(256);
comment varchar2(255);
media varchar2(255);
params varchar2(255);
archlog_failover boolean;
recid number;
stamp number;
tag varchar2(32);
begin
dbms_output.put_line(' ');
dbms_output.put_line(' BACKUP: Allocating device... ');
:devicename := dbms_backup_restore.deviceAllocate;
dbms_output.put_line(' BACKUP: Specifing datafiles... ');
dbms_backup_restore.backupSetDataFile(:set_stamp, :set_count);
dbms_backup_restore.backupDataFile(4);
dbms_backup_restore.backupDataFile(3);
dbms_backup_restore.backupDataFile(2);
dbms_backup_restore.backupDataFile(1);
dbms_output.put_line(' BACKUP: Create piece ');
dbms_backup_restore.backupPieceCreate('E:\DB_BAK\BACKUP_20071024.dfb', pieceno, done,handle,comment,media,concur,params,reuse=>true,archlog_failover=>archlog_failover,deffmt=>0,recid=>recid,stamp=>stamp,tag=>tag,docompress=>true);
IF done then
dbms_output.put_line(' BACKUP: Backup datafile done.');
else
dbms_output.put_line(' BACKUP: Backup datafile failed');
end if;
end;
----- PL/SQL Call Stack -----
object line object
handle number name
6B74FD88 947 package body SYS.X$DBMS_BACKUP_RESTORE
6B759F04 24 anonymous block
在其他网站上搜索了下说ORA-07445可能是Oracle的bug参数,但具我的估计可能还是数据库对象的问题,如何解决?
谢谢!
Wed Oct 24 10:03:46 2007
Successful mount of redo thread 1, with mount id 1652623870
Wed Oct 24 10:03:46 2007
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Wed Oct 24 10:05:48 2007
Errors in file e:\oracle\product\10.1.0\admin\pszx_db\udump\pstc_ora_52992.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [0x356C25B] [] [] [] []trc文件摘录如下:
Dump file e:\oracle\product\10.1.0\admin\thsgh\udump\thsgh_ora_52992.trc
Wed Oct 24 10:05:47 2007
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Oracle Database 10g Release 10.1.0.2.0 - Production
Windows XP Version V5.1 Service Pack 2
CPU : 1 - type 586
Process Affinity: 0x00000000
Memory (A/P) : PH:227M/991M, PG:1568M/2390M, VA:1731M/2047M
Instance name: thsghRedo thread mounted by this instance: 1Oracle process number: 13Windows thread id: 52992, image: ORACLE.EXE (SHAD)
*** ACTION NAME:(0000007 STARTED16) 2007-10-24 10:05:47.031
*** MODULE NAME:(backup full datafile: ) 2007-10-24 10:05:47.031
*** SERVICE NAME:() 2007-10-24 10:05:47.031
*** SESSION ID:(162.3) 2007-10-24 10:05:47.031
*** 2007-10-24 10:05:47.031
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [0x356C25B] [] [] [] []
Current SQL statement for this session:
declare
done boolean;
concur boolean;
pieceno binary_integer;
handle varchar2(256);
comment varchar2(255);
media varchar2(255);
params varchar2(255);
archlog_failover boolean;
recid number;
stamp number;
tag varchar2(32);
begin
dbms_output.put_line(' ');
dbms_output.put_line(' BACKUP: Allocating device... ');
:devicename := dbms_backup_restore.deviceAllocate;
dbms_output.put_line(' BACKUP: Specifing datafiles... ');
dbms_backup_restore.backupSetDataFile(:set_stamp, :set_count);
dbms_backup_restore.backupDataFile(4);
dbms_backup_restore.backupDataFile(3);
dbms_backup_restore.backupDataFile(2);
dbms_backup_restore.backupDataFile(1);
dbms_output.put_line(' BACKUP: Create piece ');
dbms_backup_restore.backupPieceCreate('E:\DB_BAK\BACKUP_20071024.dfb', pieceno, done,handle,comment,media,concur,params,reuse=>true,archlog_failover=>archlog_failover,deffmt=>0,recid=>recid,stamp=>stamp,tag=>tag,docompress=>true);
IF done then
dbms_output.put_line(' BACKUP: Backup datafile done.');
else
dbms_output.put_line(' BACKUP: Backup datafile failed');
end if;
end;
----- PL/SQL Call Stack -----
object line object
handle number name
6B74FD88 947 package body SYS.X$DBMS_BACKUP_RESTORE
6B759F04 24 anonymous block
在其他网站上搜索了下说ORA-07445可能是Oracle的bug参数,但具我的估计可能还是数据库对象的问题,如何解决?
谢谢!
解决方案 »
- rman 备份与恢复问题
- 求教:这个语句怎么优化
- 经理让建一张表,把相关的规章制度存进去,但我不知道到底该如何设计这张表。才能读的方便,不知道这样的设计对不对。架构是S1SH
- VB与oracle数据库连接问题,在线等
- 出现Created Undo Segment后数据库变慢,重启正常,每周一次
- oracle怎么返回两个date类型之间的时间差
- 表中数据存放顺序和提取问题???
- 关于10g触发器中:new 和 :old 的用法问题?? 大侠请进,分不够再加!!
- 谁见过版主?
- 用什么方法能在select子句中计算布尔表达式
- select t.part,s.part,t.plant,s.plant ,t.rowid from srm054 t,srm041 swhere t.part=s.part
- 10g创建的系统表空间为什么和9i不一样呢?
没辙了...