ORACLE EM DBA

Problems, Solutions, Test Cases from my professional and personal experience in technologies like Oracle Enterprise Manager 13 c,Oracle Enterprise Manager 12c, Oracle Configuration Manager and some other stuff.

Month: June 2015

Configure “BI Publisher Enterprise Reports” in Oracle Enterprise Manager 12cR4

Hi All,

This blog explain what BI Publisher is all about some advantage over Information Publisher also, I’ll show you step by step procedure “How we can configure “BI Publisher Enterprise Reports” in EM12cR4.

Just a brief introduction about BI Publisher, which was introduced in 12.1.0.1.  We all know that BI Publisher is used as an Enterprise Reporting Solution to generate highly formatted documents. Eg. Operational Reports, not only that it can also helps   developers to design data models. We can generate custom reports which can help us leverage existing Infrastructure of our company.

In Previous release “EM12c R1 Cloud Control” the installation and configuration of BI Publisher required more hard work. Separate download of software and an additional 10Gb of space at file system were of few mandatory requirements. However, in EM12c R4 no additional software download is required, it already comes as a package, all you need is to configure it.

Before we go further lets discuss some benefits of this enhanced reporting module.

  • It reduces the complexity and lowers the cost.
  • Has capability to use data from out resource as well.
  • BI Publisher is integrated to use familiar desktop products and other developer tools.

Advantages of BI Publisher over Information Publisher

  • User can create report in different formats like PDF, EXCEL, WORD, HTML etc
  • Users can develop their own custom reports against EM Repository
  • BI Publisher has been integrated with EM Security
  • Access can be granted to administrators on the basis of hierarchy level
  • BI Publisher has been enhanced with scheduling & delivery mechanism like email or FTP.

We can also say the BI Publisher Enterprise Reports is the replacement for deprecated Information Publisher Reporting Capability.

How to confirm if BI Publisher is already configured in EM?

Navigate to “Monitoring -> Reports -> BI Publisher Enterprise Reports”

If BI Publisher is not configured you will get a message displayed “BI PUBLISHER IS NOT CONFIGURED”.

Image0

So the first thing now we have to do is configure BI Publisher.

Steps to follow:

Login to your OMS server and check the status for BI Publisher.

    1. [oracle@hanoemap1 ] $  cd  /app/oracle/product/middleware/OMS12cR4/oms/bin
    2. [oracle@hanoemap1 bin] $  ./emctl status oms –bip_only

Now we since the BI Publisher is not configured, we have to set it up first.

Go to OMS/bin directory and run “congifureBIP” script

Image1

The First time you will run “configureBIP.sh” script, you will be prompted to take backup of OMS.

Image2

Image3

Run “./emctl exportconfig oms” to take the backup of OMS.

Image4

Enter the password of SYSMAN user when prompted.

Image5

You will be notified once the backup is finished.

Image6

Once the backup of OMS is complete execute “configureBIP.sh” script again and type “YES” when prompted.

Image8

Please enter the password for database user with SYSDBA privileges and the password for Weblogic Admin Server when prompted it will executes the Repository creation utility {RCU} to create BI Publisher schema {SYSMAN_BIPLATFORM}

Image10

It will require automatic restart of OMS and extends weblogic domain that contains EM to include BI Publisher and configure it.

Image11

Check the status of BI Publisher now.

Image12

Now login to EM console and navigate to “BI Publisher Enterprise Reporting” under  “Monitoring -> Reports -> BI Publisher Enterprise Reporting”. For the first time if you user is not “Super Administrator” user you will get screen like this.

Image14

Login with SYSMAN (Super Administrator) user and navigate to “BI Publisher Enterprise Reports”. You will able to use BI Publisher feature now.

Image16

You can also grant access to any repository user by using the below mentioned commands after which he/she will be able to access “BI Publisher Enterprise Reports”.

Image15

Hope this document will help you to configure “BI Publisher Enterprise Reports” in your Environment.

Thanks

Deepak Sharma

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

Installation & Configuration of Oracle Configuration Manager for EBS.

In this Blog I have explained how you can configure Oracle Configuration Manager for Oracle E-Business Suite.

