京港地铁PS人事系统全新安装手册

1、京港地铁人力资源管理系统项目一期京港地铁PeopleSoft 系统安装手册-PeopleSoft System Install Manual 提交人：OCS提交日期：2007年01月29日版本控制(Version Control)文档接收 (Acceptance Record)版本Version接收者Acceptor签字Sign日期Date备注Comments文档历史（Document History）版本Version作者Author日期Date描述Description1.0罗英2007-03-06初始版本版本Version审阅者Reviewer日期Date备注Comments参考文档 (

2、Reference)文档名作者版本备注目录1.Prepare for Installation42Install Web Server Product43Install Tuxedo on Windows54Install Database Products:65Install All PeopleSoft CDS86Setup Database Manually on Win200397创建Data Mover的导入脚本118Setup PeopleSoft Application Server199Setup Process Scheduler Server2110Setup Web Se

3、rver2311.Install Crystal Report2712.Compile COBOL2713.Setup Ren Server2714.配置Report Node: 报表发布器2715.安装过程中的注意事项271. Prepare for Installation1.1 安装 之前需要从 上下载三个文档：u PT847_Install_oracle.pdfu PeopleSoft Enterprise HRMS and Campus Solutions Hardware and Software Requirements Supplementu

4、 PeopleSoft Enterprise HRMS and Campus Solutions 8.9 MP1 Application Supplemental Instal2u All bundles installation Guide1.2 多语言数据库的选择：u 如果该系统仅仅使用一种语言，而且是PeopleSoft的缺省语言：英语，那么系统安装时，永远选择：Non-Unicode 的数据库。u 如果该系统不仅仅使用一种语言，除了PeopleSoft的缺省语言：英语外，还要安装其他的语言，那么在系统安装时，永远选择 Unicode 的数据库。 只有选择了Unicode，我们也才可以在

5、今后不断的加入新的语言包。1.3 Cobol 的编译u 如果此次项目的实施包含了 Global Payroll模块，那么就一定要在系统安装完毕后进行Cobol的编译。具体的编译方法请参照：PT847_Install_oracle.pdfu 即使没有实施：Global Payroll的模块，但是一样开发了Cobol的应用程序，那么也一定要编译Cobol 的程序。2 Install Web Server Product2.1 在建立PeopleSoft 的WEB Server 之前，我们安装支持Web Server 的产品。当前支持PeopleSoft 的Web Server 产品有两种： l W

6、eb Logic 8.1 Sp3l Web Sphere2.2 在MTRC BJ 的项目中， 我们选用的是Web Logic ,所以安装如下：u Install WebLogic Server8.1 Service Pack 3 for windows (c:bea)3 Install Tuxedo on Windows3.1 Tuxedo是PeopleSoft 的中间件，必须和PeopleSoft Application Server 安装在一个Server 上。 目前Tuxedo 的版本是： Tuxedo 8.1 for Windows Revision 3. 3.2 Install Tu

7、xedo 8.1 for windows Revision 3 -Double Click pstuxinstall.exe (c:beaTuxedo8.1) listen port: 3050*TListen Password: password4 Install Database Products:4.1 当前可支持PeopleSoft 的数据库产品有几种： Oracle 10g SQL Server 2000 IBM DB2 Sybase4.2 MTRC BJ 所选用的产品是基于 Win2003 Enterprise Server 上的Oracle 10g4.3 Oracle 10g 的

