Question

1
Replies
22
Views
SamratDas1991 Member since 2013 2 posts
Capgemini Pvt. Ltd
Posted: July 25, 2020
Last activity: July 26, 2020

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 ;

(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:?]

Pega Platform 8.4 System Administration Other Industry
Share this page LinkedIn