Questions and Answers from Oracle Webinar: Simplify Database Lifecycle Management with Oracle

Dear Friends,

On March 21st, the ancient New Year or Navroz day for many countries on our planet that celebrates the spring equinox as the auspicious start of the year, I was the speaker at an Oracle Webinar "Simplify Database Lifecycle Management with Oracle".

The webinar was very well received, with 140+ registrations and 95 attendees on the day and time itself. There were a number of good questions asked at the end of the webinar, and as per my usual practice, I am posting the answers on the blog for the reference of everyone. Enjoy!!

Question:
Is an out of place upgrade of grid control OMS possible from 11g to 12c?

Answer:
Yes, this is possible. Please refer to the upgrade methods described in the Cloud Control Upgrade Guide http://docs.oracle.com/cd/E24628_01/upgrade.121/e22625/overview_upg_approaches.htm#CJAHJGJI

Question:
I was told that 12c OMS will support only targets where 12.1.0.1 agent is installed. Is this correct? If so, does this agent version can monitor 9i databases?

Answer:
Yes, 12c OMS will only support 12c agents. It cannot talk to 11g agents. This is because the agent has been revamped to a modular architecture. For eg. even a database plug-in needs to be deployed now to an agent running on a database server, previously this was in-built. So now it is easier to deploy a new db plug-in. for eg when the 12c db comes along.  Regarding the target db version, yes, the 12c agent with the db plug-in can manage 9i, 10g, 11g databases.

Question:
It is interesting to know about EM 12c, but ERP like SAP does not have this features in built for the only reason could be Licenses, or limiting functionality given by Oracle so that we are only limited with features provided by SAP only.

Answer:
Certain EM Packs can be used depending on the SAP license you have. I would suggest to speak with your local SAP representative.

Question:
Question related to licensing: We are using Oracle RAC Standard Edition and DbConsole. To what extent (excluding the additional OEM license packs) are we entitled to use the OEM 12c?

Answer:
Configuration of metric thresholds and viewing alerts in the console are part of base EM. This is known as basic monitoring, you can use that. However since since you can't use/license the packs with standard one edition, you can't use pack features such as notifications.  Neither can you use the advanced features such as configuration management, EM patching provisioning, change management, or tuning. You can see the features in each pack at http://docs.oracle.com/cd/E24628_01/license.121/e24474/ch2_db_mgmt.htm

Question:
Can I have multiple Gold image at different instance of time?

Answer:
Yes, definitely. You can have multiple Gold images at any time. Suppose you had a Gold image created 3 months ago with an older CPU (critical patch update), you can now create a second one with the new CPU. Likewise, you can have a Gold image for a 10g database, or 11.1, or 11.2, and also gold images for different operating systems, eg. different ones for Linux, Solaris, AIX, etc.

Question:
Hi Porus, does EM 12c has the facility to tune the parameter? What about the static parameter.

Answer:
With the Diagnostics/Tuning Pack licence, when you run ADDM and the Tuning/Access advisors, advice is given on how to best tune your system and your SQL. This will include some of the init parameters for eg. cursor_sharing, the memory parameters, optimizer parameters, etc. Would recommend trying it out.

Question:
How can we provision the golden database in EM and use that for deployments

Answer:
You mean the Gold Copy. It is possible to take a reference database system, and create a Provisioning Profile from that. The Profile can then be used as input by the Provisioning Designer when he/she launches a deployment procedure to create a single-instance or RAC database, and then locks down the inputs, saving the procedure and publishing it to a Provisioning Operator. The operator is then able to use the locked down procedure to create new database installations and new databases either for single-instance or RAC. This requires the licence of the Database Lifecycle Management pack (DBLM).

Question:
Please share the upgrade methodology of 11g Grid to 12c Grid

Answer:
There are two methods, the one-system approach or the two-system approach. You can upgrade from EM10g or 11g to EM12c. Please read the Upgrade Guide http://docs.oracle.com/cd/E24628_01/upgrade.121/e22625/toc.htm for further details.

Question:
Honestly, I would liked to see 12c 3-4 years back. Does Oracle have R&D dept and what can be delivered? R&D must be present, but how much investment to come up with market demand? like SAP.

