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 for Me (Login required).

Search for additional results

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