QuercusPlus 8.0 Installation Guide<>

QuercusPlus 8.0 Installation on 11g

QuercusPlus configuration on Oracle Fusion

The configuration files for Oracle Forms in Oracle Fusion remain much the same as they are for a Oracle AS 10g server, namely:

tnsnames.ora

default.env

formsweb.cfg

forms.conf

registry.dat

rollover buttons location

jar files location

webutil.cfg

shortcut keys location

The difference is that the location of all these files for Oracle Fusion is very much different to that for 10g.

To understand the difference it is helpful to review the topology of the Oracle Fusion installation.

Oracle file locations

Default directory paths are configured on installation and are denoted by $[location]:

Location

Example

$ORACLE_HOME_LOCATION

C:\Oracle\Middleware\as_1

$ORACLE_INSTANCE_LOCATION

C:\Oracle\Middleware\asinst_1

$DOMAIN_HOME

C:\Oracle\Middleware\user_projects\domains\ClassicDomain

The above locations depend on directories chosen during application server installation and vary from install to install.

Within this structure files are located as follows:

File(s)

Location

tnsnames.ora

$ORACLE_INSTANCE_LOCATION\config

default.env

$DOMAIN_HOME\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_11.1.1\config

formsweb.cfg

$DOMAIN_HOME\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_11.1.1\config

registry.dat

$DOMAIN_HOME\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_11.1.1\config\forms\registry\oracle\forms\registry

rollover buttons

$ORACLE_HOME_LOCATION\forms\java\campusit\forms\ui

jar files

$ORACLE_HOME_LOCATION\forms\java

webutil.cfg

$ORACLE_INSTANCE_LOCATION\config\FormsComponent\forms\server

shortcut keys

$ORACLE_INSTANCE_LOCATION\config\FormsComponent\forms

QuercusPlus file locations

CampusIT have defined the QuercusPlus file locations as C:\quercusplus. They are notated by $QPLUS

File

Location

Forms

$QPLUS\forms

Reports

$QPLUS\reports

Images

$QPLUS\images

Control

$QPLUS\control

Rollover Buttons

$ORACLE_HOME_LOCATION\forms\java\campusit\forms\ui

Shortcut Keys

$ORACLE_INSTANCE_LOCATION\config\FormsComponent\forms

Installation prerequisites

Oracle Application Server 11g Release 1 Forms and Report Services are installed on the server.

Review and install required patches as specified in the “CIT Platform Roadmap” Document.

URL to access Oracle Enterprise Manager is working.

URL to access Oracle Forms Services is working.

Access to the Application Server as administrator.

The QuercusPlus 8.0 baseline database is installed

Oracle Application Express version 4.0 — this is only needed if you are installing QuercusPlus 8.0 Menu.

Pre-installation tasks

1Connect to the QuercusPlus database as QUERCUS user

2Create a Media folder on the Application Server host; this will be referred to as $MEDIA hereafter

3Obtain SU2800 from the Configuration Manager > Patches section of CampusIT Connect

4Extract all the files in it to the $MEDIA directory.

Installation

Create directory structure

Create a QuercusPlus home directory e.g. c:\quercusplus on the application server host; hereafter this will be referred to as “$QPLUS_HOME”.

Create the following sub-folders of $QPLUS_HOME:

$QPLUS_HOME\forms

$QPLUS_HOME\reports

$QPLUS_HOME\images

$QPLUS_HOME\control

$QPLUS_HOME\intermedia

$QPLUS_HOME\java

$QPLUS_HOME\icons

Ensure that the owner of the Oracle Application Server installation has read-write access to these directories.

Copy the binary files

When the QuercusPlus 8.0 installation files were extracted to the $MEDIA directory the following directory structure should have been created:

$MEDIA\application

$MEDIA\documents

$MEDIA\forms\windows

$MEDIA\forms\FORMS IMAGES

$MEDIA\images

$MEDIA\reports

$MEDIA\reports_source

$MEDIA\smart_links

$MEDIA\sql

The files from $MEDIA are now required for the installation.

To copy the binary files

1Copy the Control files (.ctl) and the export scripts (.sql) from your existing Quercus 2.7 installation control directory (C:\QuercusPlus\control) and paste them into the new $QPLUS_HOME\control directory.

2Copy the Forms (.fmx), Menus (.mmx) and Libraries (.plx) from $MEDIA\forms\windows to the $QPLUS_HOME\forms directory.

3Copy all files from $MEDIA\images to the C:\Oracle\Application Express\i40\images directory.

4Copy the Reports (.rep) from the $MEDIA\reports\windows to the $QPLUS_HOME\reports directory.

