4
Configuring Oracle Reports Services on Sun SPARC Solaris

When you install the Oracle Internet Application Server (iAS) with the Oracle HTTP Server (powered by the Apache Web server), the Oracle Reports Services Servlet and Oracle Reports Services CGI are automatically configured for you in the Sun SPARC Solaris environment. This chapter describes how to manually change the configurations that were provided by default.

This chapter also describes how to start and stop Oracle Reports Services and the configuration environment variables.

4.1 Starting Oracle Reports Services

Do the following to start Oracle Reports Services:

From the $ORACLE_HOME/BIN directory, run the following command line to run Oracle Reports Services in the foreground:
```
rwmts60 name=repserver
```
Run the following command line to run Oracle Reports Services in the background:
```
rwmts60 name=repserver &
```
From the $ORACLE_HOME/BIN directory, run the following command line to ensure Oracle Reports Services is running:
```
rwrqv60 server=repserver
```
Status columns (for example, NAME, OWNER, and DEST) for Oracle Reports Services are displayed. Currently, though, no status information is available since no jobs are running.

If you want to output to PostScript or to a printer, then the printer must be configured in the uiprint.txt file (this file is located in the $ORACLE_HOME/guicommon6/tk60/ADMIN directory).

4.2 Configuring the Reports Servlet

There are two Reports Servlet configurations that you can manually change:

Oracle Reports Services Servlet with JSDK
Oracle Reports Services Servlet with JServ

4.2.1 Configuring the Oracle HTTP Server to Run the Reports Services Servlet with JSDK

The following configuration assumes that the Oracle HTTP Server is installed in the following directory:

/private1/ias

It also assumes that Oracle Reports Services is installed in the following directory:

/private1/ias/6iserver

Add the following entry to the Servlet properties file, servlet.properties, (for example, the Servlet properties file located in /private1/ias/Apache/Jsdk/examples):
```
servlet.RWServlet.code=oracle.reports.rwcgi.RWServlet
```
Create the directory hierarchy oracle/reports/rwcgi in your Web server Java class directory:
```
/private1/ias/Apache/Jsdk/examples/oracle/reports/rwcgi
```
You then copy into this new directory the RWServlet.class found in:
```
/private1/ias/6iserver/reports60/java
```
Add the root directory from the previous step into your CLASSPATH environment variable, located in (/private1/ias/Apache/Ojsp). Also add Ojsp/lib/servlet.jar to the CLASSPATH environment variable. For example:
```
setenv CLASSPATH/private1/ias/Apache/jdk/bin:
/private1/ias/Apache/jdk/lib/classes.zip:
/private1/ias/Apache/Jsdk/examples:/private1/ias/Apache/Ojsp/lib/servlet.jar
```

Set the PATH variable:

setenv PATH /private1/ias/6iserver/bin:/private1/ias/Apache/Apache/bin:
private1/ias/Apache/jdk/bin:
private1/ias/Apache/jsdk/bin:$PATH

Start Oracle Reports Services.
Start the Servlet runner by running the following command:
```
servletrunner &
```
Verify that the Servlet is running by:
1. Running the following from your browser ensures the installation and setup are okay:
```
http://hostname:portno/servlet/RWServlet/help?
```
  where:
  
  hostname
  
  is the machine name where the Apache listener is running.
  
  portno
  
  is the port number that where the Apache listener is started.
  
  This shows you that the Help page is active.
1. Running the following from your browser ensures the Oracle Reports Services is up:
```
http://hostname:portno/servlet/RWServlet/showjobs?
server=repserver
```
2. Entering the following from your browser runs a report:
```
http://hostname:portno/servlet/RWServlet?server=repserver+
report=ReportName+destype=cache+userid=ConnectString+desformat=htmlcss
```
  You can also use the cgicmd.dat file for key mapping.

If you modify the configuration file, then you need to stop and restart Oracle Reports Services to acknowledge the changes.