Step 1: Download the latest setup for OCM from the Oracle Support Website as per the OS platform.

Download Link:  https://support.oracle.com/epmos/faces/CollectorHome?_adf.ctrl-state=181kh900qr_4&_afrLoop=543226244821158

Step 2: Delete the existing “ccr” directory under the “Application Home” and “Database Home” on both servers if they are not on the same machine.

Step 3: Copy the downloaded latest software of OCM to the “Oracle home” and “Application Home” on the respective servers.

Step 4: Upzip the downloaded file to the “Oracle Home”  and “Application Home” location on the respective servers.

Step 5: Before proceeding further with the Installation Check connectivity with the internet.

The example used in this document is for the EBSSUP

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

OCM @ EBSSUP on testebsap1

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

[appldev@testebsap1 EBSSUP]$ sudo su – applsup

[applsup@testebsap1 ~]$ cd /app/oracle/EBSSUP/apps/tech_st/10.1.3/

[applsup@testebsap1 10.1.3]$ rm -rf ccr/*

[applsup@testebsap1 10.1.3]$ rm -rf ccr

[applsup@testebsap1 10.1.3]$ cp /tmp/p5567658_1038_Linux-x86-64.zip /app/oracle/EBSSUP/apps/tech_st/10.1.3/p5567658_1038_Linux-x86-64.zip

[applsup@testebsap1 10.1.3]$ unzip -d /app/oracle/EBSSUP/apps/tech_st/10.1.3/ p5567658_1038_Linux-x86-64.zip

Archive:  p5567658_1038_Linux-x86-64.zip

creating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/

creating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/bin/

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/bin/OCMJarUtil.class

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/bin/deployPackages

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/bin/emSnapshotEnv

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/bin/lockfile

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/bin/strip_path.awk

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/bin/emocmrsp

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/bin/setupCCR

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/bin/common

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/bin/ocmJarUtil

creating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/config/

creating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/config/default/

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/config/default/ccr.properties

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/config/ccr.properties

creating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/doc/

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/doc/jsse_license.html

creating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/inventory/

creating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/inventory/pending/

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/inventory/pending/core.jar

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/inventory/pending/engines.jar

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/inventory/pending/metricdata.jar

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/inventory/pending/rda.jar

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/inventory/pending/rdacelin.jar

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/inventory/pending/scripts.jar

creating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/lib/

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/lib/OsInfo.class

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/lib/emocmclnt-14.jar

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/lib/emocmclnt.jar

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/lib/emocmcommon.jar

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/lib/http_client_11116.jar

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/lib/http_client_12.jar

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/lib/jcert.jar

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/lib/jnet.jar

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/lib/jsse.jar

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/lib/log4j-core.jar

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/lib/osdt_core3.jar

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/lib/osdt_jce.jar

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/lib/regexp.jar

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/lib/xmlparserv2.jar

creating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/state/

inflating: /app/oracle/EBSSUP/apps/tech_st/10.1.3/ccr/readme.txt

[applsup@testebsap1 10.1.3]$

Step 6: Run the Setup:

Default syntax for the CCR Setup Command:

./setupCCR [-R <response file>]  |  [ -C <OracleSupportHubUrl> ] [<CSI> [[<MyOracleSupportUserName>] [<Country-Code>]]]

Response file and the OracleSupportHubUrl is not required in this case.

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

 INSTALLATION ON THE APPLICATION SERVER

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

 

[applsup@testebsap1 10.1.3]$ cd ccr/bin/

[applsup@testebsap1 bin]$ ./setupCCR -s 14481879 dksharma@example.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               17-May-2013 08:10:34

Last Collection Time     –

Next Collection Time     18-May-2013 08:09:00

Collection Frequency     Daily at 08:09

Collection Status        scheduled collection running

Log Directory            /app/oracle/EBSSUP/inst/apps/EBSSUP_testebsap1/ora/10.1.2/ccr/log

Registered At            17-May-2013 08:10:04

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.

[applsup@testebsap1 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               17-May-2013 08:10:34

Last Collection Time     17-May-2013 08:10:34

Next Collection Time     18-May-2013 08:09:00

Collection Frequency     Daily at 08:09

Collection Status        idle

Log Directory            /app/oracle/EBSSUP/inst/apps/EBSSUP_testebsap1/ora/10.1.2/ccr/log

Registered At            17-May-2013 08:10:04

Automatic Update         On

Collector Mode           Connected

[applsup@testebsap1 bin]$

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

INSTALLATION ON THE DATABASE SERVER

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

ORACLE_HOME = /app/oracle/product/ebssup/db_1/

(EBSSUP) (/app/oracle/product/ebssup/db_1)

oracle@testoradb1 $ cp /tmp/p5567658_1038_Linux-x86-64.zip /app/oracle/product/ebssup/db_1/p5567658_1038_Linux-x86-64.zip

(EBSSUP) (/app/oracle/product/ebssup/db_1)

oracle@testoradb1 $ unzip -d /app/oracle/product/ebssup/db_1/ p5567658_1038_Linux-x86-64.zip

Archive:  p5567658_1038_Linux-x86-64.zip

creating: /app/oracle/product/ebssup/db_1/ccr/

creating: /app/oracle/product/ebssup/db_1/ccr/bin/

inflating: /app/oracle/product/ebssup/db_1/ccr/bin/OCMJarUtil.class

inflating: /app/oracle/product/ebssup/db_1/ccr/bin/deployPackages

inflating: /app/oracle/product/ebssup/db_1/ccr/bin/emSnapshotEnv

inflating: /app/oracle/product/ebssup/db_1/ccr/bin/lockfile

inflating: /app/oracle/product/ebssup/db_1/ccr/bin/strip_path.awk

inflating: /app/oracle/product/ebssup/db_1/ccr/bin/emocmrsp

inflating: /app/oracle/product/ebssup/db_1/ccr/bin/setupCCR

inflating: /app/oracle/product/ebssup/db_1/ccr/bin/common

inflating: /app/oracle/product/ebssup/db_1/ccr/bin/ocmJarUtil

creating: /app/oracle/product/ebssup/db_1/ccr/config/

creating: /app/oracle/product/ebssup/db_1/ccr/config/default/

inflating: /app/oracle/product/ebssup/db_1/ccr/config/default/ccr.properties

inflating: /app/oracle/product/ebssup/db_1/ccr/config/ccr.properties

creating: /app/oracle/product/ebssup/db_1/ccr/doc/

inflating: /app/oracle/product/ebssup/db_1/ccr/doc/jsse_license.html

creating: /app/oracle/product/ebssup/db_1/ccr/inventory/

creating: /app/oracle/product/ebssup/db_1/ccr/inventory/pending/

inflating: /app/oracle/product/ebssup/db_1/ccr/inventory/pending/core.jar

inflating: /app/oracle/product/ebssup/db_1/ccr/inventory/pending/engines.jar

inflating: /app/oracle/product/ebssup/db_1/ccr/inventory/pending/metricdata.jar

inflating: /app/oracle/product/ebssup/db_1/ccr/inventory/pending/rda.jar

inflating: /app/oracle/product/ebssup/db_1/ccr/inventory/pending/rdacelin.jar

inflating: /app/oracle/product/ebssup/db_1/ccr/inventory/pending/scripts.jar

creating: /app/oracle/product/ebssup/db_1/ccr/lib/

inflating: /app/oracle/product/ebssup/db_1/ccr/lib/OsInfo.class

inflating: /app/oracle/product/ebssup/db_1/ccr/lib/emocmclnt-14.jar

inflating: /app/oracle/product/ebssup/db_1/ccr/lib/emocmclnt.jar

inflating: /app/oracle/product/ebssup/db_1/ccr/lib/emocmcommon.jar

inflating: /app/oracle/product/ebssup/db_1/ccr/lib/http_client_11116.jar

inflating: /app/oracle/product/ebssup/db_1/ccr/lib/http_client_12.jar

inflating: /app/oracle/product/ebssup/db_1/ccr/lib/jcert.jar

inflating: /app/oracle/product/ebssup/db_1/ccr/lib/jnet.jar

inflating: /app/oracle/product/ebssup/db_1/ccr/lib/jsse.jar

inflating: /app/oracle/product/ebssup/db_1/ccr/lib/log4j-core.jar

inflating: /app/oracle/product/ebssup/db_1/ccr/lib/osdt_core3.jar

inflating: /app/oracle/product/ebssup/db_1/ccr/lib/osdt_jce.jar

inflating: /app/oracle/product/ebssup/db_1/ccr/lib/regexp.jar

inflating: /app/oracle/product/ebssup/db_1/ccr/lib/xmlparserv2.jar

creating: /app/oracle/product/ebssup/db_1/ccr/state/

inflating: /app/oracle/product/ebssup/db_1/ccr/readme.txt

(EBSSUP) (/app/oracle/product/ebssup/db_1)

oracle@testoradb1 $

(EBSSUP) (/app/oracle/product/ebssup/db_1/ccr/bin)

oracle@testoradb1 $ ./setupCCR -s 14481879 dksharma@example.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               17-May-2013 08:26:53

Last Collection Time     –

Next Collection Time     18-May-2013 08:26:00

Collection Frequency     Daily at 08:26

Collection Status        scheduled collection running

Log Directory            /app/oracle/product/ebssup/db_1/ccr/hosts/testoradb1.oii.example.com/log

Registered At            17-May-2013 08:26:22

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.

(EBSSUP) (/app/oracle/product/ebssup/db_1/ccr/bin)

oracle@testoradb1 $ ./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               17-May-2013 08:26:53

Last Collection Time     17-May-2013 08:26:53

Next Collection Time     18-May-2013 08:26:00

Collection Frequency     Daily at 08:26

Collection Status        idle

Log Directory            /app/oracle/product/ebssup/db_1/ccr/hosts/testoradb1.oii.example.com/log

Registered At            17-May-2013 08:26:22

Automatic Update         On

Collector Mode           Connected

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

POST INSTALLATION STEP ON THE DATABASE SERVER { Instrumenting the Database of Configuration Collection}

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

Run the post installation Scripts on the database server for specific home. To configure the database for configuration collection, perform the following steps:

Navigate to the scripts folder :

(EBSSUP) (/app/oracle/product/ebssup/db_1/ccr/bin)

oracle@testoradb1 $ cd /app/oracle/product/ebssup/db_1/ccr/admin/scripts/

Here in this folder we have to run the “installCCRSQL.sh” script which will prompt for the SYSDBA-USER Password.

(EBSSUP) (/app/oracle/product/ebssup/db_1/ccr/admin/scripts)

oracle@testoradb1 $ ./installCCRSQL.sh  collectconfig  -s EBSDEV –r  sys

Provide password for “SYS”:

Successfully installed collectconfig in the database with SID=EBSSUP.

Note:

For the RAC databases the “installCCRSQL.sh” must be run against only one instance, but OCM must be installed in all the instance homes.

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

ADDITIONAL STEP FOR EBS DATABASE ONLY

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

EBSDEV) (/app/oracle/product/ebsdev/db_1/ccr/bin)

oracle@testoradb1 $ cd /app/oracle/product/ebsdev/db_1/ccr/admin/scripts/

For the EBS database run the “installCCRSQL.sh” with the “ebs_collectconfig” option.  The –u parameter in the syntax is mandatory value for which is the “Oracle application User” and –s  option specifies the SID of the database.

(EBSSUP) (/app/oracle/product/ebsdev/db_1/ccr/admin/scripts)

oracle@testoradb1 $ ./installCCRSQL.sh ebs_collectconfig -u APPS -s EBSSUP

Provide password for “APPS”:

Successfully installed ebs_collectconfig in the database with SID=EBSSUP.

Step 7: Navigate back to the CCR bin directory and issue the “emCCR collect” command to upload the configuration to the MOS.

(EBSSUP) (/app/oracle/product/ebsdev/db_1/ccr/admin/scripts)

oracle@testoradb1 $ cd /app/oracle/product/ebssup/db_1/ccr/bin

(EBSSUP) (/app/oracle/product/ebssup/db_1/ccr/bin)

oracle@testoradb1 $ ./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.

© 2017 ORACLE EM DBA

Theme by Anders NorenUp ↑