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 😉
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/)
- On SOACS Target Host
Insert the OMS server details into the host file:
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
#Added for EM
Create the Agent Directory
#chown oracle:oracle /u01/app/agentHome
- Add the target in EM Em Console>Setup>Add Targets Manually>Install Agent on Host
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 SOACS machine.
Discovering SOA Suite
This section describes the procedure for discovering the SOA Suit.
- Login to Oracle Enterprise Manager Grid Control.
- Click Targets and then Middleware.
Oracle Enterprise Manager Grid Control displays the Middleware page that lists all the middleware targets being monitored.
- 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
- 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
- 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.1Shell123bash-4.1$ pwd/u01/app/agentHome/agent_184.108.40.206.0/plugins/oracle.sysman.emas.agent.plugin_220.127.116.11.0/archives/jlib-bash-4.1$ mkdir extjlib
#According to the error we need all these jar files.Shell1234567891.soa-infra-mgmt.jar,2.oracle-soa-client-api.jar3.jrf-api.jar,4.tracking-api.jar,5.oracle.bpm.bpmn-em-tools.jar,6.rulesdk2.jar ,7.xmlparserv2.jar ,8.com.oracle.webservices.fabric-common-api_12.1.3.jar or com.oracle.webservices.fabric-common-api.jar ,9.wlthint3client.jar.
Copy all the jar files.Shell12345678910111213141516171819202122232425-bash-4.1$ cp -p /u01/app/oracle/middleware/soa/soa/modules/oracle.soa.mgmt_11.1.1/soa-infra-mgmt.jar /u01/app/agentHome/agent_18.104.22.168.0/plugins/oracle.sysman.emas.agent.plugin_22.214.171.124.0/archives/jlib/extjlib-bash-4.1$ cp -p /u01/app/oracle/middleware/soa/soa/modules/oracle.soa.fabric_11.1.1/oracle-soa-client-api.jar /u01/app/agentHome/agent_126.96.36.199.0/plugins/oracle.sysman.emas.agent.plugin_188.8.131.52.0/archives/jlib/extjlib-bash-4.1$ cp -p /u01/app/oracle/middleware/oracle_common/modules/oracle.jrf_12.1.3/jrf-api.jar /u01/app/agentHome/agent_184.108.40.206.0/plugins/oracle.sysman.emas.agent.plugin_220.127.116.11.0/archives/jlib/extjlib-bash-4.1$ cp -p /u01/app/oracle/middleware/soa/soa/modules/oracle.soa.fabric_11.1.1/tracking-api.jar /u01/app/agentHome/agent_18.104.22.168.0/plugins/oracle.sysman.emas.agent.plugin_22.214.171.124.0/archives/jlib/extjlib-bash-4.1$ cp -p /u01/app/oracle/middleware/soa/bpm/modules/oracle.bpm.mgmt_11.1.1/oracle.bpm.bpmn-em-tools.jar /u01/app/agentHome/agent_126.96.36.199.0/plugins/oracle.sysman.emas.agent.plugin_188.8.131.52.0/archives/jlib/extjlib-bash-4.1$ cp -p /u01/app/oracle/middleware/soa/soa/modules/oracle.rules_11.1.1/rulesdk2.jar /u01/app/agentHome/agent_184.108.40.206.0/plugins/oracle.sysman.emas.agent.plugin_220.127.116.11.0/archives/jlib/extjlib-bash-4.1$ cp -p /u01/app/oracle/middleware/soa/soa/modules/oracle.rules_11.1.1/rulesdk2.jar /u01/app/agentHome/agent_18.104.22.168.0/plugins/oracle.sysman.emas.agent.plugin_22.214.171.124.0/archives/jlib/extjlib-bash-4.1$ cp -p /u01/app/agentHome/agent_126.96.36.199.0/modules/xmlparserv2.jar /u01/app/agentHome/agent_188.8.131.52.0/plugins/oracle.sysman.emas.agent.plugin_184.108.40.206.0/archives/jlib/extjlib-bash-4.1$ cp -p /u01/app/oracle/middleware/oracle_common/modules/com.oracle.webservices.fabric-common-api_12.1.3.jar /u01/app/agentHome/agent_220.127.116.11.0/plugins/oracle.sysman.emas.agent.plugin_18.104.22.168.0/archives/jlib/extjlib-bash-4.1$ cp -p /u01/app/agentHome/agent_22.214.171.124.0/plugins/oracle.sysman.emas.agent.plugin_126.96.36.199.0/archives/jlib/wlthint3client.jar /u01/app/agentHome/agent_188.8.131.52.0/plugins/oracle.sysman.emas.agent.plugin_184.108.40.206.0/archives/jlib/extjlib-bash-4.1$ ls -latotal 74412drwxrwxr-x 2 oracle oracle 4096 Jul 29 19:09 .drwxr-xr-x 3 oracle oracle 4096 Jul 29 18:59 ..-rw-r----- 1 oracle oracle 166207 May 6 2014 com.oracle.webservices.fabric-common-api_12.1.3.jar-rw-r----- 1 oracle oracle 147471 May 7 2014 jrf-api.jar-rw-r----- 1 oracle oracle 65873876 Jan 13 2016 oracle.bpm.bpmn-em-tools.jar-rw-r----- 1 oracle oracle 49893 Jan 13 2016 oracle-soa-client-api.jar-rw-r----- 1 oracle oracle 2063990 Jan 13 2016 rulesdk2.jar-rw-r----- 1 oracle oracle 1556107 Jan 13 2016 soa-infra-mgmt.jar-rw-r----- 1 oracle oracle 16081 Jan 13 2016 tracking-api.jar-rw-r--r-- 1 oracle oracle 4615123 Jul 20 2015 wlthint3client.jar-rw-r--r-- 1 oracle oracle 1684004 Oct 5 2015 xmlparserv2.jar-bash-4.1$ chmod 755 *.jar.
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.
- 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.
In this post we will set up to monitor OTD in the cloud. Pre-Requisite: 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
Shell1#ssh-keygen -b 2048 -t rsa
- 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
- 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.
- 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 aShell1$emctl status agent
Take a note of the agent url : https://********.***.net:3872/emd/main/Shell123$ ./emcli login -username=sysmanEnter password :$ ./emcli register_hybridgateway_agent -hybridgateway_agent_list='
Make sure to restart the agent after you're performed this step.
- On OTD Target Host
Insert the OMS server details into the host file:Shell1234127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6#Added for EM220.127.116.11 ******.mshome.net
Create the Agent DirectoryShell12#mkdir /u01/app/agentHome#chown oracle:oracle </span>/u01/app/agentHome
- Add the target in EM
Setup > Add Target > Add Targets Manually
Install Agent on Host
We will run script manually, so click continue all hosts.
Log onto host and run the following as root.Shell12#/u01/app/agentHome/agent_18.104.22.168.0/root.sh#/u01/app/oraInventory/orainstRoot.sh
Click <done> in your agent install screen.
If you go to Targets/Hosts, you will see the machine.
- 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 Add Targets
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.