OBIA Upgrade Script Clarification 11.1.1.10.1 To 11.1.1.10.2

(Doc ID 2350004.1)

Last updated on APRIL 10, 2018

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.2 to 11.1.1.10.2 [Release 11g]
Information in this document applies to any platform.

Goal

Clarification on the sequence of steps and commands with proper details to upgrade OBIA - 11.1.1.10.1 to 11.1.1.10.2.

Need proper command to execute the script REL10_REL11_Upgrade_BIACMProvInODI.py as mentioned in the upgrade document.

OBIA 11.1.1.10.2 Upgrade Guide: Section - Running Scripts by Connecting to the Upgraded ODI Repository Schema

https://docs.oracle.com/applications/biapps102/upgrade/GUID-887752A9-B542-4F87-8457-519B05E2474D.htm#BIAUP-GUID-887752A9-B542-4F87-8457-519B05E2474D

Existing Document content:

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;
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms