Sunday 29 January 2012

PIA Installation

Configure PIA

Navigate to – PS_HOME\setup\PsMpPIAInstall

Run the command – setup.bat


















Start the PIA

Navigate to – PS_HOME\webserv\<DOMAIN>\bin and run startPIA (double click on the command)



Wait until the status changes to Running mode.



Otherwise, you can create a NT service for the PIA using the following -

Navigate to – PS_HOME\webserv\<DOMAIN>\bin and run installNTservicePIA.cmd




Now, go the services and start the service –


Peoplesoft-PIA



Now, access the front end.




Configure Process Scheduler



Navigate to PS_HOME/appserv and run psadmin.exe





As done while application server configuration, set the userid and password.



Load the above changes.


Start the process scheduler.







Configure Application Server

Application Server Configuration

Navigate to PS_HOME/appserv and run psadmin.exe




Enter 1 and press Enter.



Since we are creating a domain, so 2 and press enter.


Enter the domain name.







Enter the user id.


Enter User Password.


Load the above changes.


Boot the domain. 



Database Creation

Database Creation

  1. Create a folder of as per your database name under C:\app\<user>\oradata to hold the control files.
  2. Create a init<SID>.ora file under - <ORACLE_HOME>/database directory.
This file will have the following contents –

DB_NAME = PSH91DMO
DB_FILES = 1021
OPEN_CURSORS = 1000
db_block_size = 8192

control_files = ("C:\app\Administrator\oradata\PSH91DMO\control01.ctl",
                 "C:\app\Administrator\oradata\PSH91DMO\control02.ctl",
                 "C:\app\Administrator\oradata\PSH91DMO\control03.ctl")
  1. Create ORACLE_SID environment variable.


               
  1. Create windows service for database instance.
i.                      Log in to the command prompt as an administrator.
ii.                     Type the following command – set ORACLE_SID = PSH91DMO
iii.                    Now, type the following command to create the service –

oradim -new -sid PSH91DMO -intpwd manager -startmode auto -pfile C:\app\Administrator\product\11.2.0\dbhome_1\database\initPSH91DMO.ora


  1. Navigate to PS_HOME/scripts/nt directory and edit the file createdb10.sql file as per your environment – (before editing please take the backup of all the scripts).
Basically, change the paths mentioned in the script file as per the paths here in the environment.

set echo on
spool createdb.log

REMARK startup nomount pfile=%ORACLE_HOME%\dbs\init<SID>.ora
startup nomount pfile=%ORACLE_HOME%\database\initPSH91DMO.ora

CREATE DATABASE   PSH91DMO
    maxdatafiles  1021
    maxinstances  1
    maxlogfiles   8
    maxlogmembers 4
    CHARACTER SET WE8ISO8859P15
    NATIONAL CHARACTER SET UTF8
DATAFILE 'C:\app\Administrator\oradata\PSH91DMO\system01.dbf' SIZE 2000M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE 'C:\app\Administrator\oradata\PSH91DMO\sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'C:\app\Administrator\oradata\PSH91DMO\temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED
UNDO TABLESPACE "PSUNDOTS" DATAFILE 'C:\app\Administrator\oradata\PSH91DMO\psundots01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT  5120K MAXSIZE UNLIMITED
LOGFILE GROUP 1 ('C:\app\Administrator\oradata\PSH91DMO\redo01.log') SIZE 100M,
        GROUP 2 ('C:\app\Administrator\oradata\PSH91DMO\redo02.log') SIZE 100M,
        GROUP 3 ('C:\app\Administrator\oradata\PSH91DMO\redo03.log') SIZE 100M;


  1. login to sqlplus using – 

  1. Now, shutdown the database using – shutdown immediate.


  1. Now run the createdb10.sql command in the sql prompt.

  1. Edit and run utlspace.sql

  1. Run dbowner.sql


  1. Run hcddl.sql


  1. Run the script psroles.sql



  1. Run the script psadmin.sql


Enter the values of owner id, owner id password and tablespace.

  1. Run the script connect.sql

  1. Now, update the TNSNAMES.ORA





Save the changes.

Now, add a new naming service.









Save the configuration.
Restart the listener and database.

Now test the connectivity.



  1. Open the registry and navigate to – HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE




Click Ok and exit the registry.

Import the DataMover Scripts

  1. Configure the configuration manager.

Connect id will be people and connect password will be – peop1e
Apply and then Ok.

  1. Now, login into Datamover










Check out the log files –




Running VERSION Application Engine


In command prompt, navigate to <PS_HOME>/bin/client/winx86 and run the following command -

psae -CD PSH91DMO -CT ORACLE -CO PS –CP PS -R INSTALL -AI VERSION




Run SQR SETSPACE

Navigate to PS_HOME\bin\sqr\ORA\binw

 Start sqrw.exe

In the report arguments type the following –

-ZIFC:\PT8.50\sqr\pssqr.ini -IC:\PT8.50\sqr\ -fC:\temp\ddsaudit.htm -keep -printer:ht