Sunday Sep 30, 2012

Oracle Enterprise Manager users present today at Oracle Users Forum

Oracle Users Forum starts in a few minutes at Moscone West, Levels 2 & 3. There are more than hundreds of Oracle user sessions during the day. Many Oracle Oracle Enterprise Manager users are presenting today as well.

 In addition, we will have a Twitter Chat today from 11:30 AM to 12:30 PM with IOUG leaders, Enterprise Manager SIG contributors and many speakers. You can participate in the chat using hash tag #em12c on Twitter.com or by going to  tweetchat.com/room/em12c      (Needs Twitter credential for participating).  Feel free to join IOUG and Enterprise team members at the User Group Pavilion on 2nd Floor, Moscone West.

RSVP by going http://tweetvite.com/event/IOUG  .

Don't miss the Oracle Open World welcome keynote by Larry Ellison this evening at 5 PM .

Here is the complete list of Oracle Enterprise Manager sessions during the Oracle Users Forum :

Time

Session Title

Speakers

Location

8:00AM - 8:45AM

UGF4569 - Oracle RAC Migration with Oracle Automatic Storage Management and Oracle Enterprise Manager 12c

VINOD Emmanuel -Database Engineering, Dell, Inc.
Wendy Chen - Sr. Systems Engineer, Dell, Inc.

Moscone West - 2011

8:00AM - 8:45AM

UGF10389 -  Monitoring Storage Systems for Oracle Enterprise Manager 12c

Anand Ranganathan - Product Manager, NetApp

Moscone West - 2016

9:00AM - 10:00AM

UGF2571 - Make Oracle Enterprise Manager Sing and Dance with the Command-Line Interface

Ray Smith - Senior Database Administrator, Portland General Electric

Moscone West - 2011

10:30AM - 11:30AM

UGF2850 - Optimal Support: Oracle Enterprise Manager 12c Cloud Control, My Oracle Support, and More

April Sims - DBA, Southern Utah University

Moscone West - 2011

12:30PM-2:00PM

UGF5131 - Migrating from Oracle Enterprise Manager 10g Grid Control to 12c Cloud Control   

Leighton Nelson - Database Administrator, Mercy

Moscone West - 2011

2:15PM-3:15PM

UGF6511 -  Database Performance Tuning: Get the Best out of Oracle Enterprise Manager 12c Cloud Control

Mike Ault - Oracle Guru, TEXAS MEMORY SYSTEMS INC
Tariq Farooq - CEO/Founder, BrainSurface

Moscone West - 2011

3:30PM-4:30PM

UGF4556 - Will It Blend? Verifying Capacity in Server and Database Consolidations

Jeremiah Wilton - Database Technology, Blue Gecko / DatAvail

Moscone West - 2018

3:30PM-4:30PM

UGF10400 - Oracle Enterprise Manager 12c: Monitoring, Metric Extensions, and Configuration Best Practices

Kellyn Pot'Vin - Sr. Technical Consultant, Enkitec

Moscone West - 2011

Stay Connected:

Twitter |  Face book |  You Tube |  Linked in |  Newsletter

Tuesday Sep 25, 2012

Oracle Enterprise Manager 12c Anniversary at Open World General Session and Twitter Chat using #em12c on October 2nd

As most of you will remember, Oracle Enterprise Manager 12c was announced last year at Open World. We are celebrating first anniversary of Oracle Enterprise Manager 12c next week at Open world.

During the last year, Oracle customers have seen the benefits of federated self-service access to complete application stacks, elastic scalability, automated metering, and charge-back from capabilities of Oracle Enterprise manager 12c. In this session you will learn how customers are leveraging Oracle Enterprise Manager 12c to build and operate their enterprise cloud. You will also hear about Oracle’s IT management strategy and some new capabilities inside the Oracle Enterprise Manager product family.

