Virtual Moving Day!

Well, I finally decided to do it!  I got my own website.  So, now comes the challenging part of moving it all to the new site.

So, please update your feeds and bookmarks to:

And, if you have any suggestions on how I can make it better, please comment.  I apologize for the inconvenience.

2010 in review

This page has moved.  Please update your links:

The stats helper monkeys at mulled over how this blog did in 2010, and here’s a high level summary of its overall blog health:

Healthy blog!

The Blog-Health-o-Meter™ reads Wow.

Crunchy numbers

Featured image

A helper monkey made this abstract painting, inspired by your stats.

About 3 million people visit the Taj Mahal every year. This blog was viewed about 55,000 times in 2010. If it were the Taj Mahal, it would take about 7 days for that many people to see it.


In 2010, there were 26 new posts, growing the total archive of this blog to 158 posts.

The busiest day of the year was September 22nd with 375 views. The most popular post that day was Step By Step.

Where did they come from?

The top referring sites in 2010 were,,,, and

Some visitors came searching, mostly for ora-01502, peopletools tables, windows file lock viewer, yum samba, and peoplesoft installation step by step.

Attractions in 2010

These are the posts and pages that got the most views in 2010.


Step By Step September 2008


PeopleTools Tables September 2007


ORA-01502: Indexes in unusable state February 2008


Server Administration Tip: Logging Into the Weblogic Console March 2007
1 comment


Step by Step: Yum + Samba December 2008

Step By Step Virtual PS Install: Database Creation

This is a continuation of my virtual PeopleSoft installation.  In this step, we will create the database in an already installed Oracle Database system.  So, this assumes that the Oracle Database software is already installed.  Loading the PeopleTools data will be covered in the next step.  To see the complete list of steps, click here.

Read the rest of this entry »

Updated Resources

This page has moved.  Please update your links:

Tahiti Views just reported that Oracle  has just put up the official PeopleBooks on their website.

The Internet Resources page now includes the official PeopleBooks:

PeopleTools Tables Updated

This page has moved.  Please update your links:

Just a quick note: I added a few tables to the PeopleTools Tables list:

SQL Definitions

  • PSSQLDEFN — header record; last update time, etc.
  • PSSQLTEXTDEFN — stores actual text in the SQL definition

I also updated the Application Engine section with some links to related posts.

New Tables for the Reference

Ketan Kothari published an article and mentioned a new table PSPRUHTABPGLT.

Also, I had another problem with tablespaces and wanted to list all of the records in a tablespace.  This is the table I needed: PSRECTBLSPC.

So, I updated the PeopleTools table list.

Blog Update

I added a few more tables to the PeopleSoft Tables listing from a post I saw at PeopleSoft Tipster.

Blog Update

Just a quick note about some updates on the pages.

First, I added a few tables to the PeopleTools tables reference:


Then, I posted some more in the Step By Step series, but I didn’t add it to the page.

Blog Update

I just found a new wiki site from Anderson University.  I have added it to the Resources List.


Blog Update: Updated Resources

Just a quick update:  I updated the PeopleBooks Resources links with some new links and removed the old broken ones.  Hope that helps.