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

1、精品文档你我共享 京港地铁 京港地铁人力资源管理系统项目一期 京港地铁PeopleSoft系统安装手册 PeopleSoft System Install Manual ORACLE* 提交人：ocs 提交日期：2007年01月29日 版本控制(Version Control) 文档接收(Acceptance Record) 版本 Versio n 接收者 Acceptor 签字 Sign 日期 Date 备注 Comments 文档历史(Document History) 版本 Versio n 作者 Author 日期 Date 描述 Description 1.0 罗英 2007-03-

2、06 初始版本 版本 Versio n 审阅者 Reviewer 日期 Date 备注 Comments 参考文档(Reference) 文档名 作者 版本 备注 目录 1. Prepare for Installation 4 2 Install Web Server Product4 3 Install Tuxedo on Windows4 4 Install Database Products:6 5 Install All PeopleSoft CDS8 6 Setup Database Manually on Win2003 8 7 仓U建 Data Mover 的导入脚本 11 8

3、 Setup PeopleSoft Application Server17 9 Setup Process Scheduler Server20 10 Setup Web Server22 11 .Install Crystal Report26 12 .Compile COBOL26 13 .Setup Ren Server26 14 .配置 Report Node:报表发布器 27 15 .安装过程中的注意事项 28 1. Prepare for Installation 1.1 安装 之前需要从 上下载三个文档: PT847nstall_oracle.pdf PeopleSoft En

4、 terprise HRMS and Campus Soluti ons Hardware and Software Requireme nts Suppleme nt PeopleSoft Enterprise HRMS and Campus Solutions 8.9 MP1 Application Suppleme ntal In stal2 All bundle s installation Gde 1.2多语言数据库的选择: PeopleSoft的缺省语言：英语，那么系统安装时, PeopleSoft的缺省语言：英语外，还要安装其他的 Unicode的数据库。只有选择了 Unicod

5、e ,我们也才 如果该系统仅仅使用一种语言，而且是 永远选择：Non-Unicode的数据库。 如果该系统不仅仅使用一种语言，除了 语言，那么在系统安装时，永远选择 可以在今后不断的加入新的语言包。 1.3 Cobol的编译 如果此次项目的实施包含了Global Payroll模块，那么就一定要在系统安装完毕后进行 Cobol的编译。具体的编译方法请参照：PT847_Install_oracle.pdf 即使没有实施：Global Payroll的模块，但是一样开发了Cobol的应用程序，那么也一定要 编译Cobol的程序。 2 Install Web Server Product 2.1 在

6、建立PeopleSoft的WEB Server之前，我们安装支持 Web Server的产品。当 前支持PeopleSoft的Web Server产品有两种： Web Logic 8.1 Sp3 Web Sphere 2.2 在MTRC BJ的项目中，我们选用的是 Web Logic所以安装如下： In stall WebLogic Server8.1 Service Pack 3 for wi ndows (c:bea) 3 Install Tuxedo on Windows 3.1 Tuxedo是 PeopleSoft的中间件，必须和 PeopleSoft Application Serv

7、e安装在一 个 Server 上。目前 Tuxedo 的版本是：Tuxedo 8.1 for Windows Revision 3. 3.2 Install Tuxedo 8.1 for windows Revision 3Double Click pstuxinstall.exe (c:beaTuxedo 8.1) listen port: 3050*TListen Password: password c. E:Install SoftTuMedo8.1 R3pstuxinsl:all.ete 1 Flie copied. 1 f ile copied. BEA Hor he ln$r d

8、efaulted to C : beA ? ： c：C E:Install 5oftsTuHedo8.1 R3pstuxinstall.exe 4 Install Database Products: 4.1当前可支持PeopleSoft的数据库产品有几种： Oracle 10g SQL Server 2000 IBM DB2 Sybase 4.2 MTRC BJ 所选用的产品是基于 Win2003 Enterprise Server 上的 Oracle 10g 4.3 Oracle 10g的安装要求及图例： In stall Oracle Database .0-no n e

9、ed in stall global database: orci- (C:oracleproduct1020db_1) Name Size Type I Date Modified FoldersX S (Db_hfi9T5T_BackUt)_20tJ7ni26 囚 O HRM5W 二 J Instal_5ofts 田 一) 二 Hyper5nap-DX 5.60.02 + O OftACLElOG FF - I* PT647 Tuxedo8JR3 ffi IlJ hp 田二 win cJj Weblogk8.1sp3 a自 3dlnreHJ mJ m File Folder File Fo

