First thing, reading the PDF manual above. Here are notes I took down while reading:
To download software and documentation, use the Oracle Technology Network.
Side note, I went to the Technology Network, and found that they have a Oracle Database 10g Express Edition. Seems to be good candidate for me.
Now I have it installed. I also have the Oracle Database 10g Express Edition Client installed as well. Did a small example application, it turned out pretty neat.
While reading a page at itpub, I found info about PeopleSoft 下载地址 and 注册码. It's kinda neat as well.
Another helpful page.
Q: 在PSFT上，如何建立一个用户Application Designer连DB时只有只读权限，但不能修改对象
A: application designer是用application的帐户登录的,你可以在数据库中设置这个用户对于哪些表有只读权限.
在Oracle10g上装PeopleSoft DB
Here is How to set up a PeopleSofter Environment -- by Snowhite2000
1.A Peoplesoft environment includes the following servers:Another one on 共享PSFT HRMS安装的资料
1) Database Server
You can choose the most common database server you like: Oracle, SQL Server, IBM DB2, informix.......
To set up a database server is the most important part of PS environment. It is 70% weight in a PS environment.
2) Application Server
PS use BEA Tuxedo as its Application Engine
3) Scheduler
Scheduler is used to run report. Also use BEA Tuxedo as Engine.
4) Web Server
You can pick BEA Weblogic or IBM Websphere as Web Server.
5) File Server
6) Workstations for power user
2. Software needed for a Peoplesoft Environment
You can pick different OS -- Windows, Unix, Linux. But each serve need to be installed the following list of Software.
1) Database Server:
BEA Tuxedo
Database Server: Oracle/SQL Server/IBM DB2......
PeopleSoft PeopleTools for database Server
PeopleSoft Applications (Finanical/HRMS/CRM .....)
2) Application Server:
BEA Tuxedo
PeopleSoft PeopleTools for Application Server
Database Client
3) Process Sheduler (Batch Server)
BEA Tuxedo
PeopleSoft PeopleTools for Seheduler
Database Client
4) File Server
PeopleSoft PeopleTools for File Server
5) Web Server
BEA tuxedo
Database Client
Web Server: BEA Weblogic/IBM Webspere
PeopleSoftPeopleTools for Web Server
6) Workstations for power user:
Database Client (With ODBC)
Crystal report (if needed)
7) Other Software:
Database Server:
A PeopleSoft Software package includes all above software except Database Server. You should purchase Database Server license youself.
Cobol Compiler:
PS also use some Cobol. You need purchase a Cobol compiler such as Net Express for Windows and Micro Focus for Unix.
FTP Server:
You may/maynot need it. It depends on how you like to transfer your report between process scheduler and Web Server
3. install workstation (map to your file server drive and install from there)
4. Create a DEMO database:
After all software has been install on the Server, we start to create a demo database.
The process of database creating is base on the database engine you use. I cannot give out the detail about this part. This part takes most of your time. Some scripts need 10 more hours to run.
5. Configure Application Server
6. Configure Process Scheduler
7. Setting up PIA (PeopleSoft Pure Internet Architecture) on Web Server
8. Setting up Crystal report (if needed)
9. Compile your Cobol
10. Installing Peoplebook -
(I do have one note about it which i worte last year: http://snowhite2000.itpub.net/post/5/3612)
My note:
1. If it is your first to create PS environment, plus, you need create demo database, you should ask minimum 2 weeks or more to finish all tasks.
2. Strong background of OS and network will be most helpful.下载下来的每一个 Maintenance Pack 里面都有很详细的 Word 文件，告诉你一步一步怎么做。有些步骤还有截屏。一步一步对照找做。注意不能出错误就好了。
不过你要决定，你的环境是否需要 MP. 这个通常是 function 组的决定。
======================
还有需要注意的事情就是，如果你的环境有很多已经 customized 的功能，你在 applied MP 之后，这些功能可能需要重新再 customize 一次。类似作了一次小小的升级的意思。
