Result_cache (MODE DEFAULT) ora-00922:missing or invalid option is encountered when building tables in Oracle 11.2 database

Result_cache (MODE DEFAULT) ora-00922:missing or invalid option is encountered when building tables in Oracle 11.2 database

Hostdr:[/home/oracle] $sqlplus/as sysdbasql*plus:release 11.2.0.3.0 Production on Thu Jul 9 12:52:11 2015Copyright (c) 1  982, Oracle. All rights reserved.  Connected to:oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit productionwith The partitioning, OLAP, Data Mining and Real Application testing optionssql>sql> CREATE TABLE USERA. "              Table_name_aa "2 (3 C1 char (8 bytes) DEFAULT", 4 C2 char (2 byte) Default ", 5 C3 number () default 0, 6 C4 number (+) Defaul    T 0, 7 C5 number (+) default 0, 8 C6 number (+) default 0, 9           C7 number (+) default 0, C8 number (+) default 0, one C9 Number () default 0, C10 number (+) default 0, C11 number (+) DEFAULT 0) tablespace USERS result_cache (MODE DEFAULT) pctused 0 PCTFREE Initrans 1 maxt RANS 255 STORAGE (INITIAL 64K 1M MinEx      Tents 1 MAXEXTENTS UNLIMITED pctincrease 0 Buffer_pool Default Flash_cache default Cell_flash_cache Default-LOGGING Nocompress NOCACHE noparallel monitoring 36/result_cache (MODE DEFAULT) *error at line 16:ora-00922:miss ing or invalid optionsql>

Background introduction:
This db is a standalone of 11.2.0.3.8 Linux and is the backup repository for Ogg, and the main library of Ogg is the RAC under Linux under 11.2.0.3.8. These two DB are prepared for disaster recovery through Ogg. The initial discovery of "ora-00922:missing or Invalid option" error is due to the RPT (report) at the time of the rep process Abend,abend on the Ogg standby as follows:

2015-05-18 10:14:14 Info OGG-01407 Setting Current schema for DDL operation to [usera].2015-05-18 10:14:15 info O GG-01408 Restoring Current schema for DDL operation to [goldengate].2015-05-18 10:15:30 INFO OGG-01407 Setting Curre NT schema for DDL operation to [USERA]. Source context:sourcemodule: [GGAPP.DDL] SourceID: [/scratch/mmar/view_storage/mmar_201990 12/OGGCORE/OPENSYS/SRC/GGLIB/GGAPP/DDLREP.C] Sourcefunction: [Ddlrep_handleddlerror (const UString &, const Ustring &, const ustring &, ustring &, int, repconfig_t *, const ustring &, const ustring &, const UST Ring &, cdbobjname<7> &, cdbobjname<1> &, long *)] Sourceline: [684]2015-05-18 10:1 OGG-00519 Error Fatal Error executing DDL replication:error [error code [922], ORA-00922: ^z^z^z^z^z^z^z SQL CRE ATE TABLE USERA. " Table_name_aa "(C1 char (8 bytes) DEFAULT ', C2 char (2BYTE) Default ", C3 number () default 0, C4 number (16)           Default 0, C5 number (+) default 0, C6 number (), default 0, C7                Number (+) default 0, C8 number (+) default 0, C9 number (12) Default 0, C10 number (+) default 0, C11 number (+) default 0) tablespace Usersresult_cache (MODE DEFAULT) pctused 0PCTFREE 10INITRANS 1MAXTRANS 255STORAGE (in            Itial 64K NEXT 1M minextents 1 MAXEXTENTS UNLIMITED Pctincrease 0 buffer_pool Default Flash_cache default Cell_flash_ca CHE DEFAULT) loggingnocompressnocachenoparallelmonitoring/* goldengate_ddl_replication *], no error handler present.***************** * Run Time Statistics * * ************************************************************************

The following error is ignored.

See Ogg of the rep process error, initially thought is the problem of Ogg, and then from the above alone to intercept create script, put in Sqlplus inside run, the result or error (this is the beginning of this article can see), that can be said to be Oracle database problem, Not the question of Ogg.

After thinking carefully about the differences between the Ogg master and Ogg repositories, the Ogg main library was newly created by DBCA, and the Ogg repository was upgraded from the 10.2.0.5. With this in mind, an experienced DBA will immediately check the compatible parameters of the Ogg repository, The result of the check is that the compatible parameter value is 10.2.0.5. This parameter is required to be modified to 11.2.0.0.0 (as in the main library), of course, there are several points of note to modify this parameter:
1. Modify the compatible parameter to restart the database for effective.
2. Once the modification completes this parameter (after restarting the database), you cannot lower this parameter to the original value, or the instance will report the following error when it is in the Mount state:

Ora-00201:control file version 11.2.0.0.0 incompatible with ORACLE version 10.2.0.5ora-00202:control file: ' D:\IM\CONTRO Lfile\control01. CTL '

The knowledge points of this case:

1. See if the DB is a new or upgrade method for DBCA:

sql> set pages lines 120sql> Col action format a16sql> col namespace format A10 Sql> Col version format a10sql> col comments format a26sql> Col action_time format a30sql> Col bundle_series F Ormat A15sql> set line 200sql> alter session set Nls_timestamp_format = ' Yyyy-mm-dd hh24:mi:ss.ff '; Sql> select * from Dba_registry_history; Action_time ACTION NAMESPACE VERSION ID bundle_series COMMENTS----------------- ----------------------------------------------------------------------------------------------------2015-01-03 12:15:56.136897 View INVALIDATE 8289601 view invalidation2015-01-03 12:16:30 .178980 UPGRADE SERVER 11.2.0.3.0 upgraded from 10.2.0.5.02015-01-03 12:16:39. 788907 APPLY SERVER 11.2.0.3 8 PSU PSU 11.2.0.3.8sql> 

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Result_cache (MODE DEFAULT) ora-00922:missing or invalid option is encountered when building tables in Oracle 11.2 database