SAP Knowledge Base Article - Preview

2536830 - ORA-01920: user name conflicts with another user or role name - SUM

Symptom

  • You are executing an upgrade with SUM and it fails in the "Create the shadow database schema" step.
  • When it fails it indicates a DMT.CREATE_SCHEMA.LOG log file, which contains error messages similar to the following:
<timestamp> [Info ]: CREATE USER $(SCHEMA) IDENTIFIED BY "$(PASSWORD)" DEFAULT TABLESPACE $(TABLE_SPACE) TEMPORARY TABLESPACE PSAPTEMP GRANT SAPCONN, UNLIMITED TABLESPACE TO $(SCHEMA)
<timestamp> [Info ]: Generating statements has finished.
<timestamp> [Info ]: Executes statement list:
<timestamp> [Info ]: Connection to SYSTEM has been established.
<timestamp> [Info ]: Error while executing statement.
<timestamp> [Info ]: ORA-01920: user name '<username>' conflicts with another user or role name
<timestamp>  [Error ]: Error while executing statement.
<timestamp>  [Info ]: Statement execution has finished.
<timestamp>  [Error ]: Error while executing statement list.
<timestamp>  [Info ]: Connection has been closed.
<timestamp>  [Info ]: Could not execute command execute.
<timestamp>  [Info ]: Could not execute command runhandler.
<timestamp>  [Info ]: Start time: <timestamp>
<timestamp>  [Info ]: Stop time : <timestamp>
<timestamp>  [Info ]: Duration : <duration>
<timestamp>  [Error ]: Error during execution.
<timestamp>  [Error ]: java.sql.SQLException: ORA-01920: user name '<username>' conflicts with another user or role name
<timestamp>  [Error ]: SQL Exception code 1920: ORA-01920: user name '<username>' conflicts with another user or role name
<timestamp>  [Error ]: Could not execute the list of statements.
<timestamp>  [Error ]: Could not execute DMT command runhandler. See previous messages.
  • The user mentioned in the ORA-01920 error does not own any database object:
SQL> select owner, object_name, object_type from dba_objects where owner=upper('<username>');
no rows selected

Read more...

Environment

  • SAP Systems based on SAP NetWeaver
  • Oracle Database

Product

SAP NetWeaver all versions

Keywords

CREATE_SCHEMA, CREATE, SCHEMA, upgrade , KBA , 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.