Running Scripts by Connecting to the Upgraded ODI Repository Schema

As part of the upgrade, you must run scripts by connecting to your upgraded ODI repository (11.1.1.10.2) schema.

Once you are done with importing the topology and the security settings backup files, run the below two scripts one by one and then run the script $ORACLE_HOME/dwtools/scripts/REL10_REL11_Upgrade_BIACMProvInODI.py.

Script 1

BEGIN 
EXECUTE IMMEDIATE 'DELETE FROM SNP_PSCHEMA_CONT WHERE I_PSCHEMA IN(SELECT 
I_PSCHEMA FROM SNP_PSCHEMA WHERE I_CONNECT IN ( SELECT  I_CONNECT FROM 
SNP_CONNECT WHERE CON_NAME LIKE ''BIAPPS_BIACOMP%''))'; 
EXECUTE IMMEDIATE 'DELETE  FROM SNP_PSCHEMA WHERE I_CONNECT IN ( SELECT   
I_CONNECT FROM SNP_CONNECT WHERE CON_NAME LIKE ''BIAPPS_BIACOMP%'')'; 
EXECUTE IMMEDIATE 'DELETE FROM SNP_CONNECT WHERE CON_NAME LIKE 
''BIAPPS_BIACOMP%'''; 
COMMIT; 
END;

(Optional) Use sections to add and organize related content if another section heading is needed.

Script 2

UPDATE SNP_FF_VALUEM SET SHORT_TXT_VALUE ='BIACM_IO' WHERE FF_CODE = 
'LS_SCHEMA_TYPE' AND I_OBJECTS = 2100 AND I_INSTANCE = (SELECT I_LSCHEMA FROM 
SNP_LSCHEMA  WHERE LSCHEMA_NAME= 'CM_BIAPPS11G'); 
@ COMMIT;

Script 3

UPDATE SNP_MTXT MT SET MT.FULL_TXT='jdbc:snps:dbfile?ENCODING=UTF-8'||'&'||'NO_RTRIM_DEL_STRING=true' WHERE MT.I_TXT IN  (SELECT MT1.I_TXT FROM SNP_CONNECT CN INNER JOIN SNP_MTXT MT1 ON 
MT1.I_TXT=CN.I_TXT_JAVA_URL AND CN.JAVA_DRIVER='com.sunopsis.jdbc.driver.file.FileDriver' INNER JOIN SNP_TECHNO TH ON CN.I_TECHNO=TH.I_TECHNO AND TH.TECH_INT_NAME='FILE'); 
COMMIT;