Installing Oracle Reports 11g

To integrate Oracle Reports 11g with Report Manager in Civic Platform, complete the procedures described in this section.

Topics

Required Software

Download all of the following Oracle software from Oracle's website.

  • Oracle Database: Oracle Database Server 11g R2 11.2.0.4
  • Weblogic Service: Weblogic Server 10.3.6
  • Oracle Form and Reports: 11.1.2.2.0

 

Key Installation Steps

The following procedure summarizes the general installation process for Oracle Reports 11g. For details about each installation step, see the Oracle documentation.

  1. Install Oracle database 11g R2 11.2.0.4 with character set AL32UTF8.

  2. Change processes and open_cursors to 500 and 800 for the database.

  3. Configure the environment of JDK (64 Bit).

  4. Use the following script to install the 64 Bit Weblogic Server:

    java –jar wls1036_generic.jar

  5. Install Oracle Form and Reports.

 

Deploying Oracle Reports and Relevant Files

  1. Deploy Civic Platform Oracle Reports:

    1. Create a folder named AA_OracleReport under the directory below:

      $APP_HOME\Middleware\user_projects\domains\ClassicDomain\servers\WLS_REPORTS\tmp\_WL_user\reports_11.1.2\89mfnr\war
    2. Copy the agency's Civic Platform Oracle reports to the folder:

      $APP_HOME\Middleware\user_projects\domains\ClassicDomain\servers\WLS_REPORTS\tmp\_WL_user\reports_11.1.2\89mfnr\war\AA_OracleReport

       

      Alternatively, create subfolder(s) in the above directory based on the Environment and Agency that was set in the Report Service Form in Civic Platform V360 (see Defining an Oracle Reports Service in Report Manager), then copy the agency's Civic Platform Oracle reports to the subfolder. For example:

      $APP_HOME\Middleware\user_projects\domains\ClassicDomain\servers\WLS_REPORTS\tmp\_WL_user\reports_11.1.2\89mfnr\war\AA_OracleReport\<environment>\<agency>>

  2. Deploy the JSP file used to get the report name list:

    1. Copy the FileDirectory.jsp file from $Accela_Home\av.deploy\dist\reportadaptor\oracle\11g to the following directory:

      $APP_HOME\Middleware\user_projects\domains\ClassicDomain\servers\WLS_REPORTS\tmp\_WL_user\reports_11.1.2\89mfnr\war

  3. Set the data source for the report(s) by updating the file tnsnames.ora:

    1. Open the tnsnames.ora file under the folder $APP_HOME \Middleware\asinst_1\config (where asinst_1 is the Oracle instance).

    2. Add or update the TNS info, as shown in the following example:
      AAOracleRptTest =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.156)(PORT = 1521))
          )
          (CONNECT_DATA =
            (SERVICE_NAME = dbs156m)
          )
        )  

 

Setting Authentication Methods on the Report Server

To enable single sign-on

  1. Open the rwservlet.properties file in the directory $APP_HOME\Middleware\Oracle_FRHome1\reports\conf.

  2. Change <singlesignon>no</singlesignon> to <singlesignon>yes</singlesignon>.

  3. Restart the Oracle Reports Server.

 

To disable single sign-on

  1. Open the file $APP_HOME \Middleware\Oracle_FRHome1\reports\conf\rwserver.conf.

  2. Change <singlesignon>yes</singlesignon> to <singlesignon>no</singlesignon>.

  3. Restart the Oracle Reports server.

 

Defining an Oracle Reports Service in Report Manager

This section describes how to define an Oracle Reports Service in Report Manager.

To define an Oracle Reports Service in Report Manager

  1. In Civic Platform V360, navigate to the Report Manager > Settings.

  2. Right-click Report Services.

  3. In the Report Service form, define the Oracle Reports Service as shown below:

    .

     

    Refer to the following table for field descriptions.

    Table 1. Oracle Reports Service Fields in Report Manager
    Authentication Method Not Required or SSO Authentication

    If SSO Authentication is the selected authentication mode, enter the DB User Name and DB Password. Enter the same value for the User Name and Password that you used for the Oracle Internet Directory, where the User Name is orcladmin and the Password is admin000.

    If you are not using Single Sign-on, select Not Required.

    Agency The agency name. This name can be used as second-level subfolder containing Civic Platform reports under AA_OracleReport. See Deploying Oracle Reports and Relevant Files.
    Environment The agency's environment name. This name can be used as first-level subfolder containing Civic Platform reports under AA_OracleReport. See Deploying Oracle Reports and Relevant Files.
    Network Alias The name of the Oracle service, as defined in tnsnames.ora.
    Report Service Name The name that identifies the report service
    Report Name List URL http://<web_server.domain_name:port>/reports/FileDirectory.jsp
    Report Service Type Oracle Reports 11g
    Report Service URL http://<web_server.domain_name:port>/reports /rwservlet?server=<report-server-name>&destype=cache&desformat=pdf

    Tip: The report server name can be seen on the Windows Start > Reports Services > Start Rerports Server menu item. For example:

    For details about the Report Service URL parameters, see the Oracle Reports 11g documentation about rswervlet and its parameters.