My Oracle Support Banner

UIM Installation Failing with Error "ORA-00942: Table Or View Does Not Exist" (Doc ID 2491603.1)

Last updated on NOVEMBER 15, 2023

Applies to:

Oracle Communications Unified Inventory Management - Version 7.3.5.0.0 and later
Information in this document applies to any platform.

Symptoms

Fresh Installation of UIM 7.3.5.8.0 is failing with error "ORA-00942: table or view does not exist"

While performing fresh installation of UIM 7.3.5.8.0 on clustered environment with Oracle RAC Database, installation is failing with below error

INFO: Calling Action J2EEActions1.3.0.0 AI_RunSQLScript
  DB_CONNECT_STRING = null
  DB_HOST_NAME = ***************
  DB_HOST_PORT = *******
  DB_SYS_ID = *********
  DB_USER_NAME =<UIM Schema user>
  DB_USER_PASSWORD = *Protected value, not to be logged*
  INSTALL_SCRIPT_LOCATION = $WLS_Domain/UIM/scripts/uimdefaultstyles.sql
  UNINSTALL_SCRIPT_LOCATION =
  SECURE_FLAG = true
  IS_SYS_DBA = false
  REPLACEMENTS =
  LOG_LOCATION =
  TABLE_TABLESPACE = null
  INDEX_TABLESPACE = null

INFO: Exception thrown from action: AI_RunSQLScript
Exception Name: oui.j2ee.core.exception.JOUIUnabletoExecuteSqlException
Exception String: Error: Unable to run SQL Script. $WLS_Domain/UIM/scripts/uimdefaultstyles.sqlSQL Exception: Error Code = 0, SQL State = null , Oracle DB Message = ORA-00942: table or view does not exist

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


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