Category Archives: Windows - Page 10

Installing PeopleTools PeopleBooks 8.49

Problem: When user clicks on PeopleTools > Web Profile > Web Profile Configuration, clicks Search > Dev, and then clicks the Help link, the following message appears:

Help cannot be displayed because no help topic was found for the help context ID "WEB_PROF_GENERAL". 
To view the PeopleSoft Online Library, click here.

Solution: The PeopleTools PeopleBooks CD was not installed.

Read more »

You are not authorized to view the report(s).

Problem:

After creating clone (tramdmo), the DDDAUDIT report was run from Process Scheduler. The report completes successfully, but when trying the view the report (PeopleTools > Process Scheduler > Process Monitor, then Details > View Log/Trace), the fsdmo PIA login screen appears with the message:

You are not authorized to view the report(s).

Solution:

Navigate to PeopleTools > Process Scheduler > Report Nodes

Set URL to http://GLWEBAPP:8020/psreports/tramdmo
Set Description to TRAMDMO Reporting Node
Ensure Operating System is NT/Win200
Network Path is \glwebappe$psreports

The correct URL now appears:

Click to access DDDAUDIT_7311.PDF

Page Not Found After SSL Setup

Problem:

After setting up SSL on PeopleSoft instance, logon page appears. After logging on, the web browser displays the message:

This page cannot be displayed.

Solution:

Needed to change Web Profile from DEV to PROD in Application Server config file.

ORA-1654: unable to extend index

