Article Number
000036989
Applies To
| | RSA Product Set: RSA Identity Governance & Lifecycle 7.1 |
Issue
After performing 7.1 P03 upgrade on existing 7.1 environment, IGL fails to start and UI web page throws this error:
Initialization Status
Initialization operations completed with errors. Please resolve the problem(s) before the application server can accept requests.
ORA-43853: SECUREFILE lobs cannot be used in non-ASSM tablespace "DATA_50M"
ORA-06512: at line 6
Issue is that upgrade SQL script ACM-83939.sql failed to execute with below error log from AveksaServer logs
java.sql.SQLException: ORA-43853: SECUREFILE lobs cannot be used in non-ASSM tablespace "DATA_50M"
ORA-06512: at line 6
Cause
When the column did not exist in this database, and the patch is trying to create it as a securefile lob which requires the tablespace to be of type ASSM.
It is possible that ‘SEGMENT SPACE MANAGEMENT’ is not set to AUTO.
Run below as avuser to verify:
Select * from user_tablespaces;
If ‘SEGMENT SPACE MANAGEMENT’ is set to MANUAL for tablespace DATA_50M, that could be the reason why you noticed the error message and it should be set to AUTO.
Resolution
‘SEGMENT SPACE MANAGEMENT’ needs to be set to AUTO so ASSM is enabled and securefile lob can be set.
