Oracle Error Dropping Baseline - ORA-13527
Performing maintenance on a given database, a fellow team mate found the need to drop an old workload baseline. He tried it through Enterprise Manager, as well on SQL Developer, but it always failed with the message bellow:
ORA-13527: invalid baseline name
ORA-06512: on "SYS.DBMS_WORKLOAD_REPOSITORY", line 581
ORA-06512: on line 1
13527. 00000 - "invalid baseline name"
*Cause: The operation failed because the specified baseline name
does not exist in the Workload Repository.
*Action: check the baseline name and retry the operation.
At first we thought it to be caused by some special character on the baseline’s name, but then we found a document on Oracle Support entitled “ORA-13527 While Dropping Baseline (Doc ID 1450716.1)”.
The error occurs on Enterprise Manager for Oracle Database - Version 11.2.0.1 to 11.2.0.3, when when trying to drop baseline whose name is over 30 bytes.
As a temporary workaround, it is suggested to rename the baseline name to less than 30 bytes and then drop it.
Workaround URL: Oracle Support Document 1450716.1 (ORA-13527 While Dropping Baseline)
No comments :
Post a Comment