Seeing Error With AT_CONTROLLERS After DBService Startup After 1.12.0.3 Install (Doc ID 2110584.1)

Last updated on MARCH 02, 2016

Applies to:

Oracle Utilities Network Management System - Version 1.12.0.3 to 1.12.0.3 [Release 1.12]
Oracle Network Management for Utilities - DMS - Version 1.12.0.3 to 1.12.0.3 [Release 1.12]
Information in this document applies to any platform.

Symptoms

You just installed NMS Service Pack 1.12.0.3.  Seeing a number of errors due to database table ATO_CONTROLLERS not existing in the DBService log.

Has this table become required?
The only place it is defined is in the OPAL_schema_attributes.sql file and in $CES_HOME/migration/sql/pr34696_migration.sql.

ERROR

02/23/16 13:38:23: dbrdwr:49676
-- ORACLE ERROR -- OCI return code from OCIStmtExecute is OCI_ERROR
while processing command 'select count(1) from ato_controllers where partition = 6143 AND ((birth_patch = 8546) or (death_patch = 8546) )'
ORA-00942: table or view does not exist
parse offset = 30[ollers where partit]
02/23/16 13:38:23: 0x7f1e1355d700,ctp=0x1c789f8,"query" Error on query: (select count(1) from ato_controllers where partition = 6143 AND ((birth_patch = 8546) or (death_patch = 8546) )) from (1/8:49911.0)
ORA-00942: table or view does not exist



Changes

This is a clean update to 1.12.0.3.0

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms