PeopleSoft PT850_HCM910_MSSQL2005安装日志_thomas

PeopleSoft PT850+HRMS910+MSSQL2005安装日志潘钊炜Thomas A. Pan914951706@2011.12.28步骤01：新建VM文件：pshr1228_2.vdi步骤02：安装WIN XP SP3KEY:XKFW9-GMDJ8-7RDJ2-G6MCG-HQXBTadministrator密码psadmin1计算机名thomas用户名panzhaowei步骤03：安装VM增强功能步骤04：安装必备软件4.1 安装解压缩软件(HAOZip)4.2 安装PDF阅读器(Foxit)4.3 安装输入法(极点五笔)4.4 安装办公软件(WPS)4.5 安装通讯软件(QQ)步骤05：安装数据库服务器5.1 安装IIS for SQL20055.2 安装SQL2005开发版服务器名称THOMASsa密码Peop1esa排序Latin1_General和Binary(二进制)增加系统数据库tempdb表空间为5120，自动增量20%步骤06：安装WebLogic_win32_10.3.1步骤07：安装Tuxedo 10gR3 with VS2005PORT:3050Password:Peop1ehrset TUXDIR=C:\Oracle\Middleware\tuxedo10gR3_VS2005步骤08：安装Micro Focus Net Express 5.0步骤09：安装PT850Environment Hub Machine Name:THOMASPORT:8000步骤10：安装HCM9.1步骤11：配置Configuration Manager步骤12：新建空数据库PEOPLE步骤13：安装PsMpDbInstallServerName:thomasDatabaseName:PEOPLEAdmin User:saAdmin Pswd:Peop1esaSymbolic ID:saAccess ID:PeosaAccess Pswd:Peop1esaConnect ID:peopleConnect Pswd:Peop1ehr设置完毕后Data Mover向PEOPLE数据库导入DEMO数据2011.12.29步骤15：升级PT系统表Run grant.sql by SQL2005Double click PS_HOME\bin\client\winx86\psdmt.exeLogon by User ID:PS,Password:PSRun storedll.dms by DATA MoverDouble click PS_HOME\bin\client\winx86\psdmt.exeLogon by User ID:Peasa,Password:Peop1esa(ACCESSID/PSWD)Run msgtlsupg.dms by Data Mover步骤16：升级PT数据库对象1. Launch Application Designer and sign on to your database with a valid PeopleSoft user ID.2. Select Tools, Copy Project, From File.3. In the resulting dialog box, change the import directory to PS_HOME\projects, select PPLTLS84CURfrom the list of projects and click the Select button.4. The Copy From File dialog box appears.Select all object types and then click the Copy button.When the progress window disappears, the project has been copied.步骤17：删除旧的PT数据库对象1. Select Tools, Copy Project, From File.2. In the resulting dialog box, change the import directory to PS_HOME\projects,select PPLTLS84CURDEL from the list of projects and click Select.3. The Copy From File dialog box appears.Select all object types and click the Copy button.When the progress dialog box disappears, the project has been copied.步骤18：修改PT表1. Launch Application Designer with a valid PeopleSoft user ID and sign on to the installed database.2. Select File, Open.3. Select Project, enter PPLTLS84CUR in the name dialog box, and click OK.4. Select Build, Project.5. Select Create Tables and Alter Tables in the Build Options region (Create Indexes and Create Trigger willautomatically be selected).6. Select Build script file in the Build Execute Options region.7. Click Settings.8. Select the Scripts tab.9. Select Write Alter comments to script.10. Select the Alter tab and ensure that the Adds, Changes, Renames, and Deletes check boxes areselected inthe Alter Any region.Drop column if data present should be selected in the Drop Column Options region, and Truncate data iffield too short should be selected in the Change Column Length Options region.Make sure that the option Alter by Table Rename is selected in the Alter Table Options region. 11. Select the Create tab and ensure that the Skip table if it already exists, Recreate view if it already exists,and Recreate index only if modified options are selected.12. Click OK.The Build dialog box reappears.13. Click Build.14. Click Close when the process is completed.15. Run the generated SQL script in your platform-specific query tool to bring your database structure in syncwith the PeopleSoft PeopleTools tables.步骤19：升级PT系统数据1. Invoke Data Mover by running PS_HOME\bin\client\winx86\psdmt.exe.The PeopleSoft Logon window appears.2. Log on using the ACCESSID you specified when you created your Data Mover scripts with the DatabaseSetup program.3. Run the pslanguages.dms Data Mover script in the PS_HOME\scripts directory.This script loads language-specific seed data.4. Run the tlsupgnoncomp.dms Data Mover script in the PS_HOME\scripts directory.This will import the updated PeopleSoft PeopleTools Trees, Roles, and Access Groups into your database.5. Open Data Mover using a valid PeopleSoft Operator ID, such as PS for HRMS or VP1 for FDM.6. Run the msgtleng.dms Data Mover Script in the PS_HOME\scripts directory.Non-English message data was loaded in the pt850tlsxxx.dms scripts. This will update the messagesin your database.7. Run the ptstreng.dms Data Mover script in the PS_HOME\scripts directory.Non-English system data was loaded in the pt850tlsxxx.dms scripts. This will update the SQR stringsin your database.8. Run the storept.dms Data Mover script in the PS_HOME\src\cbl\base directory.This will update your PeopleSoft PeopleTools COBOL stored statements.9. Run the ptdefnsec.dms Data Mover script in the PS_HOME\scripts directory.This will update the PeopleSoft PeopleTools Definition Security group.10. Run the createvw.dms Data Mover script in the PS_HOME\scripts directory.This will recreate all the views in your database.步骤20：运行PT转换1.Convert Portal ObjectsC:\>E:PT850\bin\client\winx86\psae -CD PEOPLE -CT MICROSFT -CO PS -CP PS -R INSTALL -AI UPG844PORTAL2.Convert Query HeadingsC:\>E:PT850\bin\client\winx86\psae -CD PEOPLE -CT MICROSFT -CO PS -CP PS -R INSTALL -AI UPGQRYDUPHED3.Convert Setup ManagerC:\>E:PT850\bin\client\winx86\psae -CD PEOPLE -CT MICROSFT -CO PS -CP PS -R INSTALL -AI UPGPTSMDAT(failed for reason "UPGPTSMDAT" not defined)4.Convert Navigation Collection and Pagelet Wizard DataC:\>E:PT850\bin\client\winx86\psae -CD PEOPLE -CT MICROSFT -CO PS -CP PS -R INSTALL -AI UPGPT846PP(Some SQL failed)5.Convert Additional Pagelet Wizard DataC:\>E:PT850\bin\client\winx86\psae -CD PEOPLE -CT MICROSFT -CO PS -CP PS -R INSTALL -AI UPGPT848PP6.Populating the Feed Options TableC:\>E:PT850\bin\client\winx86\psae -CD PEOPLE -CT MICROSFT -CO PS -CP PS -R INSTALL -AI UPGPT850PTFP步骤21：运行PT附加转换C:\>E:PT850\bin\client\winx86\psae -CD PEOPLE -CT MICROSFT -CO PS -CP PS -R INSTALL -AI UPGPTSERVOPR步骤22：运行VERSION应用引擎程序C:\>E:PT850\bin\client\winx86\psae -CD PEOPLE -CT MICROSFT -CO PS -CP PS -R INSTALL -AI VERSION步骤23：运行SQR报告1. Select Start, Run, click Browse, and navigate to PS_HOME\bin\sqr\MSS\binw.Select sqrw.exe and click Open.2. Add any needed flags at the end of the command line.Refer to the table that follows. For those flags that require attributes, append the attributes to the flags withno intervening spaces (for example, –fd:\psbase\psenv\cr881dmo\).Open: E:\PT850\bin\sqr\mss\BINW\sqrw.exe -IE:\PT850\sqr\-ZIFE:\PT850\sqr\pssqr.ini-3. Click OK.4. Enter the following values:• Enter the report name.(E:\PT850\sqr\dddaudit.sqr)• Enter the database name in the DataSource field.(PEOPLE)• Enter the ACCESSID in the Username field.(Peosa)• Ente r the access password in the Password field.(Peop1esa)5. Click OK to run the SQR report.Errors were found in the program file.SQR for Peoplesoft:Program Aborting.步骤24：检查数据库按照步骤23方法执行dddaudit.sqr和sysaudit.sqr(Errors happened as up)步骤25：配置应用服务器1.PSADMIN6) WSL :YES15) DBNAME :[PEOPLE]17) UserId :[PS]18) UserPswd :[PS]19) DomainID :[PEOPLE]21) ConnectID :[people]22) ConnectPswd :[Peop1ehr]24) WSL Port :[7000]25) JSL Port :[9000]26) JRAD Port :[9100]2.配置PT Configuration Manager的Profile和Startup页签1)Profile:Default-EditApplication Server:10.0.2.15:7000Machine Name or IP:thomasPort:70002)Startup:Database:Application ServerApplication Server:10.0.2.15:7000User:saConnect :peopleConnect Pswd:Peop1ehr3.配置ODBC数据源系统DSN添加SQL Server:PEOPLE步骤26：安装PIAWebsiteName:PEOPLEAppServerName:thomasJSL Port:9000HTTP Port:8000HTTPS Port:4430步骤27：启动并检查Weblogic和Tuxedo启动服务1.启动weblogic2.检查PSADMIN的tuxedo domain boot状态3.测试登录http://thomas:8000/console用户system密码Passw0rdhttp://thomas:8000/PEOPLE/signon.html用户PS密码PS提示IE版本低于7但不影响登录，下载IE8重新安装后可正常登录。