Select an operating system and installation type before starting. Click on a heading below for instructions:

1. Pre-Installation Checks

Run through these checks with the company a few days before the installation is due to take place.

1. Check that the server has a static IP address

(Video Guide)

2. Check with the customer that you will be able to reboot the server on install day
3. Disable UAC if applicable
4. Reboot the server

Close Section

2. Pre-Installation Tasks

1. Log onto server as an administrator

2. Insert Installation Disc or Download the following from the Portal

Database.rar (32 bit)
Database.rar (62 bit)
App_server.rar
Red_Inst_5.rar
WinRAR (Needed to extract the above files)
Download latest update CD from here

Copy all of these files to a folder called Aventa_Install on the drive with the most space. Extract the archived folders to this location.

3. Go to Folder "Aventa_Install\Red_Inst_5\SERVER\" and Copy the following folders to the C:\ drive

CRUSERS
oraback
Orared

4. Copy the following Folder to the root of the largest drive

Red_Inst_5

5. Remove 'Read Only' Attribute from the following folders to include ALL Sub-Folders & Files.

Red_Inst_5
CRUSERS
Oraback
Orared

6. Install Barcode Font

(Video Guide)

Double click %DRIVE%\Red_Inst_5\Misc\3of9.ttf
Click Install

Close Section

3. Installing Oracle 10g Database

(Video Guide)

1. Run setup.exe found in Aventa_Install\Database_x**\Install. Use the following settings on each screen, pressing Next or Install to continue.

Installation Method screen

Select 'Advanced Installation'

Select Installation Type screen

Select 'Standard Edition'

Specify Home Details screen

Name = 'OraDb10g_home1'
Path = 'C:\oracle\product\10.2.0\db_1'

Product-Specific Prerequisite Checks

Select Configuration Option screen

Select 'Install Software Only'

Select Configuration Option screen

Select 'Create a database'

Select Database Configuration screen

Select 'General Purpose'

Specify Database Configuration Options screen

Global Database Name: red
SID: red
Tick 'Create database with sample schemas'

Select Database Management Option screen

Select 'Use Database Control for Database Management'

Specify Database Storage Option screen

Select 'File System'
Specify Database file location: '%DRIVE%\oracle\product\10.2.0\oradata'

Specify Backup and Recovery Options screen

Select 'Do not enable Automated backups'

Specify Database Schema Passwords screen

Select 'Use the same password for all the accounts'
Enter 'red$$' as the password

Summary screen

Database Configuration Assistant screen

End of Installation screen

2. Install Database Patchset 8202632 from the instructions for patches at the end of this document

3. Install Database Bug Patch 8350262 from the instructions for patches at the end of this document

4. Run the net configuration assistant (start menu/Programs/Oracle - OraDb10g..../Configuration and Migration Tools/Net Configuration Assistant)

(Video Guide)

Welcome screen

Select 'Listener configuration'

Listener screen

Select 'Add'

Listener Name screen

Listener name: RED

Select Protocols screen

TCP/IP Protocol screen

More Listeners? screen

Select 'No'

End of Installation screen

5. Run the database configuration assistant (start menu/Programs/Oracle - OraDb10g..../Configuration and Migration Tools/Database Configuration Assistant)

(Video Guide)

Welcome screen

Operations screen

Select 'Create a Database'

Database Templates screen

Select 'General Purpose'

Database Identification screen

Global Database Name: red
SID: Red

Management Options screen

Database Credentials screen

Select 'Use the same password for all the accounts'
Enter 'red$$' as the password

Storage Options screen

Database File Locations screen

Recovery Configuration screen

Database Content screen

Initialization Parameters screen

Select 'Choose from the list of character sets'
Database Character Set 'WE8MSWIN1252...'

Database Storage screen

Creation Options screen

Confirmation screen

End of Installation screen

5. Test Database Connection

4. Test Database Connection