4.2.2 Configuring the Oracle HTTP Server to Run Reports Services Servlet with JServ

You do the following to configure the Oracle HTTP Server to run the Oracle Reports Services Servlet with JServ:

Add the following entry to zone.properties file. The zone.properties file is located in /private1/iAS/Apache/Jserv/examples directory.
```
servlet.RWServlet.code=oracle.reports.rwcgi.RWServlet
```
Create the directory hierarchy oracle/reports/rwcgi in your Web server Java class directory. For example, the full path might look like the following:
```
/private1/ias/Apache/Jserv/servlets/oracle/reports/rwcgi
```
You then copy into this new directory the RWServlet.class found in:
```
/private1/ias/6iserver/reports60/java/classes
```

Add the root directory from the previous step into your CLASSPATH environment variable. Also add Ojsp/lib/servlet.jar to the CLASSPATH environment variable. For example:

setenv CLASSPATH/private1/ias/Apache/jdk/bin:
/private1/ias/Apache/jdk/lib/classes.zip:
/private1/ias/Apache/Jserv/servlets:
/private1/ias/Apache/Ojsp/lib/servlet.jar

Start Oracle Reports Services.
Start the Oracle HTTP Server (powered by Apache) listener using the following command:
```
httpdsctl start
```
Verify the Oracle Reports Services Servlet is running by:
1. Running the following from your browser ensures the installation and setup are okay:
```
http://hostname:portno/servlets/RWServlet/help?
```
  This shows you that the Help page is active.
1. Running the following from your browser ensures Oracle Reports Services is up:
```
http://hostname:portno/servlets/RWServlet/showjobs?
server=repserver
```
2. Entering the following from your browser runs a report:
```
http://hostname:portno/servlets/RWServlet?server=repserver+
report=ReportName+destype=cache+userid=ConnectString+desformat=htmlcss
```
  You can also use the cgicmd.dat file for key mapping.

If you modify the configuration file, then you need to stop and restart Oracle Reports Services to acknowledge the changes.

4.3 Configuring Oracle HTTP Server Listener to Run Reports Services CGI

You do the following to change the default configuration for the Oracle HTTP Server listener to run the Reports CGI:

Add the following entry to the file httpds.conf (found in /private1/ias/Apache/Apache/conf):
```
ScriptAlias /cgi-bin/      "/private1/ias/6iserver/bin"
```
Start Oracle Reports Services.
Start the Oracle HTTP Server (powered by Apache) listener using the following command:
```
httpdsctl start
```
Verify the Reports CGI is running by:
1. Running the following from your browser ensures the installation and setup are okay:
```
http://hostname:portno/cgi-bin/rwcgi60/help?
```
  This shows you that the Help page is active.
1. Running the following from your browser ensures Oracle Reports Services is up:
```
http://hostname:portno/cgi-bin/rwcgi60/showjobs?
server=repserver
```
2. Entering the following from your browser runs a report:
```
http://hostname:portno/cgi-bin/rwcgi60?server=repserver+
report=ReportName+destype=cache+userid=ConnectString+desformat=htmlcss
```
  You can also use the cgicmd.dat file for key mapping.

If you modify the configuration file, then you need to stop and restart Oracle Reports Services to acknowledge the changes.

4.4 Stopping Oracle Reports Services

Do one of the following to stop Oracle Reports Services:

If Oracle Report Services is running in the foreground, then ensure that the focus is in the correct window and press ctrl-C.
If Oracle Report Services is running in the background, then enter the following at the command line:
```
ps -ef |grep 'rwmts60'
```
You would then enter:
```
kill -9 process_number
```

4.5 Environment Variables

Environment variables are the configuration parameters that are used to control or customize the behavior of Oracle Reports Services. Variables can be set using a shell script.

You can set two environment variables, REPORTS60_PATH and TNS_ADMIN. The REPORTS60_PATH is the search path for Reports Services source files (for example, RDFs, TDFs, and PLLs), and TNS_ADMIN overrides the default location for tnsnames.ora and sqlnet.ora. To set these do the following:

