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.FD1:
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.FD1
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

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 ONE Support launchpad (Login required).

Search for additional results

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