No lifts the Cluster service data base? Check if the SQL BROWSER is up :-D

I was suffering one day seeking the solution of this problem :-( ... until I found this link and understand the importance of service SQL BROWSER in the cluster instances.

I found it very interesting to share the tips, not long ago walked solving a customer problem with my current company, and we found the service instance SQL SERVER could not climb on the other node when doing a failover. The reason was because the node that was once passive, was not running the SQL BROWSER service. Once we find this note : http://dba.stackexchange.com/questions/54397/browser-service-in-sql-server-clustering , climbed the SQL BROWSER automatic service that was not on the passive node, and everything was solved.The note read:http://dba.stackexchange.com/questions/54397/browser-service-in-sql-server-clustering" 1. ) The Browser service is not cluster aware, so it would be just Generally running on each node . The browser is really used to handle incoming connections to a SQL instance. When you do not have a fixed port , are named using Situations and in other instances the browser handles the " finding" of the instance to client desires to connect to . So if you Have It running on the active node and it is being used to direct connections , I would make sure it is automatic and running on each node . "Another note :http://www.mssqltips.com/sqlservertip/1946/overview-of-the-sql-server-browser-service/

Very good alternative to Graphic tools in Oracle environments, MOATS

Need to examine a database in detail without a graphical tool involved? I found the solution :)

A few days ago researching alternatives were not monitoring oracle enterprise manager, I found a great tool called MOATS (The Mother of All Tuning Scripts) to design a genius out there on the web. This tool is run via console (sqlplus) and shows real-time database. There is also a sister tool called "Dashboard Sqlplus For RAC" for rac environments (http://blog.tanelpoder.com/2012/05/13/moats-like-sqlplus-top-utility-for-rac/). Here 'part explained by the author of this tool in your website: http://blog.tanelpoder.com/2011/03/29/moats-the-mother-of-all-tuning-scripts/

Regards, felipin

Here the author's explanation:

http://blog.tanelpoder.com/2011/03/29/moats-the-mother-of-all-tuning-scripts/

.....

 "

People talk about the Oracle SQL Developer 3 being out, which is cool, but I have something even cooler for you today ;-)
I finally figured out how to convert my screen-recordings to uploadable videos, so that the text wouldn’t get unreadable and blurry.
So, here’s the first video, about a tool called MOATS, which we have built together with fellow OakTable Network member and a PL/SQL wizard Adrian Billington (of oracle-developer.net).
Here’s the video, it’s under 3 minutes long. Play the video in full screen for best results (and if it’s too slow loading, change it to lower resolution from HD mode):

check it out and if you like MOATS, you can download it from Adrian’s website site (current version 1.05) and make sure you read the README.txt file in the zip!

• http://www.oracle-developer.net/utilities.php

Also thanks to Randolf Geist for finding and fixing some bugs in our alpha code… Note that MOATS is still kind of beta right now…
P.S. I will post my ORA-4031 and shared pool hacking video real soon now, too! :-)
P.P.S. Have you already figured out how it works?! ;-)
Update: Now you can suggest new features and improvement requests here:

• http://goo.gl/mod/0ANl

 "

Bye, Friends.

Pipe.