Migrating Oracle Warehouse Builder from
Earlier Releases
Note
that before you start the actual migration using the Repository Assistant, you
should prepare by backing up the current OWBSYS schema, Also note that the repositories from versions earlier
than 10g R2
cannot be upgraded to
11g R2 directly; they must be first upgraded
to 10g R2.
Preparing for Repository Migration
To prepare for a repository upgrade in Linux:
1. Ensure that you make a back-up copy of the
OWBSYS schema, using the backup strategy employed
in your organization.
2. At the command prompt, start SQL*Plus:
% sqlplus
SQL*Plus: Release 11.2
- Production on Mon July 27 16:37:21 2009
Copyright (c) 1982,
2009, Oracle. All rights reserved.
3. Connect as user with administrative
privileges:
SQL> connect
sys as sysdba
Enter password: password
4. You have two options:
■ If the OWBSYS schema does not exist on the Oracle Database instance, run the
cat_owb.sql script:
SQL> @OWB112/owb/UnifiedRepos/cat_owb.sql
You
are prompted for the tablespace name; enter it.
■ If the OWBSYS schema exists on the Oracle Database
instance, and you are upgrading from OWB 11g Release 1, run the cat_owb_reposupgrade.sql script:
SQL> @OWB112/owb/UnifiedRepos/cat_owb_reposupgrade.sql
You are prompted for the tablespace name;
enter it.
5. Run the reset_owbcc_home.sql script to reset the OWB_HOME directory:
SQL> @OWB112/owb/UnifiedRepos/reset_owbcc_home.sql
Note that this entry is case-sensitive,
does not accept a trailing slash, and requires forward slashes only, regardless
of the operating system.
6. Unlock the OWBSYS and OWBSYS_AUDIT accounts
Upgrading an OWB 10g R2 Repository
You
can upgrade a 10g R2
repository by exporting its content to a file, and then importing the file into
an 11g R2
repository, using the Repository Assistant.
Performing the In-Place Repository Upgrade
When upgrading from an OWB 11g R1 repository, you are
upgrading an existing
OWBSYS schema on an existing repository. When upgrading from OWB 10.2,
your upgrade process will create a new workspace in the OWB 11.2 repository,
with the same name as the schema containing the OWB 10.2 repository. In either
case, the process is similar.
To perform an in-place repository
upgrade
In Windows, from the Start menu, select Program Files,
then Oracle -
OWB112, then Warehouse Builder, then Administration,
then Repository
Assistant.
In Linux, from the command line,
run OWB_HOME
/owb/bin/unix/reposinst.sh.
2.
On the Welcome page of the Repository Assistant, click Next.
3.
On the Database Information page, enter the host name, port
number, and service name where OWB is installed.
Click Next.
4.
On the Choose Operation page, select Upgrade repository
to current release of Oracle Warehouse Builder.
Click Next.
5.
On the Choose Upgrade Operations page, select Upgrade repository
on the same database instance.
Click Next.
6.
On the OWBSYS Information page, enter the password for the
OWBSYS user.
Click Next.
7.
The File Information page appears. The in-place repository upgrade
process creates a repository export MDL file. The default file names and
location for this exported MDL file and export log file are displayed here. You
can change the location of these files.
Click Next to
accept the file information.
8.
On the Summary page, click Finish to
initiate the upgrade process.
9.
The Installation Progress popup window indicates the progress of
the upgrade operation. When complete, click OK.
You may wish to review the log for errors, and save the exported
MDL file as a backup of your pre-upgrade repository.
Exporting a Repository to a File
To export a repository to a file:
1. Start the Repository Assistant. In Linux, from
the command line, run
OWB_HOME/owb/bin/unix/reposinst.sh.
2. On the Welcome page of the Repository
Assistant, click Next.
3. On the Database Information page, enter
the host name, port number, and the service name where the OWB is installed. Click
Next.
4. On the Choose Operation page, select Upgrade repository to current release of Oracle Warehouse
Builder.
Click
Next.
1. On the Choose Upgrade Operation page, select Export entire repository to a file.
Click
Next.
6. On the User Information page, enter the
user name and password of the 10g R2 repository owner.
Click
Next.
7. On the File Information page, fill these
fields:
■ File Name: the name of the MDL file for storing the repository.
■ Log File: the name of the export operation log file that stores status
and statistical information.
Click
Next.
8. On the Summary page, click Finish.
An
Export Repository Progress window appears showing progress. At the end of the
export process, a status message appears. The export operation creates the
file.
Importing a File into a Repository
To import a file into a repository:
1. Start the Repository Assistant.
In Windows, from
the Start menu,
select Program Files, then Oracle - OWB112,
then
Warehouse Builder, then Administration, then Repository
Assistant.
In Linux, from
the command line, run
OWB_HOME/owb/bin/unix/reposinst.sh.
2. On the Welcome page of the Repository
Assistant, click Next.
3. On the Database Information page, enter
the host name, port number, and the
service
name where the OWB is installed.
Click
Next.
4. On the Choose Upgrade Operation page,
select Import entire repository from file.
Click
Next.
2. On the OWBSYS Information page, enter the password.
Click
Next.
6. On the File Information page, enter or
browse to find the name of the files used
when
exporting the repository.
Click
Next.
7. On the Summary page, click Finish.
The
file is imported into a workspace that has the same name as the 10g R2 OWB
repository.
Upgrading an OWB 11g R1 Repository
When
upgrading from an OWB 11g R1 repository, you are upgrading an existing
OWBSYS schema on an existing repository.
To perform an in-place repository upgrade of an 11g R1
repository:
1. Start the Repository Assistant.
In Windows, from
the Start menu,
select Program Files, then Oracle - OWB112,
then
Warehouse Builder, then Administration, then Repository
Assistant.
In Linux, from
the command line, run
OWB_HOME/owb/bin/unix/reposinst.sh.
2. On the Welcome page of the Repository
Assistant, click Next.
3. On the Database Information page, enter
the host name, port number, and the
service
name where the OWB is installed
Click
Next.
4. On the Choose Operation page, select Upgrade repository to current release of
Oracle Warehouse Builder.
Click
Next.
5. On the Choose Upgrade Operations page,
select Upgrade repository on the same
database instance.
Click
Next.
3. On the OWBSYS Information page, enter the password for the OWBSYS
user.
Click
Next.
7. On the File Information page, in the
Directory Name field, specify the name of the
existing
directory used for storing *.mdl files,
log files, and other temporary files
used
during repository upgrade.
Click
Next.
8. On the Summary page, click Finish to complete the
upgrade process.
9. The Installation Progress popup window
indicates the progress of the upgrade
operation.
When complete, click OK.
No comments:
Post a Comment