Flashes (Alerts)
Abstract
Schema installation will encounter ORA-27486 if the schema owner does not have CREATE JOB privilege.
Content
Maximo 6.0.3 and later on Oracle 10g or higher uses DBMS_SCHEDULE instead of DBMS_JOB for the text index synchronization job. DBMS_SCHEDULE requires CREATE JOB privilege.
Problem
Schema install or upgrade fails with the following error in the log:
java.sql.SQLException: ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 99
ORA-06512: at "SYS.DBMS_SCHEDULER", line 262
ORA-06512: at "MAXIMO.MAXIMO_TS_JOB_CALL", line 1
ORA-06512: at line 1
When the Maximo schema is on Oracle 10g or higher, it must be granted CREATE JOB privilege.
Solution
If you are running Maximo on Oracle 10g or higher, please do the following:
1. Using SQLPLUS, connect to the database as SYSTEM.
2. Type the following (change MAXIMO to your schema name if not MAXIMO):
GRANT CREATE JOB TO MAXIMO;
3. Rerun the utility which failed.
Important:
This privilege is not needed if you are running Oracle 9i. However, if your databases migrated to Oracle 10g, you will then need to add this privilege. You can still add the GRANT command to the CREATEMaximoES.SQL script. It will get a harmless error if run on Oracle 9i, but will then be ready for future use with Oracle 10g or 11g.
Historical Number
M04804
Product Synonym
MAXIMO
Was this topic helpful?
Document Information
Modified date:
25 September 2022
UID
swg21263002