Add Targets in OEM12c Declaratively specifying target monitoring properties.

In my last blog I have explained a step by step procedure, how we can add a target in Oracle Enterprise Manager 12c using “GUIDED” process. In this blog I have explained how we can add target in OEM12c using “DECLARATIVE” process. Let first understand what is the difference between “GUIDED” and “DECLARATIVE” process first.

In GUIDED process we have seen that agent on that host helps this process to discovers the target of particular type  that meets the selection criteria like in this case “Oracle Database, Listener and Automatic Storage Management”, once all these targets are discovered you just need to put the credentials and other monitoring configuration will be already filled during discovery.

However if we talk about the “DECLARATIVE” process, in this process we limit our input information and we want OEM to discover targets based on the limited information supplied to it. Lets see how this process works. Mentioned below are the steps:

Step 1: Navigate to the page “Add Targets Manually“.

image1

Step 2: Select method “Add Targets Declaratively by Specifying Target Monitoring Properties” and select the “Target Type” .

 

image4

Step 3: Select the Monitoring Agent. {The host on which the database instance/target (in this case) is located.}

image5

Step 4: Click on “Add Manually” to proceed further.

image6

Step 5: Add database instance properties, this includes not only the Monitoring configuration but also the “Target Name” and “Database System“.

image7

 Note:  The major difference between GUIDED Process and Declarative Process comes at this step. In Guided Process we just have to specify the password for monitoring user{DBSNMP}, rest of the information was filled automatically when Agent discovers the target. However while adding target by declaratively specifying the properties, we have to manually enter all these values.

Step 6: Test Connection, once you have filled all the values and make sure the connection is successful. Click NEXT to proceed further.

image8

Step 7: Review details and click on “Submit” to add this target.

image9

Now you can find the target listed under the “Targets -> Databases“.

 

Regards

ADDKS

Please follow and like us:
RSS
Follow by Email
Facebook
Google+
http://emdeepaksharma.com/2016/07/add-targets-in-oem12c-declaratively-specifying-target-monitoring-properties/
LinkedIn
Instagram

Add Targets in OEM12c Using Guided Process

In this Blog I have explained step by step procedure to discover and add targets  on a HOST on which Agent is already installed.

Note: Oracle Agent installation is mandatory on the host for which you want to discover and push targets in OEM.

  • Navigate to the “Add Targets Manually” screen using the menu at the top-right of the screen (Setup > Add Target > Add Targets Manually).

image1

  • Select the “Add Targets using Guided Process” option, select the target types to be discovered (eg. lets say in this blog I have taken “Oracle Database, Listener and Automatic Storage Manager”) and click the “Add Using guided Discovery…” button.

image10

 

  • Under “Database Discovery: Search Criteria Agent” enter the host name on which target exists and agent in installed. Click the “Continue” button.

image11

 

  • Click on “Next” button.

image12

  • Click the “Configure” icon for any discovered targets and enter the required details.

image13

image14

  • Specifying Global Target Properties for Notifications and Administrations Groups and click “OK”.

image15

  • When all the configuration steps are complete, click the “Submit” button, followed by the “Save” button, then finally the “OK” button.

image9

You can now see the recently added “database Instance” target listed on the relevant target {Databases} screen (Targets > Databases).

 

Thanks

ADDKS

 

Please follow and like us:
RSS
Follow by Email
Facebook
Google+
http://emdeepaksharma.com/2016/07/add-targets-in-oem12c-using-guided-process/
LinkedIn
Instagram

Say Hello! to Oracle Enterprise Manager 13c

In this blog I have shared one of my recent presentations with you on “Introduction to new features in OEM13c”. I delivered this session in one of our Tech-Day named as OTNYathra2016. It covers small Introduction of Oracle Enterprise Manager, Architecture of Enterprise Manager and What are all the components involved. As far as New & Enhanced features are concerned I have included “Infrastructure & Framework”,  “Enterprise Monitoring & Incident Management” and few “Database Management” features.
I have just started exploring this new release and will soon be posting more stuff on OEM13c.

 OEM13c_Intro_Blog

