Single User DB

Table of Contents
Introduction 1
Data Transfer in PIA(PeopleSoft Internet Architecture) 2
Software Details 2
Installing 64 Bit JDK 2
RDBMS installation - Oracle 11gR2 Server 64-bit Installation (for 64 bit VM) 2
RDBMS installation - Oracle 11gR2 Client 64-bit Installation (for 64 bit VM) 2
PeopleTools installation – 8.54.11c 2
Install Single User Database for HRMS 2
Installation of Oracle Tuxedo 12c VS2012 2
Installation of Java 7, 64 Bit Oracle WebLogic Server 12.1.3 2
How to configure App Server and Process Scheduler for Oracle Environments? 2
How to deploy PIA on WebLogic Server 12.1.3 – Single Server 2
 PeopleSoft Architecture Fundamentals
Introduction
PeopleSoft application runs within the PeopleSoft Internet Architecture (PIA), which requires a variety of
software and hardware elements, including:
 Relational database management system (RDBMS).
 Application server.
 Process Scheduler server.
 Web server.
 Web browsers.
Data Transfer in PIA(PeopleSoft Internet Architecture)

 System Catalog
These tables record information about the database and its contents. The type of information that is stored
in these tables includes table names, column names, and index names
 People Tools tables.
All the raw data that is required is contained in People Tools tables. This includes definitions of the
component, page, fields, navigation, and other elements. This raw data goes to the application server for
assembly as HTML.
 Application data tables.
These tables store data that is directly pertinent to an individual company. The type of information that is
stored in these tables includes ledger names, inventory items, employee names, and payroll data
 Oracle Tuxedo and Oracle Jolt.
Oracle Tuxedo manages the multiple connections to the database and schedules transaction processing.
Oracle Jolt is a Java-based communication protocol, enabling browser requests. Jolt and Tuxedo send the
assembled HTML to the web server
 PeopleSoft Pure Internet Architecture.
Individual Java programs, referred to as servlets or web applications, run in a Java Enterprise Edition
(JEE) container. These programs perform a variety of functions, such as managing the state of each user
session, displaying HTML and application content, providing integration with external systems, and so
on.
 DEMO
Software Details
 Oracle Database Server 11g – 64 bit version if the VM is 64 bit or 32 bit version if the VM is 32
bit
 Oracle 11.2 Client Software
 People Tools Version 8.54.11c
 Tuxedo 12.1.1.0
 WebLogic 12.1.3.0

Prerequisites

Installing 64 Bit JDK

Notes: (please read)
 The internal Java7 JDK installers for Windows is in zip format. Installation involves only unzipping
the file.

Getting the JDK Installer Binaries from Internal Location

For Windows platforms

 You can get the 64 Bit JDK installers (name: “jdk1.7.0_51”) for Windows from the following
internal location.
\\psbldfs\dfs\build\pt\thirdparty_ptdev\Webserver\weblogic\Java7JDK-PT8.55\Windows-64bit

 Obtain the zipped JDK file (jdk1.7.0_51) from the shared location mentioned above and save it
locally.

 Right click on the zip file and choose "Extract All" you will see the following screen.. Please
input a location in your C: drive, for example "C:\", for the files to be extracted.
 After the extraction is done, please CD to directory " C:\jdk1.7.0_51\bin" to check the java
version using command "java -version"

 The version should be:

java version "1.7.0_51"

Java(TM) SE Runtime Environment (build 1.7.0_51-b13)
Java HotSpot(TM) 64-Bit Server VM (build 24.51-b03, mixed mode)
RDBMS installation - Oracle 11gR2 Server 64-bit Installation (for 64 bit VM)

Installation Instructions
 Download the installation file from the below location
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-
094461.html

 Copy win64_11gR2_database_1of2.zip and win64_11gR2_database_2of2.zip into C:\temp\oracle

 Unzip both files into c:\temp\oracle
 Copy all the 4 folders in win64_11gR2_database_2of2/database/stage/Components to
