The following occurs:
1. Initial setup
2. Post was stopped for a while, and upon restarting Post, it fails with:
Unexpected Oracle error: ORA-00942: table or view does not exist in ../src/opst_mt/connection.cpp
************ NOTICE: Error message does not include table or view name, and this happens at connecting time ***********
Info 2019-09-07 19:09:05.584119 23691 2296916544 Poster launched, pid = 23691 (posting from PMXCTI1, queue mt0101, to SCELEXT)
The SharePlex Oracle user's role and privileges has been removed or not been granted correctly.
Do the following to confirm the root cause:
1. Log into the database as sysdba.
select sid, SERIAL#, inst_id from sys.gv_$session where 1 > 2;
2. Log into the database as the SharePlex Oracle user and run the same query:
select sid, SERIAL#, inst_id from sys.gv_$session where 1 > 2;
The returned result for the SharePlex Oracle user will typically be:
select sid, SERIAL#, inst_id from sys.gv_$session where 1 > 2;
*
ERROR at line 1:
ORA-00942: table or view does not exist
1. Execute ora_setup again.
Ensure you use the same SharePlex Oracle user.
2. Grant select on sys.gv_$session to the SharePlex Oracle user.
