StatusCheck Table or View Does Not Exist

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.