Category Archives: Uncategorized

Service Test failed on OEM12c due to JAVA7 upgrade


Recently I faced issue with my Service Tests created for ENOVIA application. Java was upgraded from Java 1.6_24 to Java1.7_79 on our Enovia Servers.

Everytime when I perform verify Service test I get “Remote host closed connection during handshake–” Error message .

Since then all the Service Test for ENOVIA were showing down but on the contrary all other Service tests for other applications are working fine.

Now OEM12c supports only till Java 6 Update 95, and this java upgrade was causing the Service Test to failed at every run. So the only workaround I was thinking was either upgrade my OEM to 13c which support JAVA or if possible lower the version of JAVA on ENOVIA servers.

What I did to resolve this Issue.


Service test failed: “Remote host closed connection during handshake–” Error message .


Java upgrade from Java 1.6_24 to Java1.7_79


Steps for Implementing TLSv1 with OEM to Fix Poodle Attack (Doc ID 2059368.1)

Steps to be followed:

  1. Applied recommended patches and update java on OMS to jdk 6 update 95.
  2. Update Java on the agent {Beacon Agent} host to jdk 6 update 95.
    1. [NOTE: This step is required only when the agents are monitoring TLSv1 enabled 12.1.3 middleware targets]
    2. Download the Patch 20418674 from Doc ID 1439822.1 All Java SE Downloads on MOS
    3. Follow the instructions as per the example given in Doc ID 1944044.1 EM12c: How to Use / Update JDK 1.6u Version on Agent.
  3. Configure the Agent to switch to TLSv1 as per the following document under the section “Oracle Management Agent”.
    1. Doc ID 1938799.1 CVE-2014-3566 Instructions to Mitigate the SSL v3.0 Vulnerability (aka “Poodle Attack”) in Oracle Enterprise Manager Grid / Cloud Control

Once you have performed all the steps make you your result look like this.

[oracle@hanoemxxx1 ~]$ openssl s_client -connect hanoemxxx1 -tls1
depth=1 O = EnterpriseManager on hanoemxxx1, OU = EnterpriseManager on hanoemxxx1, L = EnterpriseManager on hanoemxxx1, ST = CA, C = US, CN = hanoemxxx1
verify error:num=19:self signed certificate in certificate chain
verify return:0

Certificate chain
0 s:/CN=hanoemxxx1
i:/O=EnterpriseManager on hanoemxxx1 on hanoemxxx1 on hanoemxxx1
1 s:/O=EnterpriseManager on hanoemxxx1 on hanoemxxx1 on hanoemxxx1
i:/O=EnterpriseManager on hanoemxxx1 on hanoemxxx1 on hanoemxxx1

Server certificate
issuer=/O=EnterpriseManager on hanoemxxx1 on hanoemxxx1 on hanoemxxx1

No client certificate CA names sent

SSL handshake has read 1815 bytes and written 345 bytes

New, TLSv1/SSLv3, Cipher is DES-CBC3-SHA
Server public key is 1024 bit
Secure Renegotiation IS supported
Compression: NONE
Expansion: NONE
Protocol : TLSv1
Cipher : DES-CBC3-SHA
Session-ID: 56FB0E61209B62179FB5E17A9DBF49D882EB5A5BB8F4E77ACC1753E5D8050467
Master-Key: 3F6A0D03114C02914B757164F843DB8F2A8A17124445E2DB77ADFA5F21CB94A6012D92D5D771898C5FB3701F3058CD55
Key-Arg : None
Krb5 Principal: None
PSK identity: None
PSK identity hint: None
Start Time: 1459293793
Timeout : 7200 (sec)
Verify return code: 19 (self signed certificate in certificate chain)

Now re-run your Service Test, it application URL which was being monitored will show as Up and Running now.



Deepak Sharma

I’m Speaking @ OTN Yathra 2016

