Bentley OpenUtilities CONNECT Edition Help

Bentley OpenUtilities Administration

System Requirements

Bentley OpenUtilities Designer was developed for Intel-based systems running Windows NT, Windows 2000, Windows XP, or Windows Vista and utilizing an Oracle 10g database (along with Oracle Lite for users in the field).

The recommended system configuration is as follows:

Client Workstations

  • 192 Mb or more
  • 1 Gb hard drive
  • Pentium II 750 MHz or higher
  • Monitor that supports 1024 x 768 resolution

Server

  • 256 Mb of RAM (minimum) or 512 Mb or more (recommended)
  • 1 Gb to 12 Gb hard drive space (depending on the customer's storage requirements and the size of the database)
  • Pentium II 266 to 300 MHz or higher. Configurations with UNIX database servers are also supported.

Network Bandwidth

  • 100 Mbit Ethernet or switched 10 Mbit Ethernet for 30 or more full-time users.

Installation Requirements

In addition to the files supplied on the distribution CD, Bentley OpenUtilities Designer requires the following software:

  • Windows NT 4.0 with Service Pack 6 or later; or Windows 2000 with Service Pack 2 or later; or Windows XP with Service Pack 1 or Windows Vista
  • Oracle 9i ,10g
  • Oracle Lite 5.0.2.5.0 (if replication functionality will be implemented)
  • Microsoft Internet Explorer 5.01 with Service Pack 2 or later
  • Microsoft Data Access Components (MDAC) 2.6 or later
Note: If this component is not installed on the machine, the installation wizard will not complete the installation process. If an older version of MDAC is detected, a warning message will be displayed. The installation process can be cancelled and then resumed later after these components have been installed or updated.

The readme file on the Bentley OpenUtilities Designer distribution CD contains detailed, up-to-date information about all required components and should be consulted prior to installation.

The information in the following sections assumes that the required Microsoft components are already installed and that Bentley OpenUtilities Designer is being installed for the first time.

For an overview of the installation process, see “Installation Overview” on page 3. For a description of the installation wizard, see “Installing Bentley OpenUtilities Designer”.

Installation Overview

A typical installation of Bentley OpenUtilities Designer consists of the following steps. These procedures should be performed by an administrator or other user who is knowledgeable about Oracle DBA concepts and has the necessary administrative privileges. To obtain detailed procedures for installing Oracle and GIS software, consult the documentation supplied with these products.

Server Setup:

  • Install Oracle 8i (8.1.7) or 9i (9.2.0.1.0) or 10g (10.) on the server.
  • Create a new Oracle database using the following initialization parameters:

Db_block_size: 8192 bytes

Open_cursors: 25000 (50 * Max users)

Processes: 220

Remote_OS_Authentication: TRUE

Db_block_buffers: 3000

Shared_pool_size: >20000000 (20 million)

OS_Authent_Prefix: '' (empty string)

Note: For Unix or VMS, set Authentication Prefix to ''.
  • Install the Bentley OpenUtilities Designer data tables (for new installations, this step involves a batch process with a .dmp file). See “Loading the Bentley OpenUtilities Designer Tables”.
  • Install the GIS software on the server.
  • Register the GIS license.
  • Install the GIS image and datastore.
  • Install Bentley OpenUtilities Designer and ED Server on the server that will run ED Server. This is an automated process handled by the installation wizard (see “Installing Bentley OpenUtilities Designer” ).

Client Setup

  • Install Oracle 8i (8.1.7, Client Edition) , 9i (9.2.0, Client Edition), or 10g on each client machine.
  • Install the GIS software on each client machine.
  • Install Bentley OpenUtilities Designer on each client machine. This is an automated process handled by the installation wizard (see “Installing Bentley OpenUtilities Designer” ).

Loading the Bentley OpenUtilities Designer Tables

The Database folder on the distribution CD includes an Oracle .dmp file. This file must be loaded in the appropriate Oracle instance by the administrator or another user familiar with Oracle DBA concepts.

To load the dump file:

  • In the Database folder, edit the batch file update_db.bat by changing the password and instance name for the "sys" user for the database (in 5 places).
  • Add the any new Bentley OpenUtilities Designer users to the file edusers.sql (full instructions are provided in the file header).
    Note: Ignore this step if the database already has the required users.
  • Edit the file update_report_path.sql and put it in the directory or UNC for where the reports are located. If this is a UNC, then the directory needs to be shared.
  • Make sure there is no active user session on the database instance to which the dump file is to be imported.
  • Run the batch file update_db.bat.

Installing Bentley OpenUtilities Designer

Bentley OpenUtilities Designer is installed by running the installation wizard, which launches automatically from the distribution CD. The installer first determines whether Bentley OpenUtilities Designer is already installed on the machine. If not, it provides installation and setup options for a new installation. If Bentley OpenUtilities Designer already resides on the machine, the installer offers three options: Upgrade, Repair, or Uninstall.

Installation
Database Replication Installation
Setting Up Oracle Spatial 2-tier
Setting up SQL Server Spatial
User Management
Report Management
Unit Rule Management
Miscellaneous Tasks
Configuration Assistant
Job Scheduler
Parent topic: Bentley OpenUtilities Designer CONNECT Edition Help