Install Cognos Business Intelligence 10.1 Interim Fixes for Security Exposure to resolve security vulnerabilities in Rational Insight 1.1 - Oracle CPU June 2013

Content

Procedure:

Note: The following steps assume that your WAS profile is named "RationalReport". Make appropriate adjustments to the steps if it is named differently.

1. Verify that you have installed the Cognos 10.1.1 hotfix that was included in Rational Insight 1.1. Review technote 1572859: Install IBM Cognos 10 BI 10.1.1 hotfix for IBM Rational Insight 1.1.
   
   
2. If you have set up a distributed ETL server, stop the RationalReport WAS profile on the ETL server.
   
   
3. Stop the RationalReport WAS profile on the report server.
   
   
4. Download IBM Cognos Business Intelligence 10.1 Interim Fixes for Security Exposure for your platform and unzip its content to a local directory on the report server, for example <CognosPatchDir>
   
   Note: For Rational Insight 1.1, only download the patch for 32-bit Windows or Linux.
   
   
5. Navigate to <CognosPatchDir> and start the installation wizard:
• For Windows, run <CognosPatchDir>\win32\issetup.exe
• For Linux, run <CognosPatchDir>/linuxi38632/issetup
  
  
6. Follow the instructions in the installation wizard and install the patch to the <InsightInstallDir>/cognos directory.
   
   
7. Delete <InsightInstallDir>/cognos/p2pd.ear.
   
   
8. Open a command prompt or terminal window and navigate to <InsightInstallDir>/cognos/war/p2pd.
   
   For example, on Windows, navigate to C:\Program Files\IBM\Rational Insight\cognos\war\p2pd.
   
   
9. Run the following command to rebuild the <InsightInstallDir>/cognos/p2pd.ear file:
   
   build -Dcontext_root=reporting ear
   
   Note: If you had specified "insight" as the Web application root context when you installed or upgraded to Rational Insight 1.1, run the following command instead:
   
   build -Dcontext_root=insight ear
   
   
10. Start the RationalReport WAS profile on the report server.
    
    
11. Perform the following steps to update the IBM Cognos Web application on the report server by redeploying the <InsightInstallDir>/cognos/p2pd.ear file:
1. Start the WebSphere Administrative Console associated with the RationalReport profile.
2. Log on and navigate to Applications > Application Types > WebSphere enterprise applications.
3. Select the IBM Cognos checkbox, click Uninstall and click OK.
4. Click Save to save the changes.
5. Click Install to install a new Web application.
6. Click Browse, select <InsightInstallDir>/cognos/p2pd.ear file and click Next.
7. Click Next repeatedly to advance to the Summary wizard page.
8. Click Finish.
9. Click Save to the save the changes.
10. Log out and exit the WebSphere Administrative Console.
    
    
12. Restart the RationalReport WAS profile on the report server.
    
14. If you have set up a distributed ETL server, repeat steps 4 to 12 on the ETL server.
    
    Note: Substitute "report server" with "ETL server" in the above steps.