8、安装要求及图例：u Install Oracle Database .0-no need install global database: orc1-(C:oracleproduct10.2.0db_1) 5 Install All PeopleSoft CDS5.1 Load PT8.47(CD1CD6) .(D:PT8.47(d:HRMS89PT8.47)u (zm7ky3-w41m04-4u863q6-7oke1m-s7t1f2) u 如果是安装在同一个Server 上，则将所有的选项选上。（Web server/Application Server/Database S

9、erver/Batch Server/Process Server/File Server）u Unicode：多语言数据库 Non-Unicode：单语言数据库u 数据库路径一定要指定到Bin: D:oracleproduct10.2.0db_1BIN5.2 Install Application CD. (117fcf-ffff8f-ffffebf-2y40u2)u 如果是安装在同一个Server 上，则将所有的选项选上。（Web server/Application Server/Database Server/Batch Server/Process Server/File Serve

10、r）u 数据库路径一定要指定到Bin: D:oracleproduct10.2.0db_1BIN5.3 Install Multiple Languages CD. (103fff-c00000-2s43ao)u 如果是安装在同一个Server 上，则将所有的选项选上。（Web server/Application Server/Database Server/Batch Server/Process Server/File Server）u English 是缺省的语言。 需要仅将所要安装的语言安装上。6 Setup Database Manually on Win2003 6.1 Peop

11、leSoft 的数据库有两中u Demo : 数据库里面已经包含了一些Sample 的数据， 可立即用于系统的演示， 测试，开发等。u Sys: 数据库里面不包含一些Sample 的数据，可用在设置最后的公司结构，人员信息以及数据的导入。数据测试完成后，一般就做为生产机。6.2 数据库创建前期准备：u 编辑好init.ora 和initHR89TST.ora 的数据库初始化文件。u 创建好目标文件夹以及路径： -创建目录：Oracle DBF path :HR89TST and Build Folder as bellowing: D:oracleproduct10.2.0oradataHR8

12、9TST D:oracleproduct10.2.0adminHR89TSTadump D:oracleproduct10.2.0adminHR89TSTbdump D:oracleproduct10.2.0adminHR89TSTcdump D:oracleproduct10.2.0adminHR89TSTdpdump D:oracleproduct10.2.0adminHR89TSTpfileinit.ora D:oracleproduct10.2.0adminHR89TSTudumpu 设置WINDOWS的环境变量：C: Set ORACLE_SID=HR89TSTu orapwd fi

13、le=D:oracleproduct10.2.0db_1databasepwdtemp1.ora password=manager entries=5u oradim -new -sid HR89TST -intpwd manager -startmode auto -pfile D:oracleproduct10.2.0adminHR89TSTpfileinit.ora6.3 手工创建PeopleSoft 的数据库：u 数据库创建前需要准备以下的所有脚本，具体内容的设置参考: “PT847_ORACLE.PDF”.u 打开：开始-运行 CMD: Set ORACLE_SID=HR89TSTn

14、 1.sqlplus /as sysdba u 2.sqlplus E:HRMS89PT847scriptsntcreatedb10.sqlu 3. sqlplus E:HRMS89PT847scriptsntutlspace.sqlu 4. sqlplus E:HRMS89PT847scriptsntdbowner.sqlu 5.sqlplus E:HRMS89PT847scriptsnthcddl.sqln 8.sqlplus connect system/manager u 1.sqlplusE:HRMS89PT847scriptsntpsroles.sql u 2.sqlplusE:H

15、RMS89PT847scriptsntpsadmin.sql u 3.sqlplusE:HRMS89PT847scriptsntconnect.sql 6.4 设置NLS_LANG 在Windows Registry里面u 8. runCMDregedit Set NLS_LANG SIMPLIFIED CHINESE_CHINA.ZHS16GBK6.5 设置Oracle 的tnsnames.ora, sqlnet.ora and listener.ora文件u C:oracleproduct10.2.0db_1NETWORKADMIN1. Tnsnames.ora:# tnsnames.or

16、a Network Configuration File: C:oracleproduct10.2.0db_1networkadmintnsnames.ora# Generated by Oracle configuration tools.HR89TST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = HR89TST) ) )HR8

17、9DEV = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = HR89DEV) ) )HR89DMO = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521) ) (CONNECT_DATA =

18、(SERVER = DEDICATED) (SERVICE_NAME = HR89DMO) ) )HR89CFG = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HqHrms02DB.)(PORT = 1521) ) (CONNECT_DATA = (SERVICE_NAME = HR89CFG) ) )2. sqlnet.ora# SQLNET.ORA Network Configuration File: C:oracleproduct10.2.0db_1NETWORKADMINsql

