Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Peoplesoft & Oracle

Peoplesoft & Oracle

From: Koivu, Lisa <>
Date: Tue, 28 Jan 2003 13:08:58 -0800
Message-ID: <>

Hello everyone,

My apologies for bombarding the list with more questions than answers as of late. This one is pretty desparate.

For those of you who support Peoplesoft databases - Are there any websites that you frequent to check for quirks, weird anomalies, etc. related to your specific Peoplesoft/Oracle combination?

I've just inherited this environment. It's Oracle 8.1.7 on AIX. I don't know the version of AIX and I don't know the version(s) of the Peoplesoft modules being used. However I am seeing some very weird things - not the least of which is every tablespace is dictionary managed, all are on autoextend, there are 600 open database accounts but it looks like the app only connects as SYSADM, all users have SYSTEM for default/temp ts, the entire freaking database is on one disk, all redologs (one in each group) are on one disk, etc., etc., etc. The list goes on. I'm afraid to turn this environment upside down and fix it because management is only interested in keeping the system alive, not improving it. The previous DBA is elusive at best, probably because I yelled at him last year after catching him creating objects on the fly in my databases :)

I'll do the obvious things like add redologs and check backup and recovery, etc. User error is extraordinarily high in this environment. Everything else I am afraid to touch without doing my homework first. Any websites, suggestions, comments, etc. would be greatly appreciated.

The only good thing to come of all this is I'M BAAAAAAAAAAAAAACK in Unix again !!! Woo Hoo!!!!!!!

Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063


Please see the official ORACLE-L FAQ:

Author: Koivu, Lisa

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jan 28 2003 - 15:08:58 CST

Original text of this message