3 Replies Latest reply: May 28, 2013 1:25 PM by Hussein Sawwan-Oracle RSS

    ORA-39083: Object type PROCOBJ failed to create with error: ORA-27475: "1."

    ChinmayDBA
      Hi All,
      Source: Solaris( db: 11.2.0.3 and apps: 12.1.3)
      While converting to rac and maigration from Solaris to Linux we are getting following errors:
      I did not found any note in oracle support site for errors ORA-39083 and ORA-27475 combination.
      =====

      ORA-39083: Object type PROCOBJ failed to create with error:
      ORA-27475: "1." must be a SERVICE
      Failing sql is:
      BEGIN
      dbms_scheduler.create_job_class('"IDX_RB$CLASS_23283"',NULL,'1',64,NULL,
      'Transient MV Refresh class'
      );COMMIT; END;
      ORA-39083: Object type PROCOBJ failed to create with error:
      ORA-27475: "1." must be a SERVICE
      Failing sql is:
      BEGIN
      dbms_scheduler.create_job_class('"IDX_RB$CLASS_28617"',NULL,'1',64,NULL,
      'Transient MV Refresh class'
      );COMMIT; END;
      ORA-39083: Object type PROCOBJ failed to create with error:
      ORA-27475: "1." must be a SERVICE
      Failing sql is:
      BEGIN
      dbms_scheduler.create_job_class('"IDX_RB$CLASS_29338"',NULL,'1',64,NULL,
      'Transient MV Refresh class'
      );COMMIT; END;

      ============

      Please help me to resolve this issue.


      Thanks,
      Chinmay

      Edited by: ChinmayDBA on May 28, 2013 8:35 AM