Running ces_setup.ces Fails With ORA-1720 Error
Last updated on SEPTEMBER 29, 2017
Applies to:Oracle Network Management for Utilities - DMS - Version 188.8.131.52 to 184.108.40.206 [Release 1.12]
Oracle Utilities Network Management System - Version 220.127.116.11 to 18.104.22.168 [Release 1.12]
Information in this document applies to any platform.
When attempting to install NMS 22.214.171.124, 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'
The issue can be reproduced at will with the following steps:
Due to this issue, users cannot install the software
The Oracle RDBMS database was recently upgraded to 126.96.36.199.0
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