database/stage/Components of win64_11gR2_database_1of2

 Double click on c:\temp\oracle\database\setup.exe (for Win7/Win2008: right-click on

setup.exe and select “Run as administrator” And click “Yes” on the prompt that ask if you want
the following changes to change

 NOTE******* If DB installation fails at any of the below setup, then abort. Delete the folder
Oracle from C:/ drive and start installation again.
 Uncheck “I wish to receive security update via My Oracle Support” and Click Next.
 Click “Yes” to prompt below:

 Select “Install database software only” and Click Next.

 Keep default: “Single instance database installation” and Click Next.
 The Product Language refers to the GUI display of the Oracle DB utilities such as Sql Developer,
Net Configuration Assistant, etc.Keep default English and add any languages you require, then
Click Next.

 Use Default: Enterprise Edition and Click “Select Options”

 Uncheck all components except “Oracle Partitioning”, then Click OK and Click Next in the
page above.

 Click Browse for Oracle Base and find c:\Oracle or d:\Oracle depending on your disk space
situation. The software can be installed on any drive and you may need to create the Oracle
directory. Then Click Next.
 Click Finish to start the install
 The installation progress will be displayed in the page below.


 “The installation of Oracle Database was successful” message should be displayed and Click
Close
Configuring the Listener and Naming Methods configuration
 Invoke the Net Configuration Assistant:

 START -> Programs > Oracle - OraDb11g_home1 -> Configuration and Migration Tools

 Double-Click on “Net Configuration Assistant” (for Win7/Win2008: right-click on “Net

Configuration Assistant” and select “Run as administrator”)

 Select Listener configuration and Click Next

 Select Add, then click Next.
 Default “LISTENER” should be displayed. Click Next

 Default “TCP” should be display, Click Next.

 Default ‘Use the standard port number 1521’ should be checked, Click Next.
 Select NO, Click Next
 You’ll get this dialog, Click Next
 Select Naming Methods configuration and chick Next
 Select Local Naming and Click Next.
 You’ll get the following dialog. Click Next
 At this point the installation of the Oracle DB server software is complete as well as the
configuration of the Oracle listener.
 Click Finish
RDBMS installation - Oracle 11gR2 Client 64-bit Installation (for 64 bit VM)
Installation instructions

 Begin by mapping the following network share:

\\slcnas463.us.oracle.com\pt_rdbms\software
(Do not try to run the install without doing the mapping)

To Map, Go to Start >> Computer. Right Click on Computer, click on ‘Map network drive..’,
select the drive and enter the above path. Click Finish.
 Then copy zip file to a local folder. The installation sources files are different for 32 bit computers and
64 bit computers; make sure you choose the right source files.
 For 64 bit binaries, copy the p10404530_112030_MSWIN-x86-64_4of7.zip file to a local directory from
the following path: (Copy to C:\temp\oracle)
\\slcnas463\pt_rdbms\Oracle Software\Oracle 11g Software\Oracle 11gR2 11.2.0.3\11203-
64bit_client

 Once the p10404530_112030_MSWIN-x86-64_4of7.zip file is copied locally, extract the zip file
to a folder. After extraction is over, go to client folder of it and you will see the setup.exe
program
 Double-Click on setup.exe.

 You may get this dialog if you are installing it on Windows 7/ 2008R2:

 Click Yes
 Oracle 11gR2 installer now checks for pre-requisites.Most important Windows pre-requisite is
256 color display minimum, otherwise the OUI does not start.
 You will get the following dialog: Setting up Client - Step 1 of 6
 Select Custom installation type. Click Next.
 You will get the following dialog:

 Click Next.
 You’ll get the following dialog:

 English is the selected language by default. Click Next.

 You’ll now be asked to enter an Oracle base and home. The default Oracle base is <Drive>:\
apps\<user_id >. Change the Oracle base to C:\oracle or D:\oracle. The Oracle Home will be
automatically changed to <drive specified>:\oracle\product\11.2.0\client_1 if you do not have the
32 bit Oracle 11.2 client installed. If you have the 32 bit Oracle 11.2 client installed, the Oracle
Home will be <drive specified>:\oracle\product\11.2.0\client_2. To help us to remember which
software is the 64 bit Oracle client, change the Oracle Home to read: <drive specified>:\oracle\
product\11.2.0\client_64bit.

 Click Next.
 At this dialog make the selections as indicated below. Please make sure to scroll down to see all
options:
Oracle Database Utilities
Oracle Java Client
SQLPLUS
 Oracle JDBC/THIN Interfaces
Oracle Call Interfaces
Oracle XML Development kit
Oracle Advanced Security
Enterprise Manager Minimal Integration
Oracle Net
Oracle ODBC Driver
Oracle SQL Developer
Oracle Objects for OLE
Oracle Provider for OLE DB
Oracle Data Provider for .NET

 The rest of the options should be unchecked. Click Next to continue.

 A prerequisite check will be done on your system. Usually, the checking is successful. One
common issue is that Oracle will tell you that the current length of the PATH variable is too long
due to multiple software connectivity packages installed. If you have any old software that can
be removed that will help shorten PATH, please do so. If you do not have any old software that
you can remove, then you may check the Ignore All box at the upper right hand corner and then
click on Next to continue with the installation. Important: You should use the Ignore All check
box only if the check for PATH length fails. Any other failed checks should not be ignored.


 You’ll get a summary box:

 Click Install.
 The 11gR2 client installation will now begin. The installation will pause at about 80%:

 Minimize the installation window by clicking on the minus [ - ] sign. Do NOT close the
installation window. Once you minimize the installation window, you’ll see Oracle Net
Configuration Assistant Welcome window.

 Click Next to continue

 You’ll get this dialog. Local Naming is selected by default.

 Click Next.
 This next dialog will prompt for a service name. Use of one your testing databases to validate.
For my example below, I’ll enter PT853.
 Click next to continue.
 You’ll get this dialog. TCP protocol should be preselected. If not, then select TCP.

 Click next to continue.

 You’ll get this dialog. Enter the host name of your testing database. In my example below, I will
enter rtdc79515vmc.
 Click Next.
 You’ll get this dialog. If the DB information entered in the previous dialogs is good, then go
ahead and test.

 Click Next.
 You should get a dialog, indicating the test was successful.
 Click Next to continue
 You’ll get this dialog. The Net Service Name defaults to the Service Name that you entered in
Step 13. The Net Service Name is usually the name of your database. In my example below, I
entered PT853 as my Net Service Name.


 Click next to complete the configuration for that service.
*Note: A more common practice to add services is to directly add the configuration lines at the
tnsnames.ora file.
 You’ll get this dialog. The default is ‘No’, which is fine.

 Click next to continue.

 You’ll get this dialog:

 Click Next to continue

 You’ll get this dialog:

 Click Next to Continue

 You’ll get this dialog:

 Click Finish to continue. The Net Configuration Assistant dialog box will now be gone.
 Bring up the main installation window from Step 10. (Just go the Taskbar and click on the
minimized window.)

 Click Close.
 At this point the 64 bit Oracle 11.2.0.3.0 client has been installed successfully!
 Note: SQL Developer Users

 Go to the 64 bit Oracle client’s %ORACLE_HOME%\sqldeveloper\sqldeveloper\bin. Right click

on the sqldeveloperW.exe. Select Send To -> Desktop (Create Shortcut).
 Double click on the SQL Developer short cut at your desktop.

o You may get “User Account Control” dialog if you are installing it on Windows 7/
2008R2

Click Yes

 Since this is the first time you are launching SQL Developer, you will be prompted to the path to
java.exe. The 64 bit Oracle client’s SQL Developer tool is apparently still 32 bit, and so you’ll
need to give it a 32 bit java executable. If you have the 32 bit Oracle 11.2.0.3.0 client installed,
you may give it the java executable that is under the 32 bit Oracle client’s %ORACLE_HOME%\
jdk\bin\java.exe.
 o If you do not have the 32 bit Oracle 11.2.0.3.0 client installed, you will need to install 32
bit JDK 1.5.0 from \\slcnas463\pt_rdbms\Oracle Software\Oracle 11g Software\Oracle
11gR2 11.2.0.3\ jdk-1_5_0_22-windows-i586-p.exe. When SQL Developer prompts you
for the java location, give it to java.exe from your newly installed JDK 1.5.0, eg. C:\
Program Files (x86)\Java\jdk1.5.0_22\bin\java.exe.

 When prompted to migrate previous SQL Developer settings, you can simply click ‘No’ if you
don’t need your old settings. SQL Developer will launch.
 Similarly install the 32 bit oracle client also.

PeopleTools installation – 8.54.11c

In Order to install PeopleTools 8.54.11c, we will have to install the base version 8.54 first.

PeopleTools installation – 8.54

 Navigate to path \\psbldfs\dfs\build\pt\ptship\pt854

 You will find setup.exe in the path \\psbldfs\dfs\build\pt\ptship\pt854\cd\Disk1

 Double-Click on setup.exe
 Click Next

 Accept the License and Click Next.


 Select the database platform as oracle

 Select “Unicode database” and Click Next.

 Check all the options .Click Next



 Specify the directory where the peopletools have to be installed .E.g.: C:\PT8.54
 Specify the location of Connectivity Program directory (I used C:\Oracle\product\11.2.0\
client_64bit\bin)
 Specify the program group folder

 Enter the Configuration for Environment Management

 Successfully installed message will be displayed

 Once the base version is installed, navigate to the below path.

\\psbldfs\dfs\build\pt\ptship\pt85411c
  You will find setup.exe in the path \\psbldfs\dfs\build\pt\ptship\pt85411c\cd\Disk1

 Double-Click on setup.exe

 Continue the installation similar to that of 8.54 installation. Make sure to give the same directory
path here also (C:\PT8.54)

Configuring PeopleTools

 Navigate to C:\PT8.54\bin\client\winx86\pscfg

 The connect password is peop1e

 Go To profile. Select Default->Edit

  Give the below values in the next page
For Database driver path, provide the bin path of 64 bit (client_1) client
  Click OK.

Install Single User Database for HRMS

Developers need to build Oracle database environment on their own computer. This document is prepared
to provide the instruction for them to restore a database for themselves. The backup is taken on database
server (Oracle on Linux) by EM DBA team and all scripts (eg. suinstall.bat) files for Windows are
generated and packaged to one single zip file along with main backup dump.
 The zipped file is found in FTP server. It is created from Oracle DB setup for Windows platform.
Copy it to the local directory.
 Unzip to database area where the datafiles will be placed.
 Run SUINSTALL batch
o Restore database
o Install service – OracleService<instance name>
o Add TNS entry into C:\Apps\DB\Oracle102\network\admin\tnsnames.ora
How to get the backup dump

 In EM-Central go to the Bass Notiification General page for activity & build_id.
 Search with Activity = HR9 and Build ID=C384.
 The single user location is listed under Single User Database Location.
 \\slcnas455\apps_recovery\ENTERPRISE\opsdba\singleuser

\\slcnas455\apps_recovery\ENTERPRISE\
opsdba\singleuser

 Start>Run>{single user location}

 List of zipped files for single user environment are available

 Copy one of zipped files that you want to restore on your computer. You can copy it to any of
working directories (eg. C:\temp)
  Once it’s copied, unzip the file
 Unzip the file using 7-zip

NOTE*****

You have to untar the .tar part of the file as a second step after unzipping the .gz part.

You also may need to check your 7-zip settings...

 Click Tools → Options

 Go to the “System” tab.
 Make sure “tar” and “gz” are checked off.

Open the .tar folder. Extract the zipped file to the below path.
 Unzip to database area where the datafiles will be placed.
<unzipped the file to C:\SUDB >
Restore the database on our computer

 Open DOS command window and change directory to the location where data files are extracted.
(here C:\SUDB)
 Type suinstall.bat <DBNAME> <Path where PeopleTools installed> <New schema owner
password> and hit Enter
Eg: suinstall.bat MYTEST1 C:\PT8.54 emdbo

 Once restore is successfully done, you will see below kind of screen. If any error occurred in the
middle of restore, please resolve an issue and try it again.
 TNS ENTRY
Make sure the tnsnames.ora file in the path where oracle is installed (C:\Oracle\product\11.2.0\
client_1\network\admin\tnsnames.ora) is populated with the corresponding tns entry for your db.
If it is not present manually enter it

TNSENTRY :
MYTEST1.oradev.oraclecorp.com=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTO
COL=TCP)(HOST=SLC07FXJ.us.oracle.com)(PORT=1521)))(CONNECT_DATA=(SID=MYTEST1)))
Verifying Connectivity
Verify the connectivity thru SQL Developer
Verify the connectivity through and App Designer (The Appdesigner can be accessed from C:\PT8.54\
bin\client\winx86\pside)
Service Information – make sure that, in services the corresponding oracle service is started.
Troubleshoot
 Backup/Restore instructions are not supported by DBA staff. Consult Oracle OTN