Open SQLPLUSW (start menu/Programs/Oracle - OraDb10g..../Application Development

USER NAME = system
PASSWORD = red$$
HOST STRING = red

Type the following commands at the SQL> prompt.

quit

Close Section

4. Installing Oracle 10g Application Server

(Video Guide)

1. Run setup.exe found in \Aventa_Install\Apps_server\Install. Use the following settings on each screen, pressing Next or Install to continue.
(run in Windows 2003 compatibility mode)

Welcome Screen

File Locations Screen

Name: FRHome1
Path: %DRIVE%\oracle\FRHome_1

Language Selection Screen

Ensure the only language selected is "English", not English (United Kingdom)

Specify Port Configuration options Screen

Provide Outgoing Mail Server Information Screen

Specify Instance name and ias_admin Password Screen

Instance Name: red
ias_admin Password: redorcl10

Summary Screen

Post Installation Confiiguration Screen

If one of the configurations fail, click OK and then click Retry.

End of Installation Screen

2. Install Application Server Patchset 5983622 from the instructions for patches at the end of this document
(run in Windows 2003 compatibility mode)

3. Install Application Server interim patch 9282569 from the instructions for patches at the end of this document

Close Section

5. Installing Update CD

(Video Guide)

1.Copy the folder 'redthorn' from \Aventa_Install\%UPDATENO%\install\ to the root of the drive with the most space

2.Run \Aventa_Install\%UPDATENO%\install\update.exe as normal. Use the following settings on each screen, pressing Next or Install to continue.

Step 1 Screen

Step 2 Screen

Locate %DRIVE%\redthorn\aventa

3.Copy all files from \Aventa_Install\%UPDATENO%\install\forms\ to \oracle\FRHome_1\forms

Close Section

6. Configuring Oracle File Modifications

1.TNSNAMES.ORA

a. Open \oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora, you should see similar to the following:

# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

RED =
   (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_NAME)(PORT = 1521))
     )
   (CONNECT_DATA =
       (SERVICE_NAME = RED)
   )
)

EXTPROC_CONNECTION_DATA =
   (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
     )
   (CONNECT_DATA =
       (SID = PLSExtProc)
       (PRESENTATION = RO)
   )
)

b. Change the part highlighted in red to the IP Address of the server:

RED =
   (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.111.111)(PORT = 1521))
     )
   (CONNECT_DATA =
       (SERVICE_NAME = RED)
   )
)

c. Copy the selection shown in the previous part and paste it into the file \oracle\FRHome_1\NETWORK\ADMIN\tnsnames.ora as shown in blue in the following example, and change the parts highlighted in red to the IP address

# tnsnames.ora Network Configuration File: D:\oracle\frhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

REP_SERVER_NAME =
   (ADDRESS = (PROTOCOL = tcp)(HOST = 111.111.111.111)(PORT = 1950))

RED =
   (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.111.111)(PORT = 1521))
     )
   (CONNECT_DATA =
       (SERVICE_NAME = RED)
   )
)

EXTPROC_CONNECTION_DATA =
   (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.111.111)(PORT = 1521))
     )
   (CONNECT_DATA =
       (SERVICE_NAME = PLSExtProc)
   )
)

2.FORMSWEB.CFG

a. Open "\Red_Inst_5\server\text for jre.txt"

b. Open \oracle\FRhome_1\forms\server\formsweb.cfg

c. Copy the following code from "text for jre" into the end of formsweb.cfg

[AVENTA]
baseHTMLJInitiator=webutiljpi.htm
baseHTMLjpi=webutiljpi.htm
jpi_download_page=http://java.sun.com/j2se/1.6.0/download.html
jpi_classid=clsid:CAFEEFAC-0014-0002-0013-ABCDEFFEDCBA
jpi_codebase=http://java.sun.com/update/1.6.0/jinstall-6u33-windows-i586.cab#Version=1,6,0,33
jpi_mimetype=application/x-java-applet;jpi-version=1.6
pageTitle=Redthorn Aventa
separateFrame=yes
lookAndFeel=Oracle
colorScheme=blaf
width=100%
height=100%
HTMLbodyAttrs=scroll="no" leftmargin="0" topmargin="0" marginheight="0" marginwidth="0" onload="top.moveTo(0,0);top.resizeTo(screen.availWidth,screen.availHeight);"
imageBase=codebase
archive_jini=frmall_jinit.jar
WebUtilArchive=frmwebutil.jar,jacob.jar,/forms/aventa/public/aventa.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
splashScreen=startup.gif
background=background.gif
envFile=C:\redthorn\aventa\public\default.env
serverApp=/forms/aventa/public/registry
form=main.fmx

