Inplace upgrade, Reuse the existing OWB Home

The following steps are used to recover an existing OWB Home.

1.- Get the OWBSYS and OWBSYS_AUDIT users

Execute the following sentences:

2.- sqlplus OWBSYS/*****@OWB_HOME/owb/rtp/sql/stop_service.sql
chmod +x ./app/oracle/product/11.2.0/dbhome_1/owb/reposasst/secHelper.pks
chmod +x ./app/oracle/product/11.2.0/dbhome_1/owb/reposasst/secHelper.plb

chmod +x ./app/oracle/product/11.2.0/dbhome_1/owb/reposasst/upg/load_java.sql OWBSYS ***

3.- Run the following SQL statement to identify the OWB_HOME for the current installation. The rtrepos.properties file is located in the path indicated by the SERVER_SIDE_HOME of the query.

1. sqlplus OWBSYS/OWBSYS_PASSWORD
2. SELECT host_name, server_side_home from wb_rt_service_nodes s, v$instance v where s.instance_number=v.instance_number;
   HOST_NAME
   SERVER_SIDE_HOME
   yourhost_machine
   OWB_HOME

4.- For an existing repository that is installed on an Oracle 11g database (not Oracle 10g), ensure that OWB_HOME and ORACLE_SID values are pointing to the database where the repository is installed. Ensure that the PATH contains OWB_HOME/bin.

If the rtrepos.properties file is not found then:

• sqlplus owbsys/*********
• @/u01/app/oracle/product/11.2.0/dbhome_1/owb/reposasst/secHelper.pks
  @/u01/app/oracle/product/11.2.0/dbhome_1/owb/reposasst/secHelper.plb
  @/u01/app/oracle/product/11.2.0/dbhome_1/owb/reposasst/upg/load_java.sql OWBSYS *********
• @/u01/app/oracle/product/11.2.0/dbhome_1/owb/rtp/sql/reset_repository.sql *********

The reset_repository forces the user to register the location again using the Control Center Manager.

When the file is created START the service.

@/u01/app/oracle/product/11.2.0/dbhome_1/owb/rtp/sql/start_service.

Ce tout!