manuals to perform these tasks.
 Making duplicate DB – Unzip zipped files to separate directory and run the install
process
 Deleting instance manually
i. Open DOS command window
ii. Type oradim –delete –sid <Instance Name> and hit enter
iii. Delete directory where all datafiles are located

1) Oracle Server is not installed on this computer !!

It means you tried to install single user database on the computer where Oracle Server is not
installed yet.

Solution
Install Oracle Server software first and try it again.
2) TNSNAMES.ORA doesn’t exist

SUINSTALL.BAT looks for TNSNAMES.ORA under the location where TNS_ADMIN registry
value points. TNS_ADMIN.reg automatically set it to point c:\apps\db\oracle102.

Solution
Copy local TNSNAMES.ORA to C:\apps\db\oracle102 and re-run suinstall.bat. If you don’t have
local TNSNAMES.ORA, create blank TNSNAMES.ORA file under C:\apps\db\oracle102
3) Error while processing “3. Resetting security…”
If step 3 failed for any reason, you can still manually complete it.

Solution
1. Run reset.sql thru SQL*Plus. Reset.sql is located in %TEMP%\<SID> by default

2. Run secutiry.dms thru datamover. Secutiry.dms is located in %TEMP%\<SID> by

default
4) ORA-12154
If you get this error after you downloaded tnsnames.ora from \\plertest29\tnsora, please follow
below:
1. Open DOS command windows
2. Change directory to the location where database files reside

