RE: Peoplesoft & Oracle

[Henry Poras]

Title: Peoplesoft & Oracle

Welcome Lisa,

 

I've got PeopleSoft with 8.1.7 and AIX also (peoplesoft 8.4). It's not quite the dark side, more like Dante's Inferno. There are a number of websites and lists, but I haven't found any to be all that useful. A lot of the problems you mention arise because PeopleSoft doesn't really understand databases, they provide the CREATE scripts, and a lot of people run them with no (or just minor) modifications. There are also lots of levels (webserver, tuxedo (including application server and process scheduler server), jolt, OS, database). Most of the issues I've seen have nothing to do with the database. (and you think you've had problems with Oracle support? heh, heh.). I'll be glad  to tell you more, (or just rant). Let me know.

 

Henry

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, Lisa
Sent: Tuesday, January 28, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L
Subject: Peoplesoft & Oracle

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