EGRC 8.6.4.5000: New Install Fails with Error "CREATE SYNONYM QRTZ_BLOB_TRIGGERS FOR GRC_QRTZ_BLOB_TRIGGERS - java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges" (Doc ID 1620195.1)

Last updated on AUGUST 02, 2017

Applies to:

Oracle Application Access Controls Governor - Version 8.6.4 to 8.6.4 [Release 8]
Information in this document applies to any platform.

Symptoms

New Installation of  GRC 8.6.4.5000 ( Build 8.6.4.5259 ) Fails with the following error in the grc log.

ERROR:

2014-01-29 18:34:18,130 ERROR [Thread-32] DBConfigManager:1008 **************************************************
2014-01-29 18:34:18,130 ERROR [Thread-32] DBConfigManager:1009 Error while executing patch # 3028, sub-patch # 0
2014-01-29 18:34:18,131 ERROR [Thread-32] DBConfigManager:1011 **************************************************
2014-01-29 18:34:18,131 ERROR [Thread-32] DBConfigManager:1012 Error executing following patch script:
2014-01-29 18:34:18,131 ERROR [Thread-32] DBConfigManager:1013 \
CREATE SYNONYM QRTZ_BLOB_TRIGGERS FOR GRC_QRTZ_BLOB_TRIGGERS
2014-01-29 18:34:18,133 ERROR [Thread-32] DBConfigManager:1014 Error
java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges

2014-01-29 18:34:19,021 ERROR [Thread-32] DataMigrationManager:1015 Exception occured while executing stored procedure grc_seed_lookups_control
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00905: object GRC_USER.GRC_SEED_LOOKUPS_CONTROL is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


2014-01-29 18:34:19,844 INFO [Thread-32] DBConfigManager:2385 *************************************
2014-01-29 18:34:19,845 INFO [Thread-32] DBConfigManager:2386 Overall summary of schema updates:
2014-01-29 18:34:19,845 INFO [Thread-32] DBConfigManager:2387 *************************************
2014-01-29 18:34:19,845 INFO [Thread-32] DBConfigManager:2392 Status of Schema Creation: Success
2014-01-29 18:34:19,845 INFO [Thread-32] DBConfigManager:2398 Status of Patch Updates: Failed
2014-01-29 18:34:19,846 INFO [Thread-32] DBConfigManager:2404 Status of Data Migration Updates: Failed
2014-01-29 18:34:19,846 INFO [Thread-32] DBConfigManager:2425 *************************************
2014-01-29 18:34:19,846 INFO [Thread-32] DBConfigManager:2431 Overall Status of updates: FAILED
2014-01-29 18:34:19,847 INFO [Thread-32] DBConfigManager:2432 *************************************


2014-01-29 18:34:20,512 INFO [Thread-32] SQLErrorCodesFactory:128 SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
2014-01-29 18:34:20,519 ERROR [Thread-32] GrcInitializationService:455 Error occurred during initialization:
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [ SELECT DISTINCT * FROM (SELECT ds.ID, ds.BIND_KEY, ds.NAME, ds.DESCRIPTION, ds.HOST_NAME, ds.PORT, ds.USER_NAME, ds.CONNECT_STRING, ds.PASSWORD, ds.CONFIRM_PASSWORD, ds.DRIVER, ds.SCHEMA_NAME, ds.SID, ds.CREATED_BY, ds.CREATION_DATE, ds.LAST_UPDATED_BY, ds.LAST_UPDATE_DATE, ds.PREV_PASSWORD, ds.DATASOURCE_TYPE_ID, ds.DS_TYPE_VERSION_KEY, ds.LAST_ACG_SYNC_ID, ds.LAST_TCG_SYNC_ID, ds.LAST_ACG_SYNC_DATE, ds.LAST_TCG_SYNC_DATE, ds.LAST_ACG_STATUS, ds.LAST_TCG_STATUS, ds.TNS_ALIAS, ds.IS_DEFAULT, ds.DATABASE_TYPE_ID, ds.DATA_ADAPTER_KEY, dst.NAME as DATASOURCE_TYPE_NAME, dst.READ_ONLY as DATASOURCE_TYPE_READ_ONLY, dst.BIND_KEY as DATASOURCE_TYPE_BIND_KEY FROM GRC_SRC_DATASOURCE_SYNC_V ds, GRC_SRC_DS_TYPE_B dst WHERE ds.DATASOURCE_TYPE_ID = dst.ID) WHERE DATASOURCE_TYPE_ID = 4 ]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist


2014-01-29 18:34:20,521 INFO [Thread-32] GrcInitializationService:459 ********************************************************
2014-01-29 18:34:20,521 INFO [Thread-32] GrcInitializationService:460 * Application Initialization completed with Error. *
2014-01-29 18:34:20,521 INFO [Thread-32] GrcInitializationService:461 ********************************************************

Step to Reprodcue:

1. Download the patch corresponding to GRC 8.6.4.5000 ( Build 8.6.4.5259 ). For patch information , refer to <Note:1518219.1> Critical Patch Information for EGRC (EGRCC, EGRCM, EGRCI) 8.6.4.3000(8.6.4.3347) Onwards.

2. Create a new database schema as per the Installation guide included in the patch download.

3. Follow the install instructions as per the Installation document.

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