How to Install PeopleSoft on Amazon Cloud

Login it http://aws.amazon.com/Cloud

There are two was to manage cloud either via Amazon consoleor via Elasticfox Firefox Extension for Amazon EC2

Via Amazon

VIA FireFox ElasticFox

Install Elasticfox FireFox Extension for Amazon EC2

You can download it from (http://aws.amazon.com/developertools/609?_encoding=UTF8&jiveRedirect=1(

Tools ->

Chose the model

Select CPU / Memory

Once instance is created long to Server. Right click on thehost and select Connect. Point to key file and connect.  Make sure you have downloaded putty  and copy to (c:\program files\Putty\putty.exe  If you are connecting to console you need to convert keys using Putty Genkeys. 

How to connect using Putty toLinux server.

Youneed to down load key you created and convert it to putty format.

Start the PuttyGen program as shown below. If you skipped readingmost of this to get to here, you can download PuttyGen from:http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

Find the key that you made when you made your initial image andclick on load. You will get a dialog box that wants you to load your key filethat you got from Amazon. Find where you dropped your key file (again probablyin downloads). Remember to set your file type to * to see all your files(otherwise it will default to looking for a PPK file, which you do not haveyet).


Click on OK when you find and enter your file name. You should see the dialogbelow that shows the Amazon key was successfully converted from the Amazonformat to the PPK format Putty can read.

Click on OK in the above screen and if everything went well, youshould see the screen below

Click on Save Private Key. You really need to save your privatekey at this point. Remember where you saved your brand new PPK extension key(if you forget where you saved it, search your computer for *.ppk). You havemade it through the first hurdle, and now you need to fire up Putty

Start Firefox ->  Tools -> ; ElasticFox  login to cloud

Right lick on instance and select connect to instance

Pointto key file you

Clickon open , it will open a putty screen

Howto setup Oracle Database.

Changedirectory to /opt/oracle/psft/vm/scripts

Read README File

Run . ./oraclevm-template.sh to install Oracle

Reset Oracle Password else appserver won’t boot

the password will expire within 7 days

select * from dba_profiles where RESOURCE_NAME LIKE'PASSWORD_LIFE_TIME';

ALTER PROFILE default LIMITPASSWORD_LIFE_TIME UNLIMITED;

alter user sysadm identified by SYSADM;

alter user people identified by peop1e;

Install PIA

Start Oracle DB,  ( su– oracle ; dbstart  )

Start listener  ( su –oracle; lsnrctl start)

As PeopleSoft user ( psadm2) run tnsping FS91DEMO  to validate Tnsnames and listener.

Connect to DB using sqlplus : sqlplus sysadm@FS91DEMO  password sysadm

Once you can connect to database start application servers /PIA

Samples Listner.ora

# listener.ora Network Configuration File:/u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

  (SID_LIST =

      (SID_DESC =

         (SID_NAME = PLSExtProc)

         (ORACLE_HOME =/u01/app/oracle/product/11.1.0/db_1 )

         (PROGRAM = extproc)

      )

  (SID_DESC=

        (GLOBAL_DBNAME=fs91dmo)

        (ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1)

        (SID_NAME=FS91DMO)

   )

  )

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL =TCP)(HOST = localhost.localdomain)(PORT = 1521))

      (ADDRESS = (PROTOCOL =IPC)(KEY = EXTPROC1521))

    )

  )

Sample Tnsnames.ora file

[oracle@domU-12-31-39-09-26-31 admin]$ cat tnsnames.ora

# tnsnames.ora Network Configuration File:

ORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL =TCP)(HOST = %hostname% )(PORT = %port%))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

FS91DMO =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL =TCP)(HOST = localhost.localdomain)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = FS91DMO )

    )

  )

If you need word document please email me at sivaran@gmail.com