RE: Peoplesoft & Oracle

Lisa,  

Afraid I can't help with PSoft (all the best, you have already seen some of the best of the worst :), but the following link may help you when getting used to AIX.  

http://bhami.com/rosetta.html <http://bhami.com/rosetta.html>  

So how's Jr. doing? (PS: I think Dick Goulet has experience with PS) John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

I don't know what the future holds for me, but I do know who holds my future!

• The opinions and statements above are entirely my own and not those of my employer or clients **

-----Original Message-----
Sent: Tuesday, January 28, 2003 1:09 PM
To: Multiple recipients of list ORACLE-L

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: John Kanagaraj
  INET: john.kanagaraj_at_hds.com

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).