POUG – 1st Polish International Oracle Conference

Amazing 1st POUG Conference

Amazing, Awesome some of the words that come to my mind. I wrote this on the plane but I am just posting it;

I have just landed back into the UK and I am still thinking about this conference. My journey began on Thursday, I was flying into Warsaw and my plan was delayed, I really did not want to miss the speaker dinner, a great opportunity to meet everyone. I managed to arrive in sufficient time. I checked in at the hotel and went to meet the rest of the group at the bar.

At the bar was Martin, Neil and Jim, these guys rock ;). Had a quick drink then met the rest of the group at reception?

It was great to meet all the speakers. I have to say we all were well looked after by the POUG organizers, we were taken to a restaurant for an amazing meal and thereafter a little stroll/sightseeing for the few who had lost all direction and sense; we ended up at Irish bar for a night cap.

(Day 1). There was a really good turnout easily I would say 150+ and some had travelled from the borders of Poland. There were 2 tracks running, I went to Jim’s talk DBA, Heal Thyself: Five diseases of IT Organizations. It was my first time at Jim’s talk, it was superbly delivered after I had left I decided to polish up on my slides for later. I missed Heli Helskyaho’s @helifromfinland talk about SQL developer that I really wanted to go to, I heard it was really good. I will catch you next time.

After lunch I went to Pieter’s @vanpupi and Philippe’s @pfierens talk about Oracle VM on Exadata, this was good as well, learnt some things that you will not find in any documents. Straight after this talk was my presentation. I was told it would be HDMI connection, but there was only a VGA cable (Panic, Panic, Panic) – luckily Philippe let me borrow his adapter as well as a ‘Powerpoint Pointer’. Thank You Philippe.

My talk was about extraction of cloud data to a premise BI and monitoring. The room was pretty full, that was a great sign, never really been nervous too much before but I was this time – as the talk progressed we moved to Cloud security and monitoring in the cloud as there was a great interest in this area. After my talk had finished we still had around 5m so we discussed the cloud aspects in more detail. I know there were some more questions on the monitoring side, if anybody did want any info, do get in contact me. This is another great side of user groups, you can go to one talk and ask other topic questions that may come to your mind.

Thereafter I sat into Robin’s @rmoff talk about OBIEE 12c Performance, I learnt some new things that will be great for me at work. I have to say you can never know everything there is always thing to learn.

After this talk we were whisked to the POUG Appreciation event as I would call it. They really looked after the speakers and attendees.

(Day 2) – It was a long night, and it was so amazing to see so many people the next day for Neil’s @chandlerDBA talk on ‘Why has my plan changed’. Being a man with many hats at my work and being a DBA for over 17 years, I enjoyed Neil’s talk as I am always fighting SQL performance looking forward to see his scripts. I would definitely recommend it, if you are at a different conference and he is talking – don’t miss itJ.

After Neil’s talk I decided to stay in this stream for Joze’s talk on ‘Opening the black box called “Cost Based Optimizer’, he’s right it is a black box. Thereafter I moved to Martin’s @MDWildlake talk ‘Tips on Bulk Data Processing with SQL and PL/SQL’ – It was a great insight in bulk processing data and this man like’s his beer 😉

Once we had consumed our lunch we had our final session of the day ‘#DBADEV,Bridging the gap between development and operation table’ This was a panel session with Sabine @oraesque, Martin @MDWidlake, Philippe @pfierens, Neil @ChandlerDBA, Piet @pdevisser and Erik @evrocs_nl. I think most people would be able to say something in this area, I am always fighting with developersJ. What a great way to end the conference.

All my breakfasts, lunch’s were timed with Pieter’s – Absolute Legend J. At the last breakfast Pieter, Eric and myself were talking how good the conference was and how they have set the bar really high, it is very high!. It can only get better ;). I can see this conference growing huge, from talking to some of the guests they would like talks on EM Monitoring, Middleware, APEX. Maybe next year have a few of these 😉

This was a super conference venue, food, equipment and the beer, excellently organized and delivered, it was great to meet all the speakers, organizers and guests. POUG is definitely now on the map. It was bloody marvelous 😉




Installing SOACS Hybrid Agent EM13C