Create a directory for your source reports (for example, /WEB_REPORTS).
Set the REPORTS60_PATH environment variable to locate the reports. For example, using the C shell syntax:
```
setenv REPORTS60_PATH /WEB_REPORTS
```
Alternatively, after Oracle Reports Services is installed, you can set the source path by using the SOURCEDIR parameter. See Appendix B, "Oracle Reports Services Configuration Parameters" for more information.

Set the TNS_ADMIN environment variable to point to the location of the tnsnames.ora file. For example, using the C shell syntax:

setenv TNS_ADMIN $ORACLE_HOME/NET80/ADMIN

Variable Description

REPORTS60_COOKIE_EXPIRE

Determines the expire time of the cookie in minutes. The default value is 30.
Cookies save encrypted user names and passwords on the client-side when users log on to a secured Oracle Reports Services to run report requests. When users successfully log on, their browser is sent an encrypted cookie. When a cookie expires, subsequent requests (that is, ones that are sent to secured Oracle Reports Services), user must re-authenticate to run the report.

REPORTS60_DB_AUTH

Specifies the database authentication template used to log on to the database. The default value is dbauth.htm.

REPORTS60_ENCRYPTION_KEY

Specifies the encryption key used to encrypt the user name and password for the cookie. The encryption key can be any character string. The default value is reports6.0.

REPORTS60_REPORTS_SERVER

Specifies the default Oracle Reports Services for Web requests. When this parameter is set, you can omit the SERVER command line argument in report requests to process them using the default server, or you can include the SERVER command line argument to override the default.

REPORTS60_SSLPORT

If you are using SSL and you want to use a port number other than 443, then you can use this variable to set a different port number. The default value is 443.

REPORTS60_SYS_AUTH

Specifies the authentication template used to authenticate the user name and password when users run report request to a secured Oracle Reports Services. The default value is sysauth.htm.

`hostname`	is the machine name where the Apache listener is running.
`portno`	is the port number that where the Apache listener is started.

Variable	Description
REPORTS60_COOKIE_EXPIRE	Determines the expire time of the cookie in minutes. The default value is 30. Cookies save encrypted user names and passwords on the client-side when users log on to a secured Oracle Reports Services to run report requests. When users successfully log on, their browser is sent an encrypted cookie. When a cookie expires, subsequent requests (that is, ones that are sent to secured Oracle Reports Services), user must re-authenticate to run the report.
REPORTS60_DB_AUTH	Specifies the database authentication template used to log on to the database. The default value is `dbauth.htm`.
REPORTS60_ENCRYPTION_KEY	Specifies the encryption key used to encrypt the user name and password for the cookie. The encryption key can be any character string. The default value is reports6.0.
REPORTS60_REPORTS_SERVER	Specifies the default Oracle Reports Services for Web requests. When this parameter is set, you can omit the SERVER command line argument in report requests to process them using the default server, or you can include the SERVER command line argument to override the default.
REPORTS60_SSLPORT	If you are using SSL and you want to use a port number other than 443, then you can use this variable to set a different port number. The default value is 443.
REPORTS60_SYS_AUTH	Specifies the authentication template used to authenticate the user name and password when users run report request to a secured Oracle Reports Services. The default value is `sysauth.htm`.

4 Configuring Oracle Reports Services on Sun SPARC Solaris

4.1 Starting Oracle Reports Services

4.2 Configuring the Reports Servlet

4.2.1 Configuring the Oracle HTTP Server to Run the Reports Services Servlet with JSDK

4.2.2 Configuring the Oracle HTTP Server to Run Reports Services Servlet with JServ

4.3 Configuring Oracle HTTP Server Listener to Run Reports Services CGI

4.4 Stopping Oracle Reports Services

4.5 Environment Variables

4
Configuring Oracle Reports Services on Sun SPARC Solaris