Thanks

Deepak Sharma

Please follow and like us:
RSS
Follow by Email
Facebook
Google+
http://emdeepaksharma.com/2016/05/say-hello-to-oracle-enterprise-manager-13c/
LinkedIn
Instagram

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.

 

DSC_0315

Please follow and like us:
RSS
Follow by Email
Facebook
Google+
http://emdeepaksharma.com/2016/05/otnyathra2016/
LinkedIn
Instagram

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– https://chapxxx.oii.xxx.com:9010/enovia/emxLogin.jsp” 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.

Issue:

Service test failed: “Remote host closed connection during handshake– https://chapxxx.oii.xxx.com:9010/enovia/emxLogin.jsp” Error message .

Cause:

Java upgrade from Java 1.6_24 to Java1.7_79

Resolution:

Steps for Implementing TLSv1 with OEM 12.1.0.4 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 .oii.xxx.com:3872 -tls1
CONNECTED(00000003)
depth=1 O = EnterpriseManager on hanoemxxx1 .oii.xxx.com, OU = EnterpriseManager on hanoemxxx1 .oii.xxx.com, L = EnterpriseManager on hanoemxxx1 .oii.xxx.com, ST = CA, C = US, CN = hanoemxxx1 .oii.xxx.com
verify error:num=19:self signed certificate in certificate chain
verify return:0

Certificate chain
0 s:/CN=hanoemxxx1 .oii.xxx.com
i:/O=EnterpriseManager on hanoemxxx1 .oii.xxx.com/OU=EnterpriseManager on hanoemxxx1 .oii.xxx.com/L=EnterpriseManager on hanoemxxx1 .oii.xxx.com/ST=CA/C=US/CN=hanoemxxx1 .oii.xxx.com
1 s:/O=EnterpriseManager on hanoemxxx1 .oii.xxx.com/OU=EnterpriseManager on hanoemxxx1 .oii.xxx.com/L=EnterpriseManager on hanoemxxx1 .oii.xxx.com/ST=CA/C=US/CN=hanoemxxx1 .oii.xxx.com
i:/O=EnterpriseManager on hanoemxxx1 .oii.xxx.com/OU=EnterpriseManager on hanoemxxx1 .oii.xxx.com/L=EnterpriseManager on hanoemxxx1 .oii.xxx.com/ST=CA/C=US/CN=hanoemxxx1 .oii.xxx.com