Answer:
EM 12c builds on the experience of EM 10g and 11g. I have been using EM since the PC-based days of Oracle Server Manager in the 1990s and I would say it has definitely got better. There is no tool in the market that can do everything. Oracle technology is very complex and Oracle EM is the best to manage the Oracle stack.

Question:
Do you have any plugin for big data appliances.

Answer:
No EM12c plug-in exists for Big Data yet. However, as far as I am aware, the Big Data Appliance is using the X4270M2, Oracle Linux, and an application stack made of hadoop, java, nosql, R, connectors, HDFS.  Enterprise Manager Ops Center comes out of the box ready to help with the hardware and OS part of the stack. If you want to do configuration management, Enterprise Manager has a highly extensible configuration framework to capture configurations and retain a history of configuration changes.

EM also has a provisioning framework that can be used to generically provision applications. There is also an extensible user defined metric capability (UDM) that can be used to capture and alarm value matches.
These capabilities can be used to monitor and manage Big Data today. You can also use Cloudera Manager to monitor the Hadoop stack.

Question:
What are the steps to clone agent ?

Answer:
Please refer to the chapter ""Cloning Oracle Management Agent"" in the Cloud Control Advanced Installation and Configuration Guide. The link is:
http://docs.oracle.com/cd/E24628_01/install.121/e24089/clone_agent.htm

Question:
Hi I got few questions, it would be better if you could clarify me on these areas
1) OEM 12c Doesn't require and agents running on each target?
2) Will it support the targets on different time zones?
3) What about the Oracle Inventory status while cloning

Answer to Question 1:
To have fully managed targets, the 12c agents need to be installed. In initial discovery, you can use an IP scan in EM to find targets and probable software running on them, this is done via IMAP protocol. Then, you need to promote these targets from unmanaged to managed, this deploys the agent.
Note that you can have a shared agent - refer to http://docs.oracle.com/cd/E24628_01/install.121/e24089/install_agent_usng_shrd_hm.htm#CACHFCGE which is in the Cloud Control Advanced Installation and Configuration Guide. This chapter describes how you can install a Shared Agent with the help of a central, shared Oracle home location of an existing Oracle Management Agent (Management Agent) that is installed on an NFS-mounted drive.

Answer to Question 2:
Yes, you can have management agents in different time zones. The Managemet Agent uses the time zone set in emd.properties file. Resetting the time zone for an agent is explained in http://docs.oracle.com/cd/E24628_01/doc.121/e24473/emctl.htm#BABJAJGF which is the Cloud Control Administrator's Guide.

Answer to Question 3:
Yes, the Oracle inventory will be updated on the target server when cloning. This is Oracle who has written the deployment procedure so they are aware of what needs to be done in the Oracle inventory, most definitely.

Question:
It is possible to Add new RAC node through EM?

Answer:
Yes, you can extend a RAC cluster and add a new RAC node via EM. Please see http://docs.oracle.com/cd/E24628_01/em.121/e27046/prov_extend_racdb.htm#CHDCCJDA which is ""Extending Oracle Real Application Clusters"" in the Oracle Enterprise Manager Lifecycle Management Administrator's Guide 12c .

Question:
Can we configure DB replication using EM ?

Answer:
Yes. This is a part of the base database management features of Enterprise Manager Cloud Control 12c. You can configure and manage movement of data between databases using features such streams, replication, data pump. Please see http://docs.oracle.com/cd/E24628_01/license.121/e24474/ch11_base_functionality.htm

Question:
Regarding agentless discovery. How does OEM know that particular server is the one I need to do discovery on? Should we need to give the IP or server name?

Answer:
Yes, IP scan requires the IP address or range of IP addresses. This uses the NMAP protocol.

Question:
Can u please brief us on Licencing of 12c EM

Answer:
You can install EM12c on a separate server(s) for free, there is no cost for the Oracle database or OMS software on the EM servers provided you dont use the EM database for any other application.
If you use Data Guard or RAC for the EM database, then the EE license and RAC licence is payable.

The base installation of Enterprise Manager Cloud Control 12c includes several features free of charge WITH the purchase of ANY Oracle software license or Support contract.

The release of EM 12c makes several licensing changes. Some features that were part of licensed packs are now included in the base functionality. Please look at this chapter http://docs.oracle.com/cd/E24628_01/license.121/e24474/ch11_base_functionality.htm in the Licensing Information 12c guide, which outlines the list of features that are included with the base functionality of Oracle Enterprise Manager.