[REMOTE]
baseHTMLJInitiator=webutiljpi.htm
baseHTMLjpi=webutiljpi.htm
jpi_download_page=http://java.sun.com/j2se/1.6.0/download.html
jpi_classid=clsid:CAFEEFAC-0014-0002-0013-ABCDEFFEDCBA
jpi_codebase=http://java.sun.com/update/1.6.0/jinstall-6u33-windows-i586.cab#Version=1,6,0,33
jpi_mimetype=application/x-java-applet;jpi-version=1.6
pageTitle=Redthorn Aventa
separateFrame=yes
lookAndFeel=Oracle
colorScheme=blaf
width=100%
height=100%
HTMLbodyAttrs=scroll="no" leftmargin="0" topmargin="0" marginheight="0" marginwidth="0" onload="top.moveTo(0,0);top.resizeTo(screen.availWidth,screen.availHeight);"
imageBase=codebase
archive_jini=frmall_jinit.jar
WebUtilArchive=frmwebutil.jar,jacob.jar,/forms/aventa/public/aventa.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
splashScreen=startup.gif
background=none
envFile=C:\redthorn\aventa\public\default.env
serverApp=/forms/aventa/public/registry
form=main.fmx

[TOUCH]
baseHTMLJInitiator=webutiljpi.htm
baseHTMLjpi=webutiljpi.htm
jpi_download_page=http://java.sun.com/j2se/1.6.0/download.html
jpi_classid=clsid:CAFEEFAC-0014-0002-0013-ABCDEFFEDCBA
jpi_codebase=http://java.sun.com/update/1.6.0/jinstall-6u33-windows-i586.cab#Version=1,6,0,33
jpi_mimetype=application/x-java-applet;jpi-version=1.6
imageBase=codebase
WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
separateFrame=yes
splashScreen=startup.gif
background=background.gif
pageTitle=Redthorn Aventa
HTMLbodyAttrs=scroll="no" leftmargin="0" topmargin="0" marginheight="0" marginwidth="0" onload="top.moveTo(0,0);top.resizeTo(screen.availWidth,screen.availHeight);"
archive_jini=frmall_jinit.jar,/forms/aventa/public/aventa.jar
envFile=C:\redthorn\aventa\public\default.env
serverApp=/forms/aventa/public/registry
form=main.fmx
lookAndFeel=Oracle
colorScheme=blaf
width=100%
height=100%

d. Ensure that the envFile entry (shown in red above) for [AVENTA], [REMOTE] and [TOUCH] are pointing to the correct location

e. Set EM_MODE to 1

# EM config parameter
# Set this to "1" to enable Enterprise Manager to track Forms processes
em_mode=1

# Single Sign-On OID configuration parameter
oid_formsid=%OID_FORMSID%

3.DEFAULT.ENV

a. Copy default.env from \oracle\FRHome_1\forms\server to \redthorn\aventa\public

a. Open \redthorn\aventa\public\default.env

c. Copy from "text for jre" the following code

FORMS_PATH=D:\redthorn\aventa
FORMS_NMAP=False
FORMS_TIMEOUT=10
NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252

And paste it into \redthorn\aventa\public\default.env, replacing the part highlighted red

# If you need to include more than one directory, they should be semi-colon
# separated (e.g. C:\test\dir1;C:\test\dir2)
#
FORMS_PATH=D:\oracle\FRHome_1\forms

# webutil config file path
WEBUTIL_CONFIG=D:\oracle\FRHome_1\forms\server\webutil.cfg

# Disable/remove this variable if end-users need access to the query-where

Ensure the path for FORMS_PATH is correct.

# If you need to include more than one directory, they should be semi-colon
# separated (e.g. C:\test\dir1;C:\test\dir2)
#
FORMS_PATH=D:\redthorn\aventa
FORMS_NMAP=False
FORMS_TIMEOUT=10
NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252

# webutil config file path
WEBUTIL_CONFIG=D:\oracle\FRHome_1\forms\server\webutil.cfg

# Disable/remove this variable if end-users need access to the query-where

4.FORMS.CONF

a. Open \oracle\FRHome_1\forms\server\forms.conf with wordpad

b. Copy the two "AliasMatch" entries from the "text for jre" file, shown below

AliasMatch ^/forms/aventa/public/(..*) "D:\redthorn\aventa/public/$1"
AliasMatch ^/forms/forms-start/(..*) "D:\redthorn\formsstart/$1"

Ensure the path is correct.

c. Paste this into \oracle\FRHome_1\forms\server\forms.conf below the other AliasMatch entries

# Virtual path for webutil
AliasMatch ^/forms/webutil/(..*) "D:\oracle\FRHome_1/forms/webutil/$1"

AliasMatch ^/forms/aventa/public/(..*) "D:\redthorn\aventa/public/$1"
AliasMatch ^/forms/forms-start/(..*) "D:\redthorn\formsstart/$1"

# Configuration for JServ (if mod_jserv.c is available and not mod_oc4j.c)

5.WEBUTIL.CFG