10、lder File Folder File Folder File Folder File Folder File Folder 1 KB Setuu inFwmdtion 68 KB Appkation 6 KE HIM Donnant 1/24/3007 1:45 AM l/24f2D07 1:45 AM 1/24/2007 1：T5 AM 1/24/2007 1:45 AM 1/24/2007 1:45 AM 1/24/2007 1:45 AM 1/24/2007 1:45 AM 9/6/2005 9:01 PM 1/22/2007 7:06 PM 9/6/2005 9:02 PM 兰

11、Orel ci 住 Dot:ib35e lOg lFistail4iti on： Instatlotion Method Select Installation Method Baste installation Perform full Oracle Database 1 Og i.n stall a Won with standard configuration options requiring minimal input. This option uses file system storage. and a single passwod for il database account

12、s Oracle Home Location: D :a ra c lelp riD d u c m . 2.Oldti_1 Browse.J installatiDn Type:Enteprise(1 3C?B) ELg烂亘蛙豆垃便匚*亘坦总m兰邑吏亘也2口亘！卫吧色 Clobal Database Name: | ：r I Database Password: Confirm Password: | This psrssword rs used tar the SVSs SVSTEMa SVS：MAN, and DBNIvlP accounts L Advanced liristaLlIa

13、tion Allows aidvnced selections suchdlirerent passwords for the SYS. SYSTEM. SYS MAN. and DSSNMP accounts, database charact巳setB product lanauges. automated backups., custom instaHation. and! ahemative storage options such as Automatic Storage Management Help Back Next Install J.*、 Cancel czxauLj J

14、1I2SJ PrJE:HRMS89PT847scriptsntcreatedb10.sql 3. sqlplus E:HRMS89PT847scriptsntutlspace.sql 4. sqlplus E:HRMS89PT847scriptsntdbow ner.sql 5.sqlplus E:HRMS89PT847scriptsnthcddl.sql 8. sqlplus connect system/manager 1. sqlplusE:HRMS89PT847scriptsntpsroles.sql 2. sqlplusE:HRMS89PT847scriptsntpsadmi n.

15、sql 3. sqlplusE:HRMS89PT847scriptsntco nn ect.sql 6.4 设置 NLS_LANG 在 Windows Registry里面 8. run CMDregedit Set NLS_LANG SIMPLIFIED CHINESE_CHINA.ZHS16GBK 6.5 设置 Oracle 的 tnsnames.ora, sqlnet.ora and listener.or文件 C:oracleproduct1020db 1NETW0RKADMIN 1. Tnsnames.ora： # tnsnames.ora Network Configuration

16、 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) ) ) HR89DEV= (DESCRIPTION = (ADDRESS_ LIST =

17、(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 = (SERVER = DEDICATED) (SERVICE_NAME = HR89DMO) ) ) HR89CFG = (DESCRIPTION

18、= (ADDRESS_ LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HqHrms02DB)(PORT = 1521) ) (CONNECT_DATA = (SERVICE_NAME = HR89CFG) ) ) 2. sqlnet.ora # SQLNET.ORA Network Configuration File: C:oracleproduct1020db_1NETWORKADMINsqlnet.ora # Generated by Oracle configuration tools. SQLNET.AUTHENTICATION_SERVICES

19、= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) 3. Listener.ora # liste ner.ora Network Con figuratio n File: D:oracleproduct10.2.0db_1 networkadm inliste ner.ora # Gen erated by Oracle con figurati on tools. HR89TST = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =

20、)(PORT = 1521) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0) ) ) HR89DEV= (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0) ) ) SID_LIST_HR89TST = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:oracleprodu

21、ct1020db_1) (PROGRAM = extproc) ) ) SID_LIST_HR89DEV = (SID_LIST = (SID_DESC = (SID NAME = PLSExtProc) (ORACLE_HOME = D:oracleproduct1020db_1) (PROGRAM = extproc) ) ) 7创建Data Mover的导入脚本 7.1 配置 PeopleTools的 Configure Manager: (Connect ID: people; PWD: people): Path: Program-PT847 Configure Manager i