Anything beyond those features is payable. Look at http://docs.oracle.com/cd/E24628_01/license.121/e24474/ch2_db_mgmt.htm#BABGAFHD for the Enterprise Database Management licences. This chapter explains the database packs like Diagnostics, Tuning, Lifecycle Management, Data Masking, and so on. This guide "Oracle Enterprise Manager Licensing Information" on http://docs.oracle.com/cd/E24628_01/license.121/e24474/toc.htm is good enough.

Question:
Can we configure & monitor Oracle EBS Sevices & processes on OEM?

Answer:
Yes, definitely.  You can use the Enterprise Manager Application Management Suite (AMS) for E-Business to monitor and manage E-Business, including cloning, patch management and customization management. For further information please see the white paper I wrote "Managing Oracle Applications with Oracle Enterprise Manager 11g" http://www.oracle.com/us/products/enterprise-manager/managing-oracle-apps-404877.pdf

Question:
Does this integrate with SQL Developer Data Modeler for capturing changes from base system?

Answer:
A change plan can be created by the developer in SQL Developer, who then submits it, which the DBA can then access in Enterprise Manager 12c, approve, and synchronize another database with that change plan for eg. the developer can make changes on development, put the changes in a change plan, and the DBA can approve and apply on a test database, followed by production later. Please see section 1.15 Change Manager Support in SQL Developer in the Oracle SQL Developer User's Guide at http://docs.oracle.com/cd/E25259_01/appdev.31/e24285.pdf

Question:
Benifits of agent cloning?

Answer:
Benefits are obvious. If you want to install an additional Management Agent that is identical to the existing well-tested, pre-patched, and running Management Agent, then the best option is to clone the existing instance. This saves time and effort in patching a fresh installation all over again and bringing it to the current state. Please refer to the chapter ""Cloning Oracle Management Agent"" in the Cloud Control Advanced Installation and Configuration Guide. The link is:
http://docs.oracle.com/cd/E24628_01/install.121/e24089/clone_agent.htm

Question:
SAP sometime does not recognize the schema provided by Oracle directly. So when you install Oracle for SAP, EM does not come along with it.

Answer:
Certain EM Packs can be used depending on the SAP license you have. I would suggest to speak with your local SAP representative.

Question:
Will Oracle support for this free basic tool?

Answer:
Oracle EM Base licence for basic monitoring and basic database management is only free if you have purchased some Oracle software licence and support. For eg. say there is an Oracle Database Enterprise Edition in your company, it has been purchased and you have the support license purchased too per year (that is the only way you can upgrade to new versions and get patches from Oracle). Then, you can call Oracle Support and also ask them to help with basic EM issues to do with basic monitoring and basic database management. IF you dont have a support contract all all, you cannot do this since you wouldnt have a CSI number in the first place.

Question:
Where can I see the list of features for which I have paid the licences?

Answer:
Certain things are free, look at the earlier answer in this post for the Licensing question. If you have paid licenses for packs like Diagnostics, Tuning, etc, because Oracle products have never had a licence key, there is no way you can check inside the product. You need to ask your Oracle sales representative as to what licences your company has purchased.

Question:
Is golden gate replication managed by EM?

Answer:
The Oracle Golden Gate (OGG) plug-in for Em 12c will be released in the near future. However, there is an existing "management pack" for OGG that you can use. Please see the pdf on http://www.oracle.com/us/products/middleware/data-integration/goldengate/059449.pdf
This will help you to monitor and manage OGG. However this is not EM but a separate product.

Question:
As per today webcast patch cloning possible through cloned oracle home ... basically my question how does that work ..

Answer:
This is known as "out of place" patching. Basically you select a patch or multiple patches into a patch plan, and say you want out of place patching. You then have to specify a new Oracle Home on the target server. When you deploy the patches, Oracle Enterprise Manager first clones the existing home, makes a copy of it, and then patches the copy. During this time, there is no downtime. When you schedule the last stage, EM will shut the database, switch it to the new home and start it from the new home, and run the post-patch SQL on the database. This reduces downtime. However, space is required for the cloned homes.

Question:
Can we upgrade EM 12c from EM 10g Rel2?