In this anniversary general session of Oracle Enterprise Manager 12c, you will also watch an interactive role play ( similar to what some of you may have seen at "Zero to Cloud" sessions at the Oracle Cloud Builder Summit ) depicting a fictional company in the throes of deploying a private cloud. Watch as the CIO and his key cloud architects battle with misconceptions about enterprise cloud computing and watch how Oracle Enterprise Manager helps them address the key challenges of planning, deploying and managing an enterprise private cloud.

The session will be led by Sushil Kumar, Vice President, Product Strategy and Business Development, Oracle Enterprise Manager. Jeff Budge, Director, Global Oracle Technology Practice, CSC Consulting, Inc. will join Sushil for the general session as well.

Following the general session, Sushil Kumar ( Twitter user name @sxkumar ) will join us for a Twitter Chat on Tuesday at 1:00 PM to 2:00 PM.  Sushil will answer any follow-up questions from the general session or any question related to Oracle Enterprise Manager and Oracle Private Cloud .

You can participate in the chat using hash tag #em12c on Twitter.com or by going to  tweetchat.com/room/em12c (Needs Twitter credential for participating).  You could pre-submit your questions for Sushil using any of the social media channels mentioned below.

RSVP for tweet chat by going to http://tweetvite.com/event/em12c

Stay Connected:

Twitter |  Face book |  You Tube |  Linked in |  Newsletter

Thursday Sep 20, 2012

IOUG and Oracle Enterprise Manager User Community Twitter Chat and Sessions at OpenWorld

Like last many years, we will have annual Oracle Users Forum on Sunday, September 30th, 2012 at Moscone West, Levels 2 & 3 . It will be open to all registered attendees of Oracle Open World and conferences running from September 29 to October 5, 2012 .

This will be a great  opportunity to meet with colleagues, peers, and subject matter experts to share best practices, tips, and techniques around Oracle technologies. You could sit in on a special interest group (SIG) meeting or session and learn how to get more out of Oracle technologies and applications.

IOUG and Oracle Enterprise Manager team invites you to join a Twitter Chat on Sunday, Sep. 30th from 11:30 AM to 12:30 PM.  IOUG leaders, Enterprise Manager SIG contributors and many Oracle Users Forum speakers will answer questions related to their experience with Oracle Enterprise Manager and the activities and resources available for  Enterprise Manager SIG members.

You can participate in the chat using hash tag #em12c on Twitter.com or by going to  tweetchat.com/room/em12c      (Needs Twitter credential for participating).  Feel free to join IOUG and Enterprise team members at the User Group Pavilion on 2nd Floor, Moscone West.

RSVP by going http://tweetvite.com/event/IOUG  .

Here is the complete list of Oracle Enterprise Manager sessions during the Oracle Users Forum :

Time

Session Title

Speakers

Location

8:00AM - 8:45AM

UGF4569 - Oracle RAC Migration with Oracle Automatic Storage Management and Oracle Enterprise Manager 12c

VINOD Emmanuel -Database Engineering, Dell, Inc.
Wendy Chen - Sr. Systems Engineer, Dell, Inc.

Moscone West - 2011

8:00AM - 8:45AM

UGF10389 -  Monitoring Storage Systems for Oracle Enterprise Manager 12c

Anand Ranganathan - Product Manager, NetApp

Moscone West - 2016

9:00AM - 10:00AM

UGF2571 - Make Oracle Enterprise Manager Sing and Dance with the Command-Line Interface

Ray Smith - Senior Database Administrator, Portland General Electric

Moscone West - 2011

10:30AM - 11:30AM

UGF2850 - Optimal Support: Oracle Enterprise Manager 12c Cloud Control, My Oracle Support, and More

April Sims - DBA, Southern Utah University

Moscone West - 2011

11:30AM - 12:30PM

IOUG and Oracle Enterprise Manager Joint Tweet Chat 

Join IOUG Leaders, IOUG's Enterprise Manager SIG Contributors and Speakers on Twitter and ask questions related to practitioner's experience with Oracle Enterprise Manager and the new IOUG 's Enterprise Manager SIG.

