Sunday, 2 December 2012

ORA-27476: "MAXIMO.MAXIMOTSSYNC" does not exist when Upgrading Maximo 7.1.1.10 to Maximo 7.5.0

ORA-27476: "MAXIMO.MAXIMOTSSYNC" does not exist


This problem Mainly i faced during Upgrading Maximo 7.1.1.10 to Maximo 7.5.0.

Step 1 : Change to use DBMS_SCHEDULER

CREATE OR REPLACE PROCEDURE maximo_ts_job_call AS 
BEGIN 
dbms_scheduler.create_job( 
job_name => 'MAXIMOTSSYNC', 
job_type => 'STORED_PROCEDURE', 
job_action => 'maximo_ts_job', 
start_date => SYSDATE, 
repeat_interval => 'SYSDATE + 5/1440', 
enabled => TRUE); 
END; 

exec maximo_ts_job_call(); 



select job, substr(what,1,80) from user_jobs; 

Re-run Integrity checker 


No comments:

Post a Comment