Answer:
Yes, the database version must be 10.2.0.4 or above for upgrade to 11.2.0.1 and 11.2.0.2. Please see ""Upgrading Databases"" http://docs.oracle.com/cd/E24628_01/em.121/e27046/upgrade_db.htm#CHDJGJJC in the  Lifecycle Management Administrator's Guide for 12c.

Question:
Our Organization is trying to deploy on 10g for its Microfinance business, which one is most suitable ot us in terms of technology and price and Technology

Answer:
I would recommend Oracle Enterprise Edition 11.2 and not 10g. Always use the latest version, it continues in support longer. Older versions eventually need to pay extended support if they are not upgraded, and older versions will run into this scenario sooner than the newer versions.

Question:
How does EM 12c compare with VMware tools? How about Oracle VM versus VMWare?

Answer:
EM 12c is able to manage the Oracle stack much more deeply than any other product. In the EMC VMware world, they can monitor a Vmware machine but only at the machine level - the products used may be unaware of the internal state of the Oracle database inside the machine. Whereas, Oracle EM can fully manage Oracle Databases on our supported and certified Oracle VM hypervisor product.

Regarding VMware, see Metalink Note 249212.1 – “Oracle Support Policy Regarding VMware”, which states, “"Oracle has not certified any Oracle Software on VMware virtualized environments”. On the other hand, Oracle has announced certification of key Oracle products including Oracle Database, Oracle Fusion Middleware, Oracle Applications, and Oracle Real Application Clusters with Oracle VM Server for x86.

Oracle EM provides integrated management of the physical and virtual infrastructure whereas VMware’s management is primarily for the virtual infrastructure with very limited capabilities for the rest of the IT stack. Oracle VM is less costly and is more performant (less overhead) than VMware. Oracle VM 3.0 is four times more scalable than the latest VMware offering, supporting up to 128 virtual CPUs per virtual machine, at a fraction of the cost. When compared to VMware vSphere5 running Red Hat Enterprise Linux guest VMs, Oracle VM 3.0 running Oracle Linux guest VMs is four times less expensive. Oracle VM is free to download, has zero license cost, and affordable, enterprise-quality support is offered through a simple subscription model per server.

Question:
What is the architecture used for large installations of Enterprise Manager?

Answer:
When used for thousands of targets, you can use multiple management services fronted by a load balancer and back-ended by a repository database server which may or may not be a clustered RAC database. So the architecture is fully scalable.

Question:
Is it possible to set up Data Guard using Enterprise Manager?

Answer:
Yes, of course. This and other DBA tasks, like setting up RMAN backups, can be simplified and automated by simply answering wizard questions. Time savings are enormous.

Question:
Can you compare as well as synchronize reference data using the change management capabilities of DBLM?

Answer:
Yes, but only data comparison can currently be done via the Enterprise Manager console. Data synchronization can only be done via the command line i.e. using the DBMS_COMPARISON package.

Question:
Can you perform auto discovery on a range of IP addresses behind a firewall?

Answer:
Yes, but you need to use an agent for the auto discovery which is also behind the same firewall.

Question:
Is it possible to patch the Oracle RAC databases on Exadata using out of place patching?

Answer:
Absolutely yes, however regular RAC databases are not supported for out of place patching at this point.

Question:
Is there a master note for Installation of Enterprise Manager 12c?

Answer:
Yes, please see this document in My Oracle Support (MOS):
Master Index for Cloud Control Oracle Management Service (OMS) and Repository Installation, Upgrade and Patching [ID 1363769.1]

Regards,

Porus.

Oracle Database 11g Interactive Quick Reference

Oracle has just released the Oracle Database 11g Interactive Quick Reference, which is sure to be a big hit among DBAs. You can download it from this link:

http://www.mediafire.com/file/sbpozvrb7yn9wf8/db11g-interactivequickref-187977.zip

This is an interactive quick reference for the many DBA views, architecture and Background Processes in 11g.

Easy Disaster Proof Production : My New OTN Article published

I am pleased to announce that in the first month of the new year 2010, a brand-new technical article of mine has been published on the Oracle Technology Network :

Easy Disaster Proof Production with Grid Control
http://www.oracle.com/technology/pub/articles/havewala-easydr.html

The article, based on personal real-life experience, explains how the use of Oracle Enterprise Manager Grid Control for Data Guard setup, management (including switchover or failover), and monitoring can save a lot of time and resources.