19、net.ora# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)3. Listener.ora# listener.ora Network Configuration File: D:oracleproduct10.2.0db_1networkadminlistener.ora# Generated by Oracle configuration tools.HR89TST = (DESC

20、RIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0) ) )HR89DEV = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0

21、) ) )SID_LIST_HR89TST = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:oracleproduct10.2.0db_1) (PROGRAM = extproc) ) )SID_LIST_HR89DEV = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:oracleproduct10.2.0db_1) (PROGRAM = extproc) ) )7 创建Data Mover的导入脚本7.1 配置People

22、Tools的Configure Manager: (Connect ID: people; PWD: peop1e): Path: Program-PT847Configure Manager7.2 *用Data mover 来运行脚本。u Program-Datamover (sysadm/sysadm)-file/Database Setup-Demo-Eng+SimpleChinese (Add ALL)-Set Database Parameter(SysbolicID:HR89TST) AccessID: SYSADM, Connect ID: people) -Set Base L

23、anguages-ENG-Fininsh-Running Scripts. u Data Mover运行中，如果脚本出错，可用replace_all *代替：import *。u 如果从某个表开始可以在import *, 前面加入：Set Start Record_Name。7.3 Update 数据库到最新版本PeopleTools 版本：u 当上面的data mover 的脚本运行成功后，我们可以用: ID: PS; PWD: PS来登陆Application designer (PS/PS)。如果系统出现了Error,(Error: The database is at release

24、8.46. The PeopleTools being run require databases at release 8.47.) 我们则需要运行以下脚本： u sqlplus connect sysadm/sysadmHR89TSTu Sqlplus E:HRMS89PT847scriptsrel847U.sqlu 继续用 PS/PS 登陆Application Designer, 如果出现错误： (Error: Invalid User ID and password for Signon.), 则-Run the following scripts in Data mover: sy

25、sadm/sysadm。 In boot Strap.UPDATE PSSTATUS SET OWNERID = SYSADM;UPDATE PSOPRDEFN SET SYMBOLICID = HR89TST, OPERPSWD = OPRID, ENCRYPTED = 0;UPDATE PSACCESSPRFL SET ACCESSID = SYSADM, SYMBOLICID = HR89TST, ACCESSPSWD = SYSADM, VERSION = 0, ENCRYPTED = 0;UPDATE PSOPTIONS SET LICENSE_CODE = 117fcfffff8f

26、ffffebfy40u2, LICENSE_GROUP = 1;UPDATE PS_INSTALLATION SETHGA=Y, BENEFIT_ADMINISTRN=Y, CSS=Y, PSERECRUIT=Y, AV=Y, CCU=Y, DI=Y,SG=Y, EHC=Y, HR=Y, INSTALLED_PAY_INT=Y, ADP=Y, INSTALLED_PAY_PPS=Y, INSTALLED_PAY_NA=Y,PA=Y, RSRW=Y, RP=Y, ST=Y, SA=Y, PSERECRUIT_MGR=Y, TL=Y, PSEBENEFITS=Y,PSECOMP=Y, PSECOM

27、P_MGR=Y, PSEA=Y, PSEPAY=Y, PSEPERF_MANAGEMENT=Y, PSEPROFILE=Y,PSEPROFILE_MGR=Y;GRANT SELECT ON PSSTATUS TO PEOPLE;GRANT SELECT ON PSOPRDEFN TO PEOPLE;GRANT SELECT ON PSACCESSPRFL TO PEOPLE;encrypt_password *;u IN Data mover, run the scripts- (sysadm/sysadm): msgtlsupg.dms 7.4 Update PeopleTools Data

