Blog - comments

Hi Franck Pachot, my DBA-Village friend :-)When I try to login to grid I am getting the error su: ca...
Newbie
Its great Article. can you please share a a tsql proc on encryption key management for good backup ...
mpr
Hi Matthieu,No I never used QlikSense so far but I'm pretty sure I will in a near future as it's a q...
Note that the parameter helps to workaround the non-system datafile issue. But the instance still cr...
Hi Raphaël, Thank a lot yes the issue doesn't reproduce when "_datafile_write_errors_crash_instance...
Blog

dbi services Blog

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
Recent blog posts

Do you have ever seen the following message while you’re trying to validate your cluster configuration with your availability groups or FCI’s and Windows Server 2012 R2?

Hits: 82
Rate this blog entry:
0
Continue reading 0 Comments

I've written about 12c online statistics gathering in a UKOUG OracleScene article. My opinion is clear about it: you sill need to gather stale stats afterwards or you have mising, stale and inconsistent object statistics. This post is about cases where online statistics gathering does not occur (and are not documented) - which is another reason why we can't rely on it.

Tagged in: Oracle 12c
Hits: 167
Rate this blog entry:
0
Continue reading 0 Comments

I'm using Oracle SQL Developer 4.1 Early Adopter for a while and I like it. That version comes with a command line (in beta) which goal is to be fully compatible with sqlplus but running in java, and having a lot more features. 

Becuse it's connecting with thin java driver by default, it doesn't use NLS_LANG. It's java. It's unicode. So here is how to set the language and characterset with the java options.

Tagged in: Java Oracle
Hits: 57
Rate this blog entry:
0
Continue reading 0 Comments

QlikView Tips & Tricks

Posted by on in Middleware

Qlik.png
For several months now, I've been working on some QlikView projects which is a quite interesting discovery for me. Generally, these projects are limited to the management of QlikView at the administrator level (installation, upgrade, configuration of the QlikView Management Console, aso...) but I was still able to accumulate some knowledge that I want to share with you today. In this blog entry, I will try to explain how to debug the QlikView Offline Service, how to properly configure the access to remote Shared Folders and how to enable the Single Sign-On between QlikView and a third party software. I will try to describe the required steps as best I can to avoid any problems.

Hits: 176
Rate this blog entry:
1
Continue reading 2 Comments

We saw in my last blog how to install the SQL Server plugin for Nagios.
In this new blog, I will explain:

Hits: 136
Rate this blog entry:
1
Continue reading 0 Comments

I don’t work often with SQL Server replication. The main reason is that the number of customers that use replication is pretty low and each time that I have to deal with it, it’s a good opportunity to improve my skills on this area. A couple of months ago I had to face an interesting issue with the snapshot replication (yes, I was lucky ... this is not the more complex replication mechanism you have to deal with). My customer had a lot of databases (approximatively 250) to replicate from two datacenters apart from one continent.

Hits: 301
Rate this blog entry:
0
Continue reading 0 Comments

There has been the announce that non-CDB is deprecated, and the reaction that CDB is not yet stable.

Hits: 374
Rate this blog entry:
1
Continue reading 4 Comments

In the previous post we have seen how the OracleText index tables are maintained when new document arrives: At sync the new documents are read up to the available memory and words are inserted in the $I table with their mapping information. Now we will see how removed documents are processed. We will not cover updates as their are just delete + insert.

Tagged in: Oracle
Hits: 109
Rate this blog entry:
0
Continue reading 0 Comments

I plan to write several posts about OracleText indexes, which is a feature that is not used enough in my opinion. It's available in all editions and can index small text or large documents to search by words. When you create an OracleText index, a few tables are created to store the words and the association between those words and the table row that contains the document. I'll start to show how document inserts are processed.

Tagged in: Oracle
Hits: 282
Rate this blog entry:
0
Continue reading 0 Comments

Nagios is an IT Infrastructure monitoring solution which is able to monitor SQL Server instances with a specific plugin.
I have installed this plugin to test those functionalities and I will explain here how to do it.

Hits: 226
Rate this blog entry:
1
Continue reading 0 Comments
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)

Contact

Contact us now!

Send us your request!

Our workshops

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

Expert insight from insiders!

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter