Running ces_setup.ces Fails With ORA-1720 Error (Doc ID 1935856.1)

Last updated on JUNE 15, 2016

Applies to:

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

Symptoms

When attempting to install NMS 1.12.0.1, ces_setup.ces fails on the file "product_schema_web_swsheets.sql".

The log file shows this:

ISQL.ces loading /opt/nms/nmsadmin/sql/product_schema_web_swsheets.sql
Converting generic sql file to ORACLE file /opt/nms/nmsadmin/logs/tmp/isql.zdnmsadm.26005
Error converting sql file [product_schema_web_swsheets.sql] - Check sql file format.
A sql statement or a block of plsql statements failed at input file line 203
 error = ORA-01720: grant option does not exist for 'SYS.DUAL'

The failed statement or block of statements are:

CREATE OR REPLACE VIEW att_address
  (h_cls, h_idx, att_name, att_value)
AS ( SELECT 0, 0, 'None', 'None - Need Project Version of View.'
  FROM dual
);
10/06 16:59:04: 0x7f7eb3739720,ctp=0x14b0bf8,"" cessql failed!
ISQL Error encountered in file product_schema_web_swsheets.sql.

ERROR
A sql statement or a block of plsql statements failed at input file line 203
 error = ORA-01720: grant option does not exist for 'SYS.DUAL'

STEPS

The issue can be reproduced at will with the following steps:
ces_setup.ces

Due to this issue, users cannot install the software

Changes

 The Oracle RDBMS database was recently upgraded to 11.2.0.4.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