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

OpenWorld 2012—Is Almost Here!

With OpenWorld fast approaching, I thought I would take this opportunity to look at some of the “must see” database manageability activities and sessions happening this year. Here's a quick run down:

Oracle Database Manageability:
Download all the details for sessions, hands-on-labs, and demos (PDF)

Keynotes:
Sunday, September 30
Hardware and Software, Engineered to Work Together: Why It’s A Different Approach
Larry Ellison, CEO, Oracle

Monday, October 1
Shift Complexity
Hosted by Mark Hurd, President, Oracle
Andrew Mendelsohn, Senior Vice President, Database Server Technologies, Oracle

IOUG SIG Sunday:
Database Performance Tuning: Getting the Best out of Oracle Enterprise Manager Cloud Control 12c
(session ID# CON6511)

Oracle DEMOgrounds:
Floor plan – Moscone South

  • Automatic Application and SQL Tuning
  • Automatic Performance Diagnostics
  • Complete Database Lifecycle Management
  • Data Masking and Data Subsetting
  • Database Testing with Oracle Real Application Testing
  • Oracle Enterprise Manager Cloud Control 12c Overview
  • Oracle Exadata Management

Hands-on-Labs:
Database Performance Testing, Data Masking, and Subsetting
(session ID# HOL10720)

Database Performance Tuning Hands-on Lab
(session ID# HOL10393)

Sessions:
What’s Next for Oracle Database?
(session ID# GEN8259)

Building and Managing a Private Oracle Database Cloud
(session ID# GEN11421)

Using Oracle Enterprise Manager to Manage Your Own Private Cloud
(session ID# GEN11423)

Extreme Database Management with the Latest Generation of Database Technology
(session ID# CON9547)

Oracle OpenWorld Music Festival
New this year is Oracle’s first annual Oracle OpenWorld Musical Festival, featuring some of today's breakthrough musicians from around the country and the world. It's five nights of back-to-back performances in the heart of San Francisco—free to registered attendees.
See the lineup

Not Heading to OpenWorldWatch it Live!


Stay Connected:

Twitter |
Facebook | YouTube | Linkedin | Newsletter

Download the Oracle Enterprise Manager Cloud Control12c Mobile app

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

Tuesday Sep 18, 2012

Examine your readiness for managing Enterprise Private Cloud

Cloud computing promises to deliver greater agility to meet demanding  business needs, operational efficiencies, and lower cost. However these promises cannot be realized and enterprises may not be able to get the best value out of their enterprise private cloud computing infrastructure without a comprehensive cloud management solution .

Take this new self-assessment quiz that measures the readiness of your enterprise private cloud. It scores your readiness in the following areas and discover where and how you can improve to gain total cloud control over your enterprise private cloud.

Complete Cloud Lifecycle Solution

Check if you are ready to manage all phases of the building, managing, and consuming an enterprise cloud. You will learn how Oracle can help build and manage a rich catalog of cloud services – whether it is Infrastructure-as-a-Service, Database-as-a-Service, or Platform-as-a-Service, all from a single product.

Integrated Cloud Stack Management

Integrated management of the entire cloud stack – all the way from application to disk, is very important to eliminate the integration pains and costs that customers would have to otherwise incur by trying to create a cloud environment by integrating multiple point solutions.

Business-Driven Clouds

It is critical that an enterprise Cloud platform is not only able to run applications but also has deep business insight and visibility. Oracle Enterprise Manager 12c enables creation of application-aware and business-driven clouds that has deep insight into applications, business services and transactions. As the leading providers of business applications and the middleware, we are able to offer you a cloud solution that is optimized for business services.

Proactive Management

Integration of the enterprise cloud infrastructure with support can allow cloud administrators to benefit from Automatic Service Requests (ASR), proactive patch recommendations, health checks and end-of-life advisory for all of the technology deployed within cloud.

Stay Connected:

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


Thursday Sep 13, 2012

Upgrading Agent Controllers in Oracle Enterprise Manager Ops Center 12c

Oracle Enterprise Manager Ops Center 12c recently released an upgrade for Solaris Agent Controllers. In this week's blog post, we'll show you how to upgrade agent controllers.

Detailed instructions about upgrading Agent Controllers are available in the product documentation here. This blog post uses an Enterprise Controller which is configured for connected mode operation. If you'd like to apply the agent update in a disconnected installation, additional instructions are available here.

Step 1: Download Agent Controller Updates

With a connected mode Ops Center installation, you can check for product updates at any time by selecting the Enterprise Controller from the left-hand Administration navigation tab.

Select the right-hand Action link “Ops Center Downloads” to open a pop-up dialog displaying any new product updates. In this example, the Enterprise Controller has already been upgraded to the latest version (Update 1, also shown as build version 2076) so only the Agent Controller updates will appear.

There are three updates available: one for Solaris 10 X86, one for Solaris 8-10 SPARC, and one for all versions of Solaris 11. Note that the last update in the screen shot is the Solaris 11 update; for details on any of the downloads, place your mouse over the information icon under the details column for a pop-up text region.

Select the software to download and click the Next button to display the Ops Center license agreement.

Review and click the check box to accept the license agreement, then click the Next button to begin downloading the software.


The status screen shows the current download status. If desired, you can perform the downloads as a background job. Simply click the check box, then click the next button to proceed to the summary screen.


The summary screen shows the updates to be downloaded as well as the current status. Clicking the Finish button will close the dialog and return to the Browser UI. The download job will continue to run in Ops Center and progress can still be viewed from the jobs menu at the bottom of the browser window.

Step 2: Check the Version of Existing Agent Controllers

After the download job completes, you can check the availability of agent updates as well as the current versions of your Agent Controllers from the left-hand Assets navigation tab.

Select “Operating Systems” from the pull-down tab lets to display only OS assets. Next, select “Solaris” in the left-hand tab to display the Solaris assets. Finally, select the Summary tab in the center display panel to show which versions of agent controllers are installed in your data center.


Notice that a few of the OS assets are not displayed in the Agent Controllers tab. Ops Center will not display OS instances which do not have an Agent Controller installation. This includes Enterprise Controllers and Proxy Controllers (unless the agent has been activated on the OS instance) and and OS instances using agentless management.

For Agent Controllers which support an update, the version of agent software (in this example, 2083) appears to the right of the currently installed version.

Step 3: Upgrade Your Agent Controllers

If desired, you can upgrade agent controllers from the previous screen by selecting the desired systems and clicking the upgrade button. Alternatively, you can click the link “Upgrade All Agent Controllers” in the right-hand Actions menu:

In either case, a pop-up dialog lets you start the upgrade process. The first screen in the dialog lets you choose the upgrade method:

Ops Center provides three ways to upgrade agent controllers:

  • Automatic Upgrade: If Agent Controllers are running on all assets, Ops Center can automatically upgrade the software to the latest version without requiring any login credentials to the system
  • SSH using a single set of credentials: If all assets use the same login credentials, you can apply a single set to all assets for the upgrade process. The log-in credentials are the same ones used for asset discovery and management, which are stored in the Plan Management navigation tab under Credentials.
  • SSH using individual credentials: If assets use different login credentials, you can select a different set for each asset.

After selecting the upgrade method, click the Next button to proceed to the summary screen. Click the Finish button to close the pop-up dialog and start the upgrade job for the agent controllers.

The upgrade job runs a series of tasks in parallel, and will upgrade all agents which have been selected. Once the job completes, the OS instances in your data center will be upgraded and running the latest version of Agent Controller software.

Oracle Enterprise Manager Cloud Control 12c Release 2 (12.1.0.2) is Available Now !

Oracle today announced the availability of Oracle Enterprise Manager Cloud Control 12c Release 2 (12.1.0.2). It is now available for download on OTN on ALL platforms. This is the first major release since the launch of Enterprise Manager 12c in October of 2011. This is the first time when Enterprise Manager release is available on all platforms simultaneously.

This is primarily a stability release which incorporates many of issues and feedback reported by early adopters. In addition, this release contains many new features and enhancements in areas across the board.

New Capabilities and Features

  • Enhanced management capabilities for enterprise private clouds:
    • Introduces new capabilities to allow customers to build and manage a Java Platform-as-a-Service (PaaS) cloud based on Oracle Weblogic Server. The new capabilities include guided set up of PaaS Cloud, self-service provisioning, automatic scale out and metering and chargeback.
    • Enhanced lifecycle management capabilities for Oracle WebLogic Server environments: Combining in-context multiple domain, patching and configuration file synchronizations.
    • Integrated Hardware-Software management for Oracle Exalogic Elastic Cloud through features such as rack schematics visualization and integrated monitoring of all hardware and software components.
  • The latest management capabilities for business-critical applications include:
    • Business Application Management: A new Business Application (BA) target type and dashboard with flexible definitions provides a logical view of an application’s business transactions, end-user experiences and the cloud infrastructure the monitored application is running on.
    • Enhanced User Experience Reporting: Oracle Real User Experience Insight has been enhanced to provide reporting capabilities on client-side issues for applications running in the cloud and has been more tightly coupled with Oracle Business Transaction Management to help ensure that real-time user experience and transaction tracing data is provided to users in context.
  • Several key improvements address ease of administration, reporting and extensibility for massively scalable cloud environments including dynamic groups, self-updateable monitoring templates, bulk operations against many events, etc.

New and Revised Plug-Ins:

Several plug-Ins have been updated as a part of this release resulting in either new versions or revisions. Revised plug-ins contain only bug-fixes and while new plug-ins incorporate both bug fixes as well as new functionality.

Plug-In Name

Version

Enterprise Manager for Oracle Database

12.1.0.2 (revision)

Enterprise Manager for Oracle Fusion Middleware

12.1.0.3 (new)

Enterprise Manager for Chargeback and Capacity Planning

12.1.0.3 (new)

Enterprise Manager for Oracle Fusion Applications

12.1.0.3 (new)

Enterprise Manager for Oracle Virtualization

12.1.0.3 (new)

Enterprise Manager for Oracle Exadata

12.1.0.3 (new)

Enterprise Manager for Oracle Cloud

12.1.0.4 (new)

Installation and Upgrade:

  • All major platforms have been released simultaneously (Linux 32 / 64 bit, Solaris (SPARC), Solaris x86-64, IBM AIX 64-bit, and Windows x86-64 (64-bit) )
  • Enterprise Manager 12.1.0.2 is a complete release that includes both the EM OMS and Agent versions of 12.1.0.2.
  • Installation options available with EM 12.1.0.2: User can do fresh Install or an upgrade from versions EM 10.2.0.5, 11.1, or 12.1.0.2 ( Bundle Patch 1 not mandatory).
  • Upgrading to EM 12.1.0.2 from EM 12.1.0.1 is not a patch application (similar to Bundle Patch 1) but is achieved through a 1-system upgrade.

Documentation:

Please feel free to ask questions related to the new Oracle Enterprise Manager Cloud Control 12c Release 2 (12.1.0.2) at the Oracle Enterprise Manager Forum . You could also share your feedback at twitter  using hash tag #em12c or at Facebook .

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

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