septiembre 1, 2013
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: BAM, BPM, CDC, database, disaster recovery, Fusion Middleware, GoldenGate, heterogeneous database, KPI, linkedin, Log Mining, Operational Intelligence, ORCL, Product Review, Real Time, Replication
Posted in Data Warehousing, ETL, Featured, Infrastructure, Integration, Oracle Database |
julio 26, 2013
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: 11.1.1.2.0, 11.1.1.5, Fusion Middleware, install, OBIEE, Oracle HTTP Server, Oracle Web Cache, Oracle Web Tier, Patch Set 1, upgrade
Posted in Fusion Middleware, Uncategorized |
junio 9, 2013
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: Fusion Middleware, install, installation, linkedin, OBIEE 11g, OPatch, patching, WebLogic
Posted in Infrastructure |
mayo 23, 2013
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: BI Server, BI Service, Cluster Controller, Javahost, linkedin, obiee_11g, opmn, opmnctl, presentation server, Scheduler, system components
Posted in OBIEE |
abril 12, 2013
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: Error, Issue, joins, linkedin, logical layer, nQSError, nQSError 10058, OBIEE, physical layer, Repository, RPD, solution, troubleshooting
Posted in OBIEE, Troubleshooting |
marzo 28, 2013
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: configuration, Fusion Middleware, install_ohs, install_weblogic, instance, linkedin, mod_osso, OBIEE, OHS, oracle home, Oracle Web Cache, Web Server, Web Tier
Posted in Fusion Middleware |
febrero 24, 2013
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: configuration, linkedin, OBIEE, OBIEE 11g, Startup, Windows Service
Posted in Infrastructure, Install and Configuration, OBIEE |
enero 15, 2013
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: Architecture, CDC, database, ELT, ETL, Fusion Middleware, linkedin, Log Mining, MDM, ODI, Oracle Data Integrator, ORCL, Product Review, SOA, Sunopsis
Posted in Data Warehousing, ETL, Featured, Integration, Oracle Database |
diciembre 8, 2012
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: linkedin, OBIEE 11g, Oracle Support, Patch Plan, patching
Posted in Best Practices, Infrastructure |
diciembre 6, 2012
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: DOS, Environment Variables, linkedin, prompt, Tips, windows
Posted in Misc, Tips |
noviembre 11, 2012
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: hosts file, install, installation, loopback, Oracle, windows
Posted in Infrastructure, Install and Configuration, OBIEE, Oracle Database, Tips |
octubre 25, 2012
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: Error, Issue, troubleshooting, WebLogic, WIP, WIP_Done
Posted in Uncategorized |
octubre 5, 2012
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: #OOW, #OpenWorld, #OPN
Posted in Featured, General, Oracle |
septiembre 30, 2012
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: #OOW, #OpenWorld, #OPN
Posted in Featured, Uncategorized |
agosto 10, 2012
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: database, installation, linkedin, Linux, Oracle, SuSE
Posted in Oracle Database, Technical, Tips, UNIX/Linux |
julio 10, 2012
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 |
junio 14, 2012
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: 32 bit, 64-bit, client, Error, Issue, linkedin, nQSError, nQSError 46029, OBIEE, solution, troubleshooting
Posted in OBIEE, Troubleshooting |
Tags: Adapter, DHCP, install, installation, linkedin, loopback, Oracle, Static IP, windows
Posted in Infrastructure, Install and Configuration, Tips |
mayo 10, 2012
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: DESCRIPTOR_IDOF, Error, Issue, linkedin, nQSError, nQSError 23026, OBIEE, OBIEE 11g, solution, troubleshooting
Posted in OBIEE, Troubleshooting |
abril 19, 2012
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: enterprise manager, Error, fusion middleware control, Issue, linkedin, OHS, opmn, solution, Web Tier
Posted in Troubleshooting |