My book: Oracle Database 12c Backup and Recovery Survival Guide

It was a long journey of hard work and team work that now has finished, as a result you will find my book Oracle Database 12c Backup and Recovery Survival Guide that I wrote with the help of my good friend Aman Sharma. I would also take this opportunity to (more...)

Why use OVM for Oracle Databases

Some time ago I made a benchmark exercise to compare the performance of an Oracle Database running in a bare metal environment versus a virtualized environment to clear some of the main questions our team and clients in Revera have, such as:  Does an Oracle Database performs well on a (more...)

Playing with VirtualBox, Oracle 12c (12.1.0.1) and OEL 6.4 – Part 2

We will complete our lab by installing the Oracle Database software, create a Pluggable database and take a look in the Oracle Enterprise Manager Database Express.

The steps to install and create an Oracle Database 12c are:

1 – Go to the database directory created when unzipped the 2 Oracle (more...)

Playing with VirtualBox, Oracle 12c (12.1.0.1) and OEL 6.4 – Part 1

Now that 12c was released it’s time to install in on OEL 6.4 64 bits OS. Let’s start playing with this.

Before we start with the creation of the VM we will need to download some software first, such as:

A new era: Fusion Applications

Fusion Applications is out there, that is a fact. ERP customers are starting to look more and more at Fusion Applications as a serious replacement or a coexistence with there current ERP systems and we have to answer to that

Continue reading

Once again, How to Improve your Oracle Career

The main question about the DBA job I hear all the time is: How can I became a successful DBA?

Most of the people that I talk to who have difficulties starting out in their DBA career really have an issue trying to absorb the mountainous volumes of information that (more...)

Path To Understand Oracle Fusion Application

Path To Fusion


Extending the PeopleSoft 9.2 virtual machine with GUI and Guest Additions

In my previous post I described the steps for getting started with the PeopleSoft 9.2 virtual machine. Although I am still thrilled that Oracle has made this generally available, I am of the opinion that it would have even been

Continue reading

Installing PeopleSoft 9.2 pre-build virtual machine

The past years I have seen a lot of people on OTN forum struggling with PeopleSoft installations. Installing PeopleSoft on uncertified OS, mismatch between versions and releases, 32 vs 64 bit, etc, etc. Well those days are over. As of April

Continue reading

Switching from VMWare to VirtualBox

Ever since I discovered virtualization, I have been creating and using dedicated virtual machines for all my PeopleSoft sandboxes and Fusion MiddleWare components. This allowed me to run multiple releases of OS and PeopleSoft on my own laptop. Until recently I was

Continue reading

Hotsos 2013 A personal Touch 3/4 – Third Day

After having a good sleep I attended the first session in the morning from George Djerdj Srdanov with a presentation called “How to Get the Most Out of Your I/O Subsystem?”. George dived deep into the I/O subsystem, with the following important subjects:

  • Different RAID configurations (Read and Write (more...)

Hotsos 2013 A personal Touch 2/4 – Second Day

Due to a cold or “the bug” some at the symposium called it, I had a very bad night sleep. In the morning I was not able to follow the sessions and I ended up having a good breakfast and released the new white paper and latest presentation to Hotsos (more...)

Hotsos 2013 A personal Touch 1/4 – First Days

Using Gmail as SMTP server for PeopleSoft

A lot of us developers use local PeopleSoft sandboxes for (self)training and R&D. One of the biggest issues we usually encounter on local sandboxes is the lack of a SMTP server for testing workflow mail. Until today I used PostcastServer

Continue reading

Is Oracle Fusion Talent Management what Talent Management should be?

According to business dictionary, Talent Management is an organization’s attempts to recruit, keep, and train the most gifted and highest quality staff members that they can find, afford and hire. Talent management gives business managers an especially important role to

Continue reading

How to Find Software Versions and Patches in an Oracle Business Intelligence Applications Environment

This MOS Note will help consultants to find the exact Version and Patch level for installed components. This is very useful when you are logging an Oracle Service Request.  

 

OBIA: How to Find Software Versions and Patches in an Oracle Business Intelligence Applications Environment? [ID 1519745.1]


Upgrade to PeopleTools 8.53: What you need to know

It has been a couple of weeks now that PeopleTools 8.53 has been released. Soon customers will upgrade or are even already upgrading to the new PeopleTools release. To help customers and partner to streamline this process, an Advisor Webcast

Continue reading

Oracle BI Applications (OBIA) 7.9.6.4 released

Good News Oracle Business Intelligence Application new version 7.9.6.4 is available to download.

Highlights of the Oracle BI Applications 7.9.6.4 Release:

  • New Application – Oracle Manufacturing Analytics with pre-built adapters for EBS Process Manufacturing R12.x and EBS Discrete Manufacturing R12.x and 11.5.10
  • New Application – Oracle Enterprise Asset Management Analytics with pre-built adapters for EBS R12.x, EBS 11.5.10 and IBM Maximo 7.5
  • Universal Adapter to extend the capability to other source systems
  • Certified for OBIEE 11g
  • Certified for Exalytics
  • Certified for DAC 11g including support for Exalytics / Times Ten, (more...)

TASK_GROUP_Load_PartyDimension “Duplicate Keys Found”

While Running Full load on Oracle Business Intelligence Applications 7.9.6.3, when using Source system R12 TASK_GROUP_Load_PartyDimension failed with error Log says the issue is because “duplicate keys found”

Extract from the Log

**********************************************************************************************************************

CREATE INDEX:W_PARTY_D:W_PARTY_D_U1 has started.

ANOMALY INFO::: Error while executing : CREATE INDEX:W_PARTY_D:W_PARTY_D_U1
MESSAGE:::java.lang.Exception: Error while execution : CREATE UNIQUE INDEX
W_PARTY_D_U1
ON
W_PARTY_D
(
INTEGRATION_ID Asc
,DATASOURCE_NUM_ID Asc
,EFFECTIVE_FROM_DT Asc
)
NOLOGGING
with error DataWarehouse:CREATE UNIQUE INDEX
W_PARTY_D_U1
ON
W_PARTY_D
(
INTEGRATION_ID Asc
,DATASOURCE_NUM_ID Asc
,EFFECTIVE_FROM_DT Asc
)
NOLOGGING
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
EXCEPTION CLASS::: java.lang.Exception

**********************************************************************************************************************

For Resolution:- Download and (more...)

Oracle BI Apps – What are customers interested in?

A very informative Post by Rajesh Dhanapal from Infosys.

In the current era the customers are not interested to wait for months and years for BI project implementation. The customers are keen on quick wins rather than implementing the BI solution from scratch by following traditional BI approach. The Oracle BI Apps solution provides head start for the organisation to reach the to-be state quicker with reduced time and effort, and reduced risk.Read Details