4 Configuring a WebLogic Server

The Enterprise DQ for Product WAR file is a fully integrated J2EE Application Server component compatible with WebLogic Application Servers. This chapter describes how to configure an to use a WebLogic Server and deploy the Enterprise DQ for Product WAR file to it for use on a Oracle DataLens Server.

Creating a WebLogic 11g Domain on Linux and UNIX

Use the following steps to create a WebLogic 11g (10.3.1, 10.3.2, 10.3.3, or 10.3.4) domain on a system running Linux or UNIX.

Log in to the server as an administrator user. For more information, see "Establishing an Administrator User Account".
Go to the /common/bin subdirectory of the WebLogic installation directory.
Start the Fusion Middleware Configuration Wizard:

./config.sh

The Fusion Middleware Configuration Wizard Welcome screen is displayed.
Enter 1 to select the Create a new WebLogic domain option.

The Select Domain Source screen is displayed.
Enter 1 to select Choose Weblogic Platform components.

The Application Template Selection screen is displayed.
Enter next to select the Basic WebLogic Server Domain option.

The Edit Domain Information screen is displayed.
Enter a domain name, and then enter next. For example, dls_domain.

Note:
A domain name must not start with a number.

The target domain directory screen is displayed.
Enter the domain directory or next to use the default directory displayed.

The Configure Administrator User Name and Password screen is displayed.
Enter 1, and then enter a user name. For example, dlsadmin.
Enter 2, and enter a password.
Enter 3, and enter the password again confirm it.
Enter 4, and then a description for this administrative user.
Enter next to save your changes.

The Domain Mode Configuration screen is displayed.
Enter next to select the Development Mode option.

The Java SDK Selection screen is displayed.
Enter the number for JRockit JDK 28.1 64-Bit that was installed on your Oracle DataLens Server by EDQP.

Important:
Ensure that you select JRockit JDK 28.1 64-Bit because this is the only supported version and other versions may be installed.

The Select Optional Configuration screen is displayed.
Enter 1 to select Administration Server, and then enter next.

The Configure the Administration Server screen is displayed.
Enter 1, and then the name of your Oracle DataLens Administration Server. For example, dlsserver.
Configure the server protocol to be HTTP or Secure HTTP using one of the following:

For HTTP:
1. The default Listen address and SSL enabled settings should not be changed.
2. Enter 3, and then 2229 as the listen port or the port number for your Oracle DataLens Administration Server if you installed it on a different port.
For HTTPS:

Configure your server for two-way SSL, which will authenticate clients:

