When Oracle is upgraded from 11 to 12, do any settings in CA TDM repo need to be changed?

Document ID : KB000076844
Last Modified Date : 09/04/2018
Show Technical Document Details
Issue:
After copying prod repo to test repo and upgrading test server and test repo from 4.1 to 4.4, will need to upgrade the Oracle CA TDM repo from 11 to 12. The test instance name may also need to be changed. Can you provide the process needed to update the tool to recognize the new db instance name and new version 12?
Resolution:
You wont need to do anything to the repository in general to support an upgrade from Oracle 11 to Oracle12. The DBA will have to do the migration between these two versions of Oracle, but thats an Oracle process, not a TDM process. From a TDM perspective, you wont need to do anything. The only thing you might need to do is to change your repository profile to point Datamaker to the location of the repository on Oracle 12.  These updates were made to schema, but it may not matter (it did no harm):

COMPLETE: UPDATED
Apply these updates:
c:\odac64\network\admin\tnsnames.ora tdmdev = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = <>) (PORT = 1521) ) ) (CONNECT_DATA = (SERVICE_NAME = DMTDEV01) ) )

C:\oracle\orc12c_64\product\12.1.0.2\client_1\network\admin\tnsnames.ora TDMDEV = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = <>) (PORT = 1521) ) ) (CONNECT_DATA = (SERVICE_NAME = DMTDEV01) ) )

C:\Program Files (x86)\Grid-Tools\GTDatamaker\Tnsnames.ora updated with new DB mapping for tdmdev.
tdmdev = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <>)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DMTDEV01) ) )

File requiring update %Appdata% -> \Grid-Tools\profiles.xml -> change the xml repository entry TO new DB
-Profiles-
-GTREP- xml repository -GTREP-
-Profile-
-Name- Datamart -Name-
-Datasource- DMTDEV01 -Datasource-
-Username- TDMDM1 -Username-
-Password- ????? -Password-
-DBMS- Oracle -DBMS-
-DefaultDB- -DefaultDB-
-Port -1521 -Port-
-Host- <> -Host-
-DefaultSchema- TDMDM1 -DefaultSchema-
-Profile-
-Profiles-
-Profile-
-Name- xml repository -Name-
-Datasource- DMTDEV01 -Datasource-
-Username- gtrep -Username-
-Password- ??????? -Password-
-DBMS- Oracle -DBMS-
-DefaultDB- -DefaultDB-
-Port- 1521 -Port-
-Host- <> -Host-
-DefaultSchema - -DefaultSchema-
-Profile-
-Profiles-

Tables requiring Schema updates
Select * from gtrep_profile ---need to update prof_servername,prof_userid, prof_schema column -- may want to clear out most or replace pljonpdb with dmtdev01db…. COMPLETE: Update gtrep_profile set prof_schema='TDMDM1', PROF_USERID='TDMDM1', PROF_SERVERNAME='<>s:1511/dmtdev01' where prof_schema='TDMPM1' and PROF_USERID='TDMPM1' and PROF_SERVERNAME='<>:1511/PLJONP'

These profiles remain for PLJOND:

These profiles remain for PLJONP:
select * from gtrep_system sys_service_layer has the production server ma000xsgtd01 and has sys_rep_ver COMPLETE: Update gtrep_system set SYS_SERVICE_LAYER='http:<>:8090/GTService' select * from gtrep_test_table tt_table_owner has TDMPM1 – COMPLETE: Update gtrep_test_table set TT_TABLE_OWNER = 'TDMDM1' where TT_TABLE_OWNER like 'TDMPM1%' COMPLETE select * from gtrep_external_link; Update gtrep_external_link set EXL_LINK_VAL_2='TDMDM1' where EXL_LINK_VAL_2='TDMPM1';

 
Additional Information:
Video URL on how to open a Support Case - https://communities.ca.com/videos/5898-demo-how-to-open-a-support-case
You can download the latest version of TDM by following the directions in this document: https://support.ca.com/us/knowledge-base-articles.TEC1903942.html.   
To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html