你現在使用的Oracle版本

OCPHUI

調查一下目前正在使用的Oracle主流版本﹐也為廣大DBA一個重點學習方向。

doni

主要用7.3.4
8.1.7在测试中,可能会用,但不取代原有的7

我这里的环境够古老吧

OCPHUI

哈哈﹐真是夠古老的﹗

wolfop

10g，对调优和发现问题SQL太方便了。

kde2000

我现在用10.1.0.3 for linux x86的版本，出现这样的一个问题，半夜exp导出整个库的时候整个数据库进程可能会崩溃退出，故障出现的时间不是很固定。升级到10.1.0.4还是毛病依旧。

咋回事呢?

日志如下：

1. 
   
2. /u01/app/oracle/admin/hdoadb/udump/hdoadb_ora_28594.trc
   
3. Oracle Database 10g Release 10.1.0.4.0 - Production
   
4. ORACLE_HOME = /u01/app/oracle/product/10.1.0
   
5. System name:        Linux
   
6. Node name:        oaserver1.localdomain
   
7. Release:        2.4.21-9.30AXsmp
   
8. Version:        #1 SMP Wed May 26 23:37:09 EDT 2004
   
9. Machine:        i686
   
10. Instance name: hdoadb
    
11. Redo thread mounted by this instance: 1
    
12. Oracle process number: 11
    
13. Unix process pid: 28594, image: oracle@oaserver1.localdomain (TNS V1-V3)
    
14. 
    
15. *** SERVICE NAME:(SYS$USERS) 2007-03-26 01:02:25.386
    
16. *** SESSION ID:(162.3) 2007-03-26 01:02:25.386
    
17. adbdrv:  lang flag = 0
    
18. Error in executing triggers on database startup
    
19. *** 2007-03-26 01:02:29.322
    
20. ksedmp: internal or fatal error
    
21. ORA-00604: error occurred at recursive SQL level 1
    
22. ORA-06521: PL/SQL: Error mapping function
    
23. ORA-06512: at "SYS.OLAPIHISTORYRETENTION", line 1
    
24. ORA-06512: at line 7
    
25. 
    

复制代码

[ 本帖最后由 kde2000 于 2007-4-6 16:06 编辑 ]

OCPHUI

LZ, 應該是bug, 以下是Metalink上的報告﹐供LZ參考。
Subject: 10G: ORA-6512 AT SYS.OLAPIHISTORYRETENTION on Standard Edition
Doc ID: Note:266728.1 Type: PROBLEM
Last Revision Date: 02-OCT-2006 Status: MODERATED

In this Document
Symptoms
Changes
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:
Oracle OLAP - Version: 10.1.0.2 to 10.2.0.1
Oracle Server - Standard Edition - Version: 10.1.0.2 to 10.2.0.1
This problem can occur on any platform.
Symptoms
Alert log trace shows errors in standard edition database created through DBCA, e.g:
ORA-00604: error occurred at recursive SQL level 1
ORA-06521: PL/SQL: Error mapping function
ORA-06512: at "SYS.OLAPIHISTORYRETENTION", line 1
ORA-06512: at line 7
Changes
New database
Cause
BUG 3386542 - OLAPI trggers that are installed with seed database, (OLAPISTARTUPTRIGGER and OLAPISHUTDOWNTRIGGER), does not handle absence of Oracle OLAP.
Solution
Disable OLAPISTARTUPTRIGGER and OLAPISHUTDOWNTRIGGER to avoid error from being generated.

ALTER TRIGGER SYS.OLAPISTARTUPTRIGGER DISABLE;
ALTER TRIGGER SYS.OLAPISHUTDOWNTRIGGER DISABLE;
References
Errors
ORA-604 error occurred at recursive SQL level
ORA-6512 "at %sline %s"
ORA-6521 PL/SQL: Error mapping function

loveych

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE        10.2.0.1.0        Production

TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

kde2000

原帖由 OCPHUI 于 2007-4-9 09:56 发表
LZ, 應該是bug, 以下是Metalink上的報告﹐供LZ參考。
Subject: 10G: ORA-6512 AT SYS.OLAPIHISTORYRETENTION on Standard Edition
Doc ID: Note:266728.1 Type: PROBLEM
Last Revision Date: 02-OCT-2006 Stat ...

先谢了！
我去试试看。

zhaojianyong

使用的库太多了，不便一一列出

kde2000

原帖由 OCPHUI 于 2007-4-9 09:56 发表
LZ, 應該是bug, 以下是Metalink上的報告﹐供LZ參考。
Subject: 10G: ORA-6512 AT SYS.OLAPIHISTORYRETENTION on Standard Edition
Doc ID: Note:266728.1 Type: PROBLEM
Last Revision Date: 02-OCT-2006 Stat ...

把那两个触发器禁用了，还是会导致exp的时候退出。

我准备换成rman看看。