For Control-M/Server:
1. Shutdown Control-M/Server and Configuration Agent
2. Perform a backup of the Control-M data using the 'ctm_backup_bcp' utility. See the Utilities Guide for details
3.Modify the Control-M tnsnames.ora file found in the directory <home>/ctm_server/oracle/network/admin.
a. change the SID to SERVICE_NAME and enter the value for the SERVICE_NAME
b. update the HOST and PORT as needed.
4. Build the schema in the new database using the Build Database script. This will create the database user, profile, role, tablespace, datafile and the Control-M Server objects.
From ctm_menu, select 2 - Database Menu -> 1 - Maintenance -> 1 - Build Database
5. Perform a restore of the Control-M data using the ctm_restore_bcp utility. See the Utilities Guide for details
6. Start ControlM server and Configuration Agent
For Control-M/Enterprise Manager:
1. Shutdown the EM components and Control-M/Enterprise Manager processes.
2. Backup the Control-M/Enterprise Manager database using the 'util' command:
em util -Uemuser -Pempass -export -type all -file full_export.exp
(See the Utilities Guide for details.)
3. Change the connection properties in the Control-M/Enterprise Manager tnsnames.ora file
a. change the SID to SERVICE_NAME and enter the value for the SERVICE_NAME
b. update the HOST and PORT as needed.
4. Build the Control-M/Enterprise Manager schema. Run the utility 'em_database_menu' and select
"1 - Management -> 4 - Build Database"
5. Import the data:
em util -Uemuser -Pempass -import -type all -file full_export.exp
6. Start the Control-M/Enterprise Manager processes and components