This documentation shows the SQL*Plus output for resolving the ORA-01654 error.

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:Documents and Settingsoracle>f:
F:>cd oraclePRODdbtech_st10.2.0
F:oraclePRODdbtech_st10.2.0>PROD_mainfinsrv1.cmd
ECHO is off.
ECHO is off.
Thu 11/12/2009 08:04 PM
PROD_mainfinsrv1.cmd exiting with status 0
F:oraclePRODdbtech_st10.2.0>cd adminPROD_mainfinsrv1bdump
F:oraclePRODdbtech_st10.2.0adminPROD_mainfinsrv1bdump>tail -40 alert_prod.log
Thu Nov 12 19:54:51 2009
ORA-1654: unable to extend index APPLSYS.FND_CRM_HISTORY_U2 by 16 in tablespace
APPS_TS_TX_IDX
Thu Nov 12 19:55:21 2009
ORA-1654: unable to extend index APPLSYS.FND_CRM_HISTORY_U2 by 16 in tablespace
APPS_TS_TX_IDX
F:oraclePRODdbtech_st10.2.0adminPROD_mainfinsrv1bdump>sqlplus apps/apps
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Nov 12 20:05:07 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> desc dba_indexes
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER NOT NULL VARCHAR2(30)
INDEX_NAME NOT NULL VARCHAR2(30)
INDEX_TYPE VARCHAR2(27)
TABLE_OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
TABLE_TYPE VARCHAR2(11)
UNIQUENESS VARCHAR2(9)
COMPRESSION VARCHAR2(8)
PREFIX_LENGTH NUMBER
TABLESPACE_NAME VARCHAR2(30)
INI_TRANS NUMBER
MAX_TRANS NUMBER
INITIAL_EXTENT NUMBER
NEXT_EXTENT NUMBER
MIN_EXTENTS NUMBER
MAX_EXTENTS NUMBER
PCT_INCREASE NUMBER
PCT_THRESHOLD NUMBER
INCLUDE_COLUMN NUMBER
FREELISTS NUMBER
FREELIST_GROUPS NUMBER
PCT_FREE NUMBER
LOGGING VARCHAR2(3)
BLEVEL NUMBER
LEAF_BLOCKS NUMBER
DISTINCT_KEYS NUMBER
AVG_LEAF_BLOCKS_PER_KEY NUMBER
AVG_DATA_BLOCKS_PER_KEY NUMBER
CLUSTERING_FACTOR NUMBER
STATUS VARCHAR2(8)
NUM_ROWS NUMBER
SAMPLE_SIZE NUMBER
LAST_ANALYZED DATE
DEGREE VARCHAR2(40)
INSTANCES VARCHAR2(40)
PARTITIONED VARCHAR2(3)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
BUFFER_POOL VARCHAR2(7)
USER_STATS VARCHAR2(3)
DURATION VARCHAR2(15)
PCT_DIRECT_ACCESS NUMBER
ITYP_OWNER VARCHAR2(30)
ITYP_NAME VARCHAR2(30)
PARAMETERS VARCHAR2(1000)
GLOBAL_STATS VARCHAR2(3)
DOMIDX_STATUS VARCHAR2(12)
DOMIDX_OPSTATUS VARCHAR2(6)
FUNCIDX_STATUS VARCHAR2(8)
JOIN_INDEX VARCHAR2(3)
IOT_REDUNDANT_PKEY_ELIM VARCHAR2(3)
DROPPED VARCHAR2(3)
SQL> select owner, index_name, index_type, tablespace_name, initial_extent, next_extent,
min_Extents, max_extents from dba_indexes where index_name = 'FND_CRM_HISTORY_U2';
OWNER INDEX_NAME
------------------------------ ------------------------------
INDEX_TYPE TABLESPACE_NAME INITIAL_EXTENT
--------------------------- ------------------------------ --------------
NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
----------- ----------- -----------
APPLSYS FND_CRM_HISTORY_U2
NORMAL APPS_TS_TX_IDX 131072
131072 1 2147483645
SQL> DESC DBA_DATA_FILES
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_NAME VARCHAR2(513)
FILE_ID NUMBER
TABLESPACE_NAME VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS VARCHAR2(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
USER_BYTES NUMBER
USER_BLOCKS NUMBER
ONLINE_STATUS VARCHAR2(7)
SQL> SELECT FILE_NAME, TABLESPACE_NAME, BYTES/1024/1024 FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'APPS_TS_TX_IDX';
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME BYTES/1024/1024
------------------------------ ---------------
F:ORACLEPRODDBAPPS_STDATAA_TXN_IND05.DBF
APPS_TS_TX_IDX 1273
F:ORACLEPRODDBAPPS_STDATAA_TXN_IND04.DBF
APPS_TS_TX_IDX 1287
F:ORACLEPRODDBAPPS_STDATAA_TXN_IND03.DBF
APPS_TS_TX_IDX 1577
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME BYTES/1024/1024
------------------------------ ---------------
F:ORACLEPRODDBAPPS_STDATAA_TXN_IND02.DBF
APPS_TS_TX_IDX 1200
F:ORACLEPRODDBAPPS_STDATAA_TXN_IND01.DBF
APPS_TS_TX_IDX 1200
SQL> ALTER TABLESPACE APPS_TS_TX_IDX
2 ADD DATAFILE 'F:ORACLEPRODDBAPPS_STDATAA_TXN_IND06.DBF' SIZE 1200M;
ALTER TABLESPACE APPS_TS_TX_IDX
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> CONNECT SYSTEM/MANAGER
Connected.
SQL> L
1 ALTER TABLESPACE APPS_TS_TX_IDX
2* ADD DATAFILE 'F:ORACLEPRODDBAPPS_STDATAA_TXN_IND06.DBF' SIZE 1200M
SQL> R
1 ALTER TABLESPACE APPS_TS_TX_IDX
2* ADD DATAFILE 'F:ORACLEPRODDBAPPS_STDATAA_TXN_IND06.DBF' SIZE 1200M
Tablespace altered.
SQL> DISC
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> EXIT
F:oraclePRODdbtech_st10.2.0adminPROD_mainfinsrv1bdump>

After R12 Vision Installation, Concurrent Manager Not Starting

Problem: Oracle E-Business Suite R12 was installed on appswindows3. After installation, the Concurrent Manager is not starting.

Solution: Checked Event Viewer. The following messages appear:

Restart ICM (Retries left:0)
ICM process exited with error(1)
FNDLIBR Stopped(1)

Reference:
http://forums.oracle.com/forums/thread.jspa?threadID=591003&start=15&tstart=0

Checked directory: %APPLCSF%%APPLLOG%
G:oracleVIS12instappsVIS12_appswindows3logsapplconclog>

G:oracleVIS12instappsVIS12_appswindows3logsapplconclog>type CM_VIS12_appswindows3.log

List of errors encountered:
………………………………………………………..

_ 1 _
Routine AFPCAL received a return code of failure from routine spiini.

Review your concurrent request log file for more information.
………………………………………………………..

G:oracleVIS12instappsVIS12_appswindows3logsapplconclog>

Type CM_VIS12_appswindows3.log:
Routine AFPCAL received a return code of failure from routine spiini.

To reproduce error, source apps environment and run:

FNDCPUCF apps/apps 0 Y %AD_TOP%admintemplateadctxinf.tmp

Metalink Reference:
Subject: Concurrent Manager Service Fails To Start With Error Code 1067
Doc ID: 434444.1

Cause
The issue is caused because of uninitialized string (New Value #1) in the registry under APPL_CONFIG.

The uninitialized key is causing Concurrent Managers not to come up. In the Task manager FNDLIBR.exe comes up briefly and dies.

Solution
To implement the solution, please execute the following steps:

1. Go into the registry

2. Delete uninitialized key under APPL_CONFIG

3. Retest the issue by starting concurrent manager service

Ran AutoConfig on the database tier:

The above did not work, as there was no uninitialized key under APPL_CONFIG.

Stopped all Oracle application tier services and ran AutoConfig:
cd G:oracleVIS12instappsVIS12_appswindows3adminscripts
adautocfg.cmd

[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:

[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: G:oracleVIS12instappsVIS12_appswindows3admininstall
afcpctx.cmd INSTE8_PRF 1

AutoConfig is exiting with status 1

Metalink Reference:
Bug No: 3815440 (AFCPCTX.CMD FAILS WHEN AUTOCONFIG IS RUN)

Subject: After Doing a Clone All the Concurrent Managers Do Not Start
Doc ID: 555081.1

Subject: After Doing a Clone All the Concurrent Managers Do Not Start
Doc ID: 555081.1

Subject: 11i : Oracle Application Object Library Concurrent Manager Setup Test
Doc ID: 200360.1

Subject: Oracle9i Application Server (9iAS) with Oracle E-Business Suite Release 11i Troubleshooting
Doc ID: 216208.1

R12 Log File Locations

Concurrent Manager Log: %APPLCSF%%APPLLOG%

G:oracleVIS12instappsVIS12_appswindows3logsapplconclog

%APPLCSF%%APPLLOG%

%APPLCSF%%APPLOUT%

Application TNS Listener executable:

G:oracleVIS12appstech_st10.1.2BINTNSLSNR

Application TNS Listener config file:

G:oracleVIS12instappsVIS12_appswindows3ora10.1.2networkadminlistener.ora

Location of dbc file (VIS12.dbc):

G:oracleVIS12instappsVIS12_appswindows3applfnd12.0.0secure

Apache Root:

G:oracleVIS12appstech_st10.1.2ApacheApache

Wiping R12 and reinstalling

Step 1:       Stop all Oracle processes and the Distributed Transaction Coordinator service.

Step 2:       Run regedit and delete the following entries:

 HKEY_LOCAL_MACHINESOFTWAREORACLE
HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesOracle*
HKEY_LOCAL_MACHINESYSTEMControlSet001ServicesOracle*
HKEY_LOCAL_MACHINESYSTEMControlSet003ServicesOracle*

Exit regedit, and then reboot.

 Step 3:Delete the Oracle directory (x:oracleVIS12) and C:Program Filesoracle.

 Empty the recycle bin, and then reboot the computer once more.

 Step 4:Clean up the Program Menu for Oracle entries

 Step 5:Run Rapid Wizard to restart the R12 installation.

Metalink Reference:

Doc ID: 567507.1 (How to Remove an Oracle E-Business Suite Release 12.x Windows Environment)


Running AutoConfig on the Application Tier

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:Documents and SettingsAdministrator>g:
G:>cd oracleVIS12appsapps_stappl
G:oracleVIS12appsapps_stappl>appsinf.cmd
ECHO is off.
ECHO is off.
Tue 11/03/2009 12:35 PM
appsinf.cmd exiting with status 0
ERRORCODE = 0 ERRORCODE_END
G:oracleVIS12appsapps_stappl>APPSVIS12_appswindows3.cmd
ECHO is off.
ECHO is off.
Tue 11/03/2009 12:35 PM
ECHO is off.
ECHO is off.
Setting environment for using Microsoft Visual Studio 2005 x86 tools.
APPSORA.cmd exiting with status 0
G:oracleVIS12appsapps_stappl>cd ..
G:oracleVIS12apps>cd oracleVIS12instappsVIS12_appswindows3adminscripts
G:oracleVIS12instappsVIS12_appswindows3adminscripts>dir
Volume in drive G is ORAAPPSR12
Volume Serial Number is 381E-5906
Directory of G:oracleVIS12instappsVIS12_appswindows3adminscripts
10/30/2009  05:06 PM    <DIR>          .
10/30/2009  05:06 PM    <DIR>          ..
10/30/2009  05:06 PM             4,504 adalnctl.cmd
10/30/2009  05:06 PM             4,759 adapcctl.cmd
10/30/2009  05:06 PM             2,704 adautocfg.cmd
10/30/2009  05:06 PM             4,831 adcmctl.cmd
10/30/2009  05:06 PM             7,086 adexecsql.pl
10/30/2009  05:06 PM             4,901 adformsctl.cmd
10/30/2009  05:06 PM             4,767 adoacorectl.cmd
10/30/2009  05:06 PM             4,758 adoafmctl.cmd
10/30/2009  05:06 PM             4,467 adopmnctl.cmd
10/30/2009  05:06 PM            15,084 adpreclone.pl
10/30/2009  05:06 PM             5,399 adstpall.cmd
10/30/2009  05:06 PM             5,520 adstrtal.cmd
10/30/2009  05:06 PM             1,695 gsmstart.cmd
10/30/2009  02:20 PM    <DIR>          ieo
10/30/2009  05:06 PM             1,656 java.cmd
10/30/2009  05:07 PM             1,426 jtffmctl.cmd
10/30/2009  05:07 PM             6,535 mwactl.cmd
10/30/2009  05:07 PM             2,415 mwactlwrpr.cmd
17 File(s)         82,507 bytes
3 Dir(s)   1,052,397,568 bytes free
G:oracleVIS12instappsVIS12_appswindows3adminscripts>adautocfg.cmd
.
Starting up AutoConfig engine...
.
Tue 11/03/2009
12:41 PM
Enter the APPS user password:apps
The log file for this session is located at: G:oracleVIS12instappsVIS12_app
swindows3adminlog11031241adconfig.log
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location     : G:oracleVIS12instappsVIS12_appswin
dows3
Classpath                   : G:oracleVIS12appsapps_stcomnjavalib
appsborg2.zip;G:oracleVIS12appsapps_stcomnjavaclasses
Using Context file          : G:oracleVIS12instappsVIS12_appswindow
s3appladminVIS12_appswindows3.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Context Value Management Complete. Check Logs for details
ECHO is off.
ECHO is off.
Tue 11/03/2009 12:41 PM
1 file(s) copied.
Script Success, Applications Context update complete.
Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring IGS_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed with errors.
Completed execution of AutoConfig
G:oracleVIS12instappsVIS12_appswindows3adminscripts>

Running AutoConfig on the Database Tier

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:Documents and SettingsAdministrator>g:
G:>cd oracleVIS12dbtech_st10.2.0
G:oracleVIS12dbtech_st10.2.0>VIS12_appswindows3.cmd
ECHO is off.
ECHO is off.
Tue 11/03/2009 12:32 PM
VIS12_appswindows3.cmd exiting with status 0
G:oracleVIS12dbtech_st10.2.0>cd appsutilscriptsVIS12_appswindows3
G:oracleVIS12dbtech_st10.2.0appsutilscriptsVIS12_appswindows3> dir
Volume in drive G is ORAAPPSR12
Volume Serial Number is 381E-5906
Directory of G:oracleVIS12dbtech_st10.2.0appsutilscriptsVIS12_appswindows3
10/30/2009  03:08 PM    <DIR>          .
10/30/2009  03:08 PM    <DIR>          ..
10/30/2009  03:08 PM             2,690 adautocfg.cmd
10/30/2009  03:08 PM             5,262 adchknls.pl
10/30/2009  03:08 PM             3,420 addbctl.cmd
10/30/2009  03:08 PM             3,932 addlnctl.cmd
10/30/2009  03:08 PM             7,089 adexecsql.pl
10/30/2009  03:08 PM             3,441 adlsnodes.cmd
10/30/2009  03:08 PM            14,953 adpreclone.pl
10/30/2009  03:08 PM               837 adstopdb.sql
10/30/2009  03:08 PM             1,251 adstrtdb.sql
9 File(s)         42,875 bytes
2 Dir(s)   1,052,569,600 bytes free
G:oracleVIS12dbtech_st10.2.0appsutilscriptsVIS12_appswindows3> adautocfg.cmd
.
Starting up AutoConfig engine...
.
Tue 11/03/2009
12:34 PM
Enter the APPS user password:apps
The log file for this session is located at: G:oracleVIS12dbtech_st10.2.0a
ppsutillogVIS12_appswindows311031234adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : G:oracleVIS12dbtech_st10.2.0
Classpath                   : ;G:oracleVIS12dbtech_st10.2.0jdbclibojdbc14.jar;G:oracleVIS12dbtech_st10.2.0appsutiljavaxmlparserv2.jar;G:oracleVIS12dbtech_st10.2.0appsutiljava;G:oracleVIS12dbtech_st10.2.0jlibnetcfg.jar;G:oracleVIS12dbtech_st10.2.0jlibldapjclnt10.jar
Using Context file          : G:oracleVIS12dbtech_st10.2.0appsutilVIS12_appswindows3.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Context Value Management Complete. Check Logs for details
Updating rdbms version in Context file to db102
Updating rdbms type in Context file to 32 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.
Completed execution of AutoConfig
G:oracleVIS12dbtech_st10.2.0appsutilscriptsVIS12_appswindows3>

PeopleSoft HR 8.9 Installation Steps

Hardware/Software Specifications

Server Hostname

Server Description IP Address
GLWEBAPP GL Web & App Server 10.x.x.x
GLDBASE GL Database Server 10.x.x.x

The machines that were used in the installation of the PeopleSoft test environments were Dell PowerEdge 2950.

The operating system for both servers was Microsoft Windows Server 2003 R2 Enterprise Edition Service Pack 2.

The GLDBASE machine shall house only the database server software (Microsoft SQL Server 2005).

The GLWEBAPP machine shall house all the other server software:

  • File Server (PeopleTools)
  • Application Server (Tuxedo)
  • Web Server (IBM WebSphere)
  • Batch Server

These two servers were accessed remotely using Remote Desktop Connection. Local administrator accounts were set up on these two machines. The username for these accounts were ProjAdmin1, ProjAdmin2 and ProjAdmin3.

Installation Sequence

The following steps were performed in this sequence to install the PeopleSoft Demo instance:

 PeopleSoft Demo Installation (FSDMO)

  1. Install SQL Server [ok 10-Nov-08]
  2. Install PeopleTools 8.49 on Database Server [17-Nov-08]
  3. Install PeopleTools 8.49 on Application Server [ok 11-Nov-08]
  4. Install Application (Financials) on Database Server [ok 17-Nov-08]
  5. Install Application (Financials) on Application Server [ok 11-Nov-08]
  6. Install Tuxedo (Application Server) [ok 11-Nov-08]
  7. Install PeopleTools 8.49.15 Product Patch on Database Server [ok 17-Nov-08]
  8. Install PeopleTools 8.49.15 Product Patch on Application Server [ok 12-Nov-08]
  9. Install IBM WebSphere (Web Server) [ok 11-Nov-08]
  10. Create Database Manually [ok 18-Nov-08]
  11. Shutdown, Backup Database After Creating
  12. Install PIA for WebSphere (fsdmo) [ok 18-Nov-08] [reinstall WebLogic 28-Nov-08]
  13. Create Application Domain [ok 18-Nov-08]
  14. Install PeopleTools PeopleBooks [ok 18-Nov-08] [reinstall 1-Dec-08]
  15. Install Application PeopleBooks [ok 18-Nov-08] [reinstall 1-Dec-08]
  16. Create Process Scheduler [ok 18-Nov-08]
  17. Apply Maintenance Pack 5 (Financials)

PeopleSoft Demo Installation (FSDEMO)

This FSDEMO installation shall be a plain-vanilla installation (without MP5).

  1. Install SQL Server [already installed]
  2. Install PeopleTools 8.49 on Application Server [ok 15-Dec-08] [E:PSOFTFSDEMO]
  3. Install PeopleTools 8.49 on Database Server [ok 15-Dec-08] [D:PSOFTFSDEMO]
  4. Install Application CDs (Financials) on Database Server [ok 15-Dec-08]
  5. Install Application CDs (Financials) on Application Server [ok 15-Dec-08]
  6. Install PeopleTools 8.49.15 Product Patch on Database Server [ok 15-Dec-08]
  7. Install PeopleTools 8.49.15 Product Patch on Application Server [ok 15-Dec-08]
  8. Install Tuxedo CD (Application Server) [already installed in E:bea]
  9. Install IBM WebSphere CD (Web Server) [already installed in E:IBMWebSphere]
  10. Create Database Manually [ok 18-Nov-08]
  11. Shutdown, Backup Database After Creating
  12. Install PIA for WebSphere (fsdmo) [ok 18-Nov-08] [reinstall WebLogic 28-Nov-08]
  13. Create Application Domain [ok 18-Nov-08]
  14. Install PeopleTools PeopleBooks [ok 18-Nov-08] [reinstall 1-Dec-08]
  15. Install Application PeopleBooks [ok 18-Nov-08] [reinstall 1-Dec-08]
  16. Create Process Scheduler [ok 18-Nov-08]
  17. Apply Maintenance Pack 5 (Financials)

PeopleSoft Sys Installation

  1. Install SQL Server [ok 10-Nov-08]
  2. Install PeopleTools 8.49 on Database Server [17-Nov-08]
  3. Install PeopleTools 8.49 on Application Server [ok 11-Nov-08]
  4. Install Application (Financials) on Database Server [ok 17-Nov-08]
  5. Install Application (Financials) on Application Server [ok 11-Nov-08]
  6. Install Tuxedo (Application Server) [ok 11-Nov-08]
  7. Install PeopleTools 8.49.15 Product Patch on Database Server [ok 17-Nov-08]
  8. Install PeopleTools 8.49.15 Product Patch on Application Server [ok 12-Nov-08]
  9. Install IBM WebSphere (Web Server) [ok 11-Nov-08]
  10. Create Database Manually [ok 18-Nov-08]
  11. Install PIA for WebSphere (fsdmo) [ok 18-Nov-08]
  12. Create Application Domain [ok 18-Nov-08]
  13. Install PeopleTools PeopleBooks [ok 18-Nov-08]
  14. Install Application PeopleBooks [ok 18-Nov-08]
  15. Create Process Scheduler
  16. Install Crystal Reports (on Workstation)
  17. Install Change Assistant
  18. Apply Maintenance Pack 5 (Financials)

Precedence

The SQL Server software must be installed before the PeopleTools.

PeopleTools Product Patch must be installed before PIA.

Step 1: SQL Server Installation

The Microsoft SQL Server 2005 DVD was staged (that is, copied) to D:stagingSQLServer2005 on the GLDBASE machine. After staging, setup.exe from D:stagingSQLServer2005Servers was run.

By default, the following required components were installed prior to installing SQL Server:

  • .NET Framework 2.0
  • Microsoft SQL Native Client
  • Microsoft SQL Server 2005 Setup Support Files

These components were installed to C:Program FilesMicrosoft SQL Server by default.

The other SQL Server components were installed to D:Program FilesMicrosoft SQL Server. These components are:

  • Database Services
    • Data Files
    • Replication
    • Full-Text Search
    • Shared Tools
  • Client Components
    • Connectivity Components
    • Management Tools

The Microsoft SQL Native Client (SNaC) must also be installed on the GLWEBAPP machine in which PeopleTools is installed. To do so, share the D:staging directory on GLDBASE (10.18.14.31). From GLWEBAPP, navigate to \10.x.x.xstagingSQLServer2005Servers. Then run setup.exe.

Allow the required components to install (.NET Framework 2.0, Microsoft SQL Native Client and Microsoft SQL Server 2005 Setup Support Files). Continue the installation and install the Connectivity Components on GLWEBAPP.

Step 2: File Server (PeopleTools) Installation

It was necessary to install up the SQL Server Connectivity Components on the GLWEBAPP because the SQL Server Connectivity Program Directory must be specified as part of the installation.

The seven PeopleTools CDs were staged to the E:stagingCDImages

Note that you MUST install PeopleTools on both nodes.

The following values/options were set as part of the PeopleTools installation on the peoplesoft4hr node:

Variable Value
PeopleSoft (PeopleTools) License code z66smq-22c7mc-3w444e1-2is234-81p1f7
Type of Database Non-Unicode Database
Peoplesoft Application Server Checked
Peoplesoft Batch Server Checked
Peoplesoft Database Server Checked
Peoplesoft File Server Checked
Peoplesoft Web Server Checked
PS_HOME Drectory Name E:PSOFTHR900
ERP Connectors? No
Connectivity Program Directory C:Program FilesMicrosoft SQL Server80Toolsbinn
Install PeopleTools Icons? Yes
PeopleTools Program Group Folder PeopleTools 8.4
Environment Hub machine name Peoplesoft4hr
Environment Hub Port Number 8000
PeopleTools (Product Installation) Checked
PeopleTools System Database Checked
PeopleTools Language Pack Not checked
PeopleTools Language Development Kit Not checked

Step 3: Application Installation

To install the PeopleSoft Enterprise Human Resources Management System and Campus Solutions 9.0 (HR) application, the disk was obtained from the CD. It was unzipped (“exploded”) and staged to the F:stagingcd849-HR directory, in the disk1 directory.

To install the Financials application, navigate to F:stagingcd849-HRdisk1 directory and run setup.exe

The following values/options were entered

Variable Value
PeopleSoft (HRMS) License code
Type of Database Non-Unicode Database
PeopleSoft Application Server Checked
PeopleSoft Batch Server Checked
PeopleSoft Database Server Checked
PeopleSoft File Server Checked
PeopleSoft Web Server Checked
PS_HOME Directory Name E:PSOFTFS900

Step 4: Application Server (Tuxedo) Installation

The Tuxedo 9.1 CD (Windows version) was staged to E:stagingCDImagescd849-Tuxdisk1 on the GLWEBAPP server. To install Tuxedo, run pstuxinstall.exe. This brings up a console interface (as opposed to a GUI wizard).

The following prompts appeared when psstuxinstall.exe is run:

1 file(s) copied.

1 file(s) copied.

BEA Home being defaulted to C:\bea  (y/n)? [y]: n

Please provide a BEA Home: E:\bea

Tuxedo 9.1 will be installed to E:\beaTuxedo9.1  (y/n)? [y]: <Enter>

TListen port being defaulted to 3050  (y/n)? [y]: <Enter>

Accept default TListen password ‘password’  (y/n)? [y]: <Enter>

Are you happy with your selections (y/n)? [y]: <Enter>

Tuxedo 9.1 is being installed on your system….

Tuxedo 9.1 base install completed.

Stopping Tuxedo 9.1 Services…

The TListen 9.1 (Port: 3050) service is stopping..

The TListen 9.1 (Port: 3050) service was stopped successfully.

The BEA ProcMGR V9.1 service is stopping.

The BEA ProcMGR V9.1 service was stopped successfully.

Patch installation completed.

Please note that you must reboot your system before using any Tuxedo 9.1 or PeopleSoft applications.

Press any key to continue…

After installing Tuxedo, the GLWEBAPP server was rebooted remotely.

Step 5: Web Server (WebSphere) Installation

The two IBM WebSphere CDs (Windows version) were staged to the E:stagingCDImagescd849-WebSphere directories, in the disk1 and disk2 directories.

To install IBM WebSphere, navigate to disk1 and run installWAS.bat.

Install to E:IBMWebSphereAppServer

For Environments, choose None, then click Yes to accept the choice.

In the Summary screen, click Next.

Uncheck the Create a new WebSphere Application Server profile, and then click Finish.

Step 6: PeopleTools 8.49.15 Product Patch Installation

Check Customer Connection (now Metalink3 at http://metalink3.oracle.com) for the latest PeopleTools 8.49 Product Patch. As at this time, the latest PeopleTools Product Patch for version 8.49 is 8.49.15.

Download this patch 84915.exe from:

ftp://ftp.peoplesoft.com/outgoing/ptools/84915/84915.exe

(The password for 84915.exe is ‘MisterEd’)

Run 84915.exe and unzip the file to E:stagingCDImages. It automatically creates the cd84915 directory and unzips the file.

From E:stagingCDImagescd84915disk1, run setup.exe. It updates PS_HOME (E:PSOFTFS900) with the updated files.

Step 7: Pure Internet Architecture (PIA) Installation

To create the PIA, change directory to E:PSOFTFS900PsMpPIAInstall and run setup.exe

Install PIA to the IBM WebSphere web server, located in E:IBMWEBSPHEREAppServer.

Application name and web site name should be set to the name of the environment e.g. fsdmo. Create a Multi Server installation, not a Single Server installation.

Note that the port numbers for http and https must not be consecutive.

Web Profile Name, User ID and Password should remain the default.

The Report Repository should be set to E:psreports.

The installation process takes about ten minutes to complete.