Friday, January 22, 2016

ORA-00600 internal error code, arguments FILE jsks.c LINE 2388ID OCIKCallPush

SQL> exec DBMS_SCHEDULER.run_job ('ANALYZE_FULL');
BEGIN DBMS_SCHEDULER.run_job ('ANALYZE_FULL'); END;

*
ERROR at line 1:
ORA-00600: internal error code, arguments: [FILE:jsks.c LINE:2388ID:OCIKCallPush], [], [], [], [], [], [], [], [], [], [], []
ORA-28031: maximum of 148 enabled roles exceeded
ORA-28031: maximum of 148 enabled roles exceeded
ORA-28031: maximum of 148 enabled roles exceeded
ORA-06512: at "SYS.DBMS_ISCHED", line 185
ORA-06512: at "SYS.DBMS_SCHEDULER", line 486
ORA-06512: at line 1


spool c:\revokeldbo.sql

select 'REVOKE ' || GRANTED_ROLE  || ' from sys;'  from dba_role_privs where grantee='SYS' and granted_role not in ('CONNECT','DBA');
spool off

@c:\revokeldbo.sql



No comments:

Post a Comment

Followers