|Oracle® Fusion Middleware Upgrade Guide for Oracle Enterprise Repository
11g Release 1 (11.1.1)
Part Number E15746-01
This chapter describes how to use the data migration utility to migrate assets from the earlier versions of Oracle Enterprise Repository.
This chapter contains the following sections:
Oracle Enterprise Repository is Oracle's solution for storing and governing SOA metadata.
In the past, Oracle Enterprise Repository had a variety of tools for importing metadata. In version 3.x of ALER, these included Web and Open API (REX) utilities for importing from WSDL, BPEL, and UDDI and the command-line RRXU tool. These import service metadata into an asset model called the ALER 3.x Asset Model, as shown in Figure 3-1.
Figure 3-1 ALER 3.x Asset Model
In Oracle Enterprise Repository 10.3 release, there were two main tools to import metadata, the Harvester and Exchange Utility tools. The Oracle Enterprise Repository Harvester imported metadata from Oracle BPEL PM 10g and standards-based files such as WSDLs, XSDs, XSLT, and BPELs. The Exchange Utility (XU) imported metadata into Oracle Enterprise Repository from UDDI registries. These imported metadata into a particular asset model called the Oracle Enterprise Repository 10g Asset Model.
In Oracle Enterprise Repository 11g R1 release, the harvester has been extended to support Oracle SOA Suite 11g and Oracle Service Bus 10g. The Exchange Utility is also enhanced to support Oracle Service Bus. The Enterprise Manager Integration utility is added to integrate with metrics in Enterprise Manager 10g. To support these products, the Oracle Enterprise Repository asset model is also extended, which is known as the 11g R1 Asset Model.
Before using the migration tool, you must perform the following prerequisites:
The Oracle Enterprise Repository server instance must first be upgraded to 11g R1, and must be started.
The Oracle Enterprise Repository database must be backed up, so it can be restored if there are any problems with the migration.
The migration tool requires the Java JRE or JDK version 6 or higher.
The migration tool connects to Oracle Enterprise Repository using its WebService API. So it can be run on any machine that can access the Oracle Enterprise Repository server. It will run much faster if run on the same machine as the Oracle Enterprise Repository server.
The Oracle Enterprise Repository System Setting,
cmee.extframework.enabled, must be set to
true. This can be set from the Web UI in the Admin, System Settings page.
You can use the migration tool to:
Migrate assets that were imported into Oracle Enterprise Repository via the ALER 3.x WSDL importer in the Web console.
Migrate assets that were imported into Oracle Enterprise Repository via the ALER 3.x UDDI importer in the Web console.
Migrate assets that were imported into Oracle Enterprise Repository via the ALER 3.x BPEL importer in the Web console.
Migrate assets that were imported into Oracle Enterprise Repository via the ALER 3.x ALRR-XU (version 3.x).
Migrate assets that were imported into Oracle Enterprise Repository via the ALER 3.x ad-hoc "Submit an Asset" functionality in the Web console.
Migrate assets that were imported into Oracle Enterprise Repository via the 10g R3 Harvester.
Migrate assets that were imported into Oracle Enterprise Repository via the 10g R3 Exchange Utility.
Migrate WSDL assets that were imported into Oracle Enterprise Repository via the Open API (REX) WSDL import functionality.
Preview the results of a migration, without committing any changes to Oracle Enterprise Repository.
This section describes the migration tool functionality for ALER 3.x assets and Oracle Enterprise Repository 11g assets. This section contains the following topics:
The contents of the WSDL that is pointed to by the Service FileInfo is introspected from its download URI. An interface asset is created, and related to the service. An Artifact: WSDL asset is introspected from its download URI. An Artifact: WSDL asset is created and related to the endpoint.
Business Process Assets
The contents of the BPEL that is pointed to by a business process asset is introspected from its download URI. An Artifact: BPEL asset is created and related to the business process. The business process asset will have its asset type changed to Business Process: BPEL.
Any WSDLs or XSDs imported by the WSDL will result in new artifact assets and relationships, as in the Harvester (or will point to existing assets if their fingerprints match).
Any WSDLs used by a BPEL in partnerlinks will result in new artifact assets and relationships, as in the Harvester.
The FileInfo is removed from the service and endpoint assets. The new Artifact: WSDL asset will contain the updated FileInfo.
The SFID (fingerprint) is removed from the service and endpoint assets. Any Artifact: WSDL assets and Artifact: XSD assets will contain a new SFID, using the Harvester's SFID algorithm.
Any non-artifact asset that is migrated will get a new internal name, which is used for duplicate checking.
Pre-existing service, endpoint, and business process assets will keep their original name. New assets are named according to the Harvester's naming rules.
WSDL Summary metadata entries are created on the migrated assets, as in Harvester.
Manifest metadata entries are created on the migrated assets, as in Harvester, to support the new download functionality in Oracle Enterprise Repository.
Ad-hoc Assets (via "Submit an Asset"): Limited Support
Assets that were imported into Oracle Enterprise Repository in an ad-hoc manner are migrated as described in Section 220.127.116.11, "Asset Types to Migrate", only if they conform to the ALER 3.x Asset model. For example, if an ad-hoc service asset contains a FileInfo that points to a WSDL, it is migrated as described above. But an asset of another type, for example, "TestCase", will not be migrated.
Recalculates and store the SFID for artifact assets from the original artifact files, using the 11gR1 fingerprinting code.
internal.introspector.manifest.store CMF entry and FileInfo with the correct artifact location according to following 11g R1 harvester rules:
Artifacts that were harvested from remote URLs have the FileInfo updated to point to the remote location (to match the Manifest).
Artifacts that were harvested from local files have the Manifest updated to point to the repository download URL (to match the FileInfo).
internal.artifact.store CMF entries for artifacts that were harvested from remote URLs.
internal.alrr.exchange.store CMF entry to conform to the latest Exchange Utility rules.
<tmodel> entries in the
internal.alrr.exchange.store CMF entry on Service and Endpoint assets, with the UDDI keys of porttype and binding TModels. (Connects to the UDDI registry to get these).
<uddiRegistries> custom data table on Endpoint assets, including the
service-key elements. The
registry-url elements are set from the original
internal.alrr.exchange.store CMF entry. The service-key is read from the UDDI registry during migration.
Sets the <uddi> custom data elements on Service assets, including the business-key and service-key elements. These are read from the UDDI registry during migration.
Sets the <uddi> custom data elements on Business Entity assets, specifically the business-key element. This is read from the UDDI registry during migration.
internal.introspector.store CMF entry to the new format used by 11gR1 harvester.
Sets the intname harvester property for abstract assets, according to the 11gR1 harvester rules.
Calculates and sets the following harvester properties, which are automatically set by 11gR1 harvester, on the appropriate assets: Namespace, Short Name, SCA Name, Endpoint URI, Deployment URL, Transport Type, Interface Type, Service Type.
Updates the wsdlLocation element in the WSDLSummary, based on the download URL calculated in "Manifests".
Updates the asset types according to the 11g R1 model:
Changes Endpoint: WebService assets to Endpoint
Changes Interface: WebService assets to Interface
This section contains the following topics:
The migration tool is available in the
18.104.22.168.0-OER-10gMigrate.zip file. Unzip this file to a directory on your machine. The migration tool can be run in the command line using the migrate.bat utility (for Windows) or migrate.sh (for Linux and Unix).
Before running migrate.bat or migrate.sh, ensure that the environment variables mentioned in Table 3-1 are set. In Windows, from a command window, you can type "set X" to see the value of the variable X, and "set X=abc" to set the value of FOO to "abc".
Table 3-1 Comman Line Script
Ensure that the
Ensure that you set your
JAVA_OPTS refers to the extra options to the java executable. In normal cases, there is no need to set this variable. However, a common exception when you need to set this variable is when your machine is inside a firewall, and you need to use an HTTP proxy to access external servers.
See Also: http://java.sun.com/javase/6/docs/technotes/guides/net/proxies.html
You can preview the results of a migration in the Data Migration tool, without committing any changes to Oracle Enterprise Repository, by using the command-line options. Table 3-2 describes the command-line options for the Data Migration tool.
Table 3-2 Command Line Options for the Data Migration Tool
If true, the data migration tool runs in the preview mode. A detailed information about successes and failures are logged. No changes are committed to Oracle Enterprise Repository.If false, the data migration tool runs in the production mode. A detailed information about successes and failures are logged, and the changes are committed to Oracle Enterprise Repository.
This section contains the following topics:
HarvesterSettings.xml file located at
<Data Migration Home> and modify the following XML chunk to point to the Oracle Enterprise Repository instance with the right credentials.
<repository> <uri>http://localhost:8080/oer/services/FlashlineRegistry</uri> <credentials> <user>admin</user> <password>*****</password> <enableTransaction>false</enableTransaction> <triggerEvent>false</triggerEvent> </credentials> <timeout>120000</timeout> </repository>
Note:It is recommended that you run the Migration Tool as a user with the Basic Access Settings for Assets - View, Edit, Accept, and Register.
The passwords in this file must be encrypted before running the migrate script. To encrypt the passwords, use the
encrypt.sh script, which is located in <Oracle_home>/tools/solutions/22.214.171.124.0-OER-PasswordTools.zip.
The section describes the following advanced configuration options for the migration tool:
By default, the migration tool is configured to migrate the assets of the types that are created by default by the ALER 3.x and 10g R3 tools. However, these legacy importers can be configured to use different asset types, through the
If the assets were imported using non-default asset types, you must configure the migration tool to use the same non-default asset types. These can be configured by editing the following XML chunk in the
<query> <repositoryQuery> <typesToMigrate> <assetType.service>Service</assetType.service> <assetType.endpoint>Endpoint: Web Service</assetType.endpoint> <assetType.endpoint>Endpoint</assetType.endpoint> <assetType.interface>Interface: Web Service</assetType.interface> <assetType.interface>Interface</assetType.interface> <assetType.process>Business Process: BPEL</assetType.process> <assetType.process>Business Process</assetType.process> <assetType.processDeployment>Deployment: BPEL</assetType.processDeployment> <assetType.xsd>Artifact: XSD</assetType.xsd> <assetType.wsdl>Artifact: WSDL</assetType.wsdl> <assetType.bpel>Artifact: BPEL</assetType.bpel> <assetType.xslt>Artifact: XSLT</assetType.xslt> </typesToMigrate> </repositoryQuery>
Note:It is recommended that all the Assets be migrated during single run of migration tool. Individually migrating specific Asset types might cause some problems such as having same internal names, etc.