SAP Knowledge Base Article - Preview

2064052 - "ORA-00922: missing or invalid option" error in phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE or MAIN_NEWBAS/PARCONV_UPG

Symptom

  • During an upgrade/update using the SUM tool, it stops in phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE with following error:

Log directory: <DIR_PUT>/log /SAPUpConsole.log

Severe error(s) occurred in phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE!
Last error code set: Single errors (code &lt;= 8) found in logfile 'DBCLONE.ELG'
*ERROR* :
Detected the following errors:
# D:\usr\sap\<SID>\SUM\abap\log\DBCLONE01.<SID>:
3 ETGCLN END GUI_E2E_XML -> GUI_E2E_XML~ 20140904144610
5 ETGCLN GUI_E2E_XML done in 1 seconds
3 ETGCLN START GVD_BGPROCESS -> GVD_BGPROCESS~ 20140904144610
3 ETGCLN Primary key strategy for current table is 0
3 ETGCLN CREATE TABLE "GVD_BGPROCESS~" ("SNAPSHOT_ID" VARCHAR2 (000030)
DEFAULT '0000000000' NOT NULL, "INST_ID" NUMBER (000022, 000000) DEFAULT 0 NOT
NULL, "NAME" VARCHAR2 (000015) DEFAULT ' ' NOT NULL, "PADDR" RAW (000008),
"DESCRIPTION" VARCHAR2 (000192) DEFAULT ' ' NOT NULL, "ERROR" NUMBER (000022,
000000) DEFAULT 0 NOT NULL) PCTFREE 00 PCTUSED 00 INITRANS 001 TABLESPACE
PSAPSR3 COMPRESS BASIC STORAGE (INITIAL 0000000064 K NEXT 0000001024 K
MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001
FREELIST GROUPS 01)
1EETGCLN ORA-00922: missing or invalid option
1EETGCLN GVD_BGPROCESS
1EETGCLN Error when cloning table structure

======================================================================

Log directory: <DIR_PUT>/log/DBCLONE.ELG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
CLONING ERRORS and RETURN CODE in DBCLONE01.<SID>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

8 ETGCLN START CLONING TABLES
3 ETGCLN Reading D:\usr\sap\<SID>\SUM\abap\mem\TAIATRANS.DAT
3 ETGCLN START GVD_BGPROCESS -> GVD_BGPROCESS~ 20140904153905
3 ETGCLN Primary key strategy for current table is 0
3 ETGCLN CREATE TABLE "GVD_BGPROCESS~" ("SNAPSHOT_ID" VARCHAR2 (000030) DEFAULT '0000000000' NOT NULL, "INST_ID" NUMBER (000022, 000000) DEFAULT 0 NOT NULL, "NAME" VARCHAR2 (000015) DEFAULT ' ' NOT NULL, "PADDR" RAW (00
1EETGCLN ORA-00922: missing or invalid option
1EETGCLN GVD_BGPROCESS
1EETGCLN Error when cloning table structure
3 ETGCLN START GVD_DATABASE -> GVD_DATABASE~ 20140904153906
3 ETGCLN Primary key strategy for current table is 0
3 ETGCLN CREATE TABLE "GVD_DATABASE~" ("SNAPSHOT_ID" VARCHAR2 (000030) DEFAULT '0000000000' NOT NULL, "INST_ID" NUMBER (000022, 000000) DEFAULT 0 NOT NULL, "DBID" NUMBER (000022, 000000) DEFAULT 0 NOT NULL, "NAME" VARCH
1EETGCLN ORA-00922: missing or invalid option
1EETGCLN GVD_DATABASE
1EETGCLN Error when cloning table structure
3 ETGCLN START GVD_DB_CACHE_ADV -> GVD_DB_CACHE_ADV~ 20140904153906
3 ETGCLN Primary key strategy for current table is 0
3 ETGCLN CREATE TABLE "GVD_DB_CACHE_ADV~" ("SNAPSHOT_ID" VARCHAR2 (000030) DEFAULT '0000000000' NOT NULL, "INST_ID" NUMBER (000022, 000000) DEFAULT 0 NOT NULL, "ID" NUMBER (000022, 000000) DEFAULT 0 NOT NULL, "NAME" VAR
1EETGCLN ORA-00922: missing or invalid option
1EETGCLN GVD_DB_CACHE_ADV
1EETGCLN Error when cloning table structure

  •  Phase MAIN_NEWBAS/PARCONV_UPG has errors like following:
         2WETP000 21:48:21: Retcode 1: error in DDL statement for "/SAPPCE/TDPC01                " - repeat
         2EETP345 21:48:33: Retcode 1: SQL-error "922-ORA-00922: missing or invalid option" in DDL statement
         2EETP345  for "/SAPPCE/TDPC01                "
         2 ETP000                  DB-ROLLBACK()
         2EETP334 21:48:33: error in DDL, nametab for "/SAPPCE/TDPC01" not activated


Read more...

Environment

  • Upgrade ABAP stack using SUM tool
  • Oracle Database
 

Product

SAP NetWeaver all versions

Keywords

DBCLONE , SUM, ORACLE, Upgrade, ORA-00922 , ABAP , KBA , BC-UPG-TLS-TLA , Upgrade tools for ABAP , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.