3. Run addtns.bat with <DBNAME>, <TNS_ADMIN> parameter

It will automatically add your local DB (MyCRM9 in above screenshot) into

%TNS_ADMIN%\tnsnames.ora.
Our standard for <TNS_ADMIN> is “c:\apps\db\oracle102\network\admin”
Installation of Oracle Tuxedo 12c VS2012

 For Development - \\psbldfs\dfs\build\pt\thirdparty_ptdev\Tuxedo\Tuxedo12c\

 Installer Name:tuxedo12cR1_64_win_2k8_x64_VS2012.exe

 Copy the installer from the share to your Windows box. Double click the binary
“tuxedo12cR1_64_win_2k8_x64_VS2012.exe”

 This would launch the Oracle Tuxedo 12c VS2012 Installer. Click on “OK” to continue.

 Click on Next.
 Click on Next when the following window appears.

 Select Full Installation from following Window. It will be selected by default

 In the next screen you have to choose an Oracle Home. In this screen you might find your
older Oracle homes also listed, you can either choose one of the directories listed or create a
new Home. Click on “Next” to continue.
 The next screen shows your TUXDIR(Installation Location of Tuxedo 12c VS2012). You can
install Tuxedo in any location you like.The recommended location is C:\oracle. Enable
‘Install Samples’ and click Next.
 You can ignore the following error message if it comes
 Depending on Oracle products installed on your server, you might get a different screen.
