Daily Archives: June 19, 2015

Installing and Configuring Oracle Configuration Manager for PeopleSoft

Hi All,

In my last blog I shared with you guys how to configure OCM for Oracle E-Business Suite.

In this Blog I have explained how step by step we can install and configure Oracle Configuration Manager for a PeopleSoft Environment. I did this setup long back when I was working on OCM Release 10.3.8.  Before we get started just in brief  how OCM is designed to work and collect data from PeopleSoft environment.

Oracle Configuration Manager works in various number of processes one after another with PeopleSoft (EMF) also known as “PeopleSoft Environment Management Framework” for collecting configuration data from the PeopleSoft environment.

There are no special steps required for the installation and configuration of OCM in the PeopleSoft home. The most import thing required is “PSEMAgent” must be running on the instance for gathering configuration data.

The main functionality of “PSEMAgent”, after crawling is that it drops the environment data in XML format (.psft extension) to the PS_HOME/ccr/state folder from where it is uploaded to the “My Oracle Support” website.

If you want to configure “OCM” for the multiple environments you have to install separate agent in different Environment Home. Later on all the agents can be run at the same time but the important thing to be keep in mind while installation is that we have to edit the agentport in the configuration.properties file for different PSEMAgents for different environment making sure that the port number is not in use.

The default port number used for PSEMAgent is 5283. This will prevent a port conflict.

The OCM collector was originally intended to be installed in the PSEMAgent home but it can now be installed in the root directory, however the process is still the same. Mentioned below are the services that need to be running in the given order.

  • The PSEMHUB has to be up and running.
  • The PSEMAgent has to be started.
  • The OCM collector has to be started
  • Then issue the PSEMAgent recrawl command
  • Then issue the OCM collector command, emCCR collect.

Steps to be followed to Install OCM in Peoplesoft.

  1. Download the latest OCM collector from My Oracle Support (MOS). Select the desired Platform and download the software for the same.
  2. OCM is available for PeopleTools 8.48 and 8.50.10 and later.
  3. The Collector must be installed and configured on each distinct application, batch and web server machine. {If everything is configure on separate machines.}
  4. Unzip the collector into $PS_HOME.
  5. Prior to running PS_HOME/ccr/bin/setupCCR execute the following command in the shell: export LOCKFILE_LOG=/dev/null (Unix and Linux only)
  1. Run $PS_HOME/ccr/bin/setupCCR -s <CSI> <MyOracleSupport ID> to configure OCM .
  2. Configure and start the PSEMHub and PSEMAgents.
  3. In PS_HOME>\PSEMAgent start the StartAgent.Bat. While it is running in the same directory, run the command “Startagent recrawl”.
  4. If running in connected mode, the configuration data will be uploaded automatically into the CCR repository and make it visible on MOS.

The Example given in this document is for the BRDEV environment of PeopleSoft.

==================================================

OCM Installation on the BRDEV Database Server {testdb23 and testdb24}

==================================================

(BRDEV1) (/app/oracle/product/11.2.0.2/dbhome_br/ccr/bin)

oracle@testdb23 $ ./setupCCR -s 14481xxx dksharma@test.com IN

** Installing base package **

Deploying core – Version 10.3.8.0.1

** Registering installation with Oracle Configuration Manager server(s) **

Deploying engines – Version 10.3.8.0.0

Deploying metricdata – Version 10.3.7.0.0

Deploying rda – Version 4.29.12.9.4

Deploying rdacelin – Version 4.29.12.9.4

Deploying scripts – Version 10.3.8.0.1

** Getting package updates from ContentServer **

Deploying rda – Version 4.31.13.3.7

Deploying rdacelin – Version 4.31.13.3.7

** Starting the Oracle Configuration Manager Scheduler **

Oracle Configuration Manager – Release: 10.3.8.0.1 – Production

Copyright (c) 2005, 2013, Oracle and/or its affiliates.  All rights reserved.

——————————————————————

Starting Oracle Configuration Manager…

Waiting for status from Oracle Configuration Manager….

Start Date               30-May-2013 19:40:31

Last Collection Time     –

Next Collection Time     31-May-2013 19:40:00

Collection Frequency     Daily at 19:40

Collection Status        scheduled collection running

Log Directory            /app/oracle/product/11.2.0.2/dbhome_br/ccr/hosts/testdb23.oii.test.com/log