5Copy all files from your existing Quercus 2.7 installaion intermedia directoy (C:\QuercusPlus\intermedia) and paste them into the new $QPLUS_HOME\intermedia directory.

6Copy the icon files (.jar) from your existing Quercus 2.7 installaion (C:\Oracle\10gASTools\Forms\Java) to $ORACLE_HOME_LOCATION\forms\Java.

7Copy the CONFIG folder from $MEDIA\forms\FORMS IMAGES\%ORACLE_INSTANCE_HOME% folder to the %ORACLE_INSTANCE_HOME% location on your application server.

8Copy all of the images files from your existing Quercus 2.7 installation (C:\QuercusPlus\images) to the new $QPLUS_HOME\images directory.

Note: Files located in $MEDIA\reports_source (.xml) are NOT required to be installed in the Application server. They are intended to be used by developers to create customized reports.

Configuring Oracle Forms server

To configure shortcut keys

In order to make the shortcut keys work the resource files on the application server need to be replaced.

The resource files are found in $ORACLE_INSTANCE_LOCATION\config\FormsComponent\forms on the application server.

1Rename the file fmrweb.res to fmrweb.res.orig.

2Rename the file fmrpcweb.res to fmrweb.res.

To configure rollover buttons

1Create a directory $ORACLE_HOME_LOCATION\forms\java\campusit\forms\ui.

2Copy all Java class files (.class) from your existing Quercus 2.7 installation (C:\Oracle\10gASTools\forms\java\ui) to the new directory.

To create a virtual directory for document storage

Edit the file $ORACLE_INSTANCE_LOCATION\config\OHS\ohs1\moduleconf\forms.conf as follows:

1Add the line for the document storage folder:

AliasMatch ^/intermedia/(..*) "$QPLUS_HOME\intermedia/$1"

2Add line for Virtual Control Directory:

AliasMatch ^/control/(..*) "$QPLUS_HOME\control/$1"

To create the application configuration file

These steps will create a new application environment named QuercusPlus.

1Go to:
$DOMAIN_HOME\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_11.1.1\config

2Make a copy of the file default.env and rename it to quercusplus.env.

3Edit quercusplus.env as follows:

aChange FORMS_PATH to include $QPLUS_HOME\forms.

bAdd:

REPORTS_PATH = $QPLUS_HOME\reports

STUDENT_IMAGES = $QPLUS_HOME\images

LOADPATH = $QPLUS_HOME\control

LOADTOOL = $ORACLE_HOME_LOCATION\bin

CONTROL = /control/

To register the new application

Amend the file: $DOMAIN_HOME\config\fmwconfig\SERVERS\WLS_FORMS\applications\formsapp_11.1.1\config\formsweb.cfg by following the steps below:

1Amend the following parameters

separateframe=true

width=1000

height=600

imagebase=codebase

archive=frmall.jar,qpicons.jar

2Add a new application definition at the end of the file

[QuercusPlus]

baseHTML=webutilbase.htm

baseHTMLjpi=webutiljpi.htm

webutilArchive=frmwebutil.jar

jpi_download_page=http://java.sun.com/javase/downloads/index.jsp

jpi_classid=clsid:CAFEEFAC-0016-0000-0017-ABCDEFFEDCBA

jpi_mimetype=application/x-java-applet;jpi-version=1.6.0_17

jpi_codebase=http://java.sun.com/update/1.6.0/jinstall-6u17-windows-i586.cab#Version=1,6,0,17

envfile=quercusplus.env

PageTitle=QuercusPlus 8.0 Student Administration System

Form=quercusplus1_8.fmx

usesdi=yes

colorscheme=blue

Sun Java Parameters used

jpi_download_page

Specifies the page where the Sun Java console is downloaded.

jpi_classid

Specifies the version of Sun’s java plug-in that is to be used.

In the definition above version 1.6.0_17 will be used.

jpi_mimetype

The jpi-version should correspond with the version specified in the jpi_classid.

jpi_codebase

Indicates a site-specific place to download the plug-in to the client if the client doesn’t already have the plug-in installed.

Note: There can be as many independent environments on one Application server as needed (e.g. Production, Training, Test). Separate Application Configuration Files have to be created and Registered as described in the preceding paragraphs.

Configuring Oracle Reports Server

Application Server

To configure the Application Server

1Edit the reports server configuration file
$ORACLE_INSTANCE_HOME\config\ReportsServerComponent\ReportsServer_<report host machine name>\rwserver.conf
(e.g. C:\Oracle\Middleware\asinst_1\config\ReportsServerComponent\ReportsServer_CIT-TEST11G-AS_a\rwserver.conf)

2Uncomment and set source and temp directory for report server (replace $QPLUS_HOME and $TEMP_FOLDER with actual paths):

