Installing Oracle 12c Client

It's very important to have your SQL client to take full advantage of your local PeopleSoft installation. In this step-by-step tutorial, I will show you how to get your SQL Developer up and running in minutes.

Oracle Apps Technology 2015-05-13 16:11:00

Jim pinged me with this error today:

on ./ i get4:19 PM
Creating the DBC file...
java.sql.SQLRecoverableException: No more data to read from socket raised validating GUEST_USER_PWD
java.sql.SQLRecoverableException: No more data to read from socket4:19 PM
Updating Server Security Authentication
java.sql.SQLException: Invalid number format for port number
Database connection to jdbc:oracle:thin:@host_name:port_number:database failed4:19 PM
to this point, this is what i've tried.4:19 PM
clean, autoconfid on db tier, (more...)

How to Install PeopleSoft on Your Laptop

If you want to have your own local PeopleSoft installation, look no further. This post shows you exactly what I did to install PeopleSoft 9.2 / PeopleTools 8.54 on my Windows 8.1 laptop using Oracle VM Virtualbox.

FreeNAS 9.3

Just installed FreeNAS 9.3 on VMWare ESXi 5.5.
Software and data must have separate disks. So first create the VM with a disk defined for the FreeNAS software, second add a disk as you wish for the data (both disks can be on different datastore).
I choose to put boths in one datastore separated from all other VMs hosted on my server (two different RAID array), and on separated network card.

Anyway, this (more...)

VMWare ESXi copy VM and datastore

Lately, one of my drive of my RAID5 array was gone to death. Time for an infrastructure change.

I was glad to buy 4 new drives of 2TB to add new datastore to my vMWare ESXi 5.5 server. My plan is to move all the VMs from the old datastore where the disk is broken (RAID5, previously 4*500GB) to the new datastore (defined as RAID5, 4*2TB).
Then redefined the old LUN as RAID5 on (more...)

Modal Popup Error Report Tutorial For EBS

Oracle Is Easy, a blog written by <a href="" SmartDog Services

Modal Popup Error Report Tutorial For E-Business Suite



We needed a popup report to show errors from a validation process and wanted to share the walkthrough so you can set this up yourself. Follow these steps and don’t miss an error notification again with this new east-to-read report.


1. Create a hidden item called “’P25_MASS_ITEM_REC_ID” to store the Item ID (more...)

Windows 10 Tech Preview

I had some spare time last week-end and still enough Gb free on my VMWare server, so I decided to have a look into that new Windows…




So far, all what I can say is that Microsoft was concerned about customers complaints regarding previous version 8. It’s kind of mix-up but looks much better. We can wonder why some applications are there (see XBox) that we cannot uninstall…


Probably a matter of time and maturity.


Top 6 production database mistakes that could be slowing down your system

Oracle Is Easy, a blog written by <a href="" SmartDog Services


After more of 14 years of experience working with Oracle Databases of different sizes, levels of activity and critical importance, I know a thing or two about production databases. No matter the size of the database or the complexity of the product that is working with the database, there are always some common settings that DBAs are missing and can adjust improve (more...)

Supporting a Day Against DRM with PacktPub

What is DRM?

DRM stands for “digital rights management,” a bit of technology that hardware and software manufacturers, publishers, and copyright holders use to control the way we use the devices and media that we own. The idea is to limit users’ ability to copy the content without permission, but DRM does much more: it shapes how people tinker with and share devices, software, music, movies, etc. they legally paid for. Have you (more...)

Planning, Implementing and Nurturing Your Failure Analysis Codes in Oracle EAM

Oracle Is Easy, a blog written by <a href="" SmartDog Services

It has been said that the goal of a good Maintenance Manager should be the elimination of his Maintenance Department. My opinion is that phrase should be amended to read “A good Maintenance Manager’s goal should be the elimination of Corrective Maintenance.” Since machines and software are not perfect one hundred percent across the board, a more realistic goal is to (more...)

R12.2 Single file system

