Rally Backup/Restore ORA error

book

Article ID: 241811

calendar_today

Updated On:

Products

CA Agile Central On Premise (Rally)

Issue/Introduction

When executing the caac oracle_restore command to restore the Rally database on our failover site, we get the below 2 ORA errors.

07:32:31 Sun May 15 11:32:31 2022:  SQL>      revoke unlimited tablespace from RALLYAPP
07:32:31 Sun May 15 11:32:31 2022:  *
07:32:31 Sun May 15 11:32:31 2022:  ERROR at line 1:
07:32:31 Sun May 15 11:32:31 2022:  ORA-01952: system privileges not granted to 'RALLYAPP'

07:32:31 Sun May 15 11:32:31 2022:  SQL>      alter user RALLYAPP quota unlimited on RALLY_JMS_DATA
07:32:31 Sun May 15 11:32:31 2022:  *
07:32:31 Sun May 15 11:32:31 2022:  ERROR at line 1:
07:32:31 Sun May 15 11:32:31 2022:  ORA-00959: tablespace 'RALLY_JMS_DATA' does not exist

 

Resolution

These errors are a normal part of the restore process and can safely be disregarded