<property name ="sourceDir" value="$QPLUS_HOME\reports"/>
<property name="tempDir" value="$TEMP_FOLDER" />

QuercusPlus database

To register the Reports Server

1Connect as QUERCUS in SQPLUS.

2If the table opencampus_parameters is empty insert a new record:

Insert into opencampus_parameters(object_id, timestamp, report_server) values(record_id.nextval, sysdate, ‘$REPORT_SERVER_NAME’);
Commit;

3Otherwise update the existing record using:

update opencampus_parameters set report_server = '$REPORTS_SERVER_NAME';
commit;

Create additional Reports Server (optional)

» See Oracle Docs 1084103.2, 961174.1

Communication to Oracle Database instances

The communication to the Oracle Database instances must be established. This will enable forms users to connect to the database. This is done by modifying the tnsnames.ora file.

To modify tnsnames.ora

1Edit the file $ORACLE_INSTANCE_LOCATION\config\tnsnames.ora.

2Add entries for the databases that you wish to connect to; an example of an entry is:

<service_name> = (DESCRIPTION =(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)

(HOST = <db_host_name>)(PORT = <port_number>)))

(CONNECT_DATA = (SID = <database_SID>)))

Check for successful build

If the build has been successful you should be able to connect to the database via the QuercusPlus application and start using the application without any errors.

http://<host>:<port>/forms/frmservlet?config=QuercusPlus

Example

http://cit-test-as:7778/forms/frmservlet?config=QuercusPlus

Installation of QuercusPlus Menu

An optional element to QuercusPlus 8.0 is the QuercusPlus Menu. To install this you need to have Oracle Application Express installed in your database (on 11g database APEX 3.0 comes installed as part of the standard installation, this will need to be upgraded to APEX 4.0.1).

If not installed and configured you can download Oracle Application Express from http://www.oracle.com/technetwork/developer-tools/APEX/downloads/index.html

Version 4.0.1 should be downloaded, installed and configured as per the Oracle documentation for Oracle Application Express (APEX)

Importing and installing the Menu

Note: The procedure below installs the menu using the APEX interface. You can also install the menu using SQL. See Appendix 2 — Installation guide for QuercusPlus version 8.

To import and install the applications

1Log into Oracle Application Express

2On the Home Page click on the Application Builder button

3Click the IMPORT button above the list of applications

4Click on browse and select the import file from the SU2200/application folder.

5Click Next. The application will be imported into APEX.

6Click Next to install the application. This may take a few minutes.

7On the Install Application page:

aSelect the parsing schema presented to you as the parsing schema.

bSelect Run and Build Application as the Build Status.

cReuse Application ID xxx from Export File.

8Click Install. Again, this may take a few minutes.

9Select No to install supporting objects.

Once the application has been installed a verification screen is display.

Some releases of the Oracle APEX applications will contain images that need to be installed along with the updated application. Installation details of these images are contained within the readme files for each software update.

Installation of Smart Links

QuercusPlus 8.0 comes with new user interface including innovative navigation system called Smart Links.

The method you use to import the standard Smart Links configuration will depend upon whether or not you have access to Control Centre.

To install Smart Links without using Control Centre

If you are not using the QuercusLive application but wish to use the Smart Links in QuercusPlus 8.0:

1Log into SQL*Plus as the SYSTEM user and create a new virtual directory on your database server, you will need to replace DIRECTORY_LOCATION with the actual folder on the server (in this example c:\temp):

SQL> create directory QUERCUS_LOAD_DIR as 'c:\temp';
SQL> grant read on directory QUERCUS_LOAD_DIR to quercus;

2Copy the all XML files with Smart Links (in the #SUXXXX#\smart_links folder) to the directory on your database server (e.g. c:\temp).

3Once the files are in the directory you will need to run the below command for each file:

SQL> exec quercus.oc_slink_admin.import_from_file('QUERCUS_LOAD_DIR', 'FILE_NAME.xml');

4Log into QuercusPlus and confirm that the icons on home page and Smart Links are now showing on the landing page after log in, and that there are no error messages showing.

To install Smart Links using Control Centre

With QuercusLive control centre Smart Links can be imported and fully configured using browser.

1Go to QuercusLive Control Centre.

2Login as the Administrator.

3Go to the Set-up tab.

4Click on the Smart Links Option.

The Smart Links screen opens.

5Click the Import link (located in the top right of the screen).

6Browse for the QUERCUS.xml located in the #SUXXXX#\smart_links folder.

7Click the Import button.

The Install Smart Links screen opens.

8Select the Add new links only.

9Select the Add new links only option and click Install Now.

The Smart Links are installed.

10Repeat steps 59 for any other XML file in the #SUXXXX#\smart_links folder.