Server certificate
—–BEGIN CERTIFICATE—–
MIIC4DCCAkmgAwIBAgIJBBqdIBqYL6a0MA0GCSqGSIb3DQEBDQUAMIH5MTswOQYD
VQQKEzJFbnRlcnByaXNlTWFuYWdlciBvbiBoYW5vZW1hcDEub2lpLm9jZWFuZWVy
aW5nLmNvbTE7MDkGA1UECxMyRW50ZXJwcmlzZU1hbmFnZXIgb24gaGFub2VtYXAx
Lm9paS5vY2VhbmVlcmluZy5jb20xOzA5BgNVBAcTMkVudGVycHJpc2VNYW5hZ2Vy
IG9uIGhhbm9lbWFwMS5vaWkub2NlYW5lZXJpbmcuY29tMQswCQYDVQQIEwJDQTEL
MAkGA1UEBhMCVVMxJjAkBgNVBAMTHWhhbm9lbWFwMS5vaWkub2NlYW5lZXJpbmcu
Y29tMB4XDTE1MDUxMjIxMDA1MVoXDTI1MDUxMDIxMDA1MVowKDEmMCQGA1UEAxQd
aGFub2VtYXAxLm9paS5vY2VhbmVlcmluZy5jb20wgZ8wDQYJKoZIhvcNAQEBBQAD
gY0AMIGJAoGBAMZGbWxsmL+/HraSuevWybcBI2zY+3rgFOQTbRijL7pyO1jQV9bX
6NodoTBTrHp8l+s1+OWfy6SsBgz5EYwxBtsSMpmMd3zWy1b8hWeuZLBk77tPKYZL
JgMg2RY/QMjRe7l5i3rcdyNigpwBLR9VB4UI04Hhj7TDcHSzrR9QiNA3AgMBAAGj
QDA+MAwGA1UdEwEB/wQCMAAwDwYDVR0PAQH/BAUDAwfoADAdBgNVHQ4EFgQUJbLM
QJPLTX0/RlaijJ3qT05BGxowDQYJKoZIhvcNAQENBQADgYEAVmBOWk2rIZX5Ew6I
iTt1xQujqPk4EtJUPwy2iGhHhCeYvr4SDoqXD6A2za7hlqD79tENYLPZOWWHnw9H
ZihRye9vqQkQ1k+fqLyXlPCpVpUaYZnL+kjVJVGShx69Tv1Xjl4lobemcXidbIiY
mNYNa9USae70oZdlJ+63hYbcU8E=
—–END CERTIFICATE—–
subject=/CN=hanoemxxx1 .oii.xxx.com
issuer=/O=EnterpriseManager on hanoemxxx1 .oii.xxx.com/OU=EnterpriseManager on hanoemxxx1 .oii.xxx.com/L=EnterpriseManager on hanoemxxx1 .oii.xxx.com/ST=CA/C=US/CN=hanoemap1.oii.xxx.com

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
SSL-Session:
Protocol : TLSv1
Cipher : DES-CBC3-SHA
Session-ID: 56FB0E61209B62179FB5E17A9DBF49D882EB5A5BB8F4E77ACC1753E5D8050467
Session-ID-ctx:
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.

 

Thanks

Deepak Sharma

Please follow and like us:
RSS
Follow by Email
Facebook
Google+
http://emdeepaksharma.com/2016/04/service-test-failed-on-oem12c-due-to-java7-upgrade/
LinkedIn
Instagram

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 {http://www.aioug.org/aiougnichapter.php}. 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 (https://deepaksharmaem12c.wordpress.com). He can be easily reachable at { sharma.deepak345@gmail.com} and {https://in.linkedin.com/in/dksharmaemdba}

There are the details. http://www.otnyathra.info/ ,
Click on Link to see the Agenda http://www.otnyathra.info/index.php…,
Click on link to register your self ( only Limited seats are available)http://www.meraevents.com/previewevent

Mishra Airy's photo.DSC_0568

Please follow and like us:
RSS
Follow by Email
Facebook
Google+
http://emdeepaksharma.com/2016/04/im-speaking-otn-yathra-2016/
LinkedIn
Instagram

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

Thanks

DKSHARMA

Please follow and like us:
RSS
Follow by Email
Facebook
Google+
http://emdeepaksharma.com/2016/03/monitoring-best-practices-in-oem12c/
LinkedIn
Instagram

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..

Thanks

Deepak

Please follow and like us:
RSS
Follow by Email
Facebook
Google+
http://emdeepaksharma.com/2016/03/oms-repository-management-in-oem12c/
LinkedIn
Instagram

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:

DESCRIPTION
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:
http://www.meraevents.com/previewevent?view=preview&eventId=96892

Contact Person: Aman Sharma/ Deepak Sharma (ni.chapter@aioug.org)

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
Please follow and like us:
RSS
Follow by Email
Facebook
Google+
http://emdeepaksharma.com/2016/03/oracle-cloud-day-26th-march-2016/
LinkedIn
Instagram

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 …

blog1

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

localhost.em13c

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

127.0.0.1   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

127.0.0.1   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

 

Regards

Deepak Sharma

 

Please follow and like us:
RSS
Follow by Email
Facebook
Google+
http://emdeepaksharma.com/2016/01/prvf-0002-could-not-retrieve-local-nodename/
LinkedIn
Instagram