With the release of AD and TXK Delta 6, Oracle has provided the feature of single file system on development instances for R12.2. Here's what they have mentioned in article: Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.6 and R12.TXK.C.Delta.6 (Doc ID 1983782.1)
Enhancements in AD and TXK Delta 6

4. New and Changed Features

Oracle E-Business Suite (more...)

Coming Into Los Angeles

Coming into Los Angeles
Bringing in a couple of keys
But don't touch my bags if you please
Mister Customs Man
         --From Arlo Guthrie's "Coming Into Los Angeles

As I write this, I’m on the road again…Los Angeles.  It’s my good fortune to be attending some collaboration sessions on designs for new Oracle Cloud Applications.  Can’t talk about the apps being developed…sorry.  But the attendees include Oracle Development, the Oracle (more...)

Oracle Open World proposal

Last day for submitting a proposal for Oracle Open World 2015!

I submitted a paper yesterday and hope to get the chance again to speak at the biggest Oracle conference.

Why should you submit?
Not only you'll be speaking about "your" topic and interest at the biggest Oracle event of the year, you'll also have the chance to attend very interesting sessions on all Oracle topics you can think of.

How to Use the Service Contract Template in a Service Level Agreement

Oracle Is Easy, a blog written by <a href="" SmartDog Services

Today I’m talking about the importance of setting up your Oracle Service Contract correctly. This will help you comply with Service Level Agreement (SLA) and provide discounts to customers according to the contract they have with your company.

Posted on April 28, 2015  by Jose Rodriguez

Main Issues a User May Experience with the Service Contract Templates

Using the Service Contract Templates properly (more...)

EBS R12.2 Delta 6 Feature Review : Enhancement of adop console messages

ADOP console messages was always something that administrators needed changes. Delta 6 new features talks that there has been more enhancements done and running SQLs are displayed. Yes & True , it does but comparing to Delta 5 there are not much improvements. If you are from a older Delta version 2 or 3 , then Delta 6 upgrade might be interesting.

Instead of displaying the complete update statements , I can see messages like (more...)

EBS R12.2 Delta 6 Feature Review : EBS Technology Consistency Checker (ETCC)

With EBS R12.2 Delta 6 will not display a warning message when using the ADOP utility. An additional check is made every time ADOP tool is invoked which checks for the  recommended patches that are missing in the instance. This feature is ETCC and you will see something like this on the ADOP logs.

    [PROCEDURE] [START 2015/04/27 14:27:57] Performing database sanity checks
    [WARNING]   ETCC: The following database fixes are not (more...)

EBS R12.2 Delta 6 Feature Review : Single File System Instance

With one of the main feature in 12.2 dual file system, there was always a need about having a single file system in 12.2 like 12.1.x and get away with the ADOP patching cycle. With Delta 6 AD and TXK you can. It is important to understand the feature and know its limitations.

There are two advantages of this single file system feature in 12.2

What’s at Stake if You Don’t Invest Time and Resources into Software Asset Management?

Oracle Is Easy, a blog written by <a href="" SmartDog Services

For organizations running Oracle E-Business Suite (EBS), clearly it is a critical enterprise asset. But, is there someone in your IT organization who is responsible for managing the licensing nuts and bolts associated with the ERP software? This task is called software asset management (SAM), and according to many experts, it is the neglected stepchild of IT management tasks. Many organizations do (more...)

Oracle and Docker

So, as many of you know, I've been working out different ways to host my Oracle labs and demos instances without chewing up phenomenal amounts of disk space and processing power.  Lately, I've been diving into Docker.

Docker has turned out to be pretty cool and very easy to learn.  And it's lightweight.  The idea is that you run containers - your app, your operating system, and your virtual machine - bundled together in a (more...)

How to Process Orders with Different Units of Measure (Specific to Oracle Users)

Oracle Is Easy, a blog written by <a href="" SmartDog Services

For many organizations, orders must be processed in units of measure (UOMs) specified by each customer. For Oracle users, this means that conversion is needed where the customer’s UOM differs from Order Management’s (OM).

Posted on April 21, 2015 by Vijay Garlapati

All OM sales orders are entered as an item using a primary or secondary UOM. Because Inventory and Shipping transactions (more...)