To attend and participate in the chat, please use hash tag #em12c on twitter.com or your favorite Twitter client. You can also go to tweetchat.com/room/em12c to watch the conversation or login with your twitter credentials to ask questions.

User Group Pavilion

2nd Floor,

Moscone West

12:30PM-2:00PM

UGF5131 - Migrating from Oracle Enterprise Manager 10g Grid Control to 12c Cloud Control   

Leighton Nelson - Database Administrator, Mercy

Moscone West - 2011

2:15PM-3:15PM

UGF6511 -  Database Performance Tuning: Get the Best out of Oracle Enterprise Manager 12c Cloud Control

Mike Ault - Oracle Guru, TEXAS MEMORY SYSTEMS INC
Tariq Farooq - CEO/Founder, BrainSurface

Moscone West - 2011

3:30PM-4:30PM

UGF4556 - Will It Blend? Verifying Capacity in Server and Database Consolidations

Jeremiah Wilton - Database Technology, Blue Gecko / DatAvail

Moscone West - 2018

3:30PM-4:30PM

UGF10400 - Oracle Enterprise Manager 12c: Monitoring, Metric Extensions, and Configuration Best Practices

Kellyn Pot'Vin - Sr. Technical Consultant, Enkitec

Moscone West - 2011

Stay Connected:

Twitter |  Face book |  You Tube |  Linked in |  Newsletter

Wednesday Sep 19, 2012

Best Practices for Building a Virtualized SPARC Computing Environment

Oracle recently published Best Practices for Building a Virtualized SPARC Computing Environment, a white paper that provides guidance on the complete hardware and software stack for deploying and managing your physical and virtual SPARC infrastructure. The solution is based on Oracle SPARC T4 servers, Oracle Solaris 11 with Oracle VM for SPARC 2.2, Sun ZFS storage appliances, Sun 10GbE 72 port switches and Oracle Enterprise Manager Ops Center 12c. The paper emphasizes the value and importance of planning the resources (compute, network and storage) that will comprise the virtualized environment to achieve the desired capacity, performance and availability characteristics.

Please join us for Oracle Enterprise Manager Ops Center Customer Community call on Thursday, October 25 at 8AM PT, 11AM ET.  to learn more about the best practices for building a Virtualized SPARC Computing Environment and ask any questions you may have.

The document also details numerous operational best practices that will help you deliver on those characteristics with unique capabilities provided by Enterprise Manager Ops Center including policy-based guest placement, pool resource balancing and automated guest recovery in the event of server failure. Plenty of references to supplementary documentation are included to help point you to additional resources. Whether you’re building the first stages of your private cloud or a general-purpose virtualized SPARC computing environment, these documented best practices will help ensure success.

Stay Connected:

Twitter Face book |  You Tube |  Linked in |  Newsletter

Sunday Sep 09, 2012

Extending Database-as-a-Service to Provision Databases with Application Data

Oracle Enterprise Manager 12c Database as a Service (DBaaS) empowers Self Service/SSA Users to rapidly spawn databases on demand in cloud. The configuration and structure of provisioned databases depends on respective service template selected by Self Service user while requesting for database. In EM12c, the DBaaS Self Service/SSA Administrator has the option of hosting various service templates in service catalog and based on underlying DBCA templates.

Many times provisioned databases require production scale data either for UAT, testing or development purpose and managing DBCA templates with data can be unwieldy. So, we need to populate the database using post deployment script option and without any additional work for the SSA Users. The SSA Administrator can automate this task in few easy steps. For details on how to setup DBaaS Self Service Portal refer to the DBaaS Cookbook

In this article, I will list steps required to enable EM 12c DBaaS to provision databases with application data in two distinct ways using: 1) Data pump 2) Transportable tablespaces (TTS). The steps listed below are just examples of how to extend EM 12c DBaaS and you can even have your own method plugged in part of post deployment script option.

Using Data Pump to populate databases

