I would agree with Joan - we spend lots of time refreshing databases here.
We were responsible for all of the application servers, web servers,
process schedulers, etc. until a technical architecture team was formed.
That has helped tremendously since my team can concentrate on the Oracle
side. We have a very large Peoplesoft Financials environment here
(along with HR and budgets) so we have lots to keep busy with and
opportunities to use additional Oracle functionality (we have a large
replicated environment, use lots of partitioning, etc) . I would also
recommend you at least take a PeopleTools course or one of the
administration courses mentioned by Joan so you understand how Peoplesoft
stores and uses metadata. As far as book recommendations the only decent
book that I have is the "Peoplesoft Administrator's Guide" by Darrell
Bilbrey which is good for someone new to Peoplesoft. We really do most
of the normal functions that any DBA would do regardless of Peoplesoft.
Database still has to be backed up, tuned, and maintained like any other
Oracle database - I consider myself to be an Oracle/Peoplesoft DBA, not a
Peoplesoft/Oracle DBA if that helps you any.
You will also learn to hate PS Query if your users have ad-hoc query
access. :-)
John Dailey
Oracle DBA
ING Americas - Application Services
Atlanta, GA
"Joan Hsieh"
<joan.hsieh@tufts To: "Multiple recipients of list
ORACLE-L" <[EMAIL PROTECTED]>
.edu> cc: (bcc: John
Dailey/NAC/ING-FSI-NA)
Sent by: Subject: Re: Oracle and Peoplesoft
[EMAIL PROTECTED]
12/19/2002 09:45
AM
Please respond to
ORACLE-L
Hi Sumathy,
It is not too much different from oracle peoplesoft and regular dba.
Except you have to know more about peoplesoft components, peoplesoft
application server, process schedular, web server,weblogic.. there are
some peoplesoft courses I am highly recommend you to take,
"Configuration and Administration" " Data Management Tools" and another
one " peoplesoft server administration on Unix/Oracle". They has a
website just like metlink. you need a customer id to access it. I feel
like as long as peoplesoft infrastucture setup correctly in the
beginning. It save a lot of time to troubleshoot later. As a
oracle/peoplesoft dba, you have to constantly deal with upgrade
poeplesoft tools, application, oracle. so clone the production database
is major thing to do. we are constantly refresh testing databases from
production. so automate those scripts are very helpful.
Joan
"Panicker, Thankam S." wrote:
>
> How different is an Oracle Peoplesoft database from a regular database?
Or
> in other words what all extra tasks
> does an Oracle Peoplesoft DBA do? How easy/difficult is it for a an
Oracle
> DBA to transition into a Peoplesoft environment?
>
> Are there any good books/ websites on this subject?
>
> I would highly appreciate your comments and suggestions.
>
> TIA
> Sumathy Thankam
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Panicker, Thankam S.
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joan Hsieh
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
