Technical

Real Time Operational Business Intelligence with GoldenGate

Posted by on septiembre 1, 2013 at 5:00
Share

Oracle Corporation’ (ORCL) acquisition of Golden Gate Software on July of 2009 was a big step for Oracle in its quest to build a open and heterogeneous product line that will be more appealing to enterprise customers with complex OLTP and data warehouse environments. You can find a detailed presentation of the considerations that were […]

Informatica being replaced by ODI in Oracle BI Apps 7.9.5.2

Posted by on agosto 1, 2013 at 6:00
Share

In a long anticipated move among both Fusion Intelligence and Oracle BI Apps customers, Oracle has released the first versions of its packaged business intelligence solution that replaces the third party tools of previous versions (IBM DataStage or Informatica Power Center) with Oracle Data Integrator as the back end ETL tool. You can find detailed […]

How To: Download, install, configure and verify you have the latest version of Opatch

Posted by on junio 9, 2013 at 2:30
Share

On this post we will discuss all the steps necessary to ensure you have the correct version of the OPatch patching utility for oracle software running on your system.

How to stop / start individual OBIEE 11g System Components from the OPMN

Posted by on mayo 23, 2013 at 2:30
Share

Sometimes I have a configuration change to make or need to restart a specific system component in one of my servers, here is a list of stop / start commands for each of the system components…

Issue with invalid or corrupted repository joins

Posted by on abril 12, 2013 at 3:20
Share

Symptom: The following error message is displayed: [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 46043] Internal error: No matching table for expr D_OPER_UNIT_XL.OPER_UNIT_SID, File .\Src\SQOSPSimplifyJoin.cpp, line 118. Cause: This symptom is associated with corrupted physical layer join relationships. The best way to test for a root cause is to isolate the […]

Configuring OBIEE to run as a Windows Service

Posted by on febrero 24, 2013 at 3:30
Share

One key step to configuring an enterprise deployment of Oracle Business Intelligence is to be setup your services to run in the background as Windows services and start automatically with your server. By default the installer will create windows services for Oracle Process Manager (OPMN) and the Weblogic Node Manager, this leaves us with the need to configure services for the Weblogic AdminServer and the BI Managed Server.

Sunopsis seven years after it’s acquisition

Posted by on enero 15, 2013 at 10:00
Share

On October of 2006 Oracle acquired Sunopsisa sofware company whose flagship product was one of the up-and-coming players in the datata warehousing arena. Sunopsis for easy integration in environments with multiple database systems and differentiated itself by adopting an Extract-Load-Transform architecture that decreased the learning curve for database developers that were immediately able to create […]

How To: Manage your Oracle patch deployment life cycle using Oracle Support Patch Plans

Posted by on diciembre 8, 2012 at 4:30
Share

As part of my writing I often try to document and share best practices I develop on my day to day work, this one relates to formalizing the patch deployment process for your oracle environments …

Configuring the windows host file to correctly use the loopback adapter for Oracle product installations

Posted by on noviembre 11, 2012 at 1:30
Share

This procedure is required when installing Oracle products such at the Oracle Database or Oracle Business Intelligence Enterprise Edition on a host machine that uses DHCP.  Follow the steps to configure a loopback adapterand then: Open the host file under c:\windows\system32\drivers\etc using notepad Identify your computer’s host name by right clicking on My Computer, selecting […]

Verifying the pre-requisites for an Oracle Database Install on SUSE Linux

Posted by on agosto 10, 2012 at 5:30
Share

This is a list of the parameters and configuration settings you should first check when installing the oracle database into a personal/sandbox environments, I made a note of them to allow me to verify them quickly without going through all the documentation for every install. This assumes you will not use ASM on your new […]

Oracle Database 11g R2 Minimum Requirements (windows)

Posted by on julio 10, 2012 at 4:30
Share

Database Version: gRelease 2 (11.2)for Microsoft Windows (32-Bit) Hardware Requirements Requirement Minimum Value Physical memory (RAM) GB minimum Virtual memory Double the amount of RAM Disk space Total: 5.35 GB SeeTable 2for details. Processor Type Intel (x86), AMD64, and Intel EM64T Video adapter 56 colors Screen Resolution 024 X 768 minimum Space Requirements Installation Type […]

Error message when incorrect version of Oracle Database Client has been installed

Posted by on junio 14, 2012 at 3:30
Share

Symptom: The following error message is displayed when trying to issue any queries to an Oracle database: [nQSError: 10058] A general error has occurred. libclntsh.so.10.1: wrong ELF class: ELFCLASS64 [nQSError: 46029] Failed to load the DLL /usr/oracle/OracleBI/server/Bin/libnqsdbgatewayoci10g.so. Check if ‘Oracle OCI 10G’ database client is installed. Causes: This error message is typical of a situation […]

Error: [nQSError: 23026] The logical column referenced by DESCRIPTOR_IDOF does not specify a Descriptor ID column.

Posted by on mayo 10, 2012 at 3:30
Share

Description This error message is associated with the “Descriptor ID” feature introduced with OBIEE 11g. This feature is aimed at transparently replacing descriptor fields (ie. Department Name) with their equivalent ID fields (ie. Department ID) on the WHERE clause of SQL statements issued by the BI server. This is achieved by selecting a “Descriptor ID” […]

Issue with [nQSError: 10040] The requested data source name is either not found, incomplete, or incorrect. (IM002)

Posted by on marzo 29, 2012 at 3:30
Share

Problem: The OBIEE 11g presentation service fails to start. Symptoms: Error Code: “IM002. Code: 10040. [NQODBC] [SQL_STATE: IM002] [nQSError: 10040]The requested data source name is either not found, incomplete, or incorrect. (IM002)”   Cause: The DSN tag value on the instanceconfig.xml file is incorrect or a valid data source is missing.   Solution: Verify that […]

Oracle Support asking for flash version

Posted by on febrero 29, 2012 at 6:01
Share

Disculpa, pero esta entrada está disponible sólo en English.

Oracle Business Intelligence 11.1.1.6.0 is Generally Available!

Posted by on febrero 23, 2012 at 5:29
Share

(English) Features include prompt autocomplete, optional apply button, favorites, full text search, and enhancements to: Mapview, Selections, Views, Scorecard and Strategy Managemnet….

Workaround: OBIEE compatibility issue with Firefox 10

Posted by on febrero 6, 2012 at 2:00
Share

(English) This work around is related to my previous post on OBIEE error: “Your browser is not supported by Oracle BI Presentation Services”

Warning: OBIEE error: “Your browser is not supported by Oracle BI Presentation Services” being triggered by automatic update to Firefox 10

Posted by on febrero 2, 2012 at 11:41
Share

(English) OBIEE is not compatible with Firefox 10 which is being rolled out to user desktop computers through automatic updates…

List of Bug Fixes Included In OBIEE 11.1.1.5.0

Posted by on enero 5, 2012 at 9:36
Share

The following is the list of Bugs fixed in OBIEE 11.1.1.5 Release grouped by component : Admin Tool * 7538753 SAP BW IMPORT DOES NOT RETRIEVE UNIQUE NAME FOR MEASURE COLUMNS * 10012297 ADMIN TOOL CRASH ON VERY LARGE EXPRESSIONS – OVERFLOW AT APPROX 3200 CHARACTERS * 10032385 TABLE MISSING IN SQL "FROM" CLAUSE – […]