RSS
 

Archive for the ‘Database’ Category

Oracle Database Tips #2: How to replace the occurrence of two or more spaces with a single space using REGEXP_REPLACE

17 Dec

The REGEXP_REPLACE is an Oracle PLSQL function that works almost in the same way of the REPLACE function but extends its functionalities by using regular expression pattern.

In the following example I show you how to replace in a given string each occurrence of two or more spaces with a single space.

SQL> SELECT REGEXP_REPLACE('Too        Many       Spaces','( ){2,}', ' ') REPLACED_STRING FROM DUAL;

REPLACED_STRING
----------------
Too Many Spaces
 

Oracle Database Tips #1: How to fix the Oracle Database 11.2.0.1.0 em.ear file not found error

13 Dec

During the Oracle Database 11.2.0.1.0 installation on Windows platform you can face the following error: “<DB_HOME>\oc4j\j2ee\oc4j_applications\applications\em.ear file not found error“.

The database installation package is made of two zip archives:
win32_11gR2_database_1of2
win32_11gR2_database_2of2

To fix the problem: once you have unzipped the archives, you need to copy the content of win32_11gR2_database_2of2 folder into win32_11gR2_database_1of2 before running the installer.

 
No Comments

Posted in Database

 

Natively compiled Java stored procedures using NCOMP

24 Oct

1 – Introduction

Few years ago I had the chance to make an integration between the Oracle Database and a rating engine (“WARP4“) developed by ERIS4 company.
The goal was to rate telephone traffic records stored in the database, by sending them to the rating engine.

WARP4 provided some API to allow external application to send records and rate them; this comunication was made via socket layer. In order to increase the performances I had to make several trials and one of my test cases was about the native compilation.

I personally think that Java stored procedure native compilation it’s not worthy, especially when your Java classes need to open frequently a socket connection.
Because the native compilation is a really rare activity, I thought that this post could be useful for those who want to test the ncomp benefits.

Read the rest of this entry »

 

Connect ESSBASE to OBIEE 10g’s repository

18 Oct

1 – Introduction

In this topic we will see how to connect essbase to the OBIEE 10g repository and use it as data source for our reports.

2 – Prerequisites

2.1 The following product versions need to be installed:
OBIEE 10.1.3.3.2 or higher.
Essbase 7.1.6 or higher.

Essbase libraries need to be installed in the same machine where OBIEE server is installed.
We will assume that an Essbase server instance is already running somewhere as well as the OBIEE 10g, so we just need to link the two products; in order to connect Essbase to OBIEE 10g we need to install the Essbase client.

2.2 To install Essbase Client, you need to download the following software from http://otn.oracle.com (aproximately 8 Gb):
Hyperion EPM System Foundation Services (System Installer, Foundation Services, Architect)
Oracle Essbase (Client, Server, Provider Services)

Read the rest of this entry »