Please read, enjoy and recommend to your friends and colleagues.

A Happy New Year 2010 to all of you. All the Best for the New Year.

Regards,

Porus Homi Havewala
(Oracle ACE Director).

Most Popular OTN articles in 2009 - two of my articles on Enterprise Manager

Fellow Readers,

Great News. The Oracle Technology Network (OTN) has just published
the list of Most Popular OTN articles in 2009 and two of my articles
on Enterprise Manager are in the list.

http://blogs.oracle.com/otn/2009/11/the_most_popular_articles_and.html

The OTN is the world's largest community of Developers, DBAs and Architects.
The two articles of mine in the top 10 are:

Oracle RMAN Backups: Pushing the "Easy" Button
Oracle Enterprise Manager Grid Control Architecture for Very Large Sites

Thanks for the tremendous support of the readers on this topic. My aim is to make Grid Control popular among the DBA and IT community, it really is a fantastic product that makes our lives easier.

Regards,

Porus.

Final 2009 seminar on Oracle Performance Options, Products and Enterprise Manager Packs

This Friday, I conducted another interesting seminar which was S&I System's last Oracle seminar for the year. The topic was Oracle Performance Options, Products and Enterprise Manager Packs.

These were the topics I covered. The clients were introduced to many new Oracle concepts for the first time.

• Partitioning Option, and improvements in 11gR2
• Parallel Query Option, and improvements in 11gR2
• Advanced Compression Option (11g), and Hybrid Columnar Compression in 11gR2
• Active Data Guard (11g)
• In-memory Database Cache (Times-Ten), and it's Grid in 11gR2
• Enterprise Manager Diagnostics and Tuning Packs
  

The following Enterprise Manager packs were also demonstrated in live demos:

• Service Level Management Pack
• Configuration Management Pack
• Diagnostics and Tuning Packs
• Remedy Connector
  

I also demo'ed the new Enterprise Manager feature of SQL Monitoring of long-running SQL in 11g databases, which suitably impressed the attendees.

A number of clients immediately expressed interest in using the Service Level Management and Configuration Management packs for their hundreds of database targets, and discussed Grid Control architecture for such large systems.

The 2009 list of successful Oracle seminars conducted by S&I Systems can be seen on:

http://www.si-asia.com/marketing/oracleworkshops2009/

Customer Webcast: Mass Patching of Oracle Databases with Enterprise Manager

This is an interesting webcast from Oracle for Customers:

Mass Patching of Oracle Databases with Enterprise Manager

Date: Wednesday 7 October 2009
Time: 08:00 a.m. to 09:00 a.m. (PST8PDT)

Description:
http://conference.oracle.com/imtapp/app/conf_enrollment.uix?mID=159112088&mConfKey=grid

Please register for this.

Third Workshop on Grid Provisioning and Patch Automation

I just conducted a successful third workshop in the Oracle Office at Singapore
on Grid Provisioning and Patch Automation. There were a lot of attendees.
Many who could not attend are asking for repeat seminars.

In the workshop, I introduced the clients to sophisticated Oracle Grid
technology, including RAC, Weblogic server clusters, the Coherence
in-memory data grid, ASM, Oracle Enterprise Linux and Oracle VM.
I interested a lot of attendees in Oracle VM pools with Enterprise Linux
as a future platform for the Grid. I explained the various Enterprise
Manager Packs, especially the Configuration Management Pack and
the Provisioning and Patch Automation Pack.

Using an Amazon installation of Oracle Enterprise Manager
Grid Control Release 5 with the Provisioning and Patch
Automation pack - thanks to one of my friends who loaned me
this Amazon installation - I was able to successfully demonstrate
patching of twelve 10g databases with 5 patches, showing the
power of Grid Automation. The clients were suitably impressed
by the technology capabilities of Grid Control. At the same time
I told them about Oracle’s support of the Cloud.

I also successfully demonstrated a RAC Rolling Patch upgrade
of a two node RAC cluster, again using the Provisioning and
Patch Automation Pack on Oracle demonstration servers.

The DBA attendees asked for:

Ability to backup the db before the patch is applied – this feature is coming
Ability to rollback patches using Grid Control – this feature is coming
Ability to use PBRUN etc for security – which is already there
Ability to do offline download of patches – already there
Ability to keep a log of all changes done via the Grid Control console
Ability to do in Grid Control 10g what can be done in Database Control 11g eg. REPLAY