Accept the default selection and click on “Next”.
 The next screen displays the installation summary. Click on “Install” to continue installation.
After clicking on “Next” you will see a screen showing the progress of your installation.
 Enter the tlisten passwords and click on “Next” to continue with Post Installation setup. We
suggest using ‘password’ as your tlisten password.

 Choose tlistener encryption as ‘LLE’ in your next screen and click on “Next” to continue
with Post Installation Step
 Choose Min Encryption Bits as “0” and Max Encryption Bits as “256”. Click on “Next” to
continue.
 Select “No” for the option “Would you like to configure LDAP for SSL support?”
 Click on “Done” to complete the installation.
  Now try verifying your installation. See the section “Verifying the Installation” for details.

Verifying the Installation

 Verify your installation by running the following commands in successions. You should get
an output similar to the one given in the screenshot.
set TUXDIR=TUX_DIR_PATH
TUX_DIR_PATH\bin\tmadmin –v

 You need to replace TUX_DIR_PATH with path where you have installed Tuxedo.

C:\Oracle\tuxedo11gR1_VS2012\bin>tmadmin -v
INFO: Oracle Tuxedo, Version 12.1.1.0_VS2012, 64-bit, Patch Level (none)
Installation of Java 7, 64 Bit Oracle WebLogic Server 12.1.3

 You need to copy the following link into a new browser session and then copy the installer
