Category Archives: Databases

XA datasources with #WebSphere and #Oracle

When using XA data sources with Websphere and Oracle we must grant to the Oracle user rights to perform XA recovery. STEP 1: Create an XA datasource

STEP 2: Grant right to the oracle user (MY_USER). As sysdba execute the following: Grant access to pending transactions.

Grant access rights to distributed transactions awaiting… Read More »

Advertisements

#Oracle 12c invisible columns

“Invisible columns”: This is a new feature introduced in Oracle 12c that got me all excited. In short you can now have hidden columns in a table that are not visible to the standard SELECT, INSERT clauses if you do not want to. Some usage for this: Legacy application queries I hate how you have… Read More »

Set up automatic #Oracle database back-up using #RMAN

There is a very easy method of setting up on Linux an automatic back-up for Oracle by using database procedures, RMAN and scripts. STEP 1: Define a back-up script Create in /home/oracle/backup.sh a script file with the content:

Where rman parameters are configured in the following /home/oracle/bin/backup.rman configuration file:

STEP 2: Create an… Read More »

Debug tools for enterprise environments

There are various tools that I use to spot issues and investigate an enterprise environment. One of my favourite tools is IBM Performance Analysis Suite. Capabilities described by IBM: Import all kinds of performance data for analysis. Some examples: DB2 snapshot, Java verbose GC output, Java thread dumps. Import software/middle-ware configuration for compliance checking. Some… Read More »

Blog Links: Oracle Trace File Analyzer (TFA)

One of the best introduction tutorial I have seen about a useful tool set. I am sick of all the empty marketing “pitches” I see daily. Oracle Trace File Analyzer (TFA) – An Overview Guide A must read for anyone that has to work with Oracle DB and needs to do a deep investigation of… Read More »

Blog Links: SQL Server on Linux

Big news, MS finally realized that with the cloud migration of a lot of services if you do not embrace Linux you are dead. After anouncing that it joined Linux Fundation as a platinum member we got SQL Server on Linux Install SQL Server on Linux

Oracle: Reactivate a database user

I am always very annoyed when my Oracle user is automatically expired and locked. This is done automatically at 180 days in some installations. The following are some very easy steps for a question that everybody is asking again and again on forums. STEP 1: Connect to the DB

STEP 2: Update the password… Read More »

Blog Links: SQL Server Tricks and Tips

The following are some interesting SQL Server related links: A lot of times you have to relocate the data and log files of a SQL Server. It can be that the default installation was not OK or you change the storage. The following tutorial is very useful Move System Databases Using SQL Server with R… Read More »