2 Replies Latest reply on Oct 9, 2012 11:01 AM by Joe Piotrowski

    Errors running install_hotfix_update_oracle_script.sql upgrading to BSA 8.2 SP2

    Joe Piotrowski

      I'm getting errors running the database post script after upgrading my BSA environment from 8.2.01 to 8.2.02. Per the instructions, I need to run the install_hotfix_update_oracle_script.sql script (there is no need to run Migration Manager since the database is already at version 8.2.01).

       

      I'm running the script with the 'sys' user as 'sysdba.'

       

      SQL> connect sys@BSA as sysdba

      Enter password:

      Connected.

      SQL> start install_hotfix_update_oracle_script.sql

       

      > Execute SQL Script for QM001756386

        remediation_log_start('QM001756386.sql','8.2.02 - insert data for exporting the component template results to ARF/ASR format');

        *

      ERROR at line 8:

      ORA-06550: line 8, column 3:

      PLS-00201: identifier 'REMEDIATION_LOG_START' must be declared

      ORA-06550: line 8, column 3:

      PL/SQL: Statement ignored

      ORA-06550: line 11, column 38:

      PL/SQL: ORA-00942: table or view does not exist

      ORA-06550: line 11, column 3:

      PL/SQL: SQL Statement ignored

      ORA-06550: line 15, column 17:

      PL/SQL: ORA-00942: table or view does not exist

      ORA-06550: line 15, column 5:

      PL/SQL: SQL Statement ignored

       

      Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

      With the Partitioning, OLAP, Data Mining and Real Application Testing options

      [oracle@RHEL62x64-1 oracle]$

        • 1. Re: Errors running install_hotfix_update_oracle_script.sql upgrading to BSA 8.2 SP2

          can you try connecting and running the scripts as a user that owns the database (i.e. user that you have set in blasadmin database configuration)

          • 2. Re: Errors running install_hotfix_update_oracle_script.sql upgrading to BSA 8.2 SP2
            Joe Piotrowski

            Thank you lazar. I connected to the database as the 'bladelogic' user without elevated priviledges and that seemed to work.

             

            SQL> connect bladelogic@BSA     

            Enter password:

            Connected.

            SQL> start install_hotfix_update_oracle_script.sql

             

            > Execute SQL Script for QM001756386

            Processing update script for exporting the component template results to ARF/ASR

            format

            Inserting record into SYSTEM_PROPERTY table

            Creating/Replacing Stored Procedure CR_CLEAN_PUSH_GROUP_RESULT

            Completed update script for exporting the component template results to ARF/ASR

            format

            > Execute SQL Script for adding Server.TEMPLATES property

            Starting adding Server.TEMPLATES property in core DB

            Adding list type for templates

            Adding property and default value

            Adding property metadata

            Done add Server.TEMPLATES property in core DB

            > Execute SQL Script for adding recognition of Ubuntu as an OS vendor

            Processing update script for supporting Ubuntu as an OS platform

            Inserting record into bl_value table - bl_value_id = 10007

            Inserting record into primitive_bl_value table - bl_value_id = 10007

            Inserting record into bl_value table - bl_value_id = 10184

            Inserting record into property_reference table - bl_value_id = 10184

            Inserting record into property_reference_property table - bl_value_id = 10184

            Inserting record into condition table - condition_id = 2100000303

            Inserting record into property_condition table - condition_id = 2100000303

            Inserting record into condition table - condition_id = 2100000304

            Inserting record into condition_sub_condition table - condition_id = 2100000304

            Updating record in applicability_condition table - app_cond_id = 7000

            Inserting record into bl_value table - bl_value_id = 10189

            Inserting record into property_reference table - bl_value_id = 10189

            Inserting record into property_reference_property table - bl_value_id = 10189

            Inserting record into condition table - condition_id = 2100000305

            Inserting record into property_condition table - condition_id = 2100000305

            Inserting record into condition table - condition_id = 2100000306

            Inserting record into condition_sub_condition table - condition_id = 2100000306

            Updating record in applicability_condition table - app_cond_id = 7100

            Inserting record into bl_value table - bl_value_id = 10193

            Inserting record into property_reference table - bl_value_id = 10193

            Inserting record into property_reference_property table - bl_value_id = 10193

            Inserting record into condition table - condition_id = 2100000308

            Inserting record into property_condition table - condition_id = 2100000308

            Inserting record into condition table - condition_id = 2100000309

            Inserting record into condition_sub_condition table - condition_id = 2100000309

            Updating record in applicability_condition table - app_cond_id = 7700

            Inserting record into bl_value table - bl_value_id = 10195

            Inserting record into property_reference table - bl_value_id = 10195

            Inserting record into property_reference_property table - bl_value_id = 10195

            Inserting record into condition table - condition_id = 2100000311

            Inserting record into property_condition table - condition_id = 2100000311

            Inserting record into condition table - condition_id = 2100000312

            Inserting record into condition_sub_condition table - condition_id = 2100000312

            Updating record in applicability_condition table - app_cond_id = 7800

            Completed update script for supporting Ubuntu as an OS platform

            > Execute updDbVersion SQL script

            Updating the database version

            Database Version has been updated to 8.2.02

            Please check hotfix_update_oracle_script_20121009115730.log for logs and save it for future reference.

            SQL> set feedback on

            SQL>