Peplesoft schema on oracle

** Myself
Peplesoft install on path
- Install oracle path
- SW Oracle default path= /u01/oracle/product/9.2/
- Create db such as /u01/Peplesoft/ORCL/*.dbf such as system,undo,temp,… for system db
- Choose path to install app
- SW Peplesoft default path = /u01/Peplesoft/
- Create schema user default 4 schema(dev,test,sys,prodcution)
On datafiles in /u01/Peplesoft/ORCL/*.dbf as (proddv.dbf,transaction data,prodctl.dbf,control section,*811.dbf,…)
That Prod=production
- Create Peplesoft application software on E811 directory such as /u01/Peplesoft/E811 for application software and sub directory (dv811,pd811,ps811,py811) log output,packages,quesuse,system,verity,printqueue,int,log


Start Peplesoft
- start from script
Structure User on system
- user oracle
- user psft
 
Structure db on system
- schema users proddta, prodctl,crpctl,crpdta,testdta,testctl,ps811dta,ps811ctl
- schema library dd811,dv811,ol811,ps811,py811,svm811,
- schema role psft_role for all users schema privileage
 
Startup
- su – psft811
- /u01/PeopleSoft/E811/system/RunOneWorld.sh
- su - oracle
- lsnrctl stop
- shutdown immediate
 
Shutdown
- su – psft811
- /u01/PeopleSoft/E811/system/EndOneWorld.sh
- /u01/PeopleSoft/E811/system/rmics.sh
- su - oracle
- lsnrctl stop
- shutdown immediate

0 comments:

Loading