RE: Peoplesoft & Oracle

Peoplesoft & OracleWelcome 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: root_at_fatcity.com [mailto:root_at_fatcity.com]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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Henry Poras
  INET: hporas_at_etal.uri.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).