22、祖(Edit ProHI -Default* PeopleSolt 旦ome Dnectcrv (PS_HOME|: lefnp Dueetoijj IF MR) 1 | L .1 1 i 1. J J -.1 I ； J 厳擁蟄磴:墙屜 | c:lemp Crystal Rep oris (CRWFl P T FAT MJ: Database Drivgft (DDBINJ: J U AoradeproductXl U.ZUdb ll XBIlN Dutput Diiedoiy (OUTPUT) Word Executables Direclary (WINWORD): |cAITip l

23、1 1 Loq 0irectar LOG L Rgdirec-t ; 1 1 c:tcrnp J D atdbais e/A pho dtion Sei ver QtsneaieJ FrccassScheduler | nVision Common SQFI Flcpwt $汕氐? PSSQFl 刃: SQF； 2.R(GQRBIHJ: I F-hHF；閘寻旅 PT 何 TAhirAr qrVlFl 巴订 | Z1FE:M IFlMGDfJrTO47jqipi3qr.iri SflR Ri?prt gpArchl (PSSQH1)- | E 人H Fl 聞5石3沪 T 84 7Sikh!i、s

24、：L|i ”卫鬥 HEpoct SemruhQ 尸55QFl3; | c:uaoriqr SQF! Rortif Search4 (PSSQR4J |EAHRMS69FTG47iL|i -I ApiJiuoliuri Enyir 七 Debug L Djsable R#眦引l CODOL COBOL Executables CBLBINJ: )E. HHNSS9PTAebltnPS_C( _J UK Cdncoli | Apply Help 精品文档你我共享 7.2 *用Data mover来运行脚本。 Program-Datamover (sysadm/sysadrh-file/Databa

25、se Setup-Demo- E ng+SimpleChi nese (Add ALL)-Set Database Parameter(SysboliclDH R89TST) AccessID: SYSADM, Connect ID: people) -Set Base Languages-ENG-Fininsh- Running Scripts. Data Mover运行中，如果脚本出错，可用replace_all *代替：import *。 如果从某个表开始可以在import *,前面加入：Set Start Record_Name 。 7.3 Update数据库到最新版本PeopleTo

26、ols版本： 当上面的data mover的脚本运行成功后，我们可以用：ID: PS; PWD: PS 来登陆 Application desig ner (PS/PS)。如果系统出现了Error,(Error: The database is at release 8.46. The PeopleTools bei ng run require databases at release 8.47.)我们则需要运行以 下脚本： sqlplus connect sysadm/sysadmHR89TST Sqlplus E:HRMS89PT847scriptsrel847U.sql 继续用 PS/

27、PS 登陆 Applicati on Desig ner,如果出现错误：(Error: In valid User ID and password for Sig non.), 贝 U Run the followi ng scripts in Data mover: sysadm/sysadm 。 In boot Strap. UPDATE PSSTATUS SET OWNERID = SYSADM; UPDATE PSOPRDEFN SET SYMBOLICID = HR89TST, OPERPSWD = OPRID, ENCRYPTED = 0; UPDATE PSACCESSPRFL

28、SET ACCESSID = SYSADM, SYMBOLICID = HR89TST, ACCESSPSWD = SYSADM, VERSION = 0, ENCRYPTED = 0; UPDATE PSOPTIONS SET LICENSE_CODE = 117fcfffff8fffffebf0197832y40u2, LICENSE_GROUP = 1; UPDATE PS_INSTALLATION SET HGA=Y, BENEFIT_ADMINISTRN=Y, CSS=Y, PSERECRUIT=Y, AV=Y, CCU=Y, DI=Y, SG=Y, EHC=Y, HR=Y, INS

29、TALLED_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, PSECOMP_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

30、PEOPLE; GRANT SELECT ON PSACCESSPRFL TO PEOPLE; en crypt_password *; IN Data mover, run the scripts- (sysadm/sysadm):msgtlsupg.dms 7.4 Update PeopleTools Database Objects Copy the project into applicati on desig ner: -userid : PS pwd: PS I. Program-Applicatio n Designer- Tools-Copy Project from File

31、: PPLTLS84CUR 2. Program-Application Designer-Open: (PS/PS) -Tools-Copy Project from File: PPLTLS84CURML( 选择语言)-OPTION-copy Files-Simple Chinese -Copy Butt on(只有多语言数据库的用户才使用此项，En glish and Com mon不应该被选上。) 3. Program-Applicati on Designer-Open: (PS/PS) -Tools-Copy Project from File: PPLTLS84CURDEL 4.

32、 Program-Applicatio n Designer-Ope n: (PS/PS) -Build-Project: PPLTLS84CUR LIKUamc*Bi (ion Designer PPLTLS84CUR File Edit View Insert Build Debug Tools Go Window Htelp 冒:g吕:g_cm El:甲爭.EHS. Dos Comma nd E:HRMS89PT847bi nclie ntwi nx86psae -CD HR89TST -CT ORACLE -CO PS - CP PS -R INSTALL -AI UPG844PORT

33、AL E:HRMS89PT847bi nclie ntwi nx86psae -CD HR89TST -CT ORACLE -CO PS - CP PS -R INSTALL -AI UPGQRYDUPHED E:HRMS89PT847bi nclie ntwi nx86psae -CD HR89TST -CT ORACLE -CO PS - CP PS -R INSTALL -AI UPGPTSMDAT E:HRMS89PT847bi nclie ntwi nx86psae -CD HR89TST -CT ORACLE -CO PS - CP PS -R INSTALL -AI UPGPT8

34、46PP 7.7 Change the User Interface: (PS/PS) Program-Applicatio n Desig ner-Ope n style: Open-PSSTYLEDEF-DELETE PSALTERNAME-INSERT- PSALTERNAME_LIGHTBLUE; delete PTSTYLEDEF- in sert ptstyledef_LGhtblue; OPEN-PSQUERYSTYLEDEF-PSQUERYSTYLESUB- PSQUERYSTYLESUB_LIGHTBLUE 7.8 Install Multiple Language Data

35、base Project (PS/PS)(此项只用于多语言) Program-Application Designer-Tools-Copy Project from File: PPLTLSML- OPTION-SIMPLE CHINESE Data Mover: (PS/PS) PT847TLSZHS.DMS Dos Comma nd C:PT8.47bi nclie ntwi nx86psae -CD HR89ORA -CT ORACLE -CO PS -CP PS - R INSTALL -AI VERSION 7.9运行SQR的报表，来验证数据库的连接性 *Test Database

36、 Conn ection * Start- Run- Browse Check ing the Database Sysaudit.sqr Running Set space sqr report C:PT8.47sqrsetspace.sqr sysadm / sysadm HR89ORA -zifC:PT8.47sqrpssqr.ini -iC:PT8.47sqr -fctempsetspace.pdf -keep -printer:ht 8 Setup PeopleSoft Application Server e:hrms89pt847appservpsadm in. exe -! x

37、| PeopleSoft Sequel ifidninistration 1y Applxcat ion Server 2 Process Scheduler 3 5 Seruice Setup q Quit Coirnviiand to execute Cl3, Q： 1 PeopleSoft Oppliat Ion Seiuer ft din in is：ion 234q Admiin istei* a do main Create a 日ovn執in Delete a domain Impo i*t do nain conf igiurat Ion Quit iGaffninancl t

38、o EXECitte： tl4- 建 ：2 dey eloper1 largre nediuni small Administer a domain Create a domain Deleite a domain Import donaln confion Quit ion templates to execute 1-4 q) entep name of dlonain to create iDEUDMO c-C psadmiin 2 34 1234 q ion Server* ildinlns trat ion 品 psadmin Spaun Hireshold=lr600：lrl Re

39、startahle= A Llou Dnainic Changes =N LogFence=3 Trace-Log File ChavActer Set=ANSI Do you uant to change any values ? 【n】；y Domain ID DEVDMO1： Add to PATH叶aclepruduct10-2.01：C：or*cleSproductlB,2,0Shln Spaun Threshold 1,600:1,11: Restartable V）： Allou Dvnanic Change 取消1 http:/:8020/psp/hr89uat/sig non

40、. html 11.1 nstall Crystal Report Crystal Report是PeopleSoft之外的另外一个报表开发工具。 Crystal Report软件会有一张单独的光盘随PeopleSoft的软件一起。 安装是只需要点击光盘中的setup.exe文件就可。 开发的 Crystal Report 的 Source Code 需要放到：PS_Home/crw/ENG 或者 PS_Home/crw/ZHS, 分别放英文和中文的报表。 12. Compile COBOL 当我们的系统里面使用了 Payroll Module的时候，我们一定要编译 COBOL.具体的方法需

41、要参照：PT847_ Install_oracle. PDF ” 当我们使用了一些 COBOL的编译程序时， 也需要对COBOL进行编译。 13. Setup Ren Server 在配置Application Server是，每一个不同的 Application Server,我们需要给它配置一 个REN Server Port Number.当我们安装了多个 PeopleSoft的系统时， 我们一定要给 没个系统配置不同的端口号。 缺省的端口号是：7180. 地址轻 http:/hqhrms01.mtr. bj. cn： 8020/pSp/hr89dev/EMFL0YEE/HRMS/c/F

42、T_REN. KEN_SERVER_CMF. GBL?FolderFath=PORTAL_EOOT_OBTECT. F PeopleSoft 3 Haw 1 Wcirklist Mu| Menu Tree Manager Reporting Too|s PeopleTools3 Mobile Sync Framework Security1 Utilities Workflow Portal Search Engine Personalization Process Scheduler Cube Manager Application Engine Quer/Access Services I

43、ntegration Broker v REN Server Configuration REN Seivei ID: PSRENSRV_0003 -REN Server Definition 一 REN SErvmr Cluster Setup Manager MultiChannel Framework Archive Data Data Archive Manager Translations EDI Manager Mass Changes Performance Monitor Web Profile Mobile Client Delete I ID Save .Return to Search V Notify I 14 .配置Report Node:报表发布器 设置Report发布的URL: ApplicailoiwTaQnostics Tree 嗣anager Reporting Tools -PeopleTools L- Mobile Sync Rem D Security :Utilities .Workflow Portal 1= Search Engine Personaliiatioin Process Sclieduler -Svs