TIBCO Spotfire Server fails to start with error ORA-12526: TNS:listener: all appropriate instances are in restricted mode

Created
October 08, 2021 23:18

Date Posted: 2019-08-30
Product: TIBCO Spotfire®

Problem:

Solution:

The TIBCO Spotfire Server may fail to start, and the following error may be seen in the catalina.<date>.log:

java.sqI.SQLException: ORA-12526: TNS:listener: all appropriate instances are in restricted mode

You may see the ORA-12526 error if the database was started in a restricted session mode. The database is usually set to ALLOWED mode whereas the RESTRICTED session mode is used for maintenance purposes by database administrators (DBA).

To disable the RESTRICTED mode, the Oracle DBA will have to run the following command:

alter system disable restricted session;

Once the alter command is executed successfully, start the TIBCO Spotfire Server again.