Registered At            30-May-2013 19:40:03

Automatic Update         On

Collector Mode           Connected

Oracle Configuration Manager successfully started.

Oracle Configuration Manager has been configured in connected mode. If the target ORACLE_HOME is running a database, please refer to the “Post-installation Database Configuration” section of the OCM Installation and Administration Guide

(http://www.oracle.com/technology/documentation/ocm.html) to complete the installation.

View configuration data reports and access valuable configuration best

Practices by going to My Oracle Support.

=====================================

“Post-installation Database Configuration”

================================

(BRDEV1) (/app/oracle/product/11.2.0.2/dbhome_br/ccr/bin)

oracle@testdb23 $ cd /app/oracle/product/11.2.0.2/dbhome_br/ccr/admin/scripts

(BRDEV1) (/app/oracle/product/11.2.0.2/dbhome_br/ccr/admin/scripts)

oracle@testdb23 $ ./installCCRSQL.sh collectconfig -s BRDEV1 -r sys

Provide password for the SYSDBA user “sys”:

Successfully installed collectconfig in the database with SID=BRDEV1.

==========================================

OCM Installation on the BRDEV App Server { brtstrp1 }

==========================================

======================

Install OCM in PeolpeSoft Home

======================

D:\psoft\psenv\BRDEV\ccr\bin>setupCCR -s 1448xxxx dksharma@test.com IN

** Installing base package **

Deploying core – Version 10.3.8.0.1 

** Registering installation with Oracle Configuration Manager server(s) **

Deploying engines – Version 10.3.8.0.0

Deploying metricdata – Version 10.3.7.0.0

Deploying rda – Version 4.29.12.9.4

Deploying rdacewin – Version 4.29.12.9.4

Deploying scripts – Version 10.3.8.0.1

** Getting package updates from ContentServer **

Deploying rda – Version 4.31.13.3.7

Deploying rdacewin – Version 4.31.13.3.7

** Starting the Oracle Configuration Manager Scheduler **

Oracle Configuration Manager – Release: 10.3.8.0.1 – Production

Copyright (c) 2005, 2013, Oracle and/or its affiliates.  All rights reserved.

——————————————————————

Starting Oracle Configuration Manager…

Waiting for status from Oracle Configuration Manager….

Start Date               30-May-2013 11:31:39

Last Collection Time     –

Next Collection Time     31-May-2013 11:29:00

Collection Frequency     Daily at 11:29

Collection Status        scheduled collection running

Log Directory            d:\psoft\psenv\brdev\ccr\hosts\brtstrp1.oiiad.com\log

Registered At            30-May-2013 11:29:52

Automatic Update         On

Collector Mode           Connected

Oracle Configuration Manager successfully started.

Oracle Configuration Manager has been configured in connected mode. If the target ORACLE_HOME is running a database, please refer to the “Post-installation Database Configuration” section of the OCM Installation and Administration Guide

(http://www.oracle.com/technology/documentation/ocm.html) to complete the installation.

View configuration data reports and access valuable configuration best practices by going to My Oracle Support.

D:\psoft\psenv\BRDEV\ccr\bin>emCCR status

Oracle Configuration Manager – Release: 10.3.8.0.1 – Production

Copyright (c) 2005, 2013, Oracle and/or its affiliates.  All rights reserved.

——————————————————————

Start Date               30-May-2013 11:31:39

Last Collection Time     30-May-2013 11:31:39

Next Collection Time     31-May-2013 11:29:00

Collection Frequency     Daily at 11:29

Collection Status        idle

Log Directory            d:\psoft\psenv\brdev\ccr\hosts\brtstrp1.oiiad.com\log

Registered At            30-May-2013 11:29:52

Automatic Update         On

Collector Mode           Connected

D:\psoft\psenv\BRDEV\ccr\bin>emCCR collect

Oracle Configuration Manager – Release: 10.3.8.0.1 – Production

Copyright (c) 2005, 2013, Oracle and/or its affiliates.  All rights reserved.

——————————————————————

Collection and upload done.

==================================

Post-Installation in PeopleSoft Configuration

==================================

This step is required only if the Release of PeopleTools is 8.51 and higher or if the Oracle Configuration Manager is updated in the PeopleSoft Home.

 Instrumenting PeopleSoft for Configuration Manager

To configure the PeopleSoft for the configuration collection, perform the below mentioned steps:

  • Run the publisher:

Go to the PS_HOME/ccr/sysman/admin/util directory and run psft_qrypub.bat

            D:\psoft\psenv\BRDEV\ccr\bin>cd

            D:\psoft\psenv\BRDEV\ccr\sysman\admin\util

            D:\psoft\psenv\BRDEV\ccr\sysman\admin\util>psft_qrypub.bat

  • Provide the requested parameters when prompted:

Provide the SOAP url.:

https://<hostname>:<port>/PSIGW/PeopleSoftServiceListeningConnector): Provide HTTPS Listener endpoint

Provide SOAP url. (Format: https://<hostname>: <port>/PSIGW/PeopleSoftServiceListeningConnector):

https://brtstrp1.oii.test.com:8501/PSIGW/PeopleSoftServiceListeningConnector

Provide User ID:

PSSERVICES

Provide Password:

  • Provide Security Credentials when prompted:

Provide User Id:

Provide Password:

===========================

CONFIGURING PSEMAgent for BRDEV

===========================

URL changed in the config file for PSEMAgent:

==============================================

D:\psoft\psenv\BRDEV\PSEMAgent\envmetadata\config

https://brtstrp1.oiiad.com:8501/PSEMHUB/hub

URL changed in the config file for PSEMHub:

==============================================

D:\psoft\psenv\BRDEV\webserv\BRDEV\applications\peoplesoft\PSEMHUB.war\envmetadata\config

https://brtstrp1.oiiad.com:8501/PSEMHUB/hub

===========================

Start the PSEMAgent for BRDEV

===========================

D:\psoft\psenv\BRDEV\PSEMAgent\StartAgent.bat

Started Agent:

===============

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Got Message :recrawl

Results File Last Modified Date   : 1369959942598 Thu May 30 19:25:42 CDT 2013

Agent Object Last Registered Time : 1369959554680 Thu May 30 19:19:14 CDT 2013

INFO Timer-0 EMF_CATEGORY – Re-Register Search Results initiated

Adding attribute PSAppHome: —>D:\psoft/psenv/BRDEV

null

Adding attribute PSAppHome: —>D:\psoft/psenv/BRDEV

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

Sending pulse from ‘com.peoplesoft.emf.peer:id=1’

===========================

OCM Collector has to be Started.

===========================

D:\psoft\psenv\BRDEV\ccr\bin>emCCR status

Oracle Configuration Manager – Release: 10.3.8.0.1 – Production

Copyright (c) 2005, 2013, Oracle and/or its affiliates.  All rights reserved.

——————————————————————

Start Date               30-May-2013 11:31:39

Last Collection Time     30-May-2013 11:31:39

Next Collection Time     31-May-2013 11:29:00

Collection Frequency     Daily at 11:29

Collection Status        idle

Log Directory            d:\psoft\psenv\brdev\ccr\hosts\brtstrp1.oiiad.com\log

Registered At            30-May-2013 11:29:52

Automatic Update         On

Collector Mode           Connected

D:\psoft\psenv\BRDEV\ccr\bin>

=========================================

Issue the StartAgent command with the recrawl option

=========================================

D:\psoft\psenv\BRDEV\PSEMAgent>StartAgent recrawl

INFO main EMF_CATEGORY – Proceeding with matching for AppServer

INFO main EMF_CATEGORY – Proceeding with matching for Decoupled AppServer

INFO main EMF_CATEGORY – Proceeding with matching for prcsserver

INFO main EMF_CATEGORY – Proceeding with matching for CLIENT

INFO main EMF_CATEGORY – Proceeding with matching for Host

INFO main EMF_CATEGORY – Proceeding with matching for WebServer

INFO main EMF_CATEGORY – Proceeding with matching for OAS

INFO main EMF_CATEGORY –  Diff: Hours 0 Minutes 0 Seconds 2

D:\psoft\psenv\BRDEV\PSEMAgent>

================================

Then issue the OCM collector command.

================================

D:\psoft\psenv\BRDEV\ccr\bin>emCCR collect

Oracle Configuration Manager – Release: 10.3.8.0.1 – Production

Copyright (c) 2005, 2013, Oracle and/or its affiliates.  All rights reserved.

——————————————————————

Collection and upload done.

Hope simple and explained document will help you to configure OCM for your PeopleSoft Environment.

Thanks

Deepak Sharma