a. Open \oracle\FRHome_1\forms\server\webutil.cfg

b. Scroll to the bottom of the file and make the changes in red, using the correct drive letter

#NOTE: By default the file transfer is disabled as a security measure
transfer.database.enabled=TRUE
transfer.appsrv.enabled=TRUE
transfer.appsrv.workAreaRoot=C:\redthorn\temp
transfer.appsrv.accessControl=TRUE
#List transfer.appsrv.read.<n> directories
transfer.appsrv.read.1=C:\redthorn\temp
#List transfer.appsrv.write.<n> directories
transfer.appsrv.write.1=C:\redthorn\temp

transfer.appsrv.workAreaRoot=C:\redthorn\temp\

#List transfer.appsrv.read.<n> directories
transfer.appsrv.read.1=C:\redthorn\temp\
transfer.appsrv.read.2=C:\redthorn\aventa\crystal\
#List transfer.appsrv.write.<n> directories
transfer.appsrv.write.1=C:\redthorn\temp\

6.REP_%SERVERNAME%_FRHOME1.CONF

a. Open \oracle\FRHome_1\reports\conf\REP_%SERVERNAME%_FRHOME1.CONF

b. Copy from "text for jre" the following code

jvmOptions="-Xms512m -Xmx1024m -Xoss256k"

c. Paste this as shown below

d. Copy from "text for jre" the following code

Ensure that the REPORTS_PATH is set to the correct location.

e. Paste this into the bottom of the file above </server>

7.SYSTEMS.XML

a. Open \redthorn\formsstart\systems.xml

b. Edit the IP Address to be correct for the server, this is in the file twice. Also, ensure the 'term' value is the correct location. Your systems.xml file should look like the following

<?xml version="1.0"?>
<?xml-stylesheet href="systems.xsl" type="text/xsl"?>
<systems>
   <db>
     <name>Aventa - LIVE</name>
     <form>main.fmx</form>
     <webhost>111.111.111.111</webhost>
     <port>7778</port>
     <servletpath>forms/frmservlet</servletpath>
     <config>AVENTA</config>
     <logon_user>redlive</logon_user>
     <term>D:\redthorn\aventa\public\fmrpcweb.res</term>
   </db>
   <db>
     <name>Aventa - PLAY</name>
     <form>main.fmx</form>
     <webhost>111.111.111.111</webhost>
     <port>7778</port>
     <servletpath>forms/frmservlet</servletpath>
     <config>AVENTA</config>
     <logon_user>redplay</logon_user>
     <term>D:\redthorn\aventa\public\fmrpcweb.res</term>
   </db>
</systems>

8.REMOTE.XML

a. Copy \redthorn\formsstrart\systems.xml to \redthorn\formsstart\remote.xml

b. Open \redthorn\formsstrart\remote.xml

c. Edit the config from AVENTA to REMOTE, this is in the file twice. Your remote.xml file should look like the following

<?xml version="1.0"?>
<?xml-stylesheet href="systems.xsl" type="text/xsl"?>
<systems>
   <db>
     <name>Aventa - LIVE</name>
     <form>main.fmx</form>
     <webhost>111.111.111.111</webhost>
     <port>7778</port>
     <servletpath>forms/frmservlet</servletpath>
     <config>REMOTE</config>
     <logon_user>redlive</logon_user>
     <term>D:\redthorn\aventa\public\fmrpcweb.res</term>
   </db>
   <db>
     <name>Aventa - PLAY</name>
     <form>main.fmx</form>
     <webhost>111.111.111.111</webhost>
     <port>7778</port>
     <servletpath>forms/frmservlet</servletpath>
     <config>REMOTE</config>
     <logon_user>redplay</logon_user>
     <term>D:\redthorn\aventa\public\fmrpcweb.res</term>
   </db>
</systems>

9.DEFAULT-WEB-SITE.XML

a. Open ORACLE_HOME\FRHome_1\j2ee\OC4J_BI_Forms\config\default-web-site.xml

b. Remove the following line

<access-log path="../log/OC4J_BI_Forms_default_island_1/default-web-access.log"/>

c. Save and close

d. Open CMD and navigate to C:\oracle\FRHome_1\dcm\bin

e. Run

dcmctl updateconfig -co OC4J_BI_FORMS -v -d

10.HTTPD.CONF

a. Open ORACLE_HOME\Apache\Apache\conf\httpd.conf

b. Find and change the following

"LogLevel warn" to "LogLevel crit"

c. Restart Services

Close Section

7. Restart Oracle Application Server

