8 Oracle Data Profiling and Quality Post-Upgrade Tasks

This chapter describes additional tasks that may be required after you have performed the upgrade.

Section 8.1, "Update Metabase Connections"
Section 8.2, "Validate the Upgrade Operation"

8.1 Update Metabase Connections

The following commands allow you to update your loader connections after migrating the repository:

updateconnection - updates the details of a specific connection
updateallconnections - updates the details of all migrated connections

Oracle recommends using the updateconnection command to update your migrated loader connections.

To update the metabase connections:

Start the Metabase Server Administrator Prompt
- On UNIX operating systems:
```
./mtb_admin
```
- On Windows operating systems:
  
  Select Programs > Oracle > Oracle Data Profiling and Quality > Metabase Server >Administrator Command Prompt from the Start menu.
When prompted, supply your username, password, and metabase name.

Use the _control metabase name.
Enter one of the following commands:
- To update a specific migrated connection in all the metabases:
```
updateconnection <connection name>
```
- To update all migrated connections in all the metabases.
```
updateallconnections
```
Respond to the system prompts by typing a new value and pressing Enter. To keep the current value, press Enter at the prompt.

After you respond to all the prompts, the command locates the specified connection in all the metabases and updates them with the new information.

Example of a connection update:
1. Start the Metabase Server Administrator and log on to the _control metabase:
```
/.mtb_admin -user madmin -password ***** -metabase _control
```
2. At the _control prompt, enter the updateconnection command and press Enter:
```
updateconnection myconnection
```
  The following prompt appears:
```
Please enter the connection description. Just enter for the original“this is my connection”>
```
3. Press Enter to use the same description, or type a new description and then press Enter.
  
  The following prompt appears:
```
Please enter the path to data files. Just enter for the original“/data/data”>
```
4. Press Enter to use the same path, or type a new path and then press Enter. The following prompt appears:
```
Please enter the path to the schema files. Just enter for the original“/data/schemas”>
```
5. Press Enter to use the same path, or type a new path and then press Enter. The following message appears:
```
Successfully updated loader connection
Updating entities in metabase "demo"
username>
```
6. Respond to the prompts for your username and password. Progress messages appear as the command updates the connections named myconnection in each metabase. For example:
```
Successfully updated entity 11
Successfully updated entity 12
Successfully updated entity 13
Successfully updated entity 14
Updating entities in metabase "oracledq"
Successfully updated entity 1
_control:
```

8.2 Validate the Upgrade Operation

Start Metabase Manager and verify that your metabases and loader connections are available in the Control Admin pane.