TIBCO Spotfire Server fails to start with error ORA-12526: TNS:listener: all appropriate instances are in restricted mode
Article ID: KB0077321
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | All Versions |
Description
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
Issue/Introduction
The Spotfire Server may fail to start and the error ORA-12526: TNS:listener: all appropriate instances are in restricted mode may be seen in the Catalina log
Resolution
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:
Once the alter command is executed successfully, start the TIBCO Spotfire Server again.
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.
Feedback
Yes
No
Powered by