1. Open command prompt and change directory to \oracle\FRHome_1\opmn\bin

2. Run the following commands

opmnctl stopall
opmnctl startall

Close Section

8. Preparing the Database

1. Open C:\CRUSERS\Setup1.sql

2. Ensure all of the paths are correct (eg.C:\oracle\product\10.2.0\oradata\red\red*.dbf)

3. Run Setup1.sql in SQLPlusW

Open SQLPLUSW (start menu/Programs/Oracle - OraDb10g..../Application Development

USER NAME = sys as sysdba
PASSWORD = red$$
HOST STRING = red

Type the following commands at the SQL> prompt.

@C:\CRUSERS\Setup1
quit

Close Section

9. Importing the Database

1. Download blank database from the Portal

2. Open C:\orared\impred.par. Change the following highlighted parts to suit the import

file=C:\orared\aventa_release_auk.dmp
fromuser=aventa_release_auk
touser=redlive
buffer=4000000
commit=y
ignore=y

3. Open C:\orared\impredpl.par. Change the following highlighted parts to suit the import

file=C:\orared\aventa_release_auk.dmp
fromuser=aventa_release_auk
touser=redplay
buffer=4000000
commit=y
ignore=y

1. Retrieve data from the old server

2. Open C:\orared\impred.par. Change the following highlighted parts to suit the import

file=C:\orared\redlive.dmp
fromuser=redlive
touser=redlive
buffer=4000000
commit=y
ignore=y

3. Open C:\orared\impredpl.par. Change the following highlighted parts to suit the import

file=C:\orared\redplay.dmp
fromuser=redplay
touser=redplay
buffer=4000000
commit=y
ignore=y

4. Run C:\orared\impred.bat to import the live data, enter the following credentials

redlive
asd159

If this fails, you will need to add in the path to the imp executable at the beginning of the impred.bat file. This is in Oracle\product\10.2.0\db_1\bin\

5. Run C:\orared\impredpl.bat to import the play data, enter the following credentials

redlive
asd159

If this fails, you will need to add in the path to the imp executable at the beginning of the impredpl.bat file. This is in Oracle\product\10.2.0\db_1\bin\

6. Finish Import in SQLPlusW

Open SQLPLUSW (start menu/Programs/Oracle - OraDb10g..../Application Development

USER NAME = redlive
PASSWORD = asd159
HOST STRING = red

Type the following commands at the SQL> prompt.

update sfcci set cc_db_build=0;
commit;
conn redplay/play update sfcci set cc_db_build=0;
commit;
quit

7. Ensure Crystal Reports have been updgraded

Close Section

10. Install Client on server

1. Run \Red_inst_5\Server\ARC_SERVER_***.exe and follow the installation through suplying the correct IP address

Close Section

11. Update Touchscreen Shortcuts

1. Edit the IP address to the correct IP address in the four .cmd files found in \Red_inst_5\Touchscreen so they look similar to the example below

"C:\Program Files\Internet Explorer\iexplore.exe" -k "http://111.111.111.111:7778/forms/frmservlet?config=TOUCH&usesdi=yes&form=zps1.fmx&otherparams=logon_user=redlive"

Close Section

12. Testing and Setting up Aventa

1. Log into Aventa and install Java

2. Ensure the reports server is correct in Setting Central Company Information, it should look similar to the example below

REP_SERVER_FRHOME1
111.111.111.111
7778
AVENTA

The red parts are specific to each server.
The reports configuration comes from the reports configuration file name. This can be found at oracle\frhome_1\reports\conf.

3. Run the list customer report and ensure that no errors occur

4. Run the Crystal test report and ensure the no errors occur

5. Run Database Optimization and ensure no errors occur

6. Reset the root password to the first three letters of their company name followed by pcs

Close Section

13. Miscelaneous

1. Set Up Backups

Open the Start menu
Click Control Panel to expand the menu
Click Task Scheduler
Click "Add Scheduled Task"
   - Next
   - Browse...
   - Locate backup.bat in the Oraback folder
   - Change the Name to Aventa
   - Set to run Daily at 22:00
   - Enter the username and password and then click finish

To test that it will run, Right click on the task, and then click Run

1. Set Up Backups

Open the Start menu
Click Administrative Tools to expand the menu
Click Task Scheduler
Click Create Task
   - Name: Aventa
   - Tick
         Run whether user is logged on or not
         Do not store password
   - Triggers
         On A Schedule
         Daily
         22:00
   - Actions
         Start a program
         Locate backup.bat
         Start in: %oraback folder path%
Click OK
If you are prompted for a password, fill in with the correct password for the user

To test that it will run, Right click on the task, and then click Run

2. Reboot server

Close Section

14. Modify Log File Settings

Default Web Site Log

1. Open - C:\oracle\FRHome_1\j2ee\OC4J_BI_Forms\config\default-web-site.xml in notepad.

2. Remove the line

<access-log path="../log/OC4J_BI_Forms_default_island_1/default-web-access.log"/>

3. Save and close

4. Open CMD and navigate to type

cd C:\oracle\FRHome_1\dcm\bin
dcmctl updateconfig -co OC4J_BI_FORMS -v -d

Apache Logs

1. Open - C:\oracle\FRHome_1\Apache\Apache\conf\httpd.conf

2. Find and change LogLevel warn to LogLevel crit

3. Open CMD and navigate to C:\oracle\FRHome_1\opmn\bin

4. Run opmnctl stopall

5. Run opmnctl startall

Close Section

15. Common Problems

Close Section

Installation of Oracle Patches on Aventa Server

(Video Guide)

1. Run setup.exe from \Aventa_Install\Apps_server\Patches\5983622

Welcome screen

Specify Home Details screen

Name = 'FRHome1'
Path = 'C:\oracle\FRHome_1'

Select a Product Screen

Select - Oracle Appplication Server and Development Suite 10g Rel 2 Software Update 10.1.2.3.0

Enter IAS-Admin password screen

Password = 'redorcl10'

Available Product Components screen

Summary screen

If you get the error message mentioning the rotatelog.exe, you need to go into Task Manager and manually end the process(es) rotatelog.exe

End of Installation screen

2. Open up \Aventa_Install\Apps_server\Patches\5983622\10.1.2.3\10123\formsweb config\config.txt and copy the contents of the file

3. Open up \oracle\FRHome_1\forms\server\formsweb.cfg and replace the current data under the [AVENTA], [REMOTE] and [TOUCH] tags. Ensure that the path is correct for each tag envFile

[AVENTA]
baseHTMLJInitiator=webutiljpi.htm
baseHTMLjpi=webutiljpi.htm
java_version=1.6+
jpi_classid=clsid:CAFEEFAC-0016-0000-FFFF-ABCDEFFEDCBA
jpi_codebase=http://java.sun.com/update/1.6.0/jinstall-6u41-windows-i586.cab#Version=1,6,0,41
jpi_mimetype=application/x-java-applet;jpi-version=1.6
pageTitle=Redthorn Aventa
separateFrame=false
lookAndFeel=Oracle
colorScheme=blaf
width=100%
height=100%
HTMLbodyAttrs=scroll="no" leftmargin="0" topmargin="0" marginheight="0" marginwidth="0" onload="top.moveTo(0,0);top.resizeTo(screen.availWidth,screen.availHeight);"
imageBase=codebase
archive_jini=frmall_jinit.jar
WebUtilArchive=/forms/aventa/public/frmwebutil3.jar,/forms/aventa/public/jacob3.jar,/forms/aventa/public/aventa3.jar,/forms/aventa/public/aventapjc3.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
splashScreen=startup.gif
background=background.gif
envFile=C:\redthorn\aventa\public\default.env
serverApp=/forms/aventa/public/registry
form=main.fmx
networkRetries=30

[REMOTE]
baseHTMLJInitiator=webutiljpi.htm
baseHTMLjpi=webutiljpi.htm
java_version=1.6+
jpi_classid=clsid:CAFEEFAC-0016-0000-FFFF-ABCDEFFEDCBA
jpi_codebase=http://java.sun.com/update/1.6.0/jinstall-6u41-windows-i586.cab#Version=1,6,0,41
jpi_mimetype=application/x-java-applet;jpi-version=1.6
pageTitle=Redthorn Aventa
separateFrame=false
lookAndFeel=Oracle
colorScheme=blaf
width=100%
height=100%
HTMLbodyAttrs=scroll="no" leftmargin="0" topmargin="0" marginheight="0" marginwidth="0" onload="top.moveTo(0,0);top.resizeTo(screen.availWidth,screen.availHeight);"
imageBase=codebase
archive_jini=frmall_jinit.jar
WebUtilArchive=/forms/aventa/public/frmwebutil3.jar,/forms/aventa/public/jacob3.jar,/forms/aventa/public/aventa3.jar,/forms/aventa/public/aventapjc3.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
splashScreen=startup.gif
background=none
envFile=C:\redthorn\aventa\public\default.env
serverApp=/forms/aventa/public/registry
form=main.fmx
networkRetries=30

[TOUCH]
baseHTMLJInitiator=webutiljpi.htm
baseHTMLjpi=webutiljpi.htm
java_version=1.6+
jpi_classid=clsid:CAFEEFAC-0016-0000-FFFF-ABCDEFFEDCBA
jpi_codebase=http://java.sun.com/update/1.6.0/jinstall-6u41-windows-i586.cab#Version=1,6,0,41
jpi_mimetype=application/x-java-applet;jpi-version=1.6
pageTitle=Redthorn Aventa
separateFrame=false
lookAndFeel=Oracle
colorScheme=blaf
width=100%
height=100%
HTMLbodyAttrs=scroll="no" leftmargin="0" topmargin="0" marginheight="0" marginwidth="0" onload="top.moveTo(0,0);top.resizeTo(screen.availWidth,screen.availHeight);"
imageBase=codebase
archive_jini=frmall_jinit.jar
WebUtilArchive=/forms/aventa/public/frmwebutil3.jar,/forms/aventa/public/jacob3.jar,/forms/aventa/public/aventa3.jar,/forms/aventa/public/aventapjc3.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
splashScreen=startup.gif
background=background.gif
envFile=C:\redthorn\aventa\public\default.env
serverApp=/forms/aventa/public/registry
form=main.fmx
networkRetries=30

4. Backup \oracle\FRHome_1\forms\server\webutil.cfg

5. Copy \Aventa_Install\Apps_Server\Patches\5983622\10.1.2.3\10123\webutil config\webutil.cfg to \oracle\FRHome_1\forms\server\webutil.cfg and update any paths in the file shown below from the end of the file

#NOTE: By default the file transfer is disabled as a security measure
transfer.database.enabled=TRUE
transfer.appsrv.enabled=TRUE
transfer.appsrv.workAreaRoot= C:\redthorn\temp
transfer.appsrv.accessControl=TRUE
#List transfer.appsrv.read.<n> directories
transfer.appsrv.read.1=C:\temp
#List transfer.appsrv.write.<n> directories
transfer.appsrv.write.1=C:\temp

transfer.appsrv.workAreaRoot=C:\redthorn\temp\

#List transfer.appsrv.read.<n> directories
transfer.appsrv.read.1=C:\redthorn\temp\
transfer.appsrv.read.2=C:\redthorn\aventa\crystal\
#List transfer.appsrv.write.<n> directories
transfer.appsrv.write.1=C:\redthorn\temp\

6. Copy \Aventa_Install\Apps_Server\Patches\5983622\10.1.2.3\10123\webutil plx\oracle_forms\webutil.pll to \oracle\FRHome_1\forms\webutil.pll

7. Copy \Aventa_Install\Apps_Server\Patches\5983622\10.1.2.3\10123\webutil plx\redthorn_folder\webutil.plx to \redthorn\aventa\webutil.plx

8. Copy \Aventa_Install\Apps_Server\Patches\5983622\10.1.2.3\10123\jacobdll\jacob.dll to \oracle\FRHome_1\forms\webutil\jacob.dll

9. Uninstall Java 1.4

10. Go to \oracle\FRHome_1\j2ee\OC4J_BI_FORMS\applications\formsapp\formsweb\WEB-INF

Create temp subfolder and backup orion-web.xml and web.xml

11. Log into the EM console (http://ipaddress:18100)

2. Log into the EM console (http://ipaddress:18100)

Click OC4J_BI_FORMS
Click Applications
Ensure the radio button for formsapp is selected
Click Redeploy
Click Browse
Select \oracle\FRHome_1\forms\j2ee\formsapp.ear
Restart OC4J_BI_FORMS

Close Section

Installation of Aventa on Windows Server Installation of Aventa on Windows Server 2008 (All Versions) Installation of Aventa on Windows Server 2012 (All Versions) Installation of Aventa on Windows Server 2003 (All Versions)

Installation of Oracle Patches on Aventa Server

1. Pre-Installation Checks

(Video Guide)

2. Pre-Installation Tasks

1. Log onto server as an administrator

2. Insert Installation Disc or Download the following from the Portal

3. Go to Folder "Aventa_Install\Red_Inst_5\SERVER\" and Copy the following folders to the C:\ drive

4. Copy the following Folder to the root of the largest drive

5. Remove 'Read Only' Attribute from the following folders to include ALL Sub-Folders & Files.

6. Install Barcode Font

3. Installing Oracle 10g Database

(Video Guide)

(Video Guide)

1. Run setup.exe found in Aventa_Install\Database_x**\Install. Use the following settings on each screen, pressing Next or Install to continue.

2. Install Database Patchset 8202632 from the instructions for patches at the end of this document

3. Install Database Bug Patch 8350262 from the instructions for patches at the end of this document

4. Run the net configuration assistant (start menu/Programs/Oracle - OraDb10g..../Configuration and Migration Tools/Net Configuration Assistant)

(Video Guide)

5. Run the database configuration assistant (start menu/Programs/Oracle - OraDb10g..../Configuration and Migration Tools/Database Configuration Assistant)

(Video Guide)

5. Test Database Connection

4. Test Database Connection

4. Installing Oracle 10g Application Server

(Video Guide)

1. Run setup.exe found in \Aventa_Install\Apps_server\Install. Use the following settings on each screen, pressing Next or Install to continue. (run in Windows 2003 compatibility mode)

2. Install Application Server Patchset 5983622 from the instructions for patches at the end of this document (run in Windows 2003 compatibility mode)

3. Install Application Server interim patch 9282569 from the instructions for patches at the end of this document

5. Installing Update CD

(Video Guide)

1.Copy the folder 'redthorn' from \Aventa_Install\%UPDATENO%\install\ to the root of the drive with the most space

2.Run \Aventa_Install\%UPDATENO%\install\update.exe as normal. Use the following settings on each screen, pressing Next or Install to continue.

3.Copy all files from \Aventa_Install\%UPDATENO%\install\forms\ to \oracle\FRHome_1\forms

6. Configuring Oracle File Modifications

1.TNSNAMES.ORA

2.FORMSWEB.CFG

3.DEFAULT.ENV

4.FORMS.CONF

5.WEBUTIL.CFG

6.REP_%SERVERNAME%_FRHOME1.CONF

7.SYSTEMS.XML

8.REMOTE.XML

9.DEFAULT-WEB-SITE.XML

10.HTTPD.CONF

7. Restart Oracle Application Server

1. Open command prompt and change directory to \oracle\FRHome_1\opmn\bin

2. Run the following commands

8. Preparing the Database

1. Open C:\CRUSERS\Setup1.sql

2. Ensure all of the paths are correct (eg.C:\oracle\product\10.2.0\oradata\red\red*.dbf)

3. Run Setup1.sql in SQLPlusW

9. Importing the Database

1. Download blank database from the Portal

2. Open C:\orared\impred.par. Change the following highlighted parts to suit the import

3. Open C:\orared\impredpl.par. Change the following highlighted parts to suit the import

1. Retrieve data from the old server

2. Open C:\orared\impred.par. Change the following highlighted parts to suit the import

3. Open C:\orared\impredpl.par. Change the following highlighted parts to suit the import

4. Run C:\orared\impred.bat to import the live data, enter the following credentials

5. Run C:\orared\impredpl.bat to import the play data, enter the following credentials

6. Finish Import in SQLPlusW

7. Ensure Crystal Reports have been updgraded

10. Install Client on server

1. Run \Red_inst_5\Server\ARC_SERVER_***.exe and follow the installation through suplying the correct IP address

11. Update Touchscreen Shortcuts

1. Edit the IP address to the correct IP address in the four .cmd files found in \Red_inst_5\Touchscreen so they look similar to the example below

12. Testing and Setting up Aventa

1. Log into Aventa and install Java

2. Ensure the reports server is correct in Setting Central Company Information, it should look similar to the example below

3. Run the list customer report and ensure that no errors occur

4. Run the Crystal test report and ensure the no errors occur

5. Run Database Optimization and ensure no errors occur

6. Reset the root password to the first three letters of their company name followed by pcs

13. Miscelaneous

1. Set Up Backups

1. Set Up Backups

2. Reboot server

14. Modify Log File Settings

Default Web Site Log

1. Open - C:\oracle\FRHome_1\j2ee\OC4J_BI_Forms\config\default-web-site.xml in notepad.

Installation of Aventa on Windows Server

Installation of Aventa on Windows Server 2008 (All Versions)

Installation of Aventa on Windows Server 2012 (All Versions)

Installation of Aventa on Windows Server 2003 (All Versions)

1. Run setup.exe found in \Aventa_Install\Apps_server\Install. Use the following settings on each screen, pressing Next or Install to continue.
(run in Windows 2003 compatibility mode)

2. Install Application Server Patchset 5983622 from the instructions for patches at the end of this document
(run in Windows 2003 compatibility mode)