Archive for the ‘Oracle’ Category

Oracle OpenWorld 2011

October 2-6, Moscone Center, San Francisco. “Oracle OpenWorld is the most cost-effective and efficient way to stay ahead of the technology curve.” Why not believe it? When tens of thousands of people attend,  you have thousands of sessions to choose from, you can enjoy membership in a global community of Oracle technologists, customers and partners [...]

Tags:   

Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Installation

You can start your  OBIEE 11g installation after completing the prerequisites list. In the unzipped install files go to Disk 1 and run the setup.exe file (for Windows). This launches the Oracle Universal Installer. There are 12 steps in the installation process. And we’ll go through the most important ones

Tags:  

Oracle BI Publisher step by step report

Oracle BI Publisher (formerly XML Publisher)  is an enterprise-level reporting tool that separates the data from the presentation. This means that the IT department can define the data sources, and power users can specify the report layout using tools like Microsoft Word. The same data source can be used by multiple report templates. Here are [...]

Tags:    

Porting applications from Oracle to PostgreSQL

If you are planning to migrate a database application from Oracle to PostgreSQL, this article can help you to understand and solve some of the issues occurring in such a process. PostgreSQL has recently become feature-complete in many areas and therefore porting projects from Oracle might be a feasible option in much more cases. Oracle [...]

Tags:  

JBOSS ORA-02049: timeout: distributed transaction waiting for lock

Context: – JBoss 5.1.0GA – Oracle9i Problem: During a long processing transaction, the ORA-02049 exception was thrown. Solution: According with metalink note 789517.1

Tags:   

Linguistic sorting with Oracle

Sorting characters is done differently from one language to another. For example, in English digits come before letters in an ascending sorting. But, in German, digits are ascendant sorted after letters. Sorting may or may not be case sensitive, diacritics may be considered or ignored, and phonetic rules could also be used (e.g.: in Spanish [...]

Tags:    

Oracle SQL Tip – How to rank a data set and work with its top-ranked or bottom-ranked rows

In this article we will take a brief look at the Oracle SQL FIRST/LAST aggregate functions that allow you to select a value from the first or last row(s) of a sorted group, when the needed value is not the sort key. For example consider a table “PROJECT_COST” having the following structure and data:

Tags:  

Oracle issue on virtual machine

One of my latest tasks was to install an application to a virtual machine, (running on a Vmware server). This application, built on client-server architecture, use an Oracle database so i had to install Oracle 10g and import the specific database for the application. Installing Oracle and make it work seemed to be an easy [...]