In my last post we set up a hybrid agent and installed an OTD agent, in this post we shall create a SOACS agent. I am assuming you have already done the first few steps that were mentioned in my last post OTD Hybrid Agent (http://puredba.co.uk/oracle-traffic-director-otd-hybrid-agent-em-13c/)

  1. On SOACS Target Host

Insert the OMS server details into the host file:

Create the Agent Directory


  1. Add the target in EM
    Em Console>Setup>Add Targets Manually>Install Agent on Host

    Click Next


    Deploy Agent


    We will run script manually, so click continue all hosts.
    Log onto host and run the following as root.

    • /u01/app/agentHome/agent_13.
    • /u01/app/oraInventory/orainstRoot.sh


    Click <done> in your agent install screen.

    If you go to Targets/Hosts, you will see the SOACS machine.

    Discovering SOA Suite

    This section describes the procedure for discovering the SOA Suit.

    1. Login to Oracle Enterprise Manager Grid Control.
    2. Click Targets and then Middleware.

      Oracle Enterprise Manager Grid Control displays the Middleware page that lists all the middleware targets being monitored.

    3. In the Middleware page, from the Add list, select Oracle Fusion Middleware / WebLogic Domain and click Go. Specify the Administration Server Host, Port, User Name, Password, Agent (local or remote) and the JMX Protocol and click Continue.

    Click Add Targets

    1. You will return to the Middleware page. You will see the SOA instances under the WebLogic Domain.


    Wait for a few minutes then drill into the soa target you will need to configure the functionality logins.


    Bugs and Fixes


    1. This Error Hospital screen will not work, by default.


    When you go to this screen it will ask you to set up the target information, when you try to do this you will get the following message.


     According to Oracle certifications, it’s not supported with 12.1

     #According to the error we need all these jar files.

     Copy all the jar files.

     Now go back to your screen and just do a save not a rescan. If you did a rescan it will still say some error with jar files, but it will say jar files do exist. Save.

     The screen works.



    1. SOA Composite statuses, if they go down they get marked as down but when they come back up the console does not refresh, you will need to do a weblogic domain refresh in the console. You could set up a job that does this refresh automatically.



     You have SOACS monitored from EM13C cloud control.

Oracle Traffic Director (OTD) Hybrid Agent EM13C

In this post we will set up to monitor OTD in the cloud.


When you use the Add Host Targets Wizard or EM CLI to install a Management Agent on a host running on Microsoft Windows, as a prerequisite, you must install Cygwin and start the SSH Daemon on the host. To do so, follow the steps listed in Section 5.3 and 5.4



  1. Generate Public and Private Keys on a linux box.

This will generate 2 keys a private and public key
Add the public key to the Oracle user (The user being used for connecting to the host from EM13C) on your target OTD host

  1. Set up the user in EM13c


Click on Setup, Security and then Named Credentials.  Click on Create under the Named Credentials section, As per below screen shot, insert your details and the keys you generated in step 1.

Click Save.

  1. Create a Hybrid Cloud Agent

You can use an existing agent, but you should create few agents for higher availability.

Go to Agent home on the oms server and do a

Take a note of the agent url : https://********.***.net:3872/emd/main/



Make sure to restart the agent after you’re performed this step.  


  1. On OTD Target Host

 Insert the OMS server details into the host file:


Create the Agent Directory


  1. Add the target in EM


Em Console

Setup > Add Target > Add Targets Manually

Install Agent on Host

Click Next

Deploy Agent

We will run script manually, so click continue all hosts.

Log onto host and run the following as root.

Click <done> in your agent install screen.

If you go to Targets/Hosts, you will see the machine.


  1. Now let’s add OTD

In Console, Setup,Add Target, Add targets Manually.

Select Add Using Guided Process

Select Traffic Director

Click Add, The screen below we are adding the info you would use to log into the Traffic Director Console. Also if you need to find the other info, this can be found in the following file /u01/data/otd-instance/admin-server/config/snmpagt.conf for the snmp port if it has been configured.

Click Continue

Click Add Targets

7.Verify OTD

In EM13c Console, Select Targets/Middleware/

The status cross will clear once the agent has collected the data

Drill into the OTD.

We can see Traffic Director Responses and Requests, The cross in the status is because the agent is trying to connect to the SNMP port, which we have disabled at the moment. We can still collect meaningful info, without this.