28、base Objectsu Copy the project into application designer: -userid : PS pwd: PSu 1.Program-Application Designer- Tools-Copy Project from File: PPLTLS84CURu 2.Program-Application Designer-Open: (PS/PS) -Tools-Copy Project from File: PPLTLS84CURML(选择语言)-OPTION-copy Files-Simple Chinese-Copy Button(只有多语

29、言数据库的用户才使用此项, English and Common 不应该被选上。)u 3.Program-Application Designer-Open: (PS/PS) -Tools-Copy Project from File: PPLTLS84CURDEL u 4.Program-Application Designer-Open: (PS/PS) -Build-Project: PPLTLS84CUR u 5.Program-Application Designer-Open: (PS/PS) -Tools-Copy Project from File: PT84TBSPCu 6.

30、Program-Application Designer-Open: (PS/PS) -Biuld-Project: PT84TBSPC7.5 Update PeopleTools System Data:u -Run the following scripts in Data mover: （SYSADM/SYSADM） pt847tls.dms PSLANGUAGES.DMS tlsupgnoncomp.dmsu StartRunCMD: Set ORACLE_SID=HR89TST Sqlplus “/as sysdba” Connect SYSADM/SYSADMHR89TST sql

31、plus UPDATE PSLANGUAGES SET INSTALLED=1 WHERE LANGUAGE_CD =ZHS;u -Run the following scripts in Data mover: (PS/PS) pt847tlszhs.dms MSGTLENG.DMS PTSTRENG.DMS CURRENG.DMS STOREDDL.DMS STOREPT.DMS PTDEFNSEC.DMS CREATEVW.DMS7.6 Running PeopleTools Conversion: Set ORACLE_SID=HR89TST Sqlplus “/as sysdba”

32、Connect SYSADM/SYSADMHR89TST -sqlplusselect ROLEUSER, ROLENAME from PSROLEUSER where ROLENAME in (PeopleSoft Administrator,Portal Administrator);u -Dos Command E:HRMS89PT847binclientwinx86psae -CD HR89TST -CT ORACLE -CO PS -CP PS -R INSTALL -AI UPG844PORTAL E:HRMS89PT847binclientwinx86psae -CD HR89T

33、ST -CT ORACLE -CO PS -CP PS -R INSTALL -AI UPGQRYDUPHED E:HRMS89PT847binclientwinx86psae -CD HR89TST -CT ORACLE -CO PS -CP PS -R INSTALL -AI UPGPTSMDAT E:HRMS89PT847binclientwinx86psae -CD HR89TST -CT ORACLE -CO PS -CP PS -R INSTALL -AI UPGPT846PP7.7 Change the User Interface: (PS/PS) Program-Applic

34、ation Designer-Openstyle: Open-PSSTYLEDEF-DELETE PSALTERNAME-INSERT-PSALTERNAME_LIGHTBLUE; delete PTSTYLEDEF- insert PTSTYLEDEF_LIGHTBLUE; OPEN-PSQUERYSTYLEDEF-PSQUERYSTYLESUB-PSQUERYSTYLESUB_LIGHTBLUE7.8 Install Multiple Language Database Project (PS/PS)(此项只用于多语言) Program-Application Designer-Tools

35、-Copy Project from File: PPLTLSML-OPTION-SIMPLE CHINESEu Data Mover: (PS/PS) PT847TLSZHS.DMSu -Dos Command C:PT8.47binclientwinx86psae -CD HR89ORA -CT ORACLE -CO PS -CP PS -R INSTALL -AI VERSION7.9 运行SQR的报表，来验证数据库的连接性;u *Test Database Connection*u Start-Run-Browseu Checking the Database Sysaudit.sqru Running Set space sqr reportC:PT8.47sqrsetspace.sqrsysadm/ sysadmHR89ORA-zifC:PT8.47sqrpssqr.ini-iC:PT8.47sqr-fc:tempsetspace.pdf -keep -printer:ht8 Setup PeopleSoft Application S