Installing OID Schema ODS Returns an Error, "Caused By: Java.sql.SQLSyntaxErrorException: ORA-01917: User Or Role 'ODS' Does Not Exist" (Doc ID 2817690.1)

Last updated on JANUARY 10, 2023

Applies to:

Symptoms

When trying to run the RCU to create a new OID schema (ODS) in the database an error occurs. Any other schemas that might be created like <PREFIX_STB> will create correctly.

The rcu.log will contain an error similar to this.

ERROR assistants.rcu.backend.task.ActualTask: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: RCU Operation Failed
oracle.sysman.assistants.common.task.TaskExecutionException:
ERROR - RCU-6135 Error while executing Java action.
CAUSE - RCU-6135 An error occurred while trying to execute Java action.
ACTION - RCU-6135 Check the java action for the component or contact the system administrator.
  at oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:329)
  at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:345)
  at java.lang.Thread.run(Thread.java:748)
Caused by: oracle.sysman.assistants.common.task.ActionFailedException:
ERROR - RCU-6135 Error while executing Java action.
CAUSE - RCU-6135 An error occurred while trying to execute Java action.
ACTION - RCU-6135 Check the java action for the component or contact the system administrator.
  at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:694)
  ... 1 more
Caused by: java.lang.reflect.InvocationTargetException
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:657)
  ... 1 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-01917: user or role 'ODS' does not exist

  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:229)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:41)
  at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:928)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)
  at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1823)
  at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1778)
  at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:303)
  at oracle.ias.version.SchemaVersion.executeOrGenerateSql(SchemaVersion.java:2977)
  at oracle.ias.version.SchemaVersion.grantRegistryAccess(SchemaVersion.java:2440)
  at oracle.ias.version.SchemaVersion.grantRegistryAccessToComponent(SchemaVersion.java:2364)
  at oracle.ias.version.SchemaVersionUtil.utilSetComponentValid(SchemaVersionUtil.java:522)
  ... 6 more
Caused by: Error : 1917, Position : 43, Sql = GRANT SELECT ON SCHEMA_VERSION_REGISTRY TO ODS, OriginalSql = GRANT SELECT ON SCHEMA_VERSION_REGISTRY TO ODS, Error Msg = ORA-01917: user or role 'ODS' does not exist

  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)
  ... 22 more

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.