I have given this feedback to Oracle development.

Future workshops can be seen on:
http://www.si-asia.com/marketing/oracleworkshops2009/

Enterprise Manager Blog assists Akshaya Patra

The Enterprise Manager Blog, as a part of its social responsibilities, has decided to
assist a worthwhile charity doing good work in India - "Akshaya Patra" which is
feeding thousands of school children in India everyday with a noonday meal.
This in turn will help their education. Akshaya Patra is well known for doing
a great job in India in this regard.

The charity is currently trying to achieve a target in Global Giving, and we
are hosting their widget at the side of this blog. Please give what you can to
help achieve their target. The direct link is also below.

http://www.globalgiving.com/projects/sponsor-school-meals-of-200-000-children-in-india/?RF=widget_small3304

The Blog normally talks only about Oracle Enterprise Manager and related matters, but
we made an exception in this case, since it is a chance to do a lot of young children some good.

Second Workshop showed Grid Control creating and managing Dataguard

We just conducted a highly successful second workshop in
the Oracle Office at Singapore. A number of large banks attended
besides other large corporates in Singapore. We had Solution
Architects, Lead Engineers, Database Engineers, Database
Managers , Asst Vice Presidents, IT Directors, and EVPs.

We explained the disaster recovery options from Oracle, introducing
the attendees to powerful Oracle products such as Normal Dataguard,
Active Dataguard, RAC, Streams, Oracle Transparent Gateways,
Replication, Oracle Data Integrator (ODI) and the newly acquired
Oracle Golden Gate software.

The Enterprise Manager Grid Control interface was used to demonstrate
the management and performance monitoring of the Data Guard configuration,
as well as the command line interface of Data Guard “dgmgrl” for the switchover.
The power of Enterprise Manager Grid Control was emphasized for setting
up and managing Oracle Data Guard, as also the Provisioning Pack
to clone Oracle software and databases.

The attendees were excited about the Oracle technology explained
and showcased, and mentioned it was an “excellent” or “great” seminar.

Future workshops can be ssen on:
http://www.si-asia.com/marketing/oracleworkshops2009/

My profile in Peer to Peer of Oracle Magazine

For the first time, I have been profiled in the Peer to Peer Section
in Oracle Magazine of May June 2009. Here is the page. What did I talk about? Grid Control, of course!

For space reasons, the magazine had to leave out some lines from the profile,
that I am reproducing here fully:

What technology has most changed your life? Oracle grid technology, including Oracle Enterprise Manager 10g Grid Control and all the great management packs. I am an Oracle Grid Computing enthusiast: I really like the advanced capabilities of Oracle Grid Control for tasks such as patching databases in an automated schedule, setting and scheduling Oracle RMAN [Oracle Recovery Manager] backups on the fly, and issuing SQL scripts and OS commands against any database or server. Oracle Grid Control has the potential to automate a lot of tedious DBA tasks.

What would you like to see Oracle, as a company, do more of? Oracle has demonstrated technical and thought leadership since its inception in 1977, the year of Star Wars. The most recent example of innovative technology is the announcement that we can use Oracle Grid Control to back up our databases directly to the Amazon Elastic Compute Cloud, thus negating the requirement for tape drives and offline storage of backups. My request would just be to keep up the technical and thought leadership. That’s what all Oracle DBAs appreciate.

What green practices do you use in your DBA work? I don’t print anything—I keep everything as electonic copies. Recently my office moved locations, and I was the only one to have a clean, green desk. All I had to move was my laptop and phone. The others were astonished.

Do you have a favorite vacation spot? There is no country as beautiful as India. I love the countryside, the undulating hills, and the villages. This is life at its most spiritual and simplest. The ocean shores of India are also very beautiful, and I love to visit these sandy beaches. I also like to vacation in Udwada in Gujarat, which is a pilgrimage spot for our ancient Zoroastrian religion. There’s a holy fire there that’s been burning for more than 1200 years.

Grid Control Sessions in DBA Round Tables by Oracle OTN

Fellow DBAs,

