Running SQL " eq_query_adm.set_sys_admin_param" Returns Error "ORA-01402: view WITH CHECK OPTION where-clause violation" (Doc ID 2098625.1)

Last updated on FEBRUARY 02, 2024

Applies to:

Symptoms

On : SES 11.2.2.2.0 version, Admin Front End

Running the commands in document 1596251.1 to configure Peoplesoft and SES.

The command failed,

 alter system set events '30579 trace name context forever, level 1610612736';

with the error

ORA-01031: insufficient privileges

To fix this the command was run as a different user, sys as sysdba.

After this the next command fails,

SQL> exec eq_query_adm.set_sys_admin_param('INFOSOURCE_EXTRACT_MODE','DISABLED',1);
BEGIN eq_query_adm.set_sys_admin_param('INFOSOURCE_EXTRACT_MODE','DISABLED',1); END;

*
ERROR at line 1:
ORA-01402: view WITH CHECK OPTION where-clause violation
ORA-06512: at "SEARCHSYS.EQ_QUERY_ADM", line 136
ORA-06512: at line 1
 

ERROR
-----------------------
ERROR at line 1:
ORA-01402: view WITH CHECK OPTION where-clause violation
ORA-06512: at "SEARCHSYS.EQ_QUERY_ADM", line 136
ORA-06512: at line 1



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the SQL commands from document 1596251.1 to configure SES and Peoplesoft.
2. The alter system command fails with insufficient privileges.
3. Login using sys as sysdba and run the alter system command again.
4. Login as searchsys to complete the last command and it fails.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.