RE: Multiple (SYSADM) Schemas in a Peoplesoft Database
Date: Wed, 20 May 2009 17:14:07 +0100
It is supported, but it is not recommended by PeopleSoft/Oracle.
There are a number of drawbacks including and not limited to:
* You have to back and restore the databases together. The only to backup
and restore one of several PeopleSoft databases in the same Oracle database would be via export/import.
* If the database goes down, then all the PeopleSoft systems become
* If all the databases are in the same database server then the same
database parameters apply to all. You cannot control them separately.
In the end there is very little saving to be made, and it is at the price of considerable complication and loss of flexibility. I simply would not do it.
The only possible exception is if you have Portal and just one product (such as HR) then you might put them together because they are so tightly bound.
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com <http://www.psftdba.com/>
DBA Blogs: PeopleSoft: http://blog.psftdba.com <http://blog.psftdba.com/> , Oracle: http://blog.go-faster.co.uk <http://blog.go-faster.co.uk/> PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Mayen.Shah_at_lazard.com
Sent: Wednesday, May 20, 2009 4:09 PM
Cc: oracle-l_at_freelists.org; oracle-l-bounce_at_freelists.org Subject: Re: Multiple (SYSADM) Schemas in a Peoplesoft Database Importance: High
Below is the response from our PSoft admin.
- Forwarded by Mayen Shah/ITS/Lazard on 05/20/2009 11:06 AM -----
May 20 2009 10:55 AM
Mayen Shah/ITS/Lazard_at_Lazard NYC
Re: Fw: Multiple (SYSADM) Schemas in a Peoplesoft DatabaseLink <Notes:///85256A00006F0854/38D46BF5E8F08834852564B500129B2C/32F03A8AD923C03D 852575BC004E6960>
You can have any number of PeopleSoft schema in one Oracle database. You also have to create a unique service name for each schema. The number of rows in PS.PSDBOWNER controls the number of schemas. In most case, there is only one row in this table.
May 20 2009 10:18 AM
Al Kannayiram/ITS/Lazard_at_Lazard NYC,
Fw: Multiple (SYSADM) Schemas in a Peoplesoft Database
Is it possible?
"Hemant K Chitale" <hkchital_at_singnet.com.sg> Sent by: oracle-l-bounce_at_freelists.org
May 20 2009 10:12 AM
Please respond to
Multiple (SYSADM) Schemas in a Peoplesoft Database
I believe that Peoplesoft does allow multiple schemas (the default is
SYSADM, so the multiples could be SYSADM_1, SYSADM_2 etc) in a
single Oracle Database.
This could support seperate business units in one Oracle instance.
Has anyone implemented this in Production ? Particularly for Financials modules -- (GL, Payables, Assets)
(Currently, we do have multiple BUs in the single SYSADM schema but I
am asked to explore two options :
a. Seperate Database Instances
b. Seperate schemas in one Database Instance )
Hemant K ChitaleReceived on Wed May 20 2009 - 11:14:07 CDT