Chicago Oracle User Community Restart

Chicago is the third largest city in the United States. There are probably more professional Oracle users here than most other areas in the country – and yet for many years now there hasn’t been a cohesive user group.

But right now there’s an opportunity for change. If the professional community of Chicago Oracle users steps up to the plate.

Chicago Oracle User Group

First, the Chicago Oracle User Group has just elected a new (more...)

Command Line Attachment to Oracle Support Service Request

For those who haven’t looked at this in awhile: these days, it’s dirt simple to attach a file to your SR directly from the server command line.

curl –T /path/to/attachment.tgz 
     –u "your.oracle.support.login@domain.com" 
     "https://transport.oracle.com/upload/issue/0-0000000000/"

Or to use a proxy server,

curl –T /path/to/attachment.tgz
     –u "your.oracle.support.login@domain.com"
     "https://transport.oracle.com/upload/issue/0-0000000000/"
     -px proxyserver:port
     -U proxyuser

There is lots of info on MOS (really old people call it (more...)

OEM CLI Commands for Bulk Property Changes

This will be a brief post, mostly so I can save this command somewhere besides the bash_history file on my OEM server. It may prove useful to a few others too… it has been absolutely essential for me on several occasions! (I was just using it again recently which reminded me to stick it in this blog post.) This is how you can make bulk property changes to a large group of targets in (more...)

November/December Highlights

In the Oracle technical universe, it seems that the end of the calendar year is always eventful. First there’s OpenWorld: obviously significant for official announcements and insight into Oracle’s strategy. It’s also the week when many top engineers around the world meet up in San Francisco to catch up over (more...)

Readable Code for Modify_Snapshot_Settings

It annoyed me slightly that when I googled modify_snapshot_settings just now and all of the examples used huge numbers for the retention with (at best) a brief comment saying what the number meant. Here is a better example with slightly more readable code. Hope a few people down the road (more...)

Largest Tables Including Indexes and LOBs

Just a quick code snippit. I do a lot of data pumps to move schemas between different databases; for example taking a copy of a schema to an internal database to try to reproduce a problem. Some of these schemas have some very large tables. The large tables aren’t always (more...)

OSP #2c: Build a Standard Platform from the Bottom-Up

This is the fourth of twelve articles in a series called Operationally Scalable Practices. The first article gives an introduction and the second article contains a general overview. In short, this series suggests a comprehensive and cogent blueprint to best position organizations and DBAs for growth.

This article – building (more...)

Replicating Tanel’s Script Library

Tanel does offer a zip file with all of his scripts. The zip seems up-to-date now; I started doing this alternative technique awhile ago when the zip file didn’t seem to get updated as quickly as the raw scripts directory.

  mkdir tpt
  cd tpt

wget -r -nH --cut-dirs=2 --no-parent --reject="index. (more...)

Convert Raw/Hex to Timestamp

Just filing this away on my own blog because it seems that I always have hard finding it via google.  Here’s some code to convert raw/hex values into timestamps.  (I’ve come across this need in two situations: [1] bind variables recorded in trace files or sql monitor and [2] hi/low (more...)

Delete Archived Logs from Standby

This is a little surprising to me because it’s so simple – but I couldn’t find a script anywhere on oracle support or on the internet which elegantly (IMHO) cleaned up archived logs on a standby system.  (Specifically, a RAC/thread aware script.)

There are a few scripts published:

Training on Demand: Fusion Applications Extend Applications with ADF

Recently we followed the training Fusion Applications: Extend Applications with ADF in Training on Demand format. What is Training on Demand? “You train online via an Internet connection, 24/7. Access streaming lectures, whiteboarding and lab activities, with the ability to search video,

Continue reading

Business Intelligence Enterprise Edition & Applications

Not too long ago Oracle released Oracle Business Intelligence Enterprise Edition (OBIEE – 11.1.1.7.0) and Oracle Business Intelligence Applications (OBIA – 11.1.1.7.1) on version 11g. As you might know, OBIA is basicly an addition to the OBIEE where you get

Continue reading

ODI: When to use RDA and RCC ?

For Oracle Data Integrator there are two troubleshooting tools available, RDA (Remote Diagnostics Agent like for most other Oracle products) and RCC (Repository Consistency Checker). So which do I use and when? 

  • RDA can be used to help diagnose issues in an ODI 11g environment and with other integrated (more...)

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

About Java class, HTTP POST and viewContentURL

As of PeopleTools 8.52 it is possible to use REST services for POST/GET functionality. However what do you do if you are on an older PeopleTools version, but still need to make a HTTP POST and then GET the response?

Continue reading

Video Demo: Hybrid Cloud Integrations using Oracle SOA Suite

The blog post "Cloud Integration in Minutes" - True or False? highlighted the challenges faced by integration projects, beyond just simple web service connectivity. However, as stated in that article, it is possible to implement SaaS API connectivity in minutes, and this post is going to show you how! We (more...)

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

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