Wednesday, 16 December 2015

P2V(Physical to Virtual) movement with OracleASM

P2V (Physical to virtual) movement means, moving your current environments from physical stacks to Virtual stacks.

I had this task of moving the database server with ASM installed to move to virtual server created using VMware. Tasks involved are:--

1.) Creation of Virtual instance by taking the snapshot of the Physical machine w/o raw disk.
     All the raw disks for ASM mounted in Physical server will become invalid when moving to Virtual                  environment.
2.) Once the Virtual environment is created cross check all mount points and files system.
3.) Create a fresh ASM instance and start cluster services, remember the hostname assigned to Virtual               server have to be same as of Physical server.
4.) Assign new raw disks to Virtual server and slice them for ASM as per your discretion
5.) Take either cold backup by taking a downtime or RMAN backup of all the databases to be moved on a       shared mount point.
6.) Post backup map shared backup mount point to virtual server.
7.) Mapping of common backup mount point to virtual server.
8.) Creating individual Disk Groups in ASM and add multiple disks to each Disk Group.
9.) Restoration of backups on virtual server.

Just switch over the existing IP of Physical server to Virtual server and perform the sanity check after that.

!!Keep Experimenting!!

Friday, 24 July 2015

Weblogic warning Closing socket as no data read from it on,100

In the webserver logs every administrator of PeopleSoft must have seen this warning message.

Closing socket as no data read from it on,197 during the configured idle

This message is nothing to be worried about but do fills up the log files , to avoid this warning message entry in logfiles carry on the following steps

1.Set the parameter -Dweblogic.client.socket.ConnectTimeout=XXXX,measured in milliseconds under JAVA_OPTIONS


Second way of doing this change.

2. Change duration time to a higher value in the below Console path
 Server -> Protocols (tab) -> HTTP (sub-tab) -> Duration

Monday, 29 June 2015

Oracle SES silent installation on Linux using responsefile

Starting with Oracle SES installation and configuration make sure that the certified OS is checked.

SES is not certified on Linux 6

Oracle SES Linux Certifications

Oracle SES is certified to run only on the following Linux operating systems:
  • Oracle Enterprise Linux 4 (Update 6 or higher to support WebLogic)
  • Oracle Enterprise Linux 5
  • Red Hat Enterprise Linux 4 AS and ES (Update 3 or higher)
  • Red Hat Enterprise Linux 5 AS and ES (or later updates)
  • SUSE Linux Enterprise Server 10
  • SUSE Linux Enterprise Server 11

I will explain how to install  SES using a responsefile but you all have the option of running it in easy and friendly GUI mode by setting up the DISPLAY variable.
Oracle provides the SES dump on edelivery in two parts ,which need to be downloaded and unzipped.
SES creates its own database and has separate weblogic server to administer it.

Lets begin the SES installation and Configuration:--

>> Installation has to be done with a non-root user.
>> open the response file make the following changes.
response file includes two parts. You only need to provide values in the first part. Values in the second part have already been set. You should never change them.

ORACLE_HOME_NAME=sesdev --> This is unique and limited to just 8 characters.
ORACLE_BASE=/psoft/oracle --> your oracle software location
ORACLE_HOME=/psoft/oracle/seshome --> this is your ses home location where SES specific files are installed                                                        
SEARCH_DATA_STORAGE_LOCATION=/psoft/oracle/oradata -->directory for datafiles,control files,redo logs.                                                                                                                       
SEARCH_ADMIN_PASSWORD=xxxxxxxx--> this is search serve administrative password and has to be of atleast 8 characters with 1 numerical must.                                                                                
SEARCH_HTTP_PORT=7777 --> this is http port of search server, that will be configured in later stage,  not to mention ports less then 1024 will need root privileges to start the server so avoid that, and also avoid 1521 port
COMPONENT_LANGUAGES=("en") --> choose the various languages from the options given.

The chraracter set is by default AL32UTF8 which is mentioned in part 2 of the response file.

>> i specifically skipped the prerequsite check done by oracle by running this:--

./runInstaller -ignoreSysPrereqs -silent -responseFile /psoft/dumps/ses_11_1_2_2_0_linux64/response/server.rsp

and the installation kicked off going into success

Rest of the configuration in abundance in other blogs, Let me know if any of you run into issues .

Keep Experimenting

Thursday, 23 April 2015

IMAP setup in Peoplesoft

IMAP setup has become very interim in PeopleSoft to make it more user friendly for clients to have approval and reject buttons on the mail only.
Here I am going to only explain the configuration of IMAP and POP3 protocol with PeopleSoft.
I am considering as the imap server.

First of all download the certificates from by logging into gmail and import through PIA.

Then import the root certificate in the pskey, make sure to take the backup of pskey. follow the following link how to do it

how to import certificates in PeopleSoft

Then go to Peopletools>Integration Broker>Integration setup>Nodes and search for the node
Go to the connectors tab and make the configuration as shown in the below screenshot.

MCF_AttRoot:-- Give the path where the mails will be stored
MCF_Attserv:--<webserver domain>/
MCF_Password:-- the encrypted password of the id used to login into gmail
MCF_Port:-- default port on which IMAP is configured
MCF_Protocol:-- IMAP
MCF_UseSSL:-- this has to be mentioned as Y if your imap server is using SSL
MCF_User:-- the gmail user to login into gmail

