Initialization operations completed with errors after RSA Identity Governance & Lifecycle 7.1P03 upgrade

3 years ago

Originally Published: 2018-12-06

Article Number

000040307

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.

Don't see what you're looking for?

Related Articles

Trending Articles