Note:
The use of HTTPS significantly slows the response time from your Oracle DataLens Administration Server. In addition, there is a row processing limit of 5000 rows.
1. The default Listen address and SSL settings should not be changed.
2. Enter 4 to enable SSL.
3. Enter 1 to set the SSL value to true.
4. Enter 4, and then 2229 as the SSL listen port or the port number for your Oracle DataLens Administration Server if you installed it on a different port.
  
  Note:
  You must configure SSL to use certificates from a certificate authority. For more information, see "Configuring SSL" in Securing Oracle WebLogic Server for the installed WebLogic release (http://download.oracle.com/docs/cd/E17904_01/wls.htm).
Enter next to save the changed domain information and continue creating the domain.

The domain is created and a progress indicator is displayed. Upon completion the configuration wizard exits.

Any errors encountered during the domain creation are displayed. You must resolve any errors prior to continuing with the domain configuration. For information, see the installation guide for the version of WebLogic that you installed in "Installing a WebLogic Application Server".

Creating a WebLogic 10g Domain on Linux and UNIX

Use the following steps to create a WebLogic 10g (10.3) domain on a system running Linux or UNIX:

Log in to the server as an administrator user.
Go to the /common/bin subdirectory of the WebLogic installation directory.
Start the Fusion Middleware Configuration Wizard:

./config.sh

The Oracle WebLogic Configuration Wizard Welcome screen is displayed.
Enter 1 to select the Create a new WebLogic domain option.

The Select Domain Source screen is displayed.
Enter 1 to select Choose Weblogic Platform components.

The Application Template Selection screen is displayed.
Enter next to select the default WebLogic Server option.

The Configure Administrator User Name and Password screen is displayed.
Enter 1, and then enter a user name. For example, dlsadmin.
Enter 2, and then a password.
Enter 3, and then enter the password again to confirm it.
Enter 4, and then a description for this administrative user.
Enter next to save your changes.

The Domain Mode Configuration screen is displayed.
Enter 1 to select the Development Mode option.

The Java SDK Selection screen is displayed.
Enter the number for JRockit JDK 28.1 64-Bit that you installed on your Oracle DataLens Server.

Important:
Ensure that you select Oracle JRockit JDK 28.1 64-Bit because this is the only supported version and other versions may be installed.

The Choose Configuration Option screen is displayed.
Enter 1 to select Yes.

The Configure RDBMS Security Store Options screen is displayed.
Enter 1 to select no changes.

The Configure the Administration Server screen is displayed.
Configure the server protocol to be HTTP or Secure HTTP using one of the following:

For HTTP:
1. The default Listen address and SSL enabled settings should not be changed.
2. Enter 3, and then 2229 as the listen port or the port number for your Oracle DataLens Administration Server if you installed it on a different port.
For HTTPS:

Configure your server for two-way SSL, which will authenticate clients:

Note:
The use of HTTPS significantly slows the response time from your Oracle DataLens Administration Server. In addition, there is a row processing limit of 5000 rows.
1. The default Listen address and SSL settings should not be changed.
2. Enter 4 to enable SSL.
3. Enter 1 to set the SSL value to true.
4. Enter 4, and then 2229 as the SSL listen port or the port number for your Oracle DataLens Administration Server if you installed it on a different port.
  
  Note:
  You must configure SSL to use certificates from a certificate authority. For more information, see "Configuring SSL" in Securing Oracle WebLogic Server for the installed WebLogic release (http://download.oracle.com/docs/cd/E17904_01/wls.htm).
Enter next to save the changes.

The Configure Managed Servers screen is displayed.
Enter next to save the changes.

The Configure Clusters screen is displayed.
Enter next to advance to the next screen.

The Configure Machines screen is displayed.
Enter next to advance to the next screen.

The Configure Unix Machines screen is displayed.
Enter next to advance to the next screen.

The target domain directory screen is displayed.
Enter next to use the default target directory value or enter the directory that you want the domain created in.
Enter 1 and enter a domain name. For example, dls_domain.

Note:
A domain name must not start with a number.
Enter next to modify the name and continue creating the domain.

The domain is created and a progress indicator is displayed. Upon completion the wizard exits.

Any errors encountered during the domain creation are displayed. You must resolve any errors prior to continuing with the domain configuration. For information, see Oracle WebLogic Server Creating WebLogic Domains Using the Configuration Wizard 10g Release 3 (10.3).

Creating a WebLogic 11g Domain on Windows

Use the following steps to create a WebLogic 11g (10.3.1, 10.3.2, 10.3.3, or 10.3.4) domain on a Windows platform:

Click Start > All Programs > Oracle WebLogic > WebLogic Server 11gR1> Tools > Configuration Wizard to start the WebLogic Configuration Wizard.

The Fusion Middleware Configuration Wizard Welcome screen is displayed.
Select Create a new WebLogic domain option, and then click Next.

The Select Domain Source screen is displayed.
Click Next to retain the default selection.

The Specify Domain Name and Location screen is displayed.
Enter a domain name (for example, dls_domain), retain the default domain location, and then click Next.

Note:
A domain name must not start with a number.

The Configure Administrator User Name and Password screen is displayed.
Enter a user name. For example, dlsadmin.
Enter a password, and then enter it again to confirm this password.
Enter a description for this administrative user.
Click Next.

The Configure Server Start Mode and JDK screen is displayed.
Select the Development Mode option.
Ensure that Development Mode option is selected.
Select the JRockit JDK 28.1 64-Bit that was installed on your Oracle DataLens Server by EDQP.

Important:
Ensure that you select Oracle JRockit JDK 28.1 64-Bit because this is the only supported version and other versions may be installed.
Click Next.

The Select Optional Configuration screen is displayed.
Select Administration Server, and then click Next.

The Configure the Administration Server screen is displayed.
Enter the name of your Oracle DataLens Administration Server. For example, dlsserver.
Configure the server protocol to be HTTP or Secure HTTP using one of the following:

For HTTP:
1. The default Listen address and SSL settings should not be changed.
2. Enter 2229 as the Listen port or the port number for your Oracle DataLens Administration Server if you installed it on a different port.
For HTTPS:

Configure your server for two-way SSL, which will authenticate clients:

Note:
The use of HTTPS significantly slows the response time from your Oracle DataLens Administration Server. In addition, there is a row processing limit of 5000 rows.
1. Select the SSL enabled check box.
2. Use the default Listen address.
3. Enter 2229 as the SSL Listen port or the port number for your Oracle DataLens Administration Server if you installed it on a different port.
4. Enter the port you want clients to listen on as the Listen port.
  
  Note:
  You must configure SSL to use certificates from a certificate authority. For more information, see "Configuring SSL" in Securing Oracle WebLogic Server for the installed WebLogic release (http://download.oracle.com/docs/cd/E17904_01/wls.htm).
Click Next.

The Configuration Summary screen is displayed.
Retain all the domain defaults and click Create.

The domain is created and a progress indicator is displayed.

Any errors encountered during the domain creation are displayed. You must resolve any errors prior to continuing with the domain configuration. For information, see the installation guide for the version of WebLogic that you installed in "Installing a WebLogic Application Server".
Ensure that the Start Admin Server check box is not selected, and click Done.

Creating a WebLogic 10g Domain on Windows

Use the following steps to create a WebLogic domain on a Windows platform:

Click Start > All Programs > Oracle WebLogic > WebLogic Server 10gR3> Tools > Configuration Wizard to start the Fusion Middleware Configuration Wizard.

The Oracle WebLogic Configuration Wizard Welcome screen is displayed.
Select Create a new WebLogic domain option, and then click Next.

The Select Domain Source screen is displayed.
Click Next to retain the default selection.

The Configure Administrator User Name and Password screen is displayed.
Enter a user name. For example, dlsadmin.
Enter a password, and then enter it again to confirm this password.
Enter a description for this administrative user.
Click Next.

The Configure Server Start Mode and JDK screen is displayed.
Select the JRockit JDK 28.1 64-Bit that you installed on your Oracle DataLens Server.

Important:
Ensure that you select Oracle JRockit JDK 28.1 64-Bit because this is the only supported version and other versions may be installed.
Click Next.

The Customize Environment and Services Settings screen is displayed.
Select Yes, and the click Next to configure your domain.

The Configure RDBMS Security Store Database screen is displayed.
Click Next to retain the default selection and advance to the next screen.

The Configure the Administration Server screen is displayed.
Enter the name of your Oracle DataLens Administration Server. For example, dlsserver.
Configure the server protocol to be HTTP or Secure HTTP using one of the following:

For HTTP:
1. The default Listen address and SSL settings should not be changed.
2. Enter 2229 as the Listen port or the port number for your Oracle DataLens Administration Server if you installed it on a different port.
For HTTPS:

Configure your server for two-way SSL, which will authenticate clients:

Note:
The use of HTTPS significantly slows the response time from your Oracle DataLens Administration Server. In addition, there is a row processing limit of 5000 rows.
1. Select the SSL enabled check box.
2. Use the default Listen address.
3. Enter 2229 as the SSL Listen port or the port number for your Oracle DataLens Administration Server if you installed it on a different port.
4. Enter the port you want clients to listen on as the Listen port.
  
  Note:
  You must configure SSL to use certificates from a certificate authority. For more information, see "Configuring SSL" in Securing Oracle WebLogic Server for the installed WebLogic release (http://download.oracle.com/docs/cd/E17904_01/wls.htm).
Click Next.

The Configure Managed Servers screen is displayed.
Click Next to advance to the next screen.

The Configure Machines screen is displayed.
Click Next to advance to the next screen.

The Review WebLogic Domain screen is displayed.
Ensure that Deployment is selected in the Summary View list, and then click Next to advance to the next screen.

The Create WebLogic Domain screen is displayed.
Enter a domain name (for example, dls_domain), retain the default domain location, and then click Create.

Note:
A domain name must not start with a number.

The domain is created and a progress indicator is displayed.

Any errors encountered during the domain creation are displayed. You must resolve any errors prior to continuing with the domain configuration. For information, see Oracle WebLogic Server Creating WebLogic Domains Using the Configuration Wizard 10g Release 3 (10.3).
Ensure that the Start Admin Server check box is not selected, and click Done.

Configuring the HTTPS Server Variable

If you configured your WebLogic domain to use Secure HTTP, you must set the corresponding Oracle DataLens Server variable in each server configuration file as follows:

Edit the server.cfg file.

On Linux and UNIX: /opt/Oracle/Middleware/opdq/config

On Windows: C:\Oracle\Middleware\opdq\config
Add server.use.ssl=true to the file.
Save and close the file.
Repeat for each Oracle DataLens Server in your topology.

Configuring the Domain Variables

You must configure the memory and internal database variables for your WebLogic domain server to operate properly on your operating system as follows:

Go to the same directory as the one that contains your installation of WebLogic installation. For example, if you selected the default directory when configuring your domain on Linux and UNIX you would go to the /opt/Oracle/Middleware directory.
Change directories to the bin directory of your domain.

On Linux and UNIX: /user_projects/domains/dls_domain/bin/

On Windows: \user_projects\domains\dls_domain\bin\
Edit the WebLogic environment script:

On Linux and UNIX: setDomainEnv.sh

On Windows: setDomainEnv.cmd
Change the memory variable to the minimum value or to the recommended value, which is 80% of the server's total available memory:

For 11g (all operating systems):

Minimum: WLS_MEM_ARGS_64BIT="-Xms1024m -Xmx2048"

Recommended Example: WLS_MEM_ARGS_64BIT="-Xms1024m -Xmx26624m"

Where the -Xmx26624 value is set to 80% of the total amount of memory for a 32GB machine.

For 10g (all operating systems):

Minimum: MEM_ARGS="-Xms1024m -Xmx2048m"

Recommended Example: MEM_ARGS="-Xms1024m -Xmx26624m"

Where the -Xmx26624 value is set to 80% of the total amount of memory of 32GB machine.
Set the permanent memory size variables:

For 11g (all operating systems):

MEM_PERM_SIZE_64BIT="-XX:PermSize=1024m"

MEM_MAX_PERM_SIZE_64BIT="-XX:MaxPermSize=2048m"

For 10g (all operating systems):

MEM_PERM_SIZE="-XX:PermSize=512m"

MEM_MAX_PERM_SIZE="-XX:MaxPermSize=512m"

These are the lowest settings that will allow the dls_domain to operate properly. You can set these variables higher if additional memory is available on the server.
For WebLogic 11g 10.3.3 and later only, change the internal database settings so that the EDQP internal database is used rather than the WebLogic Derby Libraries to as follows:
1. Find the following lines in this file:
  
  On Linux and Windows:
```
if "%DERBY_FLAG%"=="true" (
    set DATABASE_CLASSPATH=%DERBY_CLASSPATH%
) else (
    set DATABASE_CLASSPATH=%DERBY_CLIENT_CLASSPATH%
)
```
  On UNIX:
```
if "%DERBY_FLAG%"=="true" (
    export DATABASE_CLASSPATH=%DERBY_CLASSPATH%
) else (
    export DATABASE_CLASSPATH=%DERBY_CLIENT_CLASSPATH%
)
```
2. Add the following lines immediately after the lines located in the preceding step:
  
  set DATABASE_CLASSPATH=""
3. Find the DERBY_FLAG value and ensure that it is set to false (this is the default) as follows:
```
set DERBY_FLAG=false
```
  Important:
  You must set these EDQP internal database settings correctly for the Oracle DataLens Server to start.
Save and close the file.

Starting the WebLogic Domain

The WebLogic domain must be started before the Oracle DataLens Server WAR file can be deployed. To start the domain:

On Linux and UNIX

Go to the /user_projects/domains/dls_domain/bin/ subdirectory of the WebLogic installation directory.
Start the domain:

./startWebLogic.sh

On Windows

Click Start > All Programs > Oracle WebLogic >User Projects >dls_domain >Start Admin Server for Weblogic Server Domain.

Deploying the WAR File into the WebLogic Domain

You must modify the dls_domain domain to set the deployment location of the Enterprise DQ for Product WAR file.

Start the WebLogic Server Administration Console by browsing to:

http://server:2229/console

Where server is the name of your Oracle DataLens Server.

The WebLogic Server Administration Console Log in Web page is displayed.
Enter the dls_domain user name and password, and then click Log In.

The Oracle WebLogic Server Administration Console home page is displayed.
Click Deployments from the Domain Structure tree.

The Summary of Deployments page is displayed.
Click the Install button.

The Install Application Assistant screen is displayed.
Enter or locate the path to the WAR file.

By default, the WAR file is located in:

On Linux and UNIX: /opt/Oracle/Middleware/opdq/server/datalens.war.

On Windows: C:\Oracle\Middleware\server\datalens.war.

Where server is the name of your Oracle DataLens Server.
Select the datalens.war option, and click Next.
Click Next to install the deployment as an application.

The optional settings are displayed in the Install Application Assistant screen.
Retain the page defaults, and click Finish.

The WAR file is deployed and confirmation message that the deployment was successful is displayed in the Summary of Deployments page, which can take several minutes.

The Summary of Deployments page is displayed.
Select the check box adjacent to datalens.
Click Start and select Servicing all requests to ensure that all requests are sent to the datalens WAR deployment.

Next Step

The final step in the installation process is to verify the installation. Continue to Chapter 5, "Verifying the Server Installation".