This discussion is archived
3 Replies Latest reply: May 28, 2013 11:25 AM by Hussein Sawwan-Oracle RSS

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

ChinmayDBA Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points