Free book “SaaS For Dummies”

It is not the typical book “for Dummies”, it is about giving some notions, in some cases quite basic, about the use of the cloud as a basis for everything, from infrastructure to software. It does not contribute anything from the technical point of view and part of the libreo is commercial, but it is a book that is read relatively fast.

SaaS for Dummies

HTH – Antonio NAVARRO

Advertisements

Necessary Permissions To Execute SQL Advisor

Today a person from Dev Team ask me about the necessary permissions to execute the Oracle SQL Advisor. This Advisor has get better with the years and it is a powerfull tool for test and optimize SQL in an easy way. It don’t requeried a special expertise and can save many hours from other people (seniors dev, DBAs, etc.). Below show the permissions you need;

grant advisor to <USER>
grant administer sql tuning set to <USER>

In many clients where I worked it is usual create a rol (ess rol_developer_team) with this permissions (and others like debug) and assign to developers users.

NOTE;

Privilege escalate and security checking is guarantee by its (DBMS_SQLTUNE) being the main privilege ADMINISTER SQL MANAGEMENT OBJECT.

HTH – Antonio NAVARRO

Microsoft Offering Free Private Repositories At Github

Since Microsoft bought Github a few months ago, many users had decided to leave the platform, moving their projects to Gitlab. Now everything changes since Microsoft allows free private projects (before they were only the public) but only limited to three collaborators per repository. The truth is that I’ve never been a big fan of Microsoft but I recognize that he’s doing things very well lately.

I have to admit that this platform has always caught my attention although I have not used it. From now on I’m going to upload some utilities and several scripts to my newly created repository, in my case public. First to have it on hand when I’m out of the office or visit a client and second if it can serve someone useful. I attached the url.

My public Github repository

HTH – Antonio NAVARRO

 

Status KILLED/ROLLBACK in SQL Server

Last day a backup get hang in a SQL Server (2012). I try kill it but all sessions hang in status “KILLED/ROLLBACK”.

First of all, I look for open transactions;

killed_sqlserver_2012_1_xxx

In my case, there weren’t. With the next query I retried the sessions afected by this status;

killed_sqlserver_2012_2_xxx

With inputbuffer and session number you can see the event waiting for, in my case the backup.

killed_sqlserver_2012_3_xxx

And seeing the rollback status, it has not any progress;

killed_sqlserver_2012_4_xxx

In my case the solution has been restart the database :(. After I read tha maybe set up single-user mode and after multi-user mode option would be a solution. I post the commands;

ALTER DATABASE <Database>SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE <Database> SET MULTI_USER;

 

HTH – Antonio NAVARRO

 

Legato Can Not Connect To The Database

Today I was setting up a database backup using Legato, one of the most powerful backup tools. When aparantemente is well configured as shown in the following image;

fail_setup_legato

This error appears;

fail_setup_legato_2

It’s strange because accessing directly using sqlplus is no problem and connects. after investigating for a while I realized that I was possibly making a connection with sysdba or equivalent, in my case, giving permission to sysbackup was enough;

GRANT SYSBACKUP TO USERBACKUP;

You can see these permissions in the view v$pwfile_users.

 

HTH – Antonio NAVARRO