“fmw_12.1.3.0.0_wls.jar” into your box.
\\psbldfs\dfs\build\pt\thirdparty_ptdev\Webserver\weblogic\Wls1213\

 Prerequisite: You need to have Oracle (Sun) Java7 JDK installed

 Copy the downloaded installer fmw_12.1.3.0.0_wls.jar and save it locally.

 Open a command prompt and CD to the location where you put the generic WebLogic Server
installer. (Note: On Windows 2008 platforms, you need to run your command prompt as
administrator)

 Set JAVA_HOME to be the location where you installed the Oracle (Sun) Java 7 JDK. For
example, on windows, do the following command while “C:\jdk1.7.0_51” is the location
where the Java 7 JDK had been installed.

 set JAVA_HOME= C:\jdk1.7.0_51

 Make sure that JAVA_HOME is set to the above value in ENVIRONMENT VARIABLES.

 Use the following command to launch the installer:

o %JAVA_HOME%\bin\java -jar fmw_12.1.3.0.0_wls.jar

Note: %JAVA_HOME% should not contain space as you will face issues while deploying PIA.
 It could take up to five minutes for extracting the GUI mode installer. You should see the
following screen when the extraction is done. The screen confirms your intention to install
WebLogic 12.1.3. Click the “Next” button
 Click ‘Next’.

 Enter the location you want to install your Oracle Weblogic Server 12.1.3. Please install Oracle
WebLogic Server 12.1.3 into a new location different from where you installed your previous
versions of WebLogic Server including Oracle WebLogic Server 10.3.5, 10.3.6 and 12.1.3. Then
click on “Next”. If this location does not yet exist, the installer will create it for you.
 The installer will then ask you to select the type of WebLogic installation. If you are not using
Coherence then you can select ‘WebLogic Server Installation’ and proceed further and then click on
“Next”.
 Click ‘Next’
 Click ‘Next’
 Uncheck the security updates and Click ‘Next’.

 Click ‘Yes’ to indicate "I wish to remain uniformed..."

 Click Save Response File and then click ‘Install’ to start installing WebLogic Server. The
response file can be used for silent installation. It takes about 5 to 7 minutes for the installation to
complete.

 Click ‘Next’
  This completes your Windows installation using GUI mode. The configuration wizard should