These are the steps to be followed to implement extending DBaaS using Data Pump methodolgy:

  1. Production DBA should run data pump export on the production database and make the dump file available to all the servers participating in the database zone [sample shown in Fig.1]

    -- Full export
    expdp FULL=y DUMPFILE=data_pump_dir:dpfull1%U.dmp, data_pump_dir:dpfull2%U.dmp PARALLEL=4 LOGFILE=data_pump_dir:dpexpfull.log JOB_NAME=dpexpfull

    Figure-1:  Full export of database using data pump


  2. Create a post deployment SQL script [sample shown in Fig. 2] and this script can either be uploaded into the software library by SSA Administrator or made available on a shared location accessible from servers where databases are likely to be provisioned

    -- Full import
    declare
        h1   NUMBER;
    begin
    -- Creating the directory object where source database dump is backed up.
        execute immediate 'create directory DEST_LOC as''/scratch/nagrawal/OracleHomes/oradata/INITCHNG/datafile''';
    -- Running import
        h1 := dbms_datapump.open (operation => 'IMPORT', job_mode => 'FULL', job_name => 'DB_IMPORT10');
        dbms_datapump.set_parallel(handle => h1, degree => 1);
        dbms_datapump.add_file(handle => h1, filename => 'IMP_GRIDDB_FULL.LOG', directory => 'DATA_PUMP_DIR', filetype => 3);
        dbms_datapump.add_file(handle => h1, filename => 'EXP_GRIDDB_FULL_%U.DMP', directory => 'DEST_LOC', filetype => 1);
        dbms_datapump.start_job(handle => h1);
        dbms_datapump.detach(handle => h1);
    end;
    /

    Figure-2: Importing using data pump pl/sql procedures


  3. Using DBCA, create a template for the production database – include all the init.ora parameters, tablespaces, datafiles & their sizes
  4. SSA Administrator should customize “Create Database Deployment Procedure” and provide DBCA template created in the previous step.
  5. In “Additional Configuration Options” step of Customize “Create Database Deployment Procedure” flow, provide the name of the SQL script in the Custom Script section and lock the input (shown in Fig. 3). Continue saving the deployment procedure.


    Figure-3: Using Custom script option for calling Import SQL

  6. Now, an SSA user can login to Self Service Portal and use the flow to provision a database that will also  populate the data using the post deployment step.

Using Transportable tablespaces to populate databases

Copy of all user/application tablespaces will enable this method of populating databases. These are the required steps to extend DBaaS using transportable tablespaces:

  1. Production DBA needs to create a backup of tablespaces. Datafiles may need conversion [such as from Big Endian to Little Endian or vice versa] based on the platform of production and destination where DBaaS created the test database. Here is sample backup script shows how to find out if any conversion is required, describes the steps required to convert datafiles and backup tablespace.
  2. SSA Administrator should copy the database (tablespaces) backup datafiles and export dumps to the backup location accessible from the hosts participating in the database zone(s).
  3. Create a post deployment SQL script and this script can either be uploaded into the software library by SSA Administrator or made available on a shared location accessible from servers where databases are likely to be provisioned. Here is sample post deployment SQL script using transportable tablespaces.
  4. Using DBCA, create a template for the production database – all the init.ora parameters should be included. NOTE: DO NOT choose to bring tablespace data into this template as they will be created
  5. SSA Administrator should customize “Create Database Deployment Procedure” and provide DBCA template created in the previous step.
  6. In the “Additional Configuration Options” step of the flow, provide the name of the SQL script in the Custom Script section and lock the input. Continue saving the deployment procedure.
  7. Now, an SSA user can login to Self Service Portal and use the flow to provision a database that will also populate the data using the post deployment step.

More Information:

Stay Connected:

Twitter |  Face book |  You Tube |  Linked in |  Newsletter

About

Latest information and perspectives on Oracle Enterprise Manager.

Related Blogs




Search

Categories
Archives
« September 2012 »
SunMonTueWedThuFriSat
      
1
2
3
4
5
6
7
8
10
11
12
14
15
16
17
21
22
23
24
26
27
28
29
      
Today