Upgrading BIACOMP Schema

Follow these instructions to upgrade the BIACOMP schema.

To upgrade the BIACOMP schema:
  1. Take backup of BIACOMP schema
  2. Log in to the database as sys.
  3. Run the following SQL query: 
    update schema_version_registry set COMP_ID = 'ATGLITE', MR_NAME='ATGLITE', MR_TYPE='ATGLITE' where COMP_ID ='ATG';
  4. Go to mw_home/BI_ORACLE_HOME/bin and invoke PSA. For example, for Linux, <BI_Oracle_Home>/bin/psa and for windows <BI_Oracle_Home>\bin\psa.sh.
  5. Enter database details like database host, port, and SID in PSAdialog. Enter sys as sysdba as username and enter sys password.
  6. Click on <button> to find BIACOMP schema name and select that. Click Next.
  7. Next screen will show components listed to be upgraded. It will list entries ATG, FSM, BIACM, and BIACM_IO. Select them and click Next.
    PSA will upgrade those components in BIACOMP schema and display the success message.
  8. Login into middleware host where BI ORACLE HOME is present.
    1. Use SQLPlus or any SQL tool, log into BIACOMP schema, and run the following command: 
      <ORACLE HOME>/biapps/admin/provisioning/update/11.1.1.10.1/from11.1.1.9.2/schema/oracle/obiacm/upgrade_grant_sysnonym_io.sql <BIACM_IO schema name>
    2. Ensure that there is no error message and exit from the BIACOMP schema.
    3. Log into BIACM_IO schema using SQLPlus and run the following command: 
      <ORACLE HOME>/biapps/admin/provisioning/update/11.1.1.10.1/from11.1.1.9.2/schema/oracle/biacm_io/upgrade_synonym_io.sql <BIACOMP schema name>
    4. Ensure that there is no error message and exit from the BIACM_IO schema.