Ozzie.eu

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)

BrowserSwarm - A tool that automates JavaScript testing across browsers

BrowserSwarm is a partnership by Microsoft, Sauce Labs and the open source team of appendTo that helps developers automate how they test frameworks & libraries across browsers. It’s powered through the cloud, allowing developers to save time setting-up multiple browser or device testing environments and precious server resources.

BrowserSwarm connects directly to your GitHub code repo. When your team makes updates, BrowserSwarm automatically runs your project's Unit Test Suite and supports Frameworks, like QUnit, in the cloud using SauceLabs browser automation.

BrowserSwarm is meant to help the framework authors that build stuff for developers by reducing the time spent testing.
 
Check the original post by Microsoft here.
 
Site: BrowserSwarm

Free eBook - Rethinking Enterprise Storage: A Hybrid Cloud Model

Microsoft Press has released Rethinking Enterprise Storage: A Hybrid Cloud Model, by Marc Farley, as a free download. You can download the PDF version of this book here.

The book includes seven chapters:

1. Rethinking enterprise storage
2. Leapfrogging backup with cloud snapshots
3. Accelerating and broadening disaster recovery protection
4. Taming the capacity monster
5. Archiving data with the hybrid cloud
6. Putting all the pieces together
7. Imagining the possibilities with hybrid cloud storage

If you prefer the kindle edition of the book, you can find it here: Rethinking Enterprise Storage: A Hybrid Cloud Model

PSMSSQL–Github Repository for MSSQL scripts in Powershell

This post is to share with you a personal project with some work mates. PSMSSQL. This Github repository has scripts done in Powershell to interact with MSSQL databases.
It uses SQL Server Management Objects (SMO) to connect and interact with the remote database instances. You can read further on SMO at this URL: http://msdn.microsoft.com/en-us//library/ms162169.aspx
The first script submitted, "CompareMSSQLDB.ps1", takes the file "servers.txt" with a pair of server/database per line and compares the database identified on the first line against all other databases on the remaining lines.
Happy coding!