关于ORACLE 11G RAC建库出错的问题

今天做了一套ORACLE 11G RAC FOR LINUX5.3,其中CRS和ORACLE都升级到了11.1.0.7.0( 用的是ocfs2),但是建库时候发现一个问题,如果选择“ 使用自动内存管理”,则在开始建库的时候报ORA-03113和ORA-03114错误,如果不选择,一切正常,不知道是怎么回事,请高手帮忙回答下,谢谢!

作者: whstone   发布时间: 2011-07-20

不知道有用没?

Applies to:
Oracle Database Configuration Assistant - Version: 10.1.0.3 to 11.1.0.6 - Release: 10.1 to 11.1
Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.1.0.7   [Release: 10.2 to 11.1]
Oracle Server - Standard Edition - Version: 10.2.0.1 to 11.1.0.6   [Release: 10.2 to 11.1]
Information in this document applies to any platform.

Symptoms
On oracle 10g R2 database server
when attempt to create database using DBCA it hangs

the log file show the following errors
[Thread-14] [13:31:27:148] [BasicStep.execute:201] Executing Step : CLONE_DB_CREATION_RMAN_RESTORE
[Thread-14] [13:31:27:148] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01092
[Thread-14] [13:31:27:149] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01034
[Thread-14] [13:31:27:149] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-03114
[Thread-14] [13:31:27:150] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-12560
[Thread-14] [13:31:27:150] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error:
ORA-01109
[Thread-14] [13:31:27:153] [BasicStep.execute:201] Executing Step : INSTANCE_CREATION


Also the database can be created manually

For version 11.1.0.6:
This Problem also occurs if you install Version 11.1.0.6 and the patch to 11.1.0.7 and then tries to create a database via dbca.


Cause
-- It seems there are missing files/libraries after a wrong installation (bad install)

Solution
To implement the solution, please execute the following steps:

1. Reinstall the oracle software OR reinstall DBCA

2. For version 11.1.0.6:
Create the database with Version 11.1.0.6, then install the patchset 11.1.0.7 and then proceed to create the database.

3. Similar issues in 10gR2 are found to be fixed after upgrading to 10.2.0.5 patchset.

作者: ghosthtf   发布时间: 2011-07-20