By Scott Mcneil-Oracle on Jan 07, 2015
|IOUG Webcast: Long Term and Cross-Database Performance Analysis for Oracle Databases Using Automatic Workload Repository Warehouse|
January 15, 2015
The Automatic Workload Repository (AWR) feature in Oracle Database has been the standard used by DBAs to diagnose database performance problems.
In this session, you will learn about the new AWR Warehouse capability, which enables DBAs with capacity planning and performance analysis for Oracle Databases without the constraint of the retention period and without any overhead on critical databases.
Learn how AWR Warehouse can tell why performance was slow this month compared to the same period last year or give administrators an annual report of problems in your mission-critical databases.
Featured Speaker: Jagan Athreya, Senior Director of Product Management, Oracle
One of Enterprise Manager Ops Center's core functionalities is to be able to provision the OS to bare metal servers. If the network you are provisioning across is connected to one of the onboard ports (on the first onboard network chip), all is well and provisioning will work as expected. This would be the case for 95% plus of all customers, but if you are trying to provision across a network that is connected to a port on a card in an expansion slot (or a second onboard network chip), your provisioning job will fail due to the incorrect MAC address being set in the JET/AI/Kickstart server. If you are one of the people who has hit this issue, please read on. If you are provisioning over an onboard NIC port, stop reading now and happy OS provisioning.
When Ops Center discovers the ILOM (ALOM/XSCF and all the other various LOMs) of a server, there are only certain pieces of information that can be collected from the LOM while the OS is running. We maintain a policy of creating as little impact as possible during discovery, so we do not force you to shutdown the OS during discovery.
Information we can collect:
Information we can NOT collect:
Since the LOM only provides the first MAC address, Ops Center must calculate the MAC addresses of the remaining network interfaces. Ops Center will get the MAC addresses for the onboard NICs correct but its calculated MAC addresses will be wrong for any NICs not on the first onboard network chip.
If we have an example system that has 4 onboard network ports (on the motherboard) and an expansion network card in the PCI-E/X slot with an additional 4 network ports, Ops Center's view of that server, based on the information from the LOM, would not match the physical server.
|Interfaces Name||Ops Center's Mac Address - Calculated ( from LOM)||Actual Mac Adress||Correct|
|Number of Network interfaces||8||8||YES|
|Mac Address for interface 0 (onboard)||net0||00:21:28:17:72:b2||00:21:28:17:72:b2||YES|
|Mac Address for interface 1 (onboard)||net1||00:21:28:17:72:b3||00:21:28:17:72:b3||YES|
|Mac Address for interface 2 (onboard||net2||00:21:28:17:72:b4||00:21:28:17:72:b4||YES|
|Mac Address for interface 3 (onboard||net3||00:21:28:17:72:b5||00:21:28:17:72:b5||YES|
|Mac Address for interface 4 (PCI-E/X card)||net4||00:21:28:17:72:b6||00:14:4f:6b:fd:28||NO|
|Mac Address for interface 5 (PCI-E/X card)||net5||00:21:28:17:72:b7||00:14:4f:6b:fd:29||NO|
|Mac Address for interface 6 (PCI-E/X card)||net6||00:21:28:17:72:b8||00:14:4f:6b:fd:30||NO|
|Mac Address for interface 7 (PCI-E/X card)||net7||00:21:28:17:72:b9||00:14:4f:6b:fd:31||NO|
You can confirm that the Mac addresses for an expansion network card has been calculated, by looking at the Network tab in the BUI for the LOM object.
You can see the displayed MAC addresses for GB_4 and GB_5 are just a simple increment of 1 from that of GB_3 which should not be the case as GB_4 and GB_5 are on a PCI-E/X expansion card. While most Oracle(Sun) servers have 4 on-board network interfaces of the same type, some servers may have 2 x 1GBit interfaces and 2 x 10Gbit interfaces. In this case, only the first on-board network interfaces will display the correct MAC addresses.
It should be noted that if you have discovered the LOM and discovered the running operation system, Ops Center will have been able to identify the correct MAC addresses for all the network interfaces as it combines the information gathered from the LOM and the Operating System to display the full picture (correct values). Unfortunately, you can not rely on these when re-provisioning, as part of the OSP job will delete the OS object (we are re-provisioning it after all) and the cached values for the MAC address may expire before the JET/AI/Kickstart server is configured.
If you were to provision across net0, net1, net2, or net3 all would work well, but if you selected net4 or above for provisioning, the job would fail due to a timeout in the "Monitor OS Installation" task as the Jet/AI/Kickstart server would have been configured with the wrong MAC address and so it would have not responded to the OSP request. Please note that a misidentified MAC address is not the only possible cause of a timeout in the "Monitor OS Installation" task. This error only indicates that some step of the OS provisioning has failed and can be caused by a number of different issues.
There are 2 ways of provisioning to secondary network interfaces
In Ops Center 12.2.0, we introduced an option to specify the MAC address to provision across directly in the BUI. When running the "Install Server" Action/Wizard, the "Boot Interface Resource Assignments" page has a check-box [Identify Network Interface by MAC Address]. Selecting this check-box will change the wizard from using netX interface names that rely on the discovered MAC address, to letting you manually enter the MAC address. This entered MAC address is used to setup the JET/AI/Kickstart server and is used to interrogate the OBP of the server to workout the netX interface that is required for wanboot.
It is as easy as that and your provisioning job will progress as normal.
Assuming you have already discovered and managed the systems LOM, you can overload (update) the discovered/calulated network interface MAC addresses.
In the BUI, select "Assets" ==> "All Assets" ==> "Add Assets"
then choose "Manually declared server to be a target of OS provisioning"
While this could declare multiple servers using an XML file, in this example, we will just be doing a single server. This wizard normally lets us declare a server network interfaces but as some of the MAC addresses we will be declaring are already part of an existing discovered server LOM, Ops Center will identify the overlaping MAC address and merge this data with the existing server. The matching interfaces will stay the same but the new MAC addresses will overload (replace) the incorrect addresses.
Select Declare a single server, then click the [Green Plus] icon
Enter the port name [GB_X] and the actual MAC address.
Repeat this for all the interfaces, up to and including the one you want to provision across.
Do not skip any interfaces as the interface numbering is based on the order the entries are stored in the database.
When you have entered all required interfaces, you then have to fill in the server details.
Once completed, click the [Declare Asset] button and wait for the job to complete. Normally, this will just take a few seconds.
You can check in the BUI that the updated MAC addresses have been applied.
Now, just run your provisioning job as per normal and the correct MAC address will be configured in the JET/AI/Kickstart server.
As you can see, if you have updated your Enterprise Controller to Ops Center 12.2.0 or higher, option #1 is the simpler method.
All the best with your OS provisioning,
How are you keeping up with the challenges and demands from the business? Are you able to innovate or just keeping the lights on?
Read the latest business brief on Oracle Database Performance Management to get better insight into the challenges facing IT and find out ways to overcome them.
Check out the latest SearchOracle article featuring Brett Curtis, System Administrator from IDEXX Laboratories. Read how Brett outlines how IDEXX is benefiting from using Oracle Enterprise Manager to not only monitor both middleware and database systems, but use it for provisioning as well.
Many enterprises run their EM 12c environments in the offline mode (no direct internet connection). These customers have the additional task of downloading the plug-ins, connectors, agents, etc on a machine with access to internet, and then upload them to EM. The current solution makes the task of fetching the download url rather cumbersome, so in this blog i discuss a quick hack to list all download urls for plug-ins and agents.
Check for compliance and automate patching of Oracle Database fleet using EM12c
Oracle along with its regular Quarterly Database PSU/SPU/CPU update this October 2014 released Oracle JAVA VM PSU patch, the patch is recommended to be applied to all databases in your fleet (esp. the ones that uses JAVA). (For more information, support Note- 1929745.1 explains it in detail).
The mandate primarily is to apply the patches against the databases that use JAVAVM option. Ideally, you would need to apply it against all databases, so in case a new database is created in the ORACLE_HOME it is covered.
Oracle Enterprise Manager 12c provides support features of Compliance Management and automated Patching of databases. Using both these features you could identify the databases in your fleet that needs the patch and automate applying them.
To get started, download the starter kit here. It contains utilities to jump start on your compliance, the kit contains a readily importable Compliance Standard and a step-by-step guide.[Read More]
The latest issue of the Oracle Enterprise Manager 12c newsletter is out. Read all about the latest news and information around the award winning Oracle Enterprise Manager 12c solution. This month's edition features the Oracle Application Users Group (OAUG) survey results, new study on middleware management cost reduction, and the latest details on Oracle Enterprise Manager for MySQL Database plug-in.
Oracle Database 12c contains many new capabilities including Oracle Multitenant, in-memory column stores and much more. Oracle Real Application Testing gives you verifiable functionality and performance testing capabilities to take advantage of all the new enhancements. Combining your database upgrade with Oracle Real Application Testing assures you that your database will perform as required, whether you’re implementing an in-memory column store, consolidating to a database as a service model, or doing an in-place upgrade—join us in this webcast to learn more.
Contributing Author: Shiraz Kanga, Consulting Member of Technical Staff, Oracle
Figure 2. Heap after GC and Garbage Collection Overhead for a specific JVM
Java SE 6 HotSpot Virtual Machine Garbage Collection Tuning http://www.oracle.com/technetwork/java/javase/gc-tuning-6-140523.html
Oracle OpenWorld is at full speed now and this morning we just delivered our Enterprise Manager general session. We realize that probably the majority of the thousands of readers of our blog are not attending OpenWorld so that's why we have created a summary of the Tweets that were sent during the session
(in case you are not familiar with Twitter timelines, please read from the bottom to the top for a chronological order of the presentation)
For those that want to see the full presentation, we've uploaded them to our SlideShare account for your convenience .
For all Enterprise Manager related sessions at Oracle OpenWorld 2014, please take look here and let us know which one you'd like to see summarized or even see the full deck?
To help customers simplify management of complex IT environments, Oracle is extending Oracle Enterprise Manager capabilities to MySQL databases. With this new offering, customers can manage deployments of MySQL, either on-premises or in a cloud. Existing users of Oracle Enterprise Manager can now easily add MySQL to their environments. With this capability, customers can manage their applications and technology stack, including web and departmental applications that rely on MySQL, all from a single console.
With Oracle Enterprise Manager for MySQL Database, customers can benefit from:
Watch the Demo:
MySQL Enterprise Edition customers can download Oracle Enterprise Manager for MySQL Database, Release 5.5 and higher, which is available on Oracle Linux and other Linux distributions, Microsoft Windows, and Oracle Solaris. Watch the demo for more details.
Follow Oracle Enterprise Manager 12c @ Oracle OpenWorld
If you are planning to attend OpenWorld this year, make sure you maximize the full conference experience—stay connected to all the Oracle Enterprise Manager 12c activities.
For the complete list of OpenWorld events and activities, read the Oracle Enterprise Manager 12c Focus on Doc.
Latest information and perspectives on Oracle Enterprise Manager.