Issue:
The SQL exception message is logged.
Log message:
2014-03-05 11:40:08|StatusCheck |ERROR |Exception - ORA-00942: table or view does not exist
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
Solution:
Please login to SQLPlus with sysdba or appropriate privileged user (i.e SYSTEM) and grant select_catalog_role to the NexOSS user. For example,
sqlplus /nolog
conn /as sysdba
SQL> GRANT SELECT_CATALOG_ROLE TO user;
The user is the NexOSS username (ID)
If the privilege is granted successfully, you can see the role when you login the NexOSS user.
sql> select * from session_roles;
SELECT_CATALOG_ROLE
This will allow you to run the StatusCheck application without the error message.