Technological recipes that I've held to prepare some solutions DBA environment. (by Felipe Donoso Bastias)

20 Dec 2013

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/
Share:

28 Nov 2013

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!
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:
 "
Bye, Friends.
Pipe.
Share:

Copyright © DBA TIPS | Powered by Blogger
Design by SimpleWpThemes | Blogger Theme by NewBloggerThemes.com | Free Blogger Templates