Author Archive

Real Time Operational Business Intelligence with GoldenGate

September 1, 2013
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 […]

Tags: , , , , , , , , , , , , , , ,
Posted in Data Warehousing, ETL, Featured, Infrastructure, Integration, Oracle Database | No Comments »

Upgrading the Oracle Web Tier to version 11.1.1.5.0 by applying Patchset 1

July 26, 2013
Share

This post will very briefly describe the steps required to upgrade Oracle Web Tier 11.1.1.2.0 to version 11.1.1.5.0. This is the recommended procedure to deploy Oracle Web Tier 11.1.1.5.0 per the Fusion Middleware Documentation.

Tags: , , , , , , , , ,
Posted in Fusion Middleware, Uncategorized | No Comments »

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

June 9, 2013
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.

Tags: , , , , , , ,
Posted in Infrastructure | No Comments »

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

May 23, 2013
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…

Tags: , , , , , , , , , ,
Posted in OBIEE | No Comments »

Issue with invalid or corrupted repository joins

April 12, 2013
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 […]

Tags: , , , , , , , , , , , ,
Posted in OBIEE, Troubleshooting | No Comments »

How to: Install the Oracle Web Tier / Oracle HTTP Server

March 28, 2013
Share

This post will guide you through the steps to deploy Oracle Web Tier 11.1.1.2.0. This instance will later be upgraded to 11.1.1.5.0 by applying PatchSet 1 (12395155) and configured to serve as a front end for WebLogic as part of an Oracle Business Intelligence environment.

Tags: , , , , , , , , , , , ,
Posted in Fusion Middleware | No Comments »

Configuring OBIEE to run as a Windows Service

February 24, 2013
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.

Tags: , , , , ,
Posted in Infrastructure, Install and Configuration, OBIEE | No Comments »

Sunopsis seven years after it’s acquisition

January 15, 2013
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 […]

Tags: , , , , , , , , , , , , , ,
Posted in Data Warehousing, ETL, Featured, Integration, Oracle Database | 1 Comment »

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

December 8, 2012
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 …

Tags: , , , ,
Posted in Best Practices, Infrastructure | No Comments »

Customizing your DOS prompt

December 6, 2012
Share

Being back on a windows shop I find the DOS prompt sort of gets in my way, I have customized it so that it will display my current path and then let met type on a new line with this command: PROMPT Ignacio’s rocking at $P$G$_ The different formatting options for the command are: $A […]

Tags: , , , , ,
Posted in Misc, Tips | No Comments »

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

November 11, 2012
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 […]

Tags: , , , , ,
Posted in Infrastructure, Install and Configuration, OBIEE, Oracle Database, Tips | No Comments »

Error (BEA-141244) Schema validation errors while parsing %MW_HOME%\user_projects\domains\bifoundation_domain\config\config.xml – Invalid xsi:type qname: ‘ext:osso-identity-asserterType’ in element realm@http://xmlns.oracle.com/weblogic/domain

October 25, 2012
Share

Resolving WebLogic Issue (BEA-141244) Schema validation errors while parsing %MW_HOME%\user_projects\domains\bifoundation_domain\config\config.xml – Invalid xsi:type qname: ‘ext:osso-identity-asserterType’ in element realm@http://xmlns.oracle.com/weblogic/domain

Tags: , , , , ,
Posted in Uncategorized | No Comments »

Oracle Partner Exchange Keynote

October 5, 2012
Share

It is very interesting to seat in a room filled with a large cloud, very representative of the Oracle Partner Ecosystem in its diversity and passion for the portfolio. This unique partner ecosystem is definitively a key differentiator in Oracle’s go to market strategy.   Key Topics: * Fusion Applications * Engineered Systems * Big […]

Tags: , ,
Posted in Featured, General, Oracle | No Comments »

Key Announcements by Larry Ellison @ the Open World Keynote

September 30, 2012
Share

  OK, the key announcement from day one are out now and I am pretty sure there’s a bunch of unhappy people at SAP headquarters in Germany with the announcement of Exadata X3 which is 42 times larger the largest Hanna configuration.   Key Announcements:   *) Oracle Cloud to offer Infrastructure as a Service […]

Tags: , ,
Posted in Featured, Uncategorized | No Comments »

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

August 10, 2012
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 […]

Tags: , , , , ,
Posted in Oracle Database, Technical, Tips, UNIX/Linux | No Comments »

Oracle Database 11g R2 Minimum Requirements (windows)

July 10, 2012
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 […]

Posted in Infrastructure, Install and Configuration, Oracle Database, Reference | No Comments »

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

June 14, 2012
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 […]

Tags: , , , , , , , , , ,
Posted in OBIEE, Troubleshooting | No Comments »

Configuring a new loopback adapter in windows

May 13, 2012
Share

Start > Control Pannel> Add  Hardware Click next on the Welcome screen  When ask if you have connected your hardware, specify yes  In the next dialog select Add new hardware device  On the following screen select Network Adapters  Select Microsoft > Microsoft Loopback Adapter from the list  Select next in the following screen to install […]

Tags: , , , , , , , ,
Posted in Infrastructure, Install and Configuration, Tips | No Comments »

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

May 10, 2012
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” […]

Tags: , , , , , , , , ,
Posted in OBIEE, Troubleshooting | No Comments »

Issue: Cannot manage OHS configuration from Fusion Middleware Control / Enterprise Manager (Error:Failed to invoke operation load on MBean)

April 19, 2012
Share

The following error is displayed when you attempt to follow any of the administration links

Failed to invoke operation load on MBean oracle.as.management.mbeans.register:type=component,name=ohs1,instance=instance1,Location=AdminServer

Parsing error while loading MBeans
oracle.sysman.emSDK.app.exception.EMSystemException at oracle.sysman.emas.sdk.model.jmx.JMXUtil.invokeOperation(JMXUtil.java:100) at or

Tags: , , , , , , , ,
Posted in Troubleshooting | No Comments »