start automatically. To manually launch the QuickStart configuration wizard, run this executable.

<MW_HOME>\oracle_common\common\bin\config.cmd
 On Configuration Type, enter or browse to your domain location. For example:

C:\Oracle\Middleware\user_projects\domains\base_domain where in this example base_domain is

the domain name.

 Click the Next button.

 On Templates, select the checkbox for this template:

Basic WebLogic Server Domain - 12.1.2.0 [wlserver]*

 Click the Next button.

 On Administrator Account, complete the fields for user name and password for the default user that
will start the domain. The default user is weblogic and the default password is welcome

 Click the Next button.

 On Domain Mode and JDK, for use with JD Edwards EnterpriseOne you must select this radio button
in the Domain Mode section:

Production

 In the JDK section, ensure the radio buttonis selected for the available JDK. For example:

Oracle HotSpot 1.7.0_25 C:\PROGRA~\Java\JDK17~1.0_2

 Click the Next button.

 On Advanced Configuration, check these boxes to modify their settings:
a. Administration Server
b. Node Manager
c. Manager Servers, Clusters and Coherence
 Click the Next button.
 On Administrative Server, complete these fields:
a. Server Name

Enter a name for the Administration Server. For example:

AdminServer

b. Listen address

You can accept the default selection, which is:

All Local Addresses

c. Listen Port
 You must specify this same port number in the URL that starts the Admin Console.

 Click the Next button.

 On Node Manager, in the Node Manager Type section, select this radio button:

Per Domain Default Location

 On Node Manager, in the Node Manager Credentials section, enter valid values for your Node
Manager

 Click the Next button.

 On Managed Servers, ensure that the specified Listen Port is unique for this server and click
the Next button.

 On Configure Clusters, click the Next button to skip this step for purposes of this guide. Refer to
the Note below.
 On Machines, click the Machine tab and then click the Add button to define a machine name.

 Click the Next button.

 On Assign Servers to Machines, in the left pane highlight available servers and use the right arrow
button to assign the available server(s) to the newly defined machine.
 On Configuration Summary, review your selections.
 Click the Create button.
 On Configuration Progress, when the Progress bar indicates the process is 100% complete, click
the Next button.
 On Configuration Success, click the Finish button to exit the wizard.
How to configure App Server and Process Scheduler for Oracle
Environments?

 Configure and Start Application Server

Description:
 Configure an Application Server and boot your domain.

Procedure:
 Run psadmin for your App Server: $PS_HOME\appserv\psadmin.exe
 Create your Application Server Domain:
 Choose Application Server: Option 1
 Create a domain: Option 2
 Enter name of domain: Same as <8.4xDatabaseName>

 Choose the ‘small’ Configuration template: Option 4

 Configure this domain now: “y”

 Configure your new domain:
 Option 15, DBNAME: DB Name Defaulted from <8.4XDatabaseName> selected for domain
name ( SU or network DEV/RE/QA Env as applicable)

 Select Option 16, DBTYPE: If the default value is ‘ MICROSFT’, change it to ‘ORACLE’ for
Oracle DB. If you’re working on a different platforms update accordingly)
 Option 17, UserId: <UserID> (i.e. PS or whatever the Tools User ID for the DB is. )

 Option 17, UserPswd: <UserPassword> (i.e. PS or whatever the Tools Password for the DB is)
 Option 20, AddToPATH: If the default value is ‘C:\Program Files\Microsoft SQL Server\80\
