Oracle Database

Real Time Operational Business Intelligence with GoldenGate

Posted by on September 1, 2013 at 5:00 pm

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 […]

Sunopsis seven years after it’s acquisition

Posted by on January 15, 2013 at 10:00 pm

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 […]

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

Posted by on November 11, 2012 at 1:30 am

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 August 10, 2012 at 5:30 am

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 July 10, 2012 at 4:30 am

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 […]

Materialized View Maintenance – Part I: Guidelines

Posted by on January 15, 2011 at 6:00 pm

I have been working with a lot of materialized views in our PeopleSoft Campus Solutions Warehouse lately and let me tell you, they can be a pain some times. Before I go into technical details here are some best practices that we have developed in our environment for data that is loaded once nightly.

Issues with DB Connection when creating the Informatica Power Center Repository

Posted by on October 22, 2010 at 5:30 pm

“An Exception has occurred. The database connection detail for service INFA_REPO_SVC are invalid. Please check log for details”

Configure your database to host your Informatica Repository (Oracle 11g)

Posted by on September 16, 2010 at 6:00 pm

The Informatica repository is designed to reside in a database system, for my local test environment I will be hosting it in an Oracle 11g database. Here are two design principles that need to be taken into consideration when setting up the database that will host your repository: Creating a dedicated tablespace for your repository […]

Drop [oracle] database (and clean after yourself)

Posted by on June 30, 2010 at 6:00 pm

Clean database and control files after dropping database

PeopleSoft Enterprise Performance Management Warehouse Schema Naming Standards

Posted by on June 2, 2010 at 6:00 pm

The nicest thing about PeopleSoft after the whole PIA Metadata-driven interface and its impact on data quality is how meticulous PeopleSoft engineers are about documentation and sticking to naming standards, here’s a simplified diagram of the wharehouse architecture and the naming standard for objects in each section of the schema:

Abnormal termination of stage (cast those CLOBs!)

Posted by on May 25, 2010 at 6:00 pm

Abnormal termination of stage (cast those CLOBs!)