Oracle Collaborate 2014 AWS sessions

Here are the three AWS focused sessions at Oracle Collaborate http://collaborate14.com

564: Best Practices for Running Oracle Databases on Amazon Web Services (AWS)   -- Speakers: Abdul Sait
Date: 04/11/2014
Time: 8:30 AM
Location: Level 3, Lido 3101B

Deploying PeopleSoft to the Amazon Cloud  --  Speakers: Abdul Sait, David Brunet

9 Apr 08:30 AM-09:30 AM

Session ID: 106940
Room: Level 4, Lando 4301B

OEM 12c session with Oracle Product Management and App Associates:

Workshop: Simplify, Automate, and Enhance Management of E-Business Suite (EBS) Applications

Monday, April 7 1:00 PM - 4:00 PM

Level 1 Sands 101

15526

This is a paid workshop.  More information here:
https://blogs.oracle.com/oem/entry/focus_on_oracle_applications_management

Oracle OpenWorld AWS Booth Sessions

•Amazon Web Services Booth:  South Exhibition Hall; booth 415

Monday  10:15 : AWS Overview   10:45 : Running Oracle Software on AWS

    11:15 : RDS Oracle Overview     1:15 : Oracle EM on AWS (Oracle OEM team)

  2:00 : RDS Best Practices      2:45 : Oracle Linux on AWS (Oracle Linux team)

  3:30  How are Oracle customers leveraging AWS ? (App Associates)

    4:30 : Siebel on AWS (Enterprise Beacon)

Tuesday  10:15 : Running Oracle Software on AWS  10:45 : RDS Best Practices  

    11:15 : Accenture  1:15 : Oracle Database Advanced Architectures on AWS     2:00 : CRM Cloud in a Box on AWS (Loyalty Methods) 3:30 : AWS Overview  

    4:30  : PeopleSoft on AWS (DLZP Group)

 

Wednesday  10:15 : RDS Oracle for the Enterprise   10:45 : DR on AWS  

  11:15 NetApp Private Storage for AWS   1:15 : Extending your Data Center to Cloud     2:00  : AWS Overview 2:45 : Oracle EM on AWS   3:30 : Smarter Agent’s Cloud   Forklift to AWS (SmartShift)     

Oracle on AWS webinar recordings

Here are the three Oracle on AWS recorded to date:
1. http://www.youtube.com/watch?v=t2UcCdnNsRc&feature=youtu.be - Smarter Agent, AWS and smartShift Technologies provides an overview of how they fully migrated their customer's, Smarter Agent, Oracle database to AWS to provide a scalable and cost effective hybrid implementation

2. http://youtu.be/XSBND55sghc - Listen to this webinar, presented by Amazon Web Services (AWS) and Apps Associates, an AWS Partner Network (APN) Advanced Consulting Partner, to hear how you can leverage the AWS platform to run a centralized OEM 12c environment to free up your administrative resources.

3. http://mfile.akamai.com/23543/wmv/citrixvar.download.akamai.com/23543/www/729/667/988620541967729667/2-988620541967729667-13e6bb61c33.asx

A good introduction to running Oracle databases & applications on Amazon Web Services platform.  Hear the answers to commonly asked questions like: Which Oracle products are available and possible to run on AWS?  What does support, pricing and licensing models look like? How to size Oracle on AWS?

Watch for more webinars after Oracle OpenWorld next week.

Oracle Enterprise Manager Solutions on AWS

Listen to this webinar, presented by Amazon Web Services (AWS) and Apps Associates, an AWS Partner Network (APN) Advanced Consulting Partner, to hear how you can leverage the AWS platform to run a centralized OEM 12c environment to free up your administrative resources:

http://youtu.be/XSBND55sghc

EMaaS : Oracle OEM 12c as a Service webinar

Learn how Oracle Enterprise Manager 12c Cloud Control enables you to monitor and manage the complete enterprise application stack, web tier to storage, for both dedicated and cloud-based infrastructure environments.

Join Amazon Web Services (AWS) and Apps Associates, an AWS Partner Network (APN) Advanced Consulting Partner to hear how you can leverage the AWS platform to run a centralized OEM 12c environment to free up your administrative resources.

Register here:

https://event.on24.com/eventRegistration/EventLobbyServlet?target=registration.jsp&eventid=641039&sessionid=1&key=C3BFA66F187A7E2A5DD0C6865B83A3E6&partnerref=AWSemail_v1&mkt_tok=3RkMMJWWfF9wsRow5%2FmYJoDpwmWGd5mht7VzDtPj1OY6hBkuIryWflL6iuNDGZQ7fbSfDAMKHJ52xQ5LH%2FKDdYNF6Q%3D%3D&sourcepage=register

