Re: Multiple (SYSADM) Schemas in a Peoplesoft Database

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@Lazard NYC
cc

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





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@Lazard NYC, 
cc

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


Is it possible? 

Thanks
Mayen







"Hemant K Chitale" <hkchital@xxxxxxxxxxxxxx> 
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
May 20 2009 10:12 AM
Please respond to
hkchital@xxxxxxxxxxxxxx


To
oracle-l@xxxxxxxxxxxxx
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




Other related posts: