| Oracle Product Lifecycle Analytics Installation and Setup Guide Release 3.6.1 E83715-03 |
|
 Previous |
 Next |
| Oracle Product Lifecycle Analytics Installation and Setup Guide Release 3.6.1 E83715-03 |
|
Previous |
Next |
Follow the steps in this section to upgrade from OPLA 3.6.0.0.0 to OPLA 3.6.1.0.0.
|
Important: At a later time you may want to back out from this patch installation. In order to do so, you must have performed the following steps before installing this patch. Oracle recommends that you back up certain database schemas and files. |
To backup database schemas and files, perform the following steps:
Export the following database schemas and store them in a backup location:
ODI Work Repository
Stage or ODM Schema
MDS Schema
Copy your existing RPD file to a backup location.
Copy your existing Web Catalog file to a backup location.
If at any time you need to back out of this patch installation, and you have backed up the above database schemas and files, then go to "Backing Out from the Patch Installation" for instructions.
|
WARNING: You can only apply this patch in your environment once! Repeatedly installing the patch can cause an ETL failure. |
To complete the patch installation, perform the following steps:
If you have not already done so, before starting the patch installation, ensure that the following are stopped:
ODI Agents
Scheduler Agent
ETL tasks
On the computer where OPLA is installed, create a temp folder.
Copy the OPLA36100.zip file to the temp folder and unzip jar -xvf OPLA36100.zip
It will extract the following two zip files:
OPLA36100_DM.zip
OPLA36100_BI.zip
Set the environment variable to point to the Oracle PLA home directory, that is, where the existing Oracle PLA software, the MDS ETL, and the Schema are installed.
Example in Windows:
Set OPLA_Home = D:\OPLA
Example in Linux and Solaris:
export OPLA_HOME=/home/oracle/OPLA
Copy the OPLA36100_DM.zip file to the Oracle PLA home directory.
Unzip content from OPLA36100_DM.zip file, and extract the contents of the zip file, by entering the following command:
jar -xvf OPLA36100_DM.zip
After you extract the files, the %OPLA_Home% folder or the $OPLA_Home folder displays the following folder structure:
bin
install
lib
Patches
Execute the batch/shell script to apply the schema changes.
|
Note: Use the command prompt, or shell prompt terminal to go to the%OPLA_Home%\bin directory (for windows) or to the $OPLA_Home/bin directory (for Linux and Solaris). |
Windows:
%OPLA_Home%\bin must be present in the Operation System Path.
Linux/Solaris:
$OPLA_Home\bin must be present in the Operating System Path.
The ImportSchemaComponents_OPLA36100.sh must have Executive privileges.
Navigate to OPLA_HOME/bin folder and execute ImportSchemaComponents_OPLA36100.bat (Windows) and ImportSchemaComponents_OPLA36100.sh (Linux/Solaris). Log file will be generated in the folder OPLA_HOME/logs/ as 'PatchOPLA36100_SchemaComponents.log'. Please review the log file for errors if any.
Execute the batch/shell script to apply the ETL changes.
|
Note: Use the command prompt, or shell prompt terminal to go to the %OPLA_Home%\bin directory (for windows) or to the $OPLA_Home/bin directory (for Linux and Solaris). |
|
Note: If log file contains the error message/s as ”ODI-10093: You are importing an object from another repository with the same identifier”, then OdiImport_A9_Oracle_36100.bat/ OdiImport_A9_Oracle_36100.sh will not import ETL components. Please renumber master and work repository IDs to different number, then execute ODI components batch/shell file. |
|
Note: IF the ORACLE DB Version is 12c and OPLA is installed on ODI 11g then need to set sqlnet.ora as follows: Add SQLNET.ALLOWED_LOGON_VERSION=8 in the oracle_home/network/admin/sqlnet.ora file. |
Windows:
%OPLA_Home%\bin must be present in the Operation System Path.
Linux/Solaris:
$OPLA_Home\bin must be present in the Operating System Path.
The OdiImport_A9_Oracle_36100.sh must have Executive privileges
Navigate to OPLA_HOME/bin folder and execute OdiImport_A9_Oracle_36100.bat (Windows) and OdiImport_A9_Oracle_36100.sh (Linux/Solaris). Log file will be generated in the folder OPLA_HOME/logs as ODIImport_stage_36100.log. Please review the log file for any errors.
After applying this patch, execute the FULL ETL Load.
Please note that for existing customers, customizations will be lost and they must be done again.
|
WARNING: Only OBIEE12c users should apply this patch. |
Copy the OPLA36100_BI.zip file from temp folder to the PLM_BI_Home.
Unzip content from OPLA36100_BI.zip file, and extract the contents of the zip file, by entering the following command:
jar -xvf OPLA36100_BI.zip
Navigate to PLMBI_HOME/bin folder and execute PLMBI_12213.bat (Windows) and PLMBI_12213.sh (Linux/Solaris). Log file will be generated in the folder PLMBI_HOME/logs as BIInstall.log. Please review the log file for any errors.
After the patch is installed you must modify the Heap size in ODI to improve ETL performance.
To enhance the ETL performance you must modify the Heap size in ODI.
To increase the Heap size, follow these steps:
After installing the ODI software, to avoid slow client performance, edit these properties in the following files:
<ODI_HOME>/oracledi/client/odi/bin/odi.conf
Change:
AddVMOption -XX:MaxPermSize=256M
To:
AddVMOption -XX:MaxPermSize=1024M
<ODI_HOME>oracledi/client/ide/bin/ide.conf
Change:
AddVMOption -Xmx640M
AddVMOption -Xms128M
To:
AddVMOption -Xmx2048M
AddVMOption -Xms512M
|
Note: The values you set for Heap size depends on how much memory space is on your local machine. If you have 2 GB of available memory, you can set AddVMOption -Xms128M to AddVMOption -Xms512M |
For more information, see ODI documentation located on the Oracle Technology Network.
If, for any reason, you need to back out of this patch installation, and you have backed up the database schemas and files (as mentioned in "Backing up Database Schemas and Files"), perform the following steps:
Restore the following schemas by importing the previously backed up database export dumps to schemas with the same username and password:
ODI Work Repository
Stage or ODM Schema
MDS Schema
Remove the temp tables (i$, j$ and C$) from all the schemas.
Restore the RPD file by importing it from its backup location.
Change the ETL configuration to run Data Mart or Stage and MDS in FULL load mode.
Restore the Web Catalog file by importing it from its backup location.
|
Note: You can find the webcatalog at the following location:<OPLA_ HOME>\Patches\OPLA35\OBIEE11g\webcatalog |
To deploy the OBIEE 11g Webcatalog:
Copy PLMA_11g (11g catalog) to the location:
<OBIEEHomeDirectory>\instances\instance1\bifoundation\OracleBIPresentatio nServicesComponent\coreapplication_obips1\catalog
If you are using Windows 2008, follow this step:
Copy PLMA_11g (11g catalog) to the location:
<OBIEEHomeDirectory>\instances\instance1\bifoundation\OracleBIPresentatio nServicesComponent\coreapplication_obips1\catalog
Open the Enterprise Manager and enter the WebLogic username and password.
Click Business Intelligence and select Coreapplication.
Click the Lock and Edit Configuration tab. The Deployment tab is displayed.
Close the confirmation window displaying the following message:
Lock and Edit Configuration - Completed Successfully.
Choose Deployment > Repository.
Enter the following location for PLMA_11g in the Catalog Location field located in the BI presentation Catalog section.
$ORACLE_
INSTANCE/bifoundation/OracleBIPresentationServiceComponent/$COMPONE NT_NAME/catalog/
Click Apply (displayed in the top right corner of the screen).
Choose Change Center, and then click Activate Changes.
Close the confirmation window displaying the following message:
Activate Changes - Completed Successfully.
To restart the services and apply the changes, in the Overview page select Restart.
After completing the restart process, check the status of the presentation services using the URL http://localhost:7001/analytics.
