Oracle Bi Solutions

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Sunday, 24 March 2013

DAC - Replace Base: Procedure for Upgrading

Posted on 11:21 by Unknown

10.6.1 Replace Base: High-Level Process Flow
Figure 10–4 shows a high-level process flow for using the Replace Base option to upgrade the DAC Repository when you are phasing out an older release of a transactional application and moving to a newer release.
The term base is used to refer to a source or target container that you have not changed or customized in any way.
Figure 10–4 Upgrade Process for Replace Base Option

 

In Step 1 of the high-level process flow, you import the repository data for the new base container into the repository temporary tables. This repository is referred to as the source in the Upgrade/Merge Wizard

In Step 2, you create a Difference Report that compares the new base container (source repository) with the existing base container (including customizations). The existing base container is referred to as the target

In Step 3, you accept or reject the objects that the Difference Report shows as being present in the source but not the target or changed in the source but not the target. See Section 10.8.3, "Possible Repository Merge Outcomes Based on Your Decisions" for a description of how objects are merged based on the action you take.

In Step 4, after you have resolved the differences, you then execute the merge. In Step

5, the DAC references the customizations in the newly merged repository with the new base container.

Note: The repository data is imported from a file system and should be in the DAC 10.1.3.4 format. If it is in the 7.9.x format, you should do the following:

1. Restore the repository data into a database using the 7.9.x DAC (using the regular DAC import process).
2. Install and configure DAC 10.1.3.4 to the 7.9.x repository.
3. Export the relevant source system container to a file folder.

The metadata in the folder in Step 3 above will become the source for this upgrade.

10.6.2 Replace Base: Procedure for Upgrading
Follow this procedure to use the Replace Base option to upgrade the DAC Repository when you are phasing out an older release of a transactional application and moving to a newer release.Before you begin this procedure you should review the section"Resolving Object Differences in the View Difference Report" to gain an understanding of your options for resolving object differences.

To upgrade an existing DAC Repository
1. Navigate to the Upgrade/Merge Wizard by selecting Tools, then DAC Repository
Management, and then Upgrade/Merge Wizard.

2. From the drop-down list, select Replace Base, and then click OK. The Import Source System Container dialog box appears.

3. Click Change import/export folder to navigate to the directory that holds the metadata files for the new base container to which you are upgrading.

4. Select the appropriate container from the Source System Container drop-down list, and click OK.

5. In the Importing Tables dialog box, re-type the text in the text box to confirm you want to proceed, and click Yes. When the import process is complete, the Importing Tables dialog box tells you how long the process took.

6. Click OK. The Create Difference Report dialog box appears.

7. Create the Difference Report to view the differences between the new and existing DAC repositories.

a.      Enter a name for the Difference Report, or leave the default name.

b.      Select the appropriate existing container.


c.       (Optional) Enter a description for the Difference Report.

d.      Click OK.