After making the required entries save the page.
Go to the Main Menu>PeopleTools>MultiChannel Framework>Email>Sample Pages
Username:-- Gmail userID which was configured in the MCF_User
Password:-- password of the gmail user

Then fetch the message count, if it gives the count then the setup is complete.

Keep experimenting.

Thursday, 16 April 2015

How to import certificates in PeopleSoft.

To import the root certificate, please do the following.

1. Put this address into the Browser Address bar;

2. In the pop up window, select Save button and Save the file into local directory with this filename;


3. Double click the certificate file and go to Certification Path tab.

4. Click root certificate GeoTrust and click View Certificate button.

5. In the new certificate window, go to Details tab.

6. Click Copy to File button.

7. Click Next and select Format of

Base-64 encoded X.509(.CER).

8. Click Next and fill in a file name.

9. Click Next and then Finish.

10. Close all the windows.

Copy the c:\temp\ps\rootca.cer to <PS_HOME>\webserv\<Domain> on web server box.

11. Open the command prompt on the web server box and cd to
PS_HOME\webserv\<Domain>.If on tools release 8.49+ the path is: PS_HOME\webserv\<Domain>\bin

12. Type ‘pskeymanager – import’

13. It will prompt you for the password; type password as ‘password’ (it’s default, if you want to change it, you can type something you can remember)

14. It will prompt you for Alias

 Before this open a duplicate command prompt window and go to PS_HOME\webserv\<Domain>\bin and check for existing certificates
Type " pskemanager -list"

15. come to the previous command prompt window and Enter an alias name for the root certificate, e.g. ‘PTTEST’ or any other name (Make sure it does not already exist in your keystore) and in the next step enter the rootca file name ‘rootca.cer’ which you have copied to a file from the certificate sent by certificate provider and then click ‘Enter’

If necessary enter the file path to the certificate.

16. You will see the ‘Trust this Certificate’ prompt as shown below; type ‘yes’

17. It will complete the process and you will see ‘Certificate was added to keystore’

18. Edit file.
Peopletools>Integration Broker>Configuration>Gateways and choose the gateway. Once there click on the Gateway Setup Properties link, enter the userid and password, Click OK. Now, click on the Advanced Properties Page and locate the following code and enter the path to pskey (<PS_HOME>\webserv\<Domain> /keystore/pskey) and the password.
19. On tools release 8.50+ the password must be encrypted.
Uncomment following parameters and make sure they are correct.
secureFileKeystorePath=<path to pskey>
20. Bounce web server.
21. Again type "pskemanager -list" to see the imported certificate listed.
22. Always take the backup of the pskey before doing any import or deletion of certificates.

Thursday, 19 March 2015

PeopleSoft Single Signon using Interaction Hub

I know this is a old delivered functionality of PeopleSoft, but here I will be sharing it in much detail.

In my scenario I want to access HRMS and FSCM through Portal Interaction Hub (PIH), So basically one link with one time login for all the environments.

To implement SSO concept, the single most important thing that all have to understand that the PeopleSoft cookie created after signing in will be shared with all the applications, so the cookie to be shared and be able to autheticate users into different application should be able to find same configurations across all the applications.
In PeopleSoft for every application we have dedicated local_node which appears in the URL by default.

HR application                    HRMS node
FSCM application               ERP node
Portal application                 EMPL node        

For example below is the random link of PIH that appears in the browser,concentrate on the bold :--

In the similar way you can check for HR and FSCM application.

Short Tip:-Create one user across all the environments with necessary roles so that you dont face any issue related to authorization error.

Steps to be undertaken:

1.) Configure the Gateway first, 

2.) Define the Default local nodes EMPL,HRMS and ERP in  PIH,HR and FSCM respectively. Take care of two important settings.
a.) the authentication option may be set to password or certificate, I used password.
b.) on the Portal tab of any node ,the Content URI text  and Portal URI text must be set correct, it is mentioned as example how to set it.

4.)After configuring all the nodes you have to make these nodes trusted for each other.

In PIH make ERP and HRMS node as trusted.
In HR make EMPL,HRMS node as trusted.
In FSCM make EMPL and ERP node as trusted.

5.) Now login to PIH and go to  structure and Content page and traverse to

Here you will find testing links of all the applications.Open the links of FSCM and HR and configure the URL information with the trusted node names.

Now bounce the application server domain and web server domains of all the applications.
Login to PIH you will be able to traverse to FSCM and HRMS from PIH smoothly.

Throw in queries, and keep experimenting.


Monday, 9 March 2015

Email setup with TLS encryption with Peopletools 8.53

 If you are Office 365 implemented which uses Transport Layer Security (TLS) encryption  it is mentioned categorically by oracle that 
it is not supported on PeopleTools 8.53, you need to be on PeopleTools 8.54 to use TLS encryption. There are no workarounds for this. 

Now in a specific scenario where the SMTP server is of office 365 then the only possible way ( i have tried length and breadth) to make it work with Peopletools 8.53,
 you need to setup a intermediate mail server which will understand the mail coming from Peoplesoft and relay it to Office 365 with TLS encrypion and vice sersa.