SAP Knowledge Base Article - Preview

2389183 - SAP schema owner in lower case in oracle

Symptom

A couple symptoms may arise for this issue:

First:

Primary indices are missing after homogeneous system copy

A homogeneous system copy with R3load (where the source and target database are Oracle), was carried out, this can be for example a migration with unicode conversion.

All indices were created by R3load (Migration Monitor) successfully with a valid time stamp according to the package-logs, for example:

(DB) INFO: /1BS/TEST_T_FK~0 created #20161024134447

Despite this:

- in the target system several thousand primary indices are missing in the database
- possibly also there are errors in SWPM post-installations steps, the report "RADDBDIF" fails, for example:

ERROR      <timestamp> (root/sapinst) [CSiStepExecute.cpp:1187] id=controller.stepExecuted errno=FCO-00011
The step runRADDBDIF with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|onehost|0|
NW_CI_Instance|ind|ind|ind|ind|ci|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|abapReports|0|runRADDBDIF was executed with status ERROR

Second:

Creating indexes through process chains may fail with the error below, considering SAPSR3 is the schema owner:

Error message: ORA-01920: user * 'SAPSR3' does not exist" in Creating Index step of Process chain. 


Read more...

Environment

  • Homogeneous system copy of SAP Release based on NetWeaver 7.0 and higher
  • Oracle 11.2.0.4

Product

SAP NetWeaver 7.4

Keywords

homogeneous system copy, migration, unicode conversion, SMIGR_CREATE_DDL, RADDBDIF, R3Load, Migration Monitor, oracle, SWPM, secure store, lower case, upper case , KBA , BC-DB-ORA , Oracle , BC-INS-MIG , OS/DB Migrations with SWPM and DB refresh , 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.