header

Shell script for stopping and starting App server/PSUNX

This script can be scheduled with cronjob for auto reboot and cache clear for PeopleSoft Application server and Process schedular

#!/bin/ksh

. /export/home/pshrs1/.profile

DATE=`date +%m%d%y%H%M%S`

PS_HOME=/pshrs1/hrms

export PS_HOME

TUXDIR=/pshrm2/tuxedo81

export TUXDIR

echo `date` " Stopping and starting hrs1 Application server..."

cd /pshrs1/hrms/appserv

psadmin -c shutdown -d hrs1 > /pshrs1/hrms/appserv/APPLOG/Stop_$DATE.log

psadmin -p stop -d HRS1 >> /pshrs1/hrms/appserv/APPLOG/Stop_DATE.log

sleep 10

echo `date` " Clearing cache for Application server"

rm -rf /pshrs1/hrms/appserv/hrs1/CACHE/*

sleep 20

psadmin -c boot -d hrs1 > /pshrs1/hrms/appserv/APPLOG/Start_$DATE.log

psadmin -p start -d HRS1 >> /pshrs1/hrms/appserv/APPLOG/Start_$DATE.log

Installation of People Tools Patch 8.48.03 on Solaris OS

The below steps shows how to install Tools patch 8.48.03.

Invoke tools patch as shown below

$ ./setup.solaris -is:javaconsole -console

...................................

.InstallShield Wizard

Initializing InstallShield Wizard...

Searching for Java(tm) Virtual Machine...

...................................

.........................

Preparing Java(tm) Virtual Machine...

..........

Running InstallShield Wizard...

-------------------------------------------------------------------------------

Welcome to the InstallShield Wizard for PeopleTools 8.48

The InstallShield Wizard will install PeopleTools 8.48 on your computer.

To continue, choose Next.

PeopleTools 8.48

Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------

Please Enter your PeopleSoft license code:

License Code (characters 1 to 6) []: zm7ky3

License Code (characters 7 to 12) []: w41m04

License Code (characters 13 to 19) []: 4u863q6

License Code (characters 20 to 25) []: 7oke1m

License Code (characters 26 to 31) []: s7t1f2

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------

For a database platform of 'Oracle', are you installing a:

[X] 1 - Non-Unicode Database

[ ] 2 - Unicode Database

To select an item enter its number, or 0 when you are finished [0]:

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------

For Oracle on Solaris the following can be installed:

[X] 1 - PeopleSoft Application Server

[X] 2 - PeopleSoft Batch Server

[X] 3 - PeopleSoft Database Server

[X] 4 - PeopleSoft Web Server

To select an item enter its number, or 0 when you are finished [0]: 3

[X] 1 - PeopleSoft Application Server

[X] 2 - PeopleSoft Batch Server

[ ] 3 - PeopleSoft Database Server

[X] 4 - PeopleSoft Web Server

To select an item enter its number, or 0 when you are finished [0]:

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------

PeopleTools 8.48 Install Location

Please specify a directory or press Enter to accept the default directory.

Directory Name: [/opt/PT8.48] /apps04/exp89

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

Error: /apps04/exp89 is not writable.

-------------------------------------------------------------------------------

PeopleTools 8.48 Install Location

Please specify a directory or press Enter to accept the default directory.

Directory Name: [/apps04/exp89] /apps01/exp89

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------

Would you like to install Enterprise Resource Planning (ERP) Connectors?

[X] 1 - No

[ ] 2 - Yes

To select an item enter its number, or 0 when you are finished [0]:

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------

Please select the location of the installed Tuxedo software.

Please specify a directory name or press Enter [/opt/tuxedo] /apps01/bea81/tux81/tuxedo81

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------

Please enter the configuration for Environment Management:

Environment Hub machine name: [PSEMHUB] ffeuspluxap35.foxinc.com

Environment Hub port number: [80] 16100

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------

Select the features for "PeopleTools 8.48" you would like to install:

PeopleTools 8.48

To select/deselect a feature or to view its children, type its number:

1. [x] PeopleTools

Other options:

0. Continue installing

Enter command [0]

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

PeopleTools 8.48 will be installed in the following location:

/apps01/exp89

with the following features:

PeopleTools

The following PeopleSoft Servers were selected by you:

PeopleSoft Application Server

PeopleSoft Batch Server

PeopleSoft Web Server

Database Type:

Oracle

ERP Connectors Installation:

Not Selected

Environment Hub Configuration:

Hub machine name: ffeuspluxap35.foxinc.com

Hub port number: 16100

-------------------------------------------------------------------------------

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

Installing PeopleTools 8.48. Please wait...

|-----------|-----------|-----------|------------|

0% 25% 50% 75% 100%

||||||||||||||||||||||||||||||||||||||||||||||||||||||

Creating uninstaller...

Unpacking JRE ...

Setting Files Permission... Please wait

-------------------------------------------------------------------------------

The InstallShield Wizard has successfully installed PeopleTools 8.48. Choose

Finish to exit the wizard.

Press 3 to Finish or 4 to Redisplay [3]

Installing PeopleSoft Application 8.9 on Solaris 10

1) Peoplesoft Application need to be installed over the directory where the PeopleTools installed

2) Enter the below command to invoke PeopleSoft Application Installation and point it to where the People Tools installed

$ ./setup.solaris -is:javaconsole –console

3) Installation starts as below and enters the license code and accept the options as shown below:-

Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------

Please Enter your PeopleSoft license code:

License Code (characters 1 to 6) []: 1377ff

License Code (characters 7 to 12) []: ffffff

License Code (characters 13 to 19) []: ffffff8

License Code (characters 20 to 25) []: 19ff81

License Code (characters 26 to 31) []: 2nk7mk

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------

For a database platform of 'Oracle', are you installing a:

[X] 1 - Non-Unicode Database

[ ] 2 - Unicode Database

To select an item enter its number, or 0 when you are finished [0]:

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------

For Oracle on Solaris the following can be installed:

[X] 1 - PeopleSoft Application Server

[X] 2 - PeopleSoft Batch Server

[X] 3 - PeopleSoft Database Server

[X] 4 - PeopleSoft File Server

[X] 5 - PeopleSoft Web Server

To select an item enter its number, or 0 when you are finished [0]: 4

[X] 1 - PeopleSoft Application Server

[X] 2 - PeopleSoft Batch Server

[X] 3 - PeopleSoft Database Server

[ ] 4 - PeopleSoft File Server

[X] 5 - PeopleSoft Web Server

To select an item enter its number, or 0 when you are finished [0]: 3

[X] 1 - PeopleSoft Application Server

[X] 2 - PeopleSoft Batch Server

[ ] 3 - PeopleSoft Database Server

[ ] 4 - PeopleSoft File Server

[X] 5 - PeopleSoft Web Server

To select an item enter its number, or 0 when you are finished [0]:

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------

PeopleSoft Enterprise Financials and Supply Chain Management 8.9, R1 Install

Location

Please specify a directory or press Enter to accept the default directory.

Directory Name: [/opt/PT8.9] /apps01/exp89

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------

Please select the location of the installed Tuxedo software.

Please specify a directory name or press Enter [/opt/tuxedo] /apps01/bea81/tux81/tuxedo81

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------

Select the features for "PeopleSoft Enterprise Financials and Supply Chain

Management 8.9, R1" you would like to install:

PeopleSoft Enterprise Financials and Supply Chain Management 8.9, R1

To select/deselect a feature or to view its children, type its number:

1. [x] PeopleSoft FIN/SCM Database

2. [x] PeopleSoft FIN/SCM Demo Database

3. [x] PeopleSoft Asset Management

4. [x] PeopleSoft Billing

5. [x] PeopleSoft Cash Management

6. [x] PeopleSoft Catalog Management

7. [x] PeopleSoft Collaborative Supply Mgmt

8. [x] PeopleSoft Common Objects

9. [x] PeopleSoft Contracts

10. [x] PeopleSoft Currency Conversion

11. [x] PeopleSoft Deal Management

12. [x] PeopleSoft Demand Planning

13. [x] PeopleSoft ESA Portal Pack

14. [x] PeopleSoft Engineering

15. [x] PeopleSoft Enterprise Components

16. [x] PeopleSoft Expenses

17. [x] PeopleSoft Financials Portal Pack

18. [x] PeopleSoft Flow Production

19. [x] PeopleSoft General Ledger

20. [x] PeopleSoft Grants

21. [x] PeopleSoft IT Asset Management

22. [x] PeopleSoft Inventory

23. [x] PeopleSoft Inventory Policy Planning

24. [x] PeopleSoft Maintenance Management

25. [x] PeopleSoft Manufacturing

26. [x] PeopleSoft Mobile Time and Expense

27. [x] PeopleSoft Order Management

28. [x] PeopleSoft Pay/Bill Management

29. [x] PeopleSoft Payables

30. [x] PeopleSoft Product Configurator

31. [x] PeopleSoft Program Management

32. [x] PeopleSoft Project Costing

33. [x] PeopleSoft Promotions Management

34. [x] PeopleSoft Proposal Management

35. [x] PeopleSoft Purchasing

36. [x] PeopleSoft Quality

37. [x] PeopleSoft Real Estate Management

38. [x] PeopleSoft Receivables

39. [x] PeopleSoft Resource Management

40. [x] PeopleSoft Risk Management

41. [x] PeopleSoft Services Procurement

42. [x] PeopleSoft Staffing Front Office

43. [x] PeopleSoft Strategic Sourcing

44. [x] PeopleSoft Supplier Contract Mgmt

45. [x] PeopleSoft Supply Chain Portal Pack

46. [x] PeopleSoft Supply Planning

47. [x] PeopleSoft Transaction Billing Prcsr

48. [x] PeopleSoft eBill Payment

49. [x] PeopleSoft eProcurement

50. [x] PeopleSoft eSettlements

51. [x] PeopleSoft eSupplier Connection

Other options:

0. Continue installing

Enter command [0]

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

PeopleSoft Enterprise Financials and Supply Chain Management 8.9, R1 will be installed in the following location:

/apps01/exp89

with the following features:

PeopleSoft FIN/SCM Database

PeopleSoft FIN/SCM Demo Database

PeopleSoft Asset Management

PeopleSoft Billing

PeopleSoft Cash Management

PeopleSoft Catalog Management

PeopleSoft Collaborative Supply Mgmt

PeopleSoft Common Objects

PeopleSoft Contracts

PeopleSoft Currency Conversion

PeopleSoft Deal Management

PeopleSoft Demand Planning

PeopleSoft ESA Portal Pack

PeopleSoft Engineering

PeopleSoft Enterprise Components

PeopleSoft Expenses

PeopleSoft Financials Portal Pack

PeopleSoft Flow Production

PeopleSoft General Ledger

PeopleSoft Grants

PeopleSoft IT Asset Management

PeopleSoft Inventory

PeopleSoft Inventory Policy Planning

PeopleSoft Maintenance Management

PeopleSoft Manufacturing

PeopleSoft Mobile Time and Expense

PeopleSoft Order Management

PeopleSoft Pay/Bill Management

PeopleSoft Payables

PeopleSoft Product Configurator

PeopleSoft Program Management

PeopleSoft Project Costing

PeopleSoft Promotions Management

PeopleSoft Proposal Management

PeopleSoft Purchasing

PeopleSoft Quality

PeopleSoft Real Estate Management

PeopleSoft Receivables

PeopleSoft Resource Management

PeopleSoft Risk Management

PeopleSoft Services Procurement

PeopleSoft Staffing Front Office

PeopleSoft Strategic Sourcing

PeopleSoft Supplier Contract Mgmt

PeopleSoft Supply Chain Portal Pack

PeopleSoft Supply Planning

PeopleSoft Transaction Billing Prcsr

PeopleSoft eBill Payment

PeopleSoft eProcurement

PeopleSoft eSettlements

PeopleSoft eSupplier Connection

The following PeopleSoft Servers were selected by you:

PeopleSoft Application Server

PeopleSoft Batch Server

PeopleSoft Web Server

Database Type:

Oracle

-------------------------------------------------------------------------------

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

Installing PeopleSoft Enterprise Financials and Supply Chain Management 8.9,

R1. Please wait...

|-----------|-----------|-----------|------------|

0% 25% 50% 75% 100%

|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

Setting Files Permission... Please wait

-------------------------------------------------------------------------------

The InstallShield Wizard has successfully installed PeopleSoft Enterprise

Financials and Supply Chain Management 8.9, R1. Choose Finish to exit the

wizard.

Press 3 to Finish or 4 to Redisplay [3]


Installing Web Logic 8.1SP5

Invoke Web Logic8.1 Installation on Solaris server as shown below and accept the options as displayed.The weblogic software should be in the current location.

$ ./install.sh

Installing BEA Web Logic Server 8.1 SP5

./install.sh: whoami: not found

BEA Web Logic Server 8.1 SP5 installation.

Installation log written to /apps01/psoft848/wls81install.log

OS Platform detected to be SunOS sun4u 32-bit

Where would you like to install WebLogic Server 8.1SP5 to [press ENTER to quit]?

/apps01/bea81/wl81sp5

Confirm installation of BEA WebLogic Server 8.1 SP5 to

/apps01/bea81/wl81sp5 [Y]?

Launching installer server815-solaris32.bin. Install logs will be written to /apps01/bea81/wl81sp5/logs/

Extracting 0%....................................................................................................100%

Base product and service pack installation complete.

Installing PeopleSoft provided WebLogic license.

BEA WebLogic Server license install process brought to you by PeopleSoft.

This process will update licenses for WebLogic 6.1 and 8.1 installs in /apps01/bea81/wl81sp5

Existing WebLogic license will be backed up to license.bak

Installing PeopleSoft license for WebLogic Server 8.1 (Step 1 of 2)

Please wait and do not interrupt ....

Done!

Updating license registry. (Step 2 of 2)

WebLogic Server 8.1 license install complete.

Perform patch install

Extracting patch file 'wls81sp5-p1.zip' to /apps01/bea81/wl81sp5

Extracting patch file 'wls81sp5-p2.zip' to /apps01/bea81/wl81sp5

Installation complete. Performing post install cleanup.

Installation of WebLogic 8.1 SP5 to /apps01/bea81/wl81sp5 is complete.

Steps to Earn Money with Google

What is google AdSense?

Google AdSense is one kind of advertising firm. Google is an search engine. With search engine they publish ads. But google AdSense is one kind of advertising programme that general people can participate in this and can earn money with this.

Where google get ads?

It is an simple question to answer. Those who are interested to get many visitor in their website they usually give ads. Not only for visitor but also for advertising something different company give ads by Google adwords.

Where this ads appear?

When you search something with google search you may find some results in the top or right side of the search result. This are google ads. So it is not necessary to tell you what type of advantage the advertise gets. In website you may find link named "ads by google". These are also google ads.

How I get money from adsense?

If you are a member of google adsense you can give ads in your webpage or blog. When people visit your website and click on the ads then google will pay to you.

How much can I earn with this?

It is a good question. Actually it depends on how much the advertise pay for per click. I think If you get 6 clicks then your earning can be $1.50 . But google will not pay you untill your earning reaches $100.

Some easy way to earn with google adsense.

  • Make a google id. You can make this by click here. When the window comes click sign up.
  • If you already have an google id then go to Google adsenseapplication form and fill the form.
  • You have to submit your website url. If you have no website then follow our "Earn money with Blogger" process.
  • Then go to Google adsense an sign in. Here you will get your ad code in manage ad section.
  • Make ad as your choice and then paste in your website and start to earn money.

Earn with blogger ( If you have no website)

  • Make a google id.
  • Click here to go to Blogger.
  • Sign in into Blogger.
  • Write your post.
  • Go to Layout in the top of the window.
  • In layout you see some box. Click to add a Gadget.
  • Select AdSense.
  • By do their formalities go to your mail account and you will see a mail comes from google adsense.
  • Click their given link and fill the form.

Now you can earn money with adsense. Isn't it very easy? Know all in adsense and tips to maintain a good adsense account.

Learn how google trace invalid clicks


Peopletools 8.48.00 tools on Solaris

The below steps shows how to install Tools patch 8.48.03.

Invoke tools patch as shown below

$ ./setup.solaris -is:javaconsole -console

...................................

.InstallShield Wizard

Initializing InstallShield Wizard...

Searching for Java(tm) Virtual Machine...

...................................

.........................

Preparing Java(tm) Virtual Machine...

..........

Running InstallShield Wizard...


-------------------------------------------------------------------------------

Welcome to the InstallShield Wizard for PeopleTools 8.48


The InstallShield Wizard will install PeopleTools 8.48 on your computer.

To continue, choose Next.


PeopleTools 8.48





Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]


-------------------------------------------------------------------------------


Please Enter your PeopleSoft license code:

License Code (characters 1 to 6) []: zm7ky3

License Code (characters 7 to 12) []: w41m04

License Code (characters 13 to 19) []: 4u863q6

License Code (characters 20 to 25) []: 7oke1m

License Code (characters 26 to 31) []: s7t1f2


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]


-------------------------------------------------------------------------------

For a database platform of 'Oracle', are you installing a:

[X] 1 - Non-Unicode Database

[ ] 2 - Unicode Database

To select an item enter its number, or 0 when you are finished [0]:

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------


For Oracle on Solaris the following can be installed:

[X] 1 - PeopleSoft Application Server

[X] 2 - PeopleSoft Batch Server

[X] 3 - PeopleSoft Database Server

[X] 4 - PeopleSoft Web Server


To select an item enter its number, or 0 when you are finished [0]: 3


[X] 1 - PeopleSoft Application Server

[X] 2 - PeopleSoft Batch Server

[ ] 3 - PeopleSoft Database Server

[X] 4 - PeopleSoft Web Server


To select an item enter its number, or 0 when you are finished [0]:

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]


-------------------------------------------------------------------------------

PeopleTools 8.48 Install Location

Please specify a directory or press Enter to accept the default directory.

Directory Name: [/apps04/exp89] /apps01/exp89

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------


Would you like to install Enterprise Resource Planning (ERP) Connectors?

[X] 1 - No

[ ] 2 - Yes

To select an item enter its number, or 0 when you are finished [0]:

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------

Please select the location of the installed Tuxedo software.

Please specify a directory name or press Enter [/opt/tuxedo] /apps01/bea81/tux81/tuxedo81

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------

Please enter the configuration for Environment Management:

Environment Hub machine name: [PSEMHUB] ffeuspluxap35.foxinc.com

Environment Hub port number: [80] 16100

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------

Select the features for "PeopleTools 8.48" you would like to install:

PeopleTools 8.48

To select/deselect a feature or to view its children, type its number:

1. [x] PeopleTools

Other options:

0. Continue installing

Enter command [0]

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

PeopleTools 8.48 will be installed in the following location:

/apps01/exp89

with the following features:

PeopleTools


The following PeopleSoft Servers were selected by you:

PeopleSoft Application Server

PeopleSoft Batch Server

PeopleSoft Web Server


Database Type:

Oracle


ERP Connectors Installation:

Not Selected


Environment Hub Configuration:

Hub machine name: ffeuspluxap35.foxinc.com

Hub port number: 16100




-------------------------------------------------------------------------------


Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]


Installing PeopleTools 8.48. Please wait...



|-----------|-----------|-----------|------------|

0% 25% 50% 75% 100%

||||||||||||||||||||||||||||||||||||||||||||||||||||||


Creating uninstaller...



Unpacking JRE ...



Setting Files Permission... Please wait


-------------------------------------------------------------------------------

The InstallShield Wizard has successfully installed PeopleTools 8.48. Choose

Finish to exit the wizard.


Press 3 to Finish or 4 to Redisplay [3]


Peoplesoft database connectivity

Sometimes it is good to remind how basics stuff are working. The Peoplesoft database connectivity is one of them, once it is set, we never come back onto it. However, it is rather interesting to know exactly what is happening exactly when trying to connect to a Peoplesoft database through the different tool, DataMover, AppDesigner and through the Web. And knowing this can avoid to spend time and wondering why it is does not work. It is also good as a remind what is bootstrap mode (e.g. SYSADM), what is connectid (people).This first part of Peoplesoft database connectivity "series" is focused on DataMover.DataMover is a client tool primarily used to load the database (during a manual database creation), then to export and import data accross environment. It is using Meta-SQL language which is not purely SQL.

Here we'll see different connectivity, with in the ACCESSID (the so-called bootstrap mode, SYSADM user), and with an application user PS (which is different than the PS Oracle user which host only one table and DO NOT have CREATE SESSION privilege).Note : all the tests below have been done from a W2k8 64bit workstation, on Peopletools 8.50.02 , Peoplesoft OVM database server (Peopletools 8.50.02/HCM9.1) and Peoplesoft App/Batch server (Peopletools 8.50.02).Check the database connectivity though SQL*Plus, just to be sure the Oracle client is set properly.For the need of the test, we leave the connectid field blank in Configuration managerAgain, for the need of the test below, we set a level of trace relatively high to know exactly what Peoplesoft is doing behind the scene when we connect onto the db1. DataMover connection in bootstrap Mode (no connectid configured) :There is absolutaly no problem, when connect onto the database in bootstrap mode (SYSADM)So, what's up ? Connectid is not required ?From the log file, here is what we can see :Tuxedo session opened {oprid='SYSADM', appname='TwoTier', addr='//TwoTier:7000', open at 03C97E10, pid=1620}Cur#1.1620.H91TMPLT RC=0 Dur=0.658000 Connect=Primary/H91TMPLT/SYSADM/Cur#1.1620.H91TMPLT RC=0 Dur=0.000000 COM Stmt=SELECT OWNERID FROM PS.PSDBOWNER WHERE DBNAME=:1Cur#1.1620.H91TMPLT RC=0 Dur=0.000000 Bind-1 type=2 length=8 value=H91TMPLTCur#1.1620.H91TMPLT RC=0 Dur=0.000000 Fetch=> It is clearly try (succesfully) to connect as SYSADM onto the database. It means bootstrap mode is nothing, but a database connection with a valid Oracle user.Then it is checking the OWNERID with the DBNAME given in the login screen. It must return a row, otherwise it is error out (we'll see this case later).If we continue to read the logfile :COM Stmt=SELECT OWNERID, TOOLSREL, TO_CHAR(LASTREFRESHDTTM,'YYYY-MM-DD HH24:MI:SS'), TO_CHAR(LASTCHANGEDTTM,'YYYY-MM-DD HH24:MI:SS') FROM SYSADM.PSSTATUSFetchCOM Stmt=SELECT DBID FROM SYSADM.PSSTATUSFetchCOM Stmt=SELECT VERSION, OPERPSWD, ENCRYPTED, SYMBOLICID, ACCTLOCK FROM SYSADM.PSOPRDEFN WHERE OPRID = :1Bind-1 type=2 length=6 value=SYSADMFetchCOM Stmt=SELECT OPRID, VERSION, OPERPSWD, ENCRYPTED, SYMBOLICID, ACCTLOCK FROM SYSADM.PSOPRDEFN WHERE USERIDALIAS = :1Bind-1 type=2 length=6 value=SYSADMFetchDisconnect=> It is also checking if the user we are trying to connect with is an application user, and here we see a difference, an application user must be registered as OPRID (or USERALIASID) into PSOPRDEFN, which is not the case of SYSADM.=>And eventually it is disconnect and reconnect as SYSADM to check a lot of data from PSOPTIONS :Cur#1.1620.H91TMPLT RC=0 Dur=0.006000 DisconnectCur#1.1620.notSamTran RC=0 Dur=0.1560 Connect=Primary/H91TMPLT/SYSADM/Cur#1.1620.notSamTran RC=0 Dur=0.004000 DisconnectCur#1.1620.H91TMPLT RC=0 Dur=0.157000 Connect=Primary/H91TMPLT/SYSADM/Cur#1.1620.H91TMPLT RC=0 Dur=0.003000 CEX Stmt=select pt_tde_encrypt_alg from psoptionsCur#1.1620.H91TMPLT RC=0 Dur=0.004000 FetchTDE Encryption Algorithm: ''Cur#1.1620.H91TMPLT RC=0 Dur=0.002000 COM Stmt=SELECT 'PS_DOES_TABLE_EXIST' FROM PSOPTIONSCur#2.1620.H91TMPLT RC=0 Dur=0.000000 Connect=Primary/H91TMPLT/SYSADM/Cur#2.1620.H91TMPLT RC=0 Dur=0.006000 COM Stmt=SELECT PCODEWIP FROM PSOPTIONSCur#2.1620.H91TMPLT RC=0 Dur=0.001000 COM Stmt=SELECT WSRPDISPMODE FROM PSOPTIONSCur#2.1620.H91TMPLT RC=0 Dur=0.000000 COM Stmt=SELECT PSSDWENABLED FROM PSOPTIONSCur#2.1620.H91TMPLT RC=0 Dur=0.000000 COM Stmt=SELECT PTSVBTNFOCUS FROM PSOPTIONSCur#2.1620.H91TMPLT RC=0 Dur=0.000000 COM Stmt=SELECT MAXSRCH FROM PSOPTIONSCur#2.1620.H91TMPLT RC=0 Dur=0.000000 COM Stmt=SELECT DFLTSEARCH FROM PSOPTIONSCur#2.1620.H91TMPLT RC=0 Dur=0.000000 COM Stmt=SELECT SCROLLABLEGRID FROM PSOPTIONSSo, first conclusion, bootstrap mode is nothing but a connection with an Oracle user wchih is registered in PSDBOWNER table for the given database with CREATE PRIVILEGE and SELECT grant onto the Peopletools tables. And this is rather good, because when we load a database for the first time, there is no other option than this one.2. DataMover connection with application user PS (no connectid configured) :Here it is the same test, but instead of connecting with SYSADM account, we are trying to connect with an application user PS (HCM environment).Should we remind PS is a little special since it is also an Oracle user WITHOUT CREATE SESSION privilege. The last point need to be clear here, otherwise we are going back to the previous test.So this test IS a test with an application user :=> As expected, it failed with the expected error.What about th log file generated :Tuxedo session opened {oprid='PS', appname='TwoTier', addr='//TwoTier:7000', open at 03BC7E10, pid=2484}Cur#0.2484.H91TMPLT RC=1045 Dur=0.245000 Connect=Primary/H91TMPLT/PS/Tuxedo session opened { DisconnectAll at03BC7E10, pid=2484}Ok, it is clear enough, it is trying to connect with PS directly onto the database, nothing else.Here, we got no choice than fill the connectid.3. DataMover connection with application user PS (with connectid configured) :So, let's configure the connectid for PS application user connection test :It is successful connected.How is different the log file from the conection in bootsrap mode ?Tuxedo session opened {oprid='PS', appname='TwoTier', addr='//TwoTier:7000', open at 03B48030, pid=2324}Connect=Primary/H91TMPLT/people/COM Stmt=SELECT OWNERID FROM PS.PSDBOWNER WHERE DBNAME=:1Bind-1 type=2 length=8 value=H91TMPLTFetchCOM Stmt=SELECT OWNERID, TOOLSREL, TO_CHAR(LASTREFRESHDTTM,'YYYY-MM-DD HH24:MI:SS'), TO_CHAR(LASTCHANGEDTTM,'YYYY-MM-DD HH24:MI:SS') FROM SYSADM.PSSTATUSFetchCOM Stmt=SELECT DBID FROM SYSADM.PSSTATUSFetchCOM Stmt=SELECT VERSION, OPERPSWD, ENCRYPTED, SYMBOLICID, ACCTLOCK FROM SYSADM.PSOPRDEFN WHERE OPRID = :1Bind-1 type=2 length=2 value=PSFetchCOM Stmt=SELECT ACCESSID, ACCESSPSWD, ENCRYPTED FROM SYSADM.PSACCESSPRFL WHERE SYMBOLICID = :1Bind-1 type=2 length=7 value=SYSADM1FetchDisconnect=> Here it is all the key security of the Peoplesoft connection.1. It is connecting as connectid (people/peop1e given in Configuration Manager above)2. Check if the given database in the login screen is registered in PSDBOWNER3. It take the SYMBOLICID from PSOPRDEFN for the given user4. With the SYMBOLICID return in step 3, it takes the ACCESSID and password (ACCESSPSWD) - basically the ownerid or bootstrap mode user seen earlier - and finally ENCRYPTED filed as well to know if those data are encrypted or not.5. Disconnect and recoonect as ACCESSID taken at step 4 (note, if the values are not encrypted, Peoplesoft will encrypt them)Cur#1.2324.H91TMPLT RC=0 Dur=0.174000 Connect=Primary/H91TMPLT/SYSADM/Cur#1.2324.H91TMPLT RC=0 Dur=0.016000 CEX Stmt=select pt_tde_encrypt_alg from psoptionsCur#1.2324.H91TMPLT RC=0 Dur=0.001000 FetchTDE Encryption Algorithm: ''Cur#1.2324.H91TMPLT RC=0 Dur=0.000000 COM Stmt=SELECT TO_CHAR(SYSTIMESTAMP,'YYYY-MM-DD-HH24.MI.SS.FF') FROM PSCLOCKCur#1.2324.H91TMPLT RC=0 Dur=0.000000 FetchCur#1.2324.H91TMPLT RC=0 Dur=0.000000 CommitCur#2.2324.H91TMPLT RC=0 Dur=0.000000 Connect=Primary/H91TMPLT/SYSADM/Cur#2.2324.H91TMPLT RC=0 Dur=0.001000 COM Stmt=SELECT SYMBOLICID FROM PSACCESSPRFLCur#2.2324.H91TMPLT RC=0 Dur=0.000000 FetchCur#3.2324.H91TMPLT RC=0 Dur=0.000000 Connect=Primary/H91TMPLT/SYSADM/Cur#3.2324.H91TMPLT RC=0 Dur=0.000000 COM Stmt=SELECT VERSION,ACCESSID,ACCESSPSWD,ENCRYPTED FROM PSACCESSPRFL WHERE SYMBOLICID = :1Cur#3.2324.H91TMPLT RC=0 Dur=0.000000 Bind-1 type=2 length=7 value=SYSADM1Cur#3.2324.H91TMPLT RC=0 Dur=0.000000 FetchCur#3.2324.H91TMPLT RC=0 Dur=0.000000 DisconnectCur#2.2324.H91TMPLT RC=1 Dur=0.000000 Fetch...OM Stmt=SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'SYS'etchisconnectonnect=Primary/H91TMPLT/SYSADM/OM Stmt=SELECT COUNT (DISTINCT LANGUAGE_CD) FROM PSLANGUAGES WHERE INSTALLED = 1etchOM Stmt=SELECT DISTINCT LANGUAGE_CD FROM PSLANGUAGES WHERE INSTALLED = 1etchetchisconnectonnect=Primary/H91TMPLT/SYSADM/OM Stmt=SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'SYS'etchisconnectonnect=Primary/H91TMPLT/SYSADM/OM Stmt=SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'SYS'etchOM Stmt=SELECT VERSION, EMPLID, EMAILID, LANGUAGE_CD, CURRENCY_CD, OPERPSWD, ENCRYPTED, SYMBOLICID, OPRCLASS,ind-1 type=2 length=2 value=PSetchOM Stmt=SELECT COUNT (*) FROM PSROLEUSER WHERE ROLEUSER = :1ind-1 type=2 length=2 value=PSetchOM Stmt=SELECT ROLENAME, DYNAMIC_SW FROM PSROLEUSER WHERE ROLEUSER = :1 ORDER BY ROLENAMEind-1 type=2 length=2 value=PS...1-298 21.06.51 0.000000 Cur#2.2324.H91TMPLT RC=0 Dur=0.000000 COM Stmt=SELECT COUNT (DISTINCT CLASSID) FROM PSROLEUSER A, PSROLECLASS B, PSROLEDEFN C WHERE A.ROLEUSER = :1 AND A.ROLENAME = B.ROLENAME AND B.ROLENAME = C.ROLENAME AND A.ROLENAME = C.ROLENAME AND C.ROLESTATUS = 'A'1-299 21.06.51 0.000000 Cur#2.2324.H91TMPLT RC=0 Dur=0.000000 Bind-1 type=2 length=2 value=PS1-300 21.06.51 0.130000 Cur#2.2324.H91TMPLT RC=0 Dur=0.064000 Fetch1-301 21.06.51 0.001000 Cur#2.2324.H91TMPLT RC=0 Dur=0.001000 COM Stmt=SELECT DISTINCT CLASSID FROM PSROLEUSER A, PSROLECLASS B, PSROLEDEFN C WHERE A.ROLEUSER = :1 AND A.ROLENAME = B.ROLENAME AND B.ROLENAME = C.ROLENAME AND A.ROLENAME = C.ROLENAME AND C.ROLESTATUS = 'A'1-302 21.06.51 0.000000 Cur#2.2324.H91TMPLT RC=0 Dur=0.000000 Bind-1 type=2 length=2 value=PS...It is still difficult at this stage to determine which role is required to connect rhough DataMover, the last query above take them all (from the PS user), and the test is still hidden and does not appear in the log file.=> We won't go through all the queries fired on the connection, there are hundreds, but finally, it is checking if the user we are tying to connect with is allowed to connect to the database with DataMover and open DataMover.This part was the most important one, it is resumed here everything, what's the need of CONNECTID, SYMBOLICID and ACCESSID.4. DataMover connection with PS (3tier mode - absurd testing) :This test does not make sense, DataMover tool is not designed to work in 3tier mode (through the AppServer), but it could be interesting to know what happens then.First, let's configure the a profile with Configuration Manager :And be sure the WSL port is properly configured as well as WSL activated :Then let's try the connection :As expected, that does not work, but interestingly, the log file show us some tables in database have been updated :...Starting conversation SqlAccessSqlAccess SamExec tran=10 stmt=UPDATE PSOPRDEFN SET LASTSIGNONDTTM = TO_TIMESTAMP(:1,'YYYY-MM-DD-HH24.MI.SS.FF')SqlAccess SamCompileNow tran=10 stmt=SELECT 'PS_DOES_TABLE_EXIST' FROM PSACCESSLOG: sendlen=143, retlen=39, elapsSqlAccess SamExec tran=10 stmt=INSERT INTO PSACCESSLOG (OPRID, LOGIPADDRESS, LOGINDTTM, LOGOUTDTTM) VALUES (:1, :SqlAccess SamDestroy tran=10: sendlen=42, retlen=37, elapsed time=0.0110Completed conversation SqlAccess: elapsed time=0.1140, svccnt=4, total sendlen=1497, total retlen=154...Here the login part has been skipped (the 3tier mode will be explored in next part when discussing about AppDesigner), and statement truncated, but the main part is remain to get an idea that nothing is going without being tracked...5. DataMover connection with application user PS (DBNAME <> TNS entry) :Last part of this small study, and this is because many times I've seen questions regarding this.We have a tns enty H91TMPLT, but a different database name. That is not a problem, nowadays we are working with SERVICE_NAME in tnsnames.ora (not anymore with SID), but we should be respectful about one and only one point : the DBNAME in PSDBOWNER must be the same as the client tns entry.Let's try to change it in the back end :Then we want to connect onto our database, client tns entry is H91TMPLT (the SQL*Plus connection works with this one) :Despite my tns entry is correct and works fine with SQL*Plus, it refuses to connect with in DataMover.Let's have a look into the log file :Tuxedo session opened {oprid='PS', appname='TwoTier', addr='//TwoTier:7000', open at 03D08030, pid=2152}Cur#1.2152.H91TMPLT RC=0 Dur=0.153000 Connect=Primary/H91TMPLT/people/Cur#1.2152.H91TMPLT RC=0 Dur=0.001000 COM Stmt=SELECT OWNERID FROM PS.PSDBOWNER WHERE DBNAME=:1Cur#1.2152.H91TMPLT RC=0 Dur=0.000000 Bind-1 type=2 length=8 value=H91TMPLTCur#1.2152.H91TMPLT RC=1 Dur=0.000000 FetchCur#1.2152.H91TMPLT RC=0 Dur=0.005000 DisconnectCur#0.2152.notSamTran RC=1045 Dur=0.142000 Connect=Primary/H91TMPLT/PS/Tuxedo session opened { DisconnectAll at03D08030, pid=2152}=> As usal, at least as we've seen earlier, it is connecting with people user (which is configured here), then the "problem" is starting :1. it is checking for the DBNAME in PSDBOWNER given in the login screen => no row returned2. it is trying to connect as PS and... failed. It would work with SYSADM (bootstrap) though.To be followed, Peoplesoft database connectivity part 2/3 : AppDesignerEnjoy the Peoplesoft security,

B- school admision sample recommendation letter - 3

I think extremely highly of Shanmugaraj Sundarapandian, and therefore it is my great pleasure to write a letter of recommendation on his behalf, for entrance into your MBA program.
Shanmugaraj Sundarapandian has demonstrated his technical and analytical abilities in helping create a new model for ERP Application in Finance/HRMS, and in spearheading the development of tool that used a Maximum Likelihood algorithm for ascribing missing respondent data.
Shanmugaraj is not a native English speaker or writer, and thus, he has had to work very hard to clearly communicate his ideas. I have seen him grow in this area tremendously over the last one and half years. His attentive listening, writing and great enthusiasm has helped him overcome any language limitations. He is both self-confident and self-deprecating, and has a great sense of humor that has helped him form strong relationships with subordinates, peers, and members of our team. His Verbal language is extremely good for Business communication and Management meetings
In all of these areas, Shanmugaraj Sundarapandian has gone beyond expectations, and has out-shined all others in his peer-group at Enterprise technical team. His efforts were recently rewarded with a promotion to the position of Technical team lead recently.Shanmugaraj Sundarapandian is very likeable and ambitious person. I have no doubt that he will be a serious and enthusiastic student, and someday a quite successful senior level manager or entrepreneur that you would be proud to call an alumni.

Thanks & Regards,

B-school Admision sample recommendation letter -2

TO WHOM SO EVER IT MAY CONCERN


I would like to take an opportunity to offer a formal recommendation for Shanmuagraj Sunadarapandian. As the Senior System Administrator I have known Shanmugaraj for approximately four years and feel that he is a deserving candidate for your business school program. Shanmugaraj joined our organization as an entry-System Engineer. Demonstrating an incredible initiative and a strong dedication, he moved up the ranks quickly. After only six months, he was promoted to Senoir system Engineer.
Shanmugaraj leads by example and many people here find her enthusiasm and dedication both inspiring and motivating. As part of the Enterprise application support team, Shanmugaraj has worked hard to build authentic relationships with the employees. His efforts have created a happier and more productive team. I believe Shanmugaraj exhibits many of the qualities that are essential to business managers and business students. An education at your esteemed business school will help him hone these qualities, while enhancing his career opportunities. I highly recommend Shanmuagraj Sunadarapandian for your program and hope that you will carefully consider admission application.

Sincerely,

B- School sample recommendation letter 1

Dear Sir/Madam,
This letter is to serve as my formal recommendation for Shanmugaraj Sundarapandian. He has been my direct report for past 4- years. He has been interested in obtaining an MBA degree for some time now and I feel that he would be an excellent candidate for your esteemed program. During his time here, Shanmugaraj has consistently demonstrated a strong work ethic and a dedication to success. His efforts have produced high quality results time and time again. Last year, Shanmugaraj developed and successfully implemented a plan to streamline our system support Process in onsite/offshore model. The plan was a major undertaking, requiring a great deal of thought and effort on Shanmugaraj behalf.
Shanmugaraj is a creative and original thinker. He has native intelligence, great curiosity about people and ideas, and plenty of common sense that he has applied to solving many problems here at Information Technology division of XXX Inc.,. In addition, he has demonstrated excellent powers of observation, and an ability to communicate and suggest change in effective ways.Though Shanmugaraj reports to me, he is also in team leadership role. Many of his co-workers seek his advice and support. I feel his budding leadership abilities will become even more effective in a business school setting. For these reasons, I highly recommend Shanmugaraj Sundarapandian as a candidate for your MBA program. If you have any questions regarding Shanmugaraj or this recommendation, please contact me.
Sincerely,