Ozzie.eu

Love to code, although it bugs me.

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.

topframeworks_1DE2F2E4

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

github_logoThis 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!


Rapidly test your website for cross browser compatibility

Earlier this year I posted about modern.IE, a tool meant to make it easier to test sites for Internet Explorer.
With the release of Internet Explorer 11 Developer Preview for Windows 7, Microsoft has also updated modern.IE. The three new enhancements are:

  1. Limited offer: 25% off Parallels Desktop 8 virtualization for Mac.
  2. New virtual machines for testing IE11 on Windows 8.1 and Windows 7.
  3. A new, free screenshot tool that lets you see how a site looks across browsers and devices.
About this last one, it comes from BrowserStack and it’s a really easy and useful tool to quickly assess the look of your site. Running it on this site gives the following output:
image
You can check out the live output here: http://www.browserstack.com/screenshots/5a6283df1308512082589290b4add4dcd6b9b35f
To run the tool on any site of your liking, visit BrowserStack.

All-in-One SharePoint 2003 Portal Server is an unsupported topology

Microsoft’s Sharepoint Portal Server 2003 is an out-dated technology and very few legacy sites should exist. However, since the problem of the unsupported topology is a dead end thread on all sites I’ve been searching online, here is my solution to the problem.
Microsoft article “Description of an alternative topology for SharePoint Portal Server 2003” doesn’t include the all-in-one scenario that doesn’t use the MSSQL engine coming with the portal setup.
To install a regular MSSQL instance on the same machine that you are installing Sharepoint 2003, you simply have to use an MSSQL server alias to call the server by a different name:
image
This tricks Sharepoint 2003 into thinking it’s talking to a remote database server. When you setup up the farm, use the alias instead of the server name to perform the gimmick.
Hope this still helps someone.

Free eBooks: Python, JavaScript and UI Design

6773415631_7cab96b8d9_m
Working on the application development scene, it’s hard to keep up with everything new. Every bit of help counts. Great resources are the eBooks you can find, for free, online on the Web. The books you can find in PDF format are great because you can take them with you anywhere. The ones that are available to view online are also great because you get any updates made on the subject. On this post I leave everyone a small set of links where you can find eBook compilations.
The first one comes from Speck boy Design Magazine and it’s mostly about User Interface design. For instance, the Mobile Web Design Best Practices by Mobify “is a handy mobile web design guide with over 50 tips that will help you build amazing mobile websites”. You can visit the Specky boy eBook compilation here: http://speckyboy.com/2013/06/10/free-ebooks-for-designers-and-developers/
The next eBook compilation is from Revolunet. It’s all about the Python programming language. You have the classic “Dive into Python” and a whole bunch of other interesting books. You can find them all at this Web page: http://pythonbooks.revolunet.com/
Finally, this list wouldn’t be complete without the emerging trend on multi-platform application development: javaScript. Here you have subjects for all tastes: Node.js, MongoDB, Windows 8, and so on. Get them all on this page: http://jsbooks.revolunet.com/
Happy readings!
Photo Credit: Mark J P via Compfight cc