When the Difference Report is complete, the Creating Difference Report dialog box tells you how long the process took.
e. Click OK.


Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Posted in DAC | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • [ODI] - Frequently Asked Questions (FAQ)
    Here is a list of FAQs about Oracle Data Integrator 1) What is Oracle Data Integrator (ODI)? 2) What is E-LT? 3) What components make up Ora...
  • Upper Function
    In Oracle/PLSQL, the  upper function  converts all letters in the specified string to uppercase. If there are characters in the string that ...
  • OBIEE 11g Hide/Show Sections based on Dashboard Prompt
    allow a user’s interaction to hide/show certain sections of a dashboard. In this particular case the user wanted to choose either ‘Quarterly...
  • OBIEE 11g not showing new dashboard in the drop down menu
    When creating New dashboard in  OBIEE 11g, I have faced with issue that dashboard name did not show up in drop down dashboard menu. 1. When ...
  • [OBIEE11g] - OBIEE Dashboard for Informatica Metadata Reporting
    The metadata that Informatica Power Center 8 retains in its repository can be exposed via OBIEE reports and dashboards. This metadata includ...
  • Data Modeling: Schema Generation Issue with ERwin Data Modeler 7.3
    We are using Computer Associate’s ERwin Data Modeler 7.3 for data modeling. In one of our engagements, we are pushing data model changes to ...
  • Informatica Powercenter Workflow Manager Repository Navigator docking float issue
    In case you’re also experiencing where your Repository Navigator is not dock or attached and it seems just floating within Workflow Manager ...
  • OBIEE 11g - State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 46118] Out of disk space. (HY000)
    Error Details Error Codes: AAD5E5X3:OPR4ONWY:U9IM8TAC Odbc driver returned an error (SQLFetchScroll). State: HY000. Code: 10058. [NQODBC] [S...
  • To_Char Function
    In Oracle/PLSQL, the  to_char function  converts a number or date to a string. Syntax The syntax for the  to_char function  is: to_char( val...
  • OBIEE 11g - Query Limit
    Query limit and number of minutes a query can run per physical layer database connection, follow the below steps. > Login to Repository u...

Categories

  • BI Publisher
  • DAC
  • DataWarehouse
  • Hyperion
  • Informatica
  • OBIEE
  • ODI
  • Oracle Applications EBS 12.1.3
  • Oracle Database
  • PL/SQL
  • SQL
  • Unix/Linux

Blog Archive

  • ▼  2013 (500)
    • ►  November (8)
    • ►  October (1)
    • ►  July (4)
    • ►  June (9)
    • ►  May (15)
    • ►  April (24)
    • ▼  March (43)
      • EBS 12.1.3
      • OBIEE 11g - Weblogic Security Administration
      • Error: OBIEE 11g: Error: "Stream Closed" Server Ex...
      • OBIEE 11g - Oracle Map viewer Installation & Confi...
      • Hyperion - Essbase Production Server crash
      • Hyperion - EPM, Fusion Edition Performance and Tun...
      • Hyperion FAQ'S
      • Hyperion Planning 11.1.2.2 Calculation Manager Is...
      • OBIEE 11g - Hyperion Integration With OBIEE
      • OBIEE 11g - Single Sign On With (EBS)
      • Hyperion Financial Reports – Preview User Point of...
      • OBIEE 11g - Display user name and time of the repo...
      • OBIEE 11g - Getting the custom links on the OBIEE ...
      • OBIEE 11g - supports 2 kinds of clustering Vertica...
      • DAC - Replace Base: Procedure for Upgrading
      • DAC - Simplified Refresh From Base Option
      • DAC - Peer to Peer Merge
      • OBIEE 11g - User Specific UI
      • OBIEE 11g - Multiple values in single column using...
      • OBIEE 11g - Look up Tables in obiee11g
      • DAC - W_DAY_D and Configure the Multi Calendar su...
      • OBIEE 11g - Roll back Selection Security to be Enable
      • OBIEE 11g - XMLP Server Cache Control
      • OBIEE 11g - How to remotely connect to online RPD
      • BI Publisher - 10g to 11g Upgrade Process
      • OBIEE 11g - Deployment of BI Publisher reports
      • OBIEE 11g - Deinstall
      • OBIEE 11g - Uploading/calling PDF file into OBIEE ...
      • OBIEE 11g - Switching Between Multiple Reports
      • OBIEE 11g - Action link saving a report in local d...
      • OBIEE 11g - Disable Caching
      • OBIEE - Executing Stored Procedures/Functions befo...
      • How to call stored procedure from DAC?
      • OBIEE - Selecting a Single Value and Showing a Range
      • OBIEE - Handy Date Session Variables
      • OBIEE 11g - Calculated % always shows up as 0%
      • OBIEE 11g - Using a Dashboard Prompt as a Column S...
      • OBIEE 11g - How to get proper date sorting in graphs
      • OBIEE 11g - Sorting on the Total in a Pivot
      • OBIEE - Google Charts
      • OBIEE11g - Inline Microcharts using Google Charts API
      • OBIEE 11g - Dashboard Background Image or Watermark
      • NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A gen...
    • ►  February (73)
    • ►  January (323)
Powered by Blogger.

About Me

Unknown
View my complete profile