RE: Multiple (SYSADM) Schemas in a Peoplesoft Database

From: David Kurtz <info_at_go-faster.co.uk>
Date: Wed, 20 May 2009 17:14:07 +0100
Message-ID: <D6CBEAF243A246FCAEE47114E49B623C_at_GOFASTER4>

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
unavailable.
* 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.

regards

---

David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
mailto:david.kurtz_at_go-faster.co.uk
web: www.go-faster.co.uk
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
To: hkchital_at_singnet.com.sg
Cc: oracle-l_at_freelists.org; oracle-l-bounce_at_freelists.org Subject: Re: Multiple (SYSADM) Schemas in a Peoplesoft Database Importance: High

Hemant,

Below is the response from our PSoft admin.

HTH Mayen

• Forwarded by Mayen Shah/ITS/Lazard on 05/20/2009 11:06 AM -----

Al Kannayiram/ITS/Lazard

May 20 2009 10:55 AM

To
Mayen Shah/ITS/Lazard_at_Lazard NYC

cc

Subject
Re: Fw: Multiple (SYSADM) Schemas in a Peoplesoft DatabaseLink <Notes:///85256A00006F0854/38D46BF5E8F08834852564B500129B2C/32F03A8AD923C03D 852575BC004E6960>         

Mayen,

It's possible.

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.

Thanks,
Al

Mayen Shah/ITS/Lazard

May 20 2009 10:18 AM

To
Al Kannayiram/ITS/Lazard_at_Lazard NYC,

cc

Subject
Fw: Multiple (SYSADM) Schemas in a Peoplesoft Database

Is it possible?

Thanks
Mayen

"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
hkchital_at_singnet.com.sg

To
oracle-l_at_freelists.org

cc

Subject
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 Chitale

http://hemantoracledba.blogspot.com

--
http://www.freelists.org/webpage/oracle-l








--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 20 2009 - 11:14:07 CDT