-
Title
post stopped due to error with "Failed to get NLS parameters" message in event_log -
Description
After post was stopped for some time, user was not able to start post. Post stops right away with "Failed to get NLS parameters" message in event_log -
Cause
Shareplex Oracle user's role and privileges have been revoke.
Do the following steps to confirm the root cause
1. log in oracle sqlplus as sysdba
select value$ from sys.props$ where name='NLS_LANGUAGE';
select value$ from sys.props$ where name='NLS_TERRITORY';
2. log in oracle sqlplus as Shareplex Oracle user -- check connections.yaml for Shareplex Oracle user and run the same query
select value$ from sys.props$ where name='NLS_LANGUAGE';
select value$ from sys.props$ where name='NLS_TERRITORY';
Return result when the above queries run by Oracle Shareplex User are:
select value$ from sys.props$ where name='NLS_LANGUAGE'
*
ERROR at line 1:
ORA-00942: table or view does not exist
-
Resolution
Recommended solution
1. shutdown shareplex
2. run ora_setup
*** MAKE SURE to use the same Shareplex Oracle user
Resolution 2:
1. log in oracle as sysdba2. grant select on sys.prop$ to "Shareplex Oracle User"This will help post move pass "Failed to get NLS parameter", but it may stop again because Shareplex Oracle user still does not have all the roles and privileges.select sid, SERIAL#, inst_id from sys.gv_$session where 1 > 2; *ERROR at line 1:ORA-00942: table or view does not exist3. Again sysdba must grant select on sys.gv_$session to "Oracle Shareplex user"