The Oracle Developer Program team (which is the same as the Oracle Technical Network ie. OTN) is holding an Oracle DBA Round Table in Kuala Lumpur on 25th November and in Singapore on 27 November. Oracle DBA Round Table is a half-day session and the purpose of the round table is to create a sense of community, share experiences and provide DBAs with the opportunity to network with Oracle experts, Oracle ACE/ACE Directors and other DBAs.

As the only Oracle ACE Director in this region, I will be conducting a session at both events on "Patching Databases with Grid Control". The scheduled agenda is as follows:

Kuala Lumpur, 25 November
Time	Activity	Speaker
10.00a.m.	Introduction	Blair Layton
10.15a.m.	Flashback Data Archive	Rajender Singh, Oracle ACE
11.15a.m.	Backup and Recovery with Oracle Database
12.15p.m.	Lunch
1.00p.m.	Patching Oracle Databases via Grid Control	Porus Homi Havewala, Oracle ACE Director, S&I Systems Pte Ltd
2.00p.m.	Customer Presentation
3.00p.m.	Break & General Discussion	Blair Layton
4.00p.m.	Closing Remark	Blair Layton
Singapore, 27 November
Time	Activity	Speaker
10.00a.m.	Introduction	Blair Layton
10.15a.m.	Creating an Ideal Database Infrastructure	Ravishankar Buddha
11.15a.m.	Backup and Recovery with Oracle Database
12.15p.m.	Lunch
1.00p.m.	Patching Oracle Databases via Grid Control	Porus Homi Havewala, Oracle ACE Director, S&I Systems Pte Ltd
2.00p.m.	Customer Presentation - Olam 11g Reference
3.00p.m.	Break & General Discussion	Blair Layton
4.00p.m.	Closing Remark	Blair Layton

The events will be held in the Oracle offices:

Oracle KL address:
Langkawi Room
Level 38 Menara Citibank, 165 Jalan Ampang, 50450 Kuala Lumpur, Malaysia

Oracle Singapore address:
Hong Kong Room
6 Temasek Boulevard #18-01 Suntec Tower 4 Singapore 038986

Please let me know if any of you will be attending the round tables in either Kuala Lumpur or Singapore, and I will let Oracle know. You can write to oracleacedirector@si-asia.com , thanks.

Free Oracle GRID CONTROL workshops in Singapore

Oracle DBAs / Database Managers / Senior Management,

If you are based in Singapore, please feel free to attend the Oracle GRID CONTROL workshop we will be running at our Office @ 2.30 to 5pm Every Thursday starting 25th Sept. These workshops are totally free. Snacks and drinks will be provided.

S&I Oracle Core Technology Workshop Series

25th Sept : 2 hour session on Grid Control architecture and day to day Database Management using Grid Control

· Explain Grid Control architecture and scalability for multiple target monitioring and management
· Explain Grid Control multiple-level security via target groups, administrators, roles, privileges
· Overview of Grid Control Console and access to target information such as database versions, server configurations, server performance, alerts and patch notifications
· Overview of Database Home Page
· Day to day Database Administration using Grid Control
· Execution of server scripts on multiple hosts or sql scripts on multiple databases

2nd Oct: 2 hour session on Database Performance monitoring and Performance improvement using Grid Control

· Overview of Database Performance page
· Drilldown to specific performance issues and top events
· Generate stress load on the database using Swinggbench and demonstrate ADDM capabilities
· Demonstrate Advisor Central capabilites eg. Sql Tuning Advisor, Sql tuning sets

9th Oct: 2 hour session on Database RMAN Backups using Grid Control

· Overview of Database Maintenance page
· Configure RMAN settings for a database eg. controlfile autobackup, retention policy
· Setup and schedule full RMAN backups for a database
· Setup and schedule incremental RMAN backups for a database
· Setup and schedule image copy refreshes for a database

16th Oct: 2 hour session on Database Patch application using Grid Control

· Overview of Patch Deployments using Grid Control
· Critical patch advisory for databases on Grid Control
· Connect to Metalink and find a patch, download to staging area on oms server,
· After testing, deploy patch on multiple databases in an automated “lights-out” operation

Our office address is curently:

S&I Systems Ptd Ltd
298 Tiong Bahru Road
#12-01/06 Central Plaza
Singapore 168730
http://www.si-asia.com/

Please register (free) by emailing your name, title, company and contact information to
OracleAceDirector@si-asia.com

Look forward to seeing you in the workshop.