OTN Yatra Noida-2016 , Dated 01-May-2016,at BirlaSoft , H–9, Sector 63, NOIDA – 201306.
Speaker: Deepak Sharma, working as SR. Application Administrator with experience of 6+ years has worked on technologies like Oracle Enterprise Manager 11g Grid Contol, Oracle Enterprise Manager 12c Cloud Control, Oracle Enterprise Manager 13c, Oracle Database. He is currently working with “Oceaneering International Inc.” from last 4 years and before that he has been employee of “Bebo Technologies” for 2 years. He is Co-Founder of AIOUG-North India Chapter and core team member of AIOUG itself {}. He has presented at various Oracle conferences organized by AIOUG i.e. OTNYathra and Monthly Tech Days etc.

He also shares his research and findings over his Oracle blog ( He can be easily reachable at {} and {}

There are the details. ,
Click on Link to see the Agenda…,
Click on link to register your self ( only Limited seats are available)

Mishra Airy's photo.DSC_0568

Monitoring Best Practices in OEM12c

This blog highlights some of the important features which if used effectively can help you to monitor you environment.

Best practice includes :

  • Metric Thresholds
  • Monitoring Templates
  • Administrations Groups
  • Template collections
  • Synchronization Schedules
  • Incident Management

To know more about them in details you can check my presentation from one of my sessions for AIOUG-North India Chapter.

Managing &Monitoring Best Practices



OMS & Repository Management in OEM12c

I have uploaded slides from one of my presentation for AIOUG-North India Chapter. These  slide covers in details how you can manage “Oracle Management Service” and “Oracle Management Repository” using Oracle Enterprise Manager 12c Cloud Control.

Hope this will help you all to manage your environment without using the command line too EMCLI and SQLPLUS..

OMS & Repository Management

Thoughts and Suggestions are always welcome..



Oracle Cloud Day 26th March 2016

AIOUG-North India Chapter is organizing first ever Oracle Cloud day in North India. First event on Cloud technologies of Oracle at Noida! Don’t miss the chance to meet and learn the experts behind the awesome Oracle Cloud technology stack! Register and secure your seat!

Mentioned below are the venue details, Seats filling up fast:

Oracle Cloud Day – Noida

Venue: Oracle India Pvt Ltd, Building 3C, Tower A, Ground To 6th Floors, Plot No. 8, Express Highway, Sector 127, Noida, Uttar Pradesh 201301

Date & Time: 26th March 2016, 9 AM to 4 PM

Registration Link:

Contact Person: Aman Sharma/ Deepak Sharma (

Mobile Number : 7696049775
Speakers Profile Details with abstract of their sessions.

Here is information about Session by Neelima Bawa.

Manage the Modern Cloud using Oracle Management Cloud (OMC)

Oracle Management Cloud (OMC) is a suite of next-generation integrated monitoring, management and analytics solutions delivered as a service on Oracle Cloud.
• Designed for today’s heterogeneous environments, across your premises, Oracle Cloud and third-party cloud services.
• Built on a horizontally scalable big data platform with high-throughput processing to provide real-time analysis and deep insights across technical and business events.
• Automatic analysis of data using machine learning, and correlation across all Oracle Management Cloud services, thereby eliminating multiple information silos across end-user and infrastructure data.

OMC has following services:

  • Application Performance Monitoring
  • Log Analytics
  • IT Analytics

In this session, we will learn about Oracle Management Cloud and its various features.

Neelima Bawa‘s profile
Neelima has around 18 yrs. of total IT experience. She has been with Oracle for 15 years and has held variety of positions in product development and has worked with multiple products like Oracle Internet Directory, Oracle Identity Manager, and as a Development Manager for JVM Diagnostics (AD4J). In her latest role, Neelima is working with Oracle Enterprise Manager Strategic customer engagements, helping customers successfully deploy
Oracle Management Cloud and OEM to manage their engineering systems and middleware technologies.

Information about Session by Saurabh Gupta.

Oracle Database Cloud Service

 Abstract – Oracle Database Cloud service is a part of Oracle’s Platform as a Service solution offering in the public cloud. Upon subscription, it provides you a dedicated Oracle Database instance within a virtual container in Oracle’s public cloud environment. The database on the cloud is the same software piece that we all are aware of and have been working with since years.

As a cloud service consumer, you can choose between manual or automated database cloud service, Oracle database editions, standard or high memory compute shapes, and backup strategy at the time of service creation. Oracle Database Cloud Service offers full portability between on-premise and cloud instances, that means, you can lift and shift the data from on-premise to the cloud and vice versa.

You get to perform wide range of database operations, manage and monitor database instance on the cloud. With the Oracle’s DBaaS offering, you can run your database application without planning and procuring database server infrastructures. The key drivers of Oracle Database Cloud Service is to reduce cost and risk while enhancing the agility and manageability. Attend this session, if you are a seasoned Oracle database administrator or architect and want to learn about Oracle Database Cloud service.

Saurabh K. Gupta’s  Profile
Saurabh K. Gupta is a Principal Technologist with the Database Product Management Team in Oracle’s Server Technologies organization. At Oracle, his work is focused in driving Oracle database adoption programs with the partner community and customers. His technology focus is centered around database architecture, Oracle Public Cloud, Database In-Memory, Multitenant, Exadata, Big Data solutions, and Hadoop. He has authored the first and second of “Oracle Advanced PL/SQL Developer Professional Guide”.


Session – Hybrid Cloud Management for DevOps using Oracle Enterprise Manager
Deploy, move, and manage your data and applications with ease anytime, anywhere, both on premises or in Oracle Cloud—with a single pane of glass. Oracle Enterprise Manager 13c provides the single pane of glass that lets DevOps/IT administrators and DBA’s deploy their assets into the cloud or migrate them across clouds, and most important, monitor and manage them on a continual basis. In this session, learn how Oracle Enterprise Manager simplifies management of the database and middleware assets using capabilities for database as a service and middleware as a service. We will also see how enterprise manager extends these capabilities to Oracle cloud using hybrid cloud solution.

Akshay Sangaonkar’s Profile
Akshay is product manager for Enterprise Manager and focuses on private and hybrid cloud. With broad experience of more than 15 years in development, consulting and product management, he helps customers move to   cloud quickly and efficiently. He is regular speaker at Oracle customer webcasts and IOUG and has helped many customer on their cloud journey.

Time Session Title Speaker
9.00 to 9:30 AM Registration
9:30 to 10:00 AM North India Chapter & OTNYathra 2016 Updates Aman/Navneet/Deepak
10:00 to 11:15 AM Manage the Modern Cloud using Oracle Management Cloud (OMC) Neelima Bawa
11.15 to 11.30 AM Tea Break & Networking
11.30 to 1.00 PM Hybrid Cloud Management for DevOps using Oracle Enterprise Manager Akshay Sangaonkar
1:00 to 2:00 PM Lunch Break
2:00 to 3:15 PM Oracle Database Cloud Service Saurabh K. Gupta
3:15 to 4:00 PM Q & A / Wrap-Up

PRVF-0002 : Could not retrieve local nodename

I faced this error recently when I was building up my VM to install and configure OEM12cR5 on it. So before I can start with OEM setup I have to install Oracle Database for OMR. While I was performing Oracle 12c Release 1 database installation on my Virtual Machine on Virtual Box having Oracle Enterprise Linux 6 on it I came across this error.

[oracle@localhost database]$ ./runInstaller

Starting Oracle Universal Installer…


Checking Temp space: must be greater than 500 MB.   Actual 45136 MB    Passed

Checking swap space: must be greater than 150 MB.   Actual 4031 MB    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-01-24_10-25-50AM. Please wait …


To check if my hostname is setup properly, I thought of looking into my hosts file and there it was.  The problem was that the hostname was missing in the hosts” file:

[oracle@localhost database]$ hostname


[oracle@localhost database]$ cat /etc/hosts   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6


Using the editor I put the entry of my hostname in “hosts” file under “/etc/hosts”.  Make sure you have proper permissions while making that change. Login with root user and do the required editing and save the file.

So after making the changed my “hosts” file looked like this.


[oracle@localhost database]$ cat /etc/hosts   localhost localhost.em13c

::1         localhost localhost.em13c


After making this change, I ran the installer again and this time the setup ran successfully without any error messages.


Also the other option can be before running the setup you can set the value of Environment Variable “ORACLE_HOSTNAME” to your hostname and then run the setup.


[oracle@localhost database]$ ORACLE_HOSTNAME=localhost.em13c

[oracle@localhost database]$ export ORACLE_HOSTNAME



Deepak Sharma


12c Agents compatibility with OMS 13c…

Last time when I performed upgrade from 11g Grid Control to 12c Cloud Control, I had to replace all existing 11g Oracle Agents to Agent 12c. Oracle stated that 11g Oracle Agents are not compatible with OEM 12c, so it left me with no other option than to install Oracle Agent 12c on all monitoring hosts.

Even though multiple Agent installation on different hosts is available in 12c cloud Control but for one time when you have to do install and configure Agent 12c on more than 150 hosts, you really do not want to do that and could there have been shortcut it could have ease your life.

The same question came to my mind again, do I have to replace all my existing 12c Agents if I upgrade to this new release.  The answer is “NO” I do not have to replace my old Oracle Agent 12c.

Thanks to Oracle you do not have to do it but only if you have Oracle Management Agent 12c Release 3 or higher installed on your hosts.

YES, that’s true. Oracle Agent 12c is compatible with new release of Oracle Management Service 13c.

Mentioned below is the Compatibility table across OMS13c and Agent 12c.

Releases Oracle Management Agent 12c Release 3 ( Oracle Management Agent 12c Release 4 ( Oracle Management Agent 12c Release 5 ( Oracle Management Agent 13c
Oracle Management Service 13c Yes Yes Yes Yes

There are some important points which you have to keep in mind before you begin Installing OEM 13c.

  • Ensure that you have the latest Enterprise Manager Cloud Control software. {13c}
    • You can refer to the Oracle Enterprise Manager Cloud Control Advanced Installation and Configuration Guide.” for more information.
  • Oracle Management Service 13c can communicate only with the above listed versions of Management Agents.
  • Another important point to remember is while you download and run the OEM 13c software making sure there are no white spaces in the name of the directory.
    • Example: do not download and run the software from a directory titled “EM Software” because there is a white space between the two words of the directory name.
  • Through installation wizard, installation of OEM 13c Cloud Control can be done only on a single host, that is, locally on the server from where the wizard is invoked. Installation cannot be done on multiple or remote hosts.
  • Do not set the ORACLE_HOME and ORACLE_SID environment variables, also you must ensure that the Oracle directories do NOT appear in the PATH.
  • OEM13c onwards preinstalled JDK or Oracle WebLogic Server is no more supported.
  • Java Development Kit (JDK) 1.7.0_80 and Oracle WebLogic Server 12c Release 1 ( are installed as the part of EM13c Cloud Control.
  • Dedicated Weblogic Server 12c.
    • You must ensure that the Oracle WebLogic Server 12c Release 1 ( installed by the Enterprise Manager Cloud Control Installation Wizard is dedicated for Enterprise Manager Cloud Control.
    • You must not have any other Oracle Fusion Middleware product installed in that Middleware home.
  • OEM 13c Cloud Control cannot coexist with any Oracle Fusion Middleware product in the same Middleware home because the ORACLE_COMMON property is used by both the products.
  • As a prerequisite, you must have an existing Oracle Database {can also have the Automatic Memory Management (AMM) feature enabled} to configure the Management Repository.
  • Manual Startup required for OMS and OMA.
    • If you install the OMS and the Oracle Database, which houses the Management Repository, on the same host, then when you reboot the host, the OMS and the Management Agent installed with it will not automatically start up. You will have to manually start them.

I have listed few of the important ones, you can find detailed information in Oracle Documentation.

Hope this will help you setting up your new environment.

You can reach out to me on my personal email id:


Deepak Sharma

Hardware Requirement for OEM13c

In my last blog I mentioned “Step by step installation of OEM13c on Windows server”.

This blog contains all the hardware requirements for all three components. “Oracle Management Service, Oracle Management Agent and Oracle Management Repository {Database}

Mentioned below are the three different tables which will help you understand what all ammo {Hardware} is required before you leave for war.{OEM13c Installation}

NOTE: If you wish to install OEM13c on single host {both OMS and OMR (database) on single machine} than make sure you meet hardware requirments mentioned in TABLE 1 and TABLE 2 together.

Minimum CPU, RAM, Heap Size, and Hard Disk Space Requirements Per OMS


  Evaluation or Simple Installation Advanced Installation (SMALL) Advanced Installation (MEDIUM) Advanced Installation (LARGE)
Deployment Size Evaluation or Simple Small Medium Large
Configuration 1 OMS, <100 Targets, <10 Agents, < 3 Concurrent User Sessions 1 OMS, <1000 Targets, <100 Agents, <10 Concurrent User Sessions 2 OMSes, >=1000 but <10,000 Targets, >=100 but <1000 Agents,>=10 but <25 Concurrent User Sessions 2 OMSes, >=10,000 Targets, >=1000 Agents, >=25 but <=50 Concurrent User Sessions 4 OMSes, >=10,000 Targets, >=1000 Agents, >=25 but <=50 Concurrent User Sessions
CPU Cores/Host

(Can be shared with other processes)

2 4 6 12 6

(With Oracle BI Publisher and JVMD Engine)

10 GB 10 GB 12 GB 24 GB 12 GB
Hard Disk Space

(With Oracle Software Library, Oracle BI Publisher, and JVMD Engine)

24 GB 24 GB 24 GB 24 GB 24 GB
Temporary Directory Hard Disk Space 10 GB 10 GB 10 GB 10 GB 10 GB
Oracle WebLogic Server JVM Heap Size 1 GB 1.7 GB 4 GB 8 GB 4 GB

Note:  The physical memory {RAM} mentioned here includes 5 GB of RAM required for Oracle BI Publisher. At the time of installation.

If you choose not to configure Oracle BI Publisher, then the actual physical memory required can be 5 GB less than what is mentioned here.

Minimum CPU, RAM, and Hard Disk Space Requirements for Management Repository


  Evaluation or Simple Installation Advanced Installation (SMALL) Advanced Installation (MEDIUM) Advanced Installation (LARGE)
Deployment Size Small Medium Large
Configuration 1 OMS, <100 Targets, <10 Agents, < 3 Concurrent User Sessions 1 OMS, <1000 Targets, <100 Agents, <10 Concurrent User Sessions 2 OMSes, >=1000 but <10,000 Targets, >=100 but <1000 Agents,>=10 but <25 Concurrent User Sessions > 2 OMSes, >=10,000 Targets, >=1000 Agents, >=25 but <=50 Concurrent User Sessions
CPU Cores/Host 4 6 12
RAM 7 GB 10 GB 18 GB
Hard Disk Space 23 GB


147 GB


455 GB


649 GB


CPU, RAM, and Hard Disk Space Requirements for Oracle Management Agent, Hybrid Cloud Agent, Hybrid Cloud Gateway Agent

NOTE: Mentioned below in TABLE 3 are the different ways you can install Oracle Agent 13c, the hardware required will entirely depend on the method you adopt to install Oracle Agent. Please select accordingly.


  CPU Cores Per Host


RAM Agent Base Directory Space Swap Space Temporary Directory Space Stage/Working Directory Space Agent Instance Home
Agent Installation Using the Add Host Targets Wizard or Any of the Silent Methods 2 512 MB 1.5 GB 500 MB 1 GB N/A Included as part of the Agent Base Directory space.  
Agent Cloning Using the Add Host Targets Wizard or Any of the Silent Methods 2 512 MB 1.5 GB 500 MB 500 MB N/A Included as part of the Agent Base Directory space.  
Agent Installation Using Agent Gold Images 2 512 MB 1.5 GB 500 MB 500 MB 750 MB Included as part of the Agent Base Directory space.  
Agent Gold Image Creation N/A N/A N/A N/A N/A 1 GB N/A  
Agent Gold Image Staging N/A N/A N/A N/A N/A 1 GB N/A  


I hope this will help you do design your server before you install Oracle Enterprise Manager 13c on that. Make sure you do meet minimum requirements as listed above in the three table, failing in same will result in Poor Performance and if unlucky your system might also get crash. It happened with me very first time. 😉

Play Safe…


Deepak Sharma




OEM 13c Step by Step Installation on Windows

In this blog I have explained the step by step installation of Oracle Enterprise Manager 13c on Windows server.


Make sure you have sufficient resources on your laptop or server since OEM13c is really very heavy and might slow down performance of your machine if it does not get sufficient food {resources }.

Since I have done installation on my personal laptop so I have mentioned the resource requirement accordingly. So make sure your machine has below listed resources available.

 Minimum CPU, RAM, Heap Size, and Hard Disk Space Requirements Per OMS for Simple Installation

   Simple Installation
Deployment Size Evaluation or Simple
Configuration 1 OMS, <100 Targets, <10 Agents, <3 Concurrent User Sessions
CPU Cores/Host

(Can be shared with other processes)

RAM11The physical memory mentioned here includes .5 GB of RAM required for Oracle BI Publisher. At the time of installation, if you choose not to configure Oracle BI Publisher, then the actual physical memory required can be .5 GB less than what is mentioned here.

(With Oracle BI Publisher and JVMD Engine)

10 GB
Hard Disk Space

(With Oracle Software Library, Oracle BI Publisher, and JVMD Engine)

24 GB
Temporary Directory Hard Disk Space 10 GB
Oracle WebLogic Server JVM Heap Size 1 GB

I am assuming you already have a database created for your OEM. In my environment I have 12C database created.

Step 1: Download the software. {there are 5 files}

Step 2: Run the installer


It will run for sometime and you can monitor the progress.


Once the Installer is finished, it run the prerequisite system compatibility test to start the setup.


Step 3: Enter your MOS account details (optional), if you want to receive security updates from Oracle.


Just a warning will be displayed if you skip your “Support Details” part, you have to confirm that you do not wish to receive updates.


Step 4: Software update search. It is recommended to run this step to ensure your environment is ready for this installation.


If your machine is having all the updated required softwares it will prompt “No updates found”


Step 5: Prerequisite Check. It will run a check to ensure you have sufficient resources available.

{Like in my case I got warning for in-sufficient RAM minimum required was 10 Gb and I had 8Gb of RAM, still I decided to continue with Installation. I was crazy to test this new release and lazy enough to increase my machine’s RAM to 10Gb.}


Click NEXT to continue with Installation.


Step 6: Installation Type. {Simple or Advanced}

If you are already familiar with previous releases and are EM DBA you can go for “Advanced” option.


Step 7: Setting up Installation directories. Here you have configure you Middleware Home, Agent Base Directory and Hostname.


Step 8: Set Administrator Password and put your database connection details.

[Informational message will pop-up with recommendation to setup AL32UTF8 character set for EM Repository database.]


Click OK, it will execute some prerequisite checks.


In next few steps you will be prompted for mismatch of you database settings if they already do not match with the recommended setting for OEM13c installation.

Prompted to check “optimizer_adaptive_features” parameter


Prompted to check “parallel max and min servers” parameter


Prompted to check “shared_pool_size” & “session_cached_cursors” parameter


Step 9 :  Configure Software Library  and Enable BI Publisher.

OEM13c gives you option to configure and enable “BI Publisher” during Installation itself.


Step 10: Review all details entered in all previous steps.



Step 11: Start the installation. 

[Now if you are installing it on your laptop with insufficient resources just like mine 😉 RAM 8Gb ,  believe me installation is going to take more than 4  hours it happened with me. So if you do not want to get irritated while setting this up make sure you have a very good machine with you for your installation ]





Once the Installation is finished, it will run a clean-up process.


Now you are ready to use your OEM13c.

EXCITED… Believe me I was  very much eager to start using it. I have put some more screenshot of the “Login Console, Welcome Page, Incident Manager etc.. “ check out below.


Accessibility Preferences Page


Disclaimer Page


Incident Manager Page


I’ll be posting more stuff soon on this new release of OEM 13c. Hope this blog will help to install OEM13c easily on your machine.

Till next post, it me Signing Off, time to go to sleep now. Good Night Folks..