Oracle Database Errors or Warnings from Error ORA-27377 to ORA-27416


ORA-27377: windows cannot have event based schedules
Cause: Event based schedules for windows are currently not supported.
Action: Use a time-based schedule instead.
ORA-27378: cannot stop jobs of type EXECUTABLE on this platform
Cause: An attempt was made to stop a job of type EXECUTABLE on a platform where the stop operation was not supported.
Action: If the attempt to stop the job was made with the FORCE option set to FALSE, try again but change the FORCE option to TRUE.
ORA-27379: INSTANCE_ID attribute conflicts with job class settings
Cause: The value of the INSTANCE_ID attribute of the job conflicted with the value of the SERVICE attribute of its job class.
Action: Change the value of the INSTANCE_ID attribute or place the job in a job class whose settings do not conflict with the INSTANCE_ID attribute. Then re-enable the job.

ORA-27399: job type EXECUTABLE requires the CREATE EXTERNAL JOB privilege
Cause: The owner of a job of type EXECUTABLE does not have the CREATE EXTERNAL JOB system privilege.
Action: Grant the CREATE EXTERNAL JOB system privilege to the job owner or create another job in a schema which does have the CREATE EXTERNAL JOB system privilege.
ORA-27411: empty string is not a valid repeat interval.
Cause: An empty string ” was provided as a repeat interval for a window or a schedule.
Action: Specify a valid repeat interval, e.g., ‘FREQ=DAILY;BYHOUR=8;BYMINUTE=0;BYSECOND=0’ for a job that executes daily at 8am.
ORA-27412: repeat interval or calendar contains invalid identifier: string
Cause: The calendar string or calendar definition for the repeat interval of a job, schedule or window contained an unsupported keyword or reference to an undefined calendar.
Action: Correct the repeat interval such that it no longer contains the invalid keyword.

ORA-27413: repeat interval is too long
Cause: The repeat interval consisted of a calendar string larger than the maximum size allowed.
Action: Use a shorter calendar string for the repeat interval.
ORA-27414: Invalid BY value type
Cause: The type of BY value was not allowed for the frequency specified
Action: Ommit BY values of this type or alter the frequency
ORA-27415: repeat interval or calendar must start with the FREQ= clause
Cause: The specified calendar string for the repeat interval did not start with the frequency clause.
Action: Create a repeat interval that starts with a frequency clause, e.g. ‘FREQ=YEARLY;BYMONTH=FEB’
ORA-27416: BYDAY= clause in repeat interval or calendar contains an invalid weekday
Cause: The BYDAY clause of the repeat interval contained a value that doesn’t properly represent a weekday.
Action: Use the correct three letter abbreviations for weekdays, e.g. MON for Monday and FRI for Friday.

Above are list of Oracle Database Errors or Warnings from Error ORA-27377 to ORA-27416 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *