Category Archives: Uncategorized

OTNYathra2016 – My first Experience as Speaker

In this blog I have share my experience of OTNyathra2016 as a SPEAKER.

It was for the first time when beside the managing the entire event along with my Gurus Mr. Aman Sharma and Mr Navneet Upneja, I was there as a Speaker in the same event. Yes for the first time in a National Level Event I was nominated as Speaker and I had to deliver session on “Oracle Enterprise Manager 13c“.

Was I worried, YES a lot. It would sound weird but there were lots of ups and downs going on in my mind. I thought many  times to take my name back but then I took it as challenge and  thought no matter what I will speak. I knew some day I have to start so why not now.

Moreover it was for the first time being the Regional chapter of parental body AIOUG, AIOUG-North India Chapter took the responsibility for conducting this event. There was lot of pressure on our minds but yes with the hard work of entire team of North India Chapter our event was a GRAND SUCCESS. We broke the record of last 7 years with attendance of 130 delegates.

Special thanks to our Volunteers who helped us promoting this event on Social Media. Thank You so much guys. {Pavan Mishra, Vijay, Vinay and Anoop}


Back to experience as Speaker. 🙂

My session was at the last, when people are in mood of just rushing back to their homes. Few of them already left,  well I would say it was not actually a BAD start, there were around 20 people sitting in that room to attend my session. Before starting my session I had made my mind that I will not get confused, worried or shiver and I guess I succeeded in that. My both Gurus Mr Aman Sharma and Mr Navneet Upneja, came there in my session one by one.

The topic was new “Oracle Enterprise Manager 13c – New Features”, of course this release has a lot of new feature but I just took three domain and explain new or enhanced things in them. There were many cross questioning from the delegates some of which I was able to answer and some of them I did not know as I myself had not explored that feature. Overall it all went well and I would say my first experience was not that Bad to get upset.

My mentors Aman and Navneet both told me about some flaws and area of improvements, and I’ll  make sure not to make those mistakes again. I would like to thank both of them for there forever support and guidance.


Will be back soon with stuff on OEM13c, till then TC.



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