Tools\Binn’, for Oracle change it to
<ORACLE_HOME>\BIN (Eg: C:\Oracle\product\11.2.0\client_1\bin)

 Option 21, ConnectID: Leave default value ‘people’ (people, as in many persons)
 Option 21, ConnectPswd: : Leave default value ‘peop1e’ (peop1e, as in “peop-ONE-e”)
 Option22, ServerName: <server where your database resides> (i.e. If DB is local: <machine
name>. If DB is remote: example is ADDB0104 or your local machine name if it’s your single
user DB) or leave it blank.
 Select Option 8 to change the default Event Notification from ‘Yes’ to ‘No’
 Load configuration as shown: Option 13

 Boot this domain: select Option 1

 Select Option 1 Boot (Serial Boot)

 You should see following screen on successful launch.

 Configure and Start Process Scheduler
Description:
 Configure Process Scheduler Server and boot your domain.
Procedure:
 Run psadmin for your App Server: $PS_HOME\appserv\psadmin.exe
 Create your Application Server Domain:
 Choose Process Scheduler: Option 2

 Select Option 4 – Create Process Scheduler Configuration

 Enter DB Name
 Hit Enter to leave default ‘y’ to configure Process Scheduler Server

 Select 6 to change DB Type, and change it to ORACLE

 Select Option 8 to update User ID. Update this to ‘PS’ or whatever the Tools User ID is.
 Select Option 9 to update User Password. Update this to ‘PS’ or whatever the Tools Password is.
 Leave default Connect ID/Connect Password for Options 10 and 11 as ‘people/Peop1e’
 Select Option 16 to change DBBIN if its pointing to MSS SQL Server Bin. You should see
following values on completion of above steps.

 Select Option 3 to load the configuration

 Bounce the Process Scheduler

 Select the database from the list if multiple databases configured.

 You should see 8 processes started on successful launch

 Note: Even if the number of processes started is 7, you could proceed to the next step
How to deploy PIA on WebLogic Server 12.1.3 – Single Server

Note: The screenshots refers to weblogic 12.1.2.The screens vary doe 12.1.3

 From your PS_HOME/setup/PsPIAInstall, launch setup.bat

 Click 'Next' Enter your PIA_HOME location and click Next.
 Select Oracle WebLogic Server and click Next.
 Choose your WLS_HOME where you installed your WLS12.1.2. If the WLS_HOME is valid,
PIA installer should automatically detect the version of your WLS. Click Next to continue.
 Enter LoginID/Password for your WebLogic Admin Server you wish to use and click Next.
 If PIA installer does not detect any existing PIA, it will only provide you 1 option – Create New
WebLogic Domain. If there is an existing PIA, it will provide two options (i.e., Create New
WebLogic Deomain and Existing WebLogic Domain)
 Enter a domain name you wish to use (default value is peoplesoft).Click Next to continue.
 Select Single Server Domain and click Next to continue.
[ Note: For most of development and QA purpose, we choose 1, however if you are working on
clustering or PeopleBook, you will be using 2 or 3 depending on the environment you wish to
setup.]
 Enter IB User ID and Password. Note down this credentials as you require it for IB Setup
 Enter AppServer Domain Connection Password(Refer the appserver configuration for the domain
connection password. Normally no password is assigned for the same.)
 Enter website name you wish to use. Default value is “ps”. Your PIA URL will be
http://<hostname>:<port>/ps/signon.html
 Enter your AppServer, JSL port, HTTP/HTTPS port number, and domain token value.
Click Next to continue.Please refer appserver configuration for JSL port number.Http port is given as
8000 normally.
  Enter your WebProfile Name you wish to use, and provide UserID/Password and click Next to
continue.

NOTE:The default password is PTWEBSERVER.If it is changed ,it may not work properly.
 Enter Report repository location you wish to use, or accept default c:\psreports and click Next to
continue.
Note: you need to have write access to the location you specify here.
 11. Review the install summary and click Next to continue.

 It will take around 3 minutes to deploy a fresh PIA.

 13. Once the PIA is deployed successfully, you can bring up PIA by running startPIA.cmd from
PIA_HOME/webserv/<domain>/bin
 Accessing the webserver

 The url would be http://slc04jls.us.oracle.com:8000/psp/ps/?cmd=login&languageCd=ENG&

The default username is PS and the default password is PS.