Question
Wipro Pvt. Ltd.
IN
Last activity: 26 Jul 2020 9:32 EDT
Pega 8.4 jBoss With Oracle Installation Issue, ORA-01031: insufficient privileges
To deploy Pega 8.4 in jBoss EAP 7 with Oracle 12c1 database server, got error in log as ORA-01031: insufficient privileges.
I have done with all the privileges for PegaRules, PegaData and AdminPegaRULES schema, as per the installation guide. Please help me to find the below issue.
Grant the below for the schema in oracle:
GRANT "SELECT_CATALOG_ROLE" TO adminpegarules ; GRANT DROP ANY TRIGGER TO adminpegarules ; GRANT CREATE ANY PROCEDURE TO adminpegarules ; GRANT CREATE ANY INDEX TO adminpegarules ; GRANT GRANT ANY OBJECT PRIVILEGE TO adminpegarules ; GRANT ALTER ANY TABLE TO adminpegarules ; GRANT CREATE SESSION TO adminpegarules ; GRANT SELECT ANY TABLE TO adminpegarules ; GRANT DELETE ANY TABLE TO adminpegarules ; GRANT DROP ANY TABLE TO adminpegarules ; GRANT EXECUTE ANY PROCEDURE TO adminpegarules ; GRANT DROP ANY INDEX TO adminpegarules ; GRANT UPDATE ANY TABLE TO adminpegarules ; GRANT ALTER ANY TRIGGER TO adminpegarules ; GRANT CREATE ANY VIEW TO adminpegarules ; GRANT INSERT ANY TABLE TO adminpegarules WITH ADMIN OPTION; GRANT DROP ANY PROCEDURE TO adminpegarules ; GRANT UNLIMITED TABLESPACE TO adminpegarules ; GRANT CREATE ANY TRIGGER TO adminpegarules ; GRANT CREATE ANY TABLE TO adminpegarules ; GRANT CREATE ANY TYPE TO adminpegarules ;
To deploy Pega 8.4 in jBoss EAP 7 with Oracle 12c1 database server, got error in log as ORA-01031: insufficient privileges.
I have done with all the privileges for PegaRules, PegaData and AdminPegaRULES schema, as per the installation guide. Please help me to find the below issue.
Grant the below for the schema in oracle:
GRANT "SELECT_CATALOG_ROLE" TO adminpegarules ; GRANT DROP ANY TRIGGER TO adminpegarules ; GRANT CREATE ANY PROCEDURE TO adminpegarules ; GRANT CREATE ANY INDEX TO adminpegarules ; GRANT GRANT ANY OBJECT PRIVILEGE TO adminpegarules ; GRANT ALTER ANY TABLE TO adminpegarules ; GRANT CREATE SESSION TO adminpegarules ; GRANT SELECT ANY TABLE TO adminpegarules ; GRANT DELETE ANY TABLE TO adminpegarules ; GRANT DROP ANY TABLE TO adminpegarules ; GRANT EXECUTE ANY PROCEDURE TO adminpegarules ; GRANT DROP ANY INDEX TO adminpegarules ; GRANT UPDATE ANY TABLE TO adminpegarules ; GRANT ALTER ANY TRIGGER TO adminpegarules ; GRANT CREATE ANY VIEW TO adminpegarules ; GRANT INSERT ANY TABLE TO adminpegarules WITH ADMIN OPTION; GRANT DROP ANY PROCEDURE TO adminpegarules ; GRANT UNLIMITED TABLESPACE TO adminpegarules ; GRANT CREATE ANY TRIGGER TO adminpegarules ; GRANT CREATE ANY TABLE TO adminpegarules ; GRANT CREATE ANY TYPE TO adminpegarules ;
(nternal.store.DataStoreManager) ERROR - Error occurred performing a "read" operation in a transaction 2020-07-26 00:29:24,081 INFO [stdout] (Log4j2-TF-8-AsyncLoggerConfig-1) com.pega.pegarules.pub.database.DatabaseException: Database-General Problem executing lock delete 1031 42000 ORA-01031: insufficient privileges 2020-07-26 00:29:24,082 INFO [stdout] (Log4j2-TF-8-AsyncLoggerConfig-1) 2020-07-26 00:29:24,082 INFO [stdout] (Log4j2-TF-8-AsyncLoggerConfig-1) DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges 2020-07-26 00:29:24,082 INFO [stdout] (Log4j2-TF-8-AsyncLoggerConfig-1) 2020-07-26 00:29:24,082 INFO [stdout] (Log4j2-TF-8-AsyncLoggerConfig-1) | SQL Code: 1031 | SQL State: 42000 2020-07-26 00:29:24,082 INFO [stdout] (Log4j2-TF-8-AsyncLoggerConfig-1) 2020-07-26 00:29:24,082 INFO [stdout] (Log4j2-TF-8-AsyncLoggerConfig-1) at com.pega.pegarules.data.internal.access.ExceptionInformation.createAppropriateExceptionDueToDBFailure(ExceptionInformation.java:385) ~[prprivate-data.jar:?] 2020-07-26 00:29:24,082 INFO [stdout] (Log4j2-TF-8-AsyncLoggerConfig-1) at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:364) ~[prprivate-data.jar:?] 2020-07-26 00:29:24,082 INFO [stdout] (Log4j2-TF-8-AsyncLoggerConfig-1) at com.pega.pegarules.data.internal.access.DBLockProviderImpl.executePreparedStatementForReleaseLock(DBLockProviderImpl.java:1283) ~[prprivate-data.jar:?] 2020-07-26 00:29:24,082 INFO [stdout] (Log4j2-TF-8-AsyncLoggerConfig-1) at com.pega.pegarules.data.internal.access.DBLockProviderImpl.access$1800(DBLockProviderImpl.java:78) ~[prprivate-data.jar:?] 2020-07-26 00:29:24,082 INFO [stdout] (Log4j2-TF-8-AsyncLoggerConfig-1) at com.pega.pegarules.data.internal.access.DBLockProviderImpl$3.releaseSystemLocksInDb(DBLockProviderImpl.java:1236) ~[prprivate-data.jar:?] 2020-07-26 00:29:24,082 INFO [stdout] (Log4j2-TF-8-AsyncLoggerConfig-1) at com.pega.pegarules.data.internal.access.DBLockProviderImpl$3.action(DBLockProviderImpl.java:1225) ~[prprivate-data.jar:?] 2020-07-26 00:29:24,082 INFO [stdout] (Log4j2-TF-8-AsyncLoggerConfig-1) at com.pega.pegarules.data.internal.access.DBLockProviderImpl$3.action(DBLockProviderImpl.java:1222) ~[prprivate-data.jar:?] 2020-07-26 00:29:24,082 INFO [stdout] (Log4j2-TF-8-AsyncLoggerConfig-1) at com.pega.pegarules.data.internal.store.DataStoreManager.readInTransaction(DataStoreManager.java:74) ~[prprivate-data.jar:?] 2020-07-26 00:29:24,082 INFO [stdout] (Log4j2-TF-8-AsyncLoggerConfig-1) at com.pega.pegarules.data.internal.store.DataStoreManager.doInTransaction(DataStoreManager.java:317) ~[prprivate-data.jar:?]