This chapter describes additional tasks that may be required after you have performed the upgrade.
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:
Start the Metabase Server Administrator and log on to the _control
metabase:
/.mtb_admin -user madmin -password ***** -metabase _control
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”>
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”>
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”>
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>
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:
Start Metabase Manager and verify that your metabases and loader connections are available in the Control Admin pane.