Replay can be found here:
http://www.youtube.com/watch?v=XSBND55sghc

OEM 12c test drive on AWS

Now you can try out Oracle Enterprise Manager 12c on AWS:https://blogs.oracle.com/oem/entry/test_drive_oracle_enterprise_manager

Oracle ADDM monitoring on AWS

OEM 12c is the away to go for monitoring ADDM metric (DB diagnostic for ADDM).  You can test drive OEM 12c running on AWS EC2 here:

http://cloudconclave.blogspot.com/2013/04/oracle-enterprise-manager-cloud-control.html

You can also monitor EC2, RDS and EBS volumes when running Oracle on AWS using the OEM 12c plug-in for AWS:

http://cloudconclave.blogspot.com/2012/12/oracle-enterprise-manager-aws-plug-in.html

Oracle Enterprise Manager Cloud Control 12c - Monitoring Essentials test drive lab

App Associates and AWS just announced a new test drive lab.  This test drive lab demonstrates how OEM 12c can be used to monitor and manage on premise Oracle environments in the cloud.

http://awslabs.appsassociates.com/oemdb-registration.php

Oracle Enterprise Manager and AWS EC2 instance restart

Question: An EC2 restart causes OEM to loss IP address of OEM management console - Is there a way to attach a static IP address to an EC2 instance instead the default o

ec2 IP.compute-1.amazonaws.com Response: If you assign an Elastic IP address to the EC2  instance before installing OEM, then you should have no problem.     Once the EC2 instance has been created (without an EIP) and  OEM has been installed there is no  other way to do it except to use this workaround -  http://cloudconclave.blogspot.com/2012/12/oracle-enterprise-manager-on-ec2-ip.html

Oracle Enterprise Manager 12c AWS plug in

There is now a plug in for Oracle Enterprise Manager (OEM) so OEM 12c can be used to monitor Oracle technology running on AWS:
http://www.oracle.com/technetwork/oem/grid-control/downloads/oem-aws-plugin-1852739.html

This plug in uses AWS CloudWatch metrics and can monitor EBS, EC2 and RDS. 

Oracle Enterprise Manager on EC2 - IP address change after reboot

The script (/usr/local/bin/sethostname) to be run by cron:

·        Login as root.

·        vi /usr/local/bin/sethostname

·        Place the following line in the /usr/local/bin/sethostname

       echo desired_hostname > /proc/sys/kernel/hostname

·        chmod 755 /usr/local/bin/sethostname

·        Issue crontab –e and place the following line in the cron tab and save.

   # SET HOSTNAME

   * * * * * /usr/local/bin/sethostname >> /usr/local/bin/sethostname.log 2>&1

·        The desired_hostname and IP entry needs to be in the /etc/hosts file

desired_hostname = Hostname of your choice.

This is work around to this known limitation: http://taliphakanozturken.wordpress.com/2011/12/31/oem-configuration-when-the-database-host-name-or-ip-address-changes/

Oracle Enterprise Manager on EC2

The situation:  Every time your reboot an AWS  server (EC2 instance - you may to do this to reattach an EBS volume that is in an LVM), - the Enterprise Manager in Oracle gets confused with the temporary host name (since the elastic IP is detached on restart). So when you assign the elastic IP back to the instance Enterprise Manager is referring to the temp hostname it got when the server rebooted.What is the recommended path to handling a server restart on elastic IPs without breaking OEM?

Solution:

I found these two items on web which may be useful:

1. https://forums.oracle.com/forums/thread.jspa?messageID=3386069

2. http://www.oracle.com/technetwork/topics/cloud/oracle-aws-getting-started-twp-171089.pdf

Both mention using this process at instance boot time:

1. export ORACLE_HOSTNAME=`wget -q -O - http://169.254.169.254/latest/meta-data/public-hostname`

2. export EMKEY_LOCATION=/u02/admin/$ORACLE_SID/

3. dbs emca -config dbcontrol db

Oracle Enterprise Manager with AWS Database Instance

Oracle Enterprise Manager 11g Database Control support was just announced this May. It seems like it may be a long time in coming but Oracle Database support on the AWS cloud was first released just a few years ago in September 2008. Here is a great blog entry on using OEM with Oracle on AWS:

AWS OEM for Oracle DB

Remember that without https in front of the URL OEM will not respond.https://ec2-99-55-139-99.eu-west-1.compute.amazonaws.com:1158/em