Download - Schem SPI Installation Guide

SmartPlant Instrumentation Installation and Upgrade Guide

Version 2009 SP4 (9.0.4)

October 2009/June 2012

DSPI2-PE-200001A-Updated

Copyright

Copyright 1995-2012 Intergraph Corporation. All Rights Reserved.

Including software, file formats, and audiovisual displays; may be used pursuant to applicable software license agreement; contains confidential and proprietary information of Intergraph and/or third parties which is protected by copyright law, trade secret law, and international treaty, and may not be provided or otherwise made available without proper authorization from Intergraph Corporation.

U.S. Government Restricted Rights Legend

Use, duplication, or disclosure by the government is subject to restrictions as set forth below. For civilian agencies: This was developed at private expense and is "restricted computer software" submitted with restricted rights in accordance with subparagraphs (a) through (d) of the Commercial Computer Software - Restricted Rights clause at 52.227-19 of the Federal Acquisition Regulations ("FAR") and its successors, and is unpublished and all rights are reserved under the copyright laws of the United States. For units of the Department of Defense ("DoD"): This is "commercial computer software" as defined at DFARS 252.227-7014 and the rights of the Government are as specified at DFARS 227.7202-3.

Unpublished - rights reserved under the copyright laws of the United States.

Intergraph Corporation P.O. Box 240000 Huntsville, AL 35813

Terms of Use

Use of this software product is subject to the End User License Agreement ("EULA") delivered with this software product unless the licensee has a valid signed license for this software product with Intergraph Corporation. If the licensee has a valid signed license for this software product with Intergraph Corporation, the valid signed license shall take precedence and govern the use of this software product. Subject to the terms contained within the applicable license agreement, Intergraph Corporation gives licensee permission to print a reasonable number of copies of the documentation as defined in the applicable license agreement and delivered with the software product for licensee's internal, non-commercial use. The documentation may not be printed for resale or redistribution.

Warranties and Liabilities

All warranties given by Intergraph Corporation about equipment or software are set forth in the EULA provided with the software or applicable license for the software product signed by Intergraph Corporation, and nothing stated in, or implied by, this document or its contents shall be considered or deemed a modification or amendment of such warranties. Intergraph believes the information in this publication is accurate as of its publication date.

The information and the software discussed in this document are subject to change without notice and are subject to applicable technical product descriptions. Intergraph Corporation is not responsible for any error that may appear in this document.

The software discussed in this document is furnished under a license and may be used or copied only in accordance with the terms of this license. No responsibility is assumed by Intergraph for the use or reliability of software on equipment that is not supplied by Intergraph or its affiliated companies. THE USER OF THE SOFTWARE IS EXPECTED TO MAKE THE FINAL EVALUATION AS TO THE USEFULNESS OF THE SOFTWARE IN HIS OWN ENVIRONMENT.

Intergraph is not responsible for the accuracy of delivered data including, but not limited to, catalog, reference and symbol data. Users should verify for themselves that the data is accurate and suitable for their project work.

Trademarks

Intergraph, the Intergraph logo, PDS, SmartPlant, SmartMarine, FrameWorks, I-Convert, I-Export, I-Sketch, IntelliShip, INtools, ISOGEN, MARIAN, SmartSketch, SPOOLGEN, SupportManager, and SupportModeler are trademarks or registered trademarks of Intergraph Corporation or its subsidiaries in the United States and other countries. Microsoft and Windows are registered trademarks of Microsoft Corporation. MicroStation is a registered trademark of Bentley Systems, Inc. Other brands and product names are trademarks of their respective owners.

SmartPlant Instrumentation Installation and Upgrade Guide 3

Contents Preface .......................................................................................................................................................... 7

Installing the Software for SmartPlant Instrumentation .......................................................................... 9

SmartPlant Instrumentation Program Group .......................................................................................... 9

Pre-Installation Requirements ................................................................................................................. 11

Upgrading the NamingConventionsMap.xml File ................................................................................. 12

Internationalization .................................................................................................................................... 15

Hardware and Software Recommendations ........................................................................................... 17

SmartPlant Instrumentation Database Server ...................................................................................... 17 SmartPlant Instrumentation Workstation .............................................................................................. 18 SmartPlant Instrumentation Standalone ............................................................................................... 20

List of SmartPlant Instrumentation Components .................................................................................. 23

Installing SmartPlant Instrumentation .................................................................................................... 25

Installation Checklist ............................................................................................................................. 25 Uninstall a Previous Version of SmartPlant Instrumentation ................................................................ 25 Installation Prerequisite for Vista .......................................................................................................... 26 Install a SmartPlant Instrumentation Service Pack ............................................................................... 26

Oracle Installation and Configuration ..................................................................................................... 29

Oracle Installation Workflow ................................................................................................................. 29 Installing Oracle Database Server ........................................................................................................ 30

Install Oracle Database Server ...................................................................................................... 30 Create an Oracle Listener ..................................................................................................................... 30 Creating an Oracle Instance ................................................................................................................. 30

Requirements for Oracle Instance Creation ................................................................................... 31 Create a New Oracle Instance ....................................................................................................... 32

Oracle System User Requirements ...................................................................................................... 34 Installing Oracle Client .......................................................................................................................... 36

Installing Oracle Client Prerequisites ............................................................................................. 36 Install Oracle Client ........................................................................................................................ 36

Check the Connection to Your Oracle Database Server ...................................................................... 37

Installing SmartPlant Instrumentation on Oracle ................................................................................... 39

Install New Version of SmartPlant Instrumentation on an Oracle Platform .......................................... 40 Flowchart for Standard Installation on Oracle ................................................................................ 42

Installing SmartPlant Instrumentation Over a Previous Installation ...................................................... 43 Install SmartPlant Instrumentation for Oracle Over a Previous Installation ................................... 43 Flowchart for Overwrite Installation on Oracle ............................................................................... 46

Contents

4 SmartPlant Instrumentation Installation and Upgrade Guide

Microsoft SQL Server Installation and Configuration ........................................................................... 49

Install SQL Server 2005 ........................................................................................................................ 50 Install SQL Server 2008 ........................................................................................................................ 50 Configure SQL Server Database Server .............................................................................................. 52 Set Database Maintenance Options for SQL Server ............................................................................ 53 Run DBCC Utility Options for SQL Server ............................................................................................ 54 Update Statistics for SQL Server .......................................................................................................... 54 Installing SQL Server Client .................................................................................................................. 54

Install SQL Server Client ................................................................................................................ 55

Installing SmartPlant Instrumentation on Microsoft SQL Server ......................................................... 59

Install New Version of SmartPlant Instrumentation on a SQL Server Platform .................................... 60 Flowchart for Standard Installation on SQL Server .............................................................................. 63 Installing SmartPlant Instrumentation Over a Previous Installation ...................................................... 64

Install SmartPlant Instrumentation for SQL Server Over a Previous Installation ........................... 64 Flowchart for Overwrite Installation on SQL Server ....................................................................... 67

Check the Connection to Your SQL Server Database Server .............................................................. 68

Installing SmartPlant Instrumentation Stand-Alone for Sybase........................................................... 69

Running Setup for SmartPlant Instrumentation Stand-Alone for Sybase ............................................. 70 Install New Version of SmartPlant Instrumentation on a Stand-Alone Machine ............................ 70 Flowchart for Standard Installation on Sybase Adaptive Server Anywhere ................................... 72

Installing SmartPlant Instrumentation Over a Previous Installation ...................................................... 73 Install SmartPlant Instrumentation Stand-Alone Over a Previous Installation ............................... 73 Flowchart for Overwrite Installation on Sybase Adaptive Server Anywhere .................................. 76

Installing SmartPlant Instrumentation in Silent Mode ........................................................................... 77

Install SmartPlant Instrumentation in Silent Mode ................................................................................ 77

Installing the Enhanced Report Utility .................................................................................................... 81

Install MDAC Driver .............................................................................................................................. 81 Install Enhanced Report Utility .............................................................................................................. 81

Working in Thin Client Mode .................................................................................................................... 83

Tuning the Software for Use in Thin Client Mode ................................................................................. 83 Publish the SmartPlant Application using Citrix Presentation Server ................................................... 84 Configure Citrix Presentation Server 4.5 .............................................................................................. 85 Publish the SmartPlant Application using XenApp ............................................................................... 86 Create Individual Intools.ini Files for New Users .................................................................................. 96 Create the MKIntools.cmd File .............................................................................................................. 97 Modify the Registry Path Key ................................................................................................................ 97 Tune Citrix for Seamless Mode ............................................................................................................. 98 Terminal Server Logon Sequence ........................................................................................................ 99

Working with SmartPlant Integration .................................................................................................... 101

Preparing the Integrated Environment ................................................................................................ 102 Install SmartPlant Schema Component ....................................................................................... 102 Install SmartPlant Client ............................................................................................................... 104

Updating SmartPlant Information in Title Blocks ................................................................................ 104

Contents


Title Block Requirements for Integration Reports ........................................................................ 105 PowerSoft Reports ....................................................................................................................... 105 Enhanced Reports ........................................................................................................................ 106 Install the Update Title Block Component for SmartPlant Instrumentation .................................. 107 Create a New Local Printer Port (64-bit server only) ................................................................... 107

Installing SmartPlant Instrumentation Add-In Software Programs .................................................... 109

External Editor Installation .................................................................................................................. 109 Hardware Recommendations ............................................................................................................. 109 External Editor Installation Common Tasks ........................................................................................ 109

Install External Editor from the SmartPlant Instrumentation CD .................................................. 110 Uninstall External Editor ............................................................................................................... 110

Modifying the SmartPlant Instrumentation Installation ....................................................................... 111

Modify the Component Selection ........................................................................................................ 111 Repair Installed Components .............................................................................................................. 111 Remove SmartPlant Instrumentation .................................................................................................. 112

Upgrading SmartPlant Instrumentation ................................................................................................ 113

Prerequisites for Upgrading to Version 2009 ...................................................................................... 113 General Prerequisites ................................................................................................................... 113 Specific Prerequisites ................................................................................................................... 115

Upgrading on Oracle ........................................................................................................................... 116 Workflow for Upgrade of SmartPlant Instrumentation on an Oracle Platform .............................. 116

Upgrading on SQL Server ................................................................................................................... 117 Workflow for Upgrade of SmartPlant Instrumentation on a SQL Server Platform ....................... 117

Upgrading on Sybase Adaptive Server Anywhere .............................................................................. 118 Workflow for Upgrade of SmartPlant Instrumentation on Sybase Adaptive Server Anywhere ...................................................................................................................................... 118

Database Upgrade .............................................................................................................................. 119 Upgrade the Database ................................................................................................................. 119 Upgrade Domain Schemas .......................................................................................................... 120 Batch Upgrade .............................................................................................................................. 121

Post-Upgrade Tasks ........................................................................................................................... 121 Update Custom Title Blocks After Version Upgrade .................................................................... 121 Regenerate SmartLoop Drawings Using an Alternative Method.................................................. 122 Upgrade Calibration Results ........................................................................................................ 122 Update Link Definitions for Importing Data into the PANEL Table ............................................... 124 Update Customized Symbols ....................................................................................................... 124 Perform a Database Check .......................................................................................................... 125 Rebuild Default Views .................................................................................................................. 125 Update Custom Views .................................................................................................................. 125 Rebuild Projects in a Domain on Sybase Adaptive Server Anywhere ......................................... 126 Update Process Data ................................................................................................................... 126 Move Power Distribution Boards .................................................................................................. 126

Index ......................................................................................................................................................... 127


This document is the installation and upgrade guide for SmartPlant Instrumentation.

Intergraph gives you permission to print as many copies of this document as you need for non-commercial use at your company. You cannot print this document for resale or redistribution outside your company.

Preface


S E C T I O N 1

This section describes how to set up your database and install SmartPlant Instrumentation and supporting software. Before you begin installing the software, verify that the computers on which the software components will be installed meet the requirements described in Hardware and Software Recommendations (on page 17).

If you are working with IDEAL, you must install SmartPlant Instrumentation Server, which requires a special serial number. For installation details, see the SmartPlant Instrumentation Server and IDEAL Installation and Configuration Guide.

Third Party Software Installation

Third party software such as CAD package and report generator such as InfoMaker can be installed at any location on the network or local stations. The drives (local or network mapped) on which these packages are installed require read/write access for the stations that are configured to use them.

The driver used for printing the PDF files, SmartPlant PDF Converter 4.51, is included in the SmartPlant Instrumentation installation. This printer is used for PDF generation and should not be removed or used for any other purpose.

If you are running SmartPlant Instrumentation on a Windows XP 64-bit machine, you must manually register CDINTF400.dll by running the following command: regsvr32 c:\windows\syswow64\CDINTF400.dll.

SmartPlant Instrumentation Program Group SmartPlant Instrumentation provides multiple views of a central, unified data structure that represents the plant model. A view is a visual presentation of the data in the plant model and can be a schematic drawing or a table. The plant model is the computer representation of the conceptual design, including all plant components and their relationships. By manipulating model views, you can organize the information within the plant model to better understand and maintain the data.

SmartPlant Instrumentation has several programs and utilities for running and managing your plant data.

SmartPlant Instrumentation provides an environment that allows you to design and maintain every stage in the life-cycle of plant engineering systems, from construction, through maintenance and modernization, to de-commissioning.

Administration Module provides you with administrative tools for keeping track of your resources and maintaining user access security.

DB Setup Utility allows you to create an initial SmartPlant Instrumentation database.

Installing the Software for SmartPlant Instrumentation

Installing the Software for SmartPlant Instrumentation


Import Utility allows you to import data from most common database formats into a selected table or module in the SmartPlant Instrumentation database.

Internal Setup Utility is for the use of System Administrators to troubleshoot and fix database problems in SmartPlant Instrumentation without the need to log on to SmartPlant Instrumentation.

Merger Utility provides you with the means of transferring a selected plant hierarchy item (for example, domain, plant, and so forth) from a source domain to the same type of plant hierarchy item in an existing target domain.

SmartPlant Instrumentation Rule Manager is an environment used for creating, manipulating, and managing sets of consistency rules that apply whenever a user associates two items or modifies properties of a certain item in SmartPlant Instrumentation. Rule manager also creates GUI rules that allow a user control over every field in every item's 'Properties' dialog box. These rules determine how items act and interact within a project. Usually, you create a set of rules at the beginning of a project.

In addition to the main application, a number of add-on utilities are available as separate installations.

Enhanced Report Utility allows you to generate graphical reports for items such as loops, cables, and terminal strips using a generic engine that draws various wiring objects based on database query retrieval.

Symbol Editor allows you to customize symbols to fit your own design conventions specifically for Layout reports and for Enhanced SmartLoop drawings that use the Custom by Loop or Custom by Signal generation methods.

Intergraph IDEAL API is a set of components that are used to generate reports containing SmartPlant Instrumentation data. IDEAL enables you to retrieve data and display it in a Web browser in a format appropriate for the report type.

DDP Export Utility allows you to specify parameters needed to create a data file that is used to export dimensional data from SmartPlant Instrumentation to Plant Design System (PDS).

External Editor allows you to view and modify external instrument specification sheets (.psr and .isf files).

Process Data Editor allows you to view and modify external process data sheets (.ipd files).

SAP Export Utility allows you to specify parameters needed to create a data file that is used to export data from SmartPlant Instrumentation to SAP.


S E C T I O N 2

The Setup Utility allows you to install required and optional components, such as SmartPlant Instrumentation modules (for example, Administration, Instrument Index, Wiring), Import and Merger utilities, documentation files, and so forth. You can install all or only some of the components, depending on the amount of free space available on your hard disk, and your engineering needs. For details of components that are required for working with SmartPlant Instrumentation, see List of SmartPlant Instrumentation Components (on page 23).

You run Setup when:

Installing a new version of SmartPlant Instrumentation.

Upgrading an existing SmartPlant Instrumentation installation.

Adding selected SmartPlant Instrumentation components to an existing installation.

If you add any components to an existing installation, make sure that the version of the components you install is the same as the version of the existing installation.

If you upgrade your current software version, it is recommended that you backup your current database before you start the actual installation process.

For details of how to back up an entire Oracle or SQL Server database, you need to use Oracle or SQL Server tools. For details, see SmartPlant Instrumentation Configuration and Maintenance Guide, Backup and Restore. If you have System Administrator database access rights, you can also back up your database by selecting to save a copy of your existing database during the setup procedure.

When you install SmartPlant Instrumentation you need to determine the appropriate access rights for each user (regular users, Domain Administrators and the System Administrator). For details, see the Administration User's Guide, Access Rights.

You install SmartPlant Instrumentation either on the computer where you installed the database server (file server) or on the local station. The following are some of the environment characteristics that you should consider when deciding where to install SmartPlant Instrumentation:

Free disk space The computer where you install SmartPlant Instrumentation should have free disk space sufficient for the installation.

Network performance Most databases operate on local networks. Therefore, the local network data transfer rate significantly influences the overall performance of the database platform and SmartPlant Instrumentation. For this reason, if the local network under-performs, install SmartPlant Instrumentation on the local station to be able to work faster with SmartPlant Instrumentation features.

SmartPlant Instrumentation components upgrade You should consider the amount of work involved in upgrading or re-installing all the copies of SmartPlant Instrumentation on the local network, in case you install SmartPlant Instrumentation on the stations.

Before you start the installation process, make sure that your computer (file server or local station) has access to a CD-ROM or DVD drive. If your machine does not have access to a suitable drive, you need to copy all the installation files from the installation media to your local hard disk.

If you are upgrading from an existing installation, make sure that all components of the software are inactive before starting the Setup process.

Pre-Installation Requirements



Upgrading the NamingConventionsMap.xml File A new NamingConventionMap.xml that handles conventional instruments and other instrument classes such as Soft Tags, Fieldbus and so forth, is included with the SmartPlant Instrumentation Service Pack 1 installation. Installing Service Pack 1 over SmartPlant instrumentation 2009 overwrites the existing NamingConventionMap.xml with the new one. If you have customized the NamingConventionMap.xml in SmartPlant Instrumentation 2009 or earlier, and want to save these customizations for use with Service Pack 1, do the following:

1. Locate the NamingConventionMap.xml, found in the SmartPlant Instrumentation home folder > XML folder, or in the location defined in the Domain Definition.

2. Change the .xml file name to NamingConventionMapOLD.xml.

3. Install the service pack.

4. In the XML folder, right-click on the NamingConventionMapOLD.xml file and on the shortcut menu, click Edit.

5. Right-click on the NamingConventionMap.xml file and on the shortcut menu, click Edit.

6. In the NamingConventionMapOLD.xml under the tag, locate the tags.

7. Select and highlight the tags and text between the tags, for example;

8. Right-click and from the shortcut menu, select Copy.

9. In the NamingConventionMap.xml file, highlight the tags and text between the tags, right-click and from the shortcut menu select Paste.

10. Repeat this procedure with the and the tags.

11. In the NamingConventionMap.xml file, highlight the text and tags that appear between the tags, for example;



B_InterfaceDefUID="INamedInstrument"

B_PropertyDefUID="InstrFuncModifier"/>

12. Right-click, and from the shortcut menu, select Copy.

13. Paste the copied tags and text between the remaining classes of instrument tags, for example , , overwriting the existing tags.

14. Save the.xml file.

15. Open the SmartPlant Instrumentation Administration module and in the Naming Conventions dialog box, check that the naming conventions in the NamingConventionMap.xml file match the naming conventions for each instrument class.

16. Close the NamingConventionMap.xml file.

If there any problems you should return to the NamingConventionMap.xml file and manually edit the appropriate tags.


S E C T I O N 3

Supporting internationalization in a homogeneous environment is one of the enhancements available in SmartPlant Enterprise. A homogeneous environment uses elements from only a single locale. For example, a German customer running on a German operating system using only German characters and German cultural conventions is a fully supported homogeneous environment configuration.

Homogeneous Environments

When starting a new project, use extra care during installation and configuration to ensure the proper creation and maintenance of homogeneous environments:

All the computers (servers and clients) within an integrated SmartPlant Enterprise implementation must have the same regional settings, and no one should change the regional settings after the project has started.

Do not cross the decimal locale boundary. This is the most common cause of numeric data corruption and calculation errors. Having users with different regional settings (like with a period versus a comma for the decimal point) causes the software to interpret values unpredictably. For example, a motor with a rated power of 10.5 kW can be read by the software as 105 kW to the user with different regional settings. A cable length defined as 39 ft. 11,21 inches has been interpreted as 121718910971323 meters when published to an XML file. These incorrect interpretations may be used in internal software calculations and can be impossible to backtrack or correct. Do not change the decimal point character to try to solve an issue. Doing so will only corrupt values in the database or in text files.

Do not cross the character-set locale boundary. For example, the character set boundary between Western (Latin-based) and Eastern Europe (Cyrillic-based), or between Eastern Europe and Japan.

Create Microsoft SQL Server databases with locale-specific collation settings and ensure that all databases have the same setting.

Heterogeneous Environments

In contrast, a heterogeneous environment using elements from different, or even multiple locales, is not supported. Many customers are currently operating in unsupported heterogeneous environments and are often not aware of that fact. Examples of heterogeneous environments:

Entering or viewing Japanese data on an US/English operating system

Using German Regional Settings (where the decimal point is a comma) on a US/English operating system

Using databases with different character encodings such as CL8MSWIN1251 or JA16SJIS

Using multiple languages in a project, especially when crossing language-group boundaries

Using an English server with different local language clients

International / Bi-lingual Projects

International bi-lingual projects are possible; however, great care must be used when configuring these environments. Limitations exist and must be properly understood:

Internationalization

Internationalization


Oracle and MS SQL Server databases can reside on any language operating system, as long as the databases have been created and configured with proper Unicode and collation settings.

All Microsoft operating systems (Japanese, Russian, German, and so forth) can enter English characters. The reverse, however, is not true in most cases.

Keyboard-locale can be changed as long as a character-set and code- page boundary is not crossed. For example, English, German, French, and Spanish characters can all be used in the same project because the same Windows code-page (1252) is used. However, Russian characters (code-page 1251) cannot be used in a US/English environment.

You must decide which language operating system will be the master for bi-lingual projects.

The following is an example of a Russian-based project:

Companies in the United States and the United Kingdom are working a project with a Russian company and the deliverables (drawings, reports, and so forth) must ultimately be provided in Russian. The companies in the U.S. and the U.K. are working the project using the "master" Russian operating systems (possibly using virtual Russian operating systems running on VMware Workstation). The U.S. and U.K. companies can install and use English Microsoft Office products on the Russian operating system because Office products are globally enabled. If a Russian interface exists for the SmartPlant Enterprise application, then Russian users can use the Russian interface while the English-speaking users would continue to use the US/English interface. English-speaking engineers can enter English characters. Russian-speaking engineers can enter Russian characters.

However, because the Russian locale uses different decimal and character-set locales, everyone (English and Russian engineers) must use the Russian decimal symbol which is a comma. For customization purposes, databases can be modified to accommodate new Russian-specific requirements (fields, properties, and so forth.) Using filters, display sets, and other software features, bi-lingual projects can be further customized. Graphic data, reports, and so forth can be created in either or both languages.

Do not change regional settings to reflect a U.S. environment in order to resolve problems in a non-US/English homogeneous configuration. Doing this creates a heterogeneous configuration that will cause other possibly hidden problems that cannot be corrected. Everyone working on a project must use the same regional settings and character set throughout the life of the project.

Questions and Assistance

Please contact your support representative for assistance.


S E C T I O N 4

Before beginning an installation of SmartPlant Instrumentation, verify that your servers and end-user workstation computers meet the following hardware recommendations and software requirements.

The SmartPlant Instrumentation database management server installation was certified on 64-bit hardware with a 64-bit operating system and 32-bit database software. The client machine installation was certified on 64-bit hardware with a 32-bit operating system and 32-bit database software for SmartPlant Instrumentation.

The SmartPlant Instrumentation software cannot work with SQL Server 64-bit client because it is a 32-bit application. The software works with SQL Server 32-bit client, which can then work with SQL Server 64-bit server.

If you are running SmartPlant Instrumentation on a Windows XP 64-bit machine, you must manually register CDINTF400.dll by running the following command: regsvr32 c:\windows\syswow64\CDINTF400.dll.

SmartPlant Instrumentation Database Server

Hardware Recommendations

Pentium machine with 2.4 GHz processor (for Oracle), Xeon machine with 2 GHz processor or higher (for SQL Server)

2 GB RAM (or more for a large database)

100 BaseT or higher network interface (1 Gbit recommended)

Digital tape or DVD backup system for server

For all installations, DVD drive access, either locally or through a network connection

Supported Operating Systems

Windows 2003 R2 32-bit - SP2, Standard & Enterprise

Windows 2003 R2 64-bit - SP2, Standard & Enterprise

Windows Server 2008 R2 64-bit - Standard & Enterprise

The operating system must be installed in the account where you have administrator privileges.

Supported Database Servers

Microsoft SQL Server 2005 Service Pack 4

Microsoft SQL Server 2008 Service Pack 2 (supported in SmartPlant Instrumentation 2009 Service Pack 3 and above)

Oracle Database 10g Release 2 (10.2.0.5) Standard and Enterprise editions

Hardware and Software Recommendations



Recommended Disk Space

Oracle 10g Software SQL Server 2005 Software SQL Server 2008 Software SmartPlant Instrumentation Software

Oracle Server installation

2 GB SQL Server 2005 installation

1 GB SQL Server 2008 installation

4 GB Initial SmartPlant Instrumentation database

200 MB

Initial Oracle instance

500 MB SQL Server temporary database

100 MB SQL Server temporary database

100 MB SmartPlant Instrumentation data files (5000 loops with wiring)

500 MB

Total: 2.5 GB Total: 1.1 GB Total: 4.1 GB Total: 0.7 GB

Software Prerequisites

Adobe Reader 9.x (required for viewing the Software License Agreement and Printable Guides). The latest version is available from the Adobe Web site.

Microsoft Data Access Components (MDAC) 2.8 Service Pack 1 or later service pack of MDAC 2.8 if installed with the operating system. For more information, see Install MDAC Driver (on page 81)

Microsoft .NET Framework 3.5 Service Pack 1

Windows Installer 4.5 (for SQL Server 2008)

MDAC and Microsoft .NET Framework are delivered as part of Microsoft Windows Server installation.

SmartPlant Instrumentation Workstation


Pentium IV with 3 GHz processor or Pentium dual core with 2 GHz processor or higher

2 GB RAM or higher


For SmartPlant Enterprise installation, DVD drive access, either locally or through a network connection

For SmartPlant Instrumentation installation, CD-ROM drive access, either locally or through a network connection

Windows supported printer access, either locally or through a network connection


Microsoft Windows XP Professional Service Pack 3, 32-bit

Microsoft Vista Business Client 1.0 Service Pack 2, 32-bit

Microsoft Windows 7 Professional and Enterprise, 32-bit and 64-bit

The operating system must be installed in an account where you have administrator privileges.

Windows 7 is certified with UAC On at Level 3 (Default).



Supported Database Clients

Microsoft SQL Server Client 2005 Service Pack 4

Microsoft SQL Server Client 2008 R1 Service Pack 2 64-bit (supported in SmartPlant Instrumentation 2009 Service Pack 3 and above)

Oracle 10g Client Release 2 (10.2.0.5) 32-bit

The client database software must be of the same version as the server database software.

Only 32-bit installations are supported.


Oracle 10g Software SQL Server 2005 Software SQL Server 2008 Software SmartPlant Instrumentation Software

Oracle Client installation

1 GB SQL Server 2005 Client installation

100 MB SQL Server 2008 Client installation

2 GB SmartPlant Instrumentation application (full installation)

1.6 GB

Enhanced Report Utility

210 MB

Total: 1 GB Total: 0.1 GB Total: 2 GB Total: 1.8 GB



Microsoft XML Core Services (MSXML) 6.0 Service Pack 1

Microsoft Office 2003, 2007, or 2010 (Microsoft Excel is required for working with report templates and for viewing the Installation Checklist and various other files).

Microsoft Data Access Components (MDAC) 2.8 Service Pack 1 or later service pack of MDAC 2.8 if installed with the operating system. For more information, see Install MDAC Driver (on page 81).


MDAC and Microsoft .NET Framework are delivered as part of Microsoft Windows XP and Vista installations.

Optional Software

Apart from SmartSketch, the following software programs are not Intergraph corporation software and are owned by third parties. It is the responsibility of the customer to select in its sole discretion the applicable third party software customer desires to use to generate reports and Intergraph makes no recommendation as to the choice of said third party software. Customer is responsible for obtaining a valid license to use said third party software from the owner of said third party software and to pay any license fees to the owner of said third party software for the use of said third party software. INTERGRAPH DISCLAIMS AND MAKES NO WARRANTY EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY OR THE WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE IN REGARDS TO SAID THIRD PARTY SOFTWARE.

One of the following drawing software programs, if needed for loop drawings:

SmartSketch 2009.x or similar graphical editor (required for editing border template files and for symbol creation)



Autodesk AutoCAD version 2010 or higher. For compatibility with other versions, see the Version Compatibility section of the Readme.htm file in the SmartPlant Instrumentation folder

Bentley MicroStation J (not certified on Vista, Windows 7, or on a 64-bit machine)

InfoMaker 11 Service Pack 2 (report generator / export data functionality software)

For working in a Citrix environment, Citrix Presentation Server 4.5 or XenApp 6.

SmartPlant Instrumentation Standalone These requirements apply when you are running the software in single-user standalone mode on a Sybase Adaptive Server Anywhere database.

Prior to installing SmartPlant Instrumentation on a Sybase Adaptive Server Anywhere database, you must purchase an appropriate Sybase license.


Pentium IV with 3 GHz processor or Pentium dual core with 2 GHz processor or higher

2 GB RAM or higher


CD-ROM drive access, either locally or through a network connection

Windows supported printer access, either locally or through a network connection


Microsoft Windows XP Professional Service Pack 3, 32-bit

Microsoft Vista Business Client 1.0 Service Pack 2, 32-bit

Microsoft Windows 7 Professional and Enterprise, 32-bit and 64-bit

The operating system must be installed in an account where you have administrator privileges.

Windows 7 is certified with UAC On at Level 3 (Default).

Supported Database

Sybase Adaptive Server Anywhere 10.1


SmartPlant Instrumentation 2009 application (full installation) 1.6 GB

Enhanced Report Utility 210 MB



Microsoft Office 2003, 2007, or 2010 (Microsoft Excel is required for working with report templates and for viewing the Installation Checklist and various other files).




Optional Software

Apart from SmartSketch, the following software programs are not Intergraph corporation software and are owned by third parties. It is the responsibility of the customer to select in its sole discretion the applicable third party software customer desires to use to generate reports and Intergraph makes no recommendation as to the choice of said third party software. Customer is responsible for obtaining a valid license to use said third party software from the owner of said third party software and to pay any license fees to the owner of said third party software for the use of said third party software. INTERGRAPH DISCLAIMS AND MAKES NO WARRANTY EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY OR THE WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE IN REGARDS TO SAID THIRD PARTY SOFTWARE.

One of the following drawing software programs, if needed for loop drawings:

SmartSketch 2009.x or similar graphical editor (required for editing border template files and for symbol creation)

Autodesk AutoCAD version 2010 or higher. For compatibility with other versions, see the Version Compatibility section of the Readme.htm file in the SmartPlant Instrumentation folder

Bentley MicroStation J (not certified on Vista, Windows 7, or on a 64-bit machine)

InfoMaker 11 Service Pack 2 (report generator / export data functionality software)


S E C T I O N 5

The table below lists and describes the components you need to install to be able to work with SmartPlant Instrumentation. This table also describes optional components that you can install. You need an appropriate license to install some of these optional components.

Component Details Required or Optional License-Dependent

Notes

Program Files Common Files Required

Deployment Kit Required

Internal Setup Utility

Optional

Admin Module Administration module files

Required (see Notes) For the Admin station

Catalog databases

Optional For the Admin station

Demonstration database

Optional For the Admin station

Merger Merger Utility Required (see Notes) For Merger

Import Import Utility Required (see Notes) For Import

Module ODBC Drivers Optional

DBF Samples Optional

Merger Utility Optional

CAD SmartSketch Optional

AutoCAD Optional

MicroStation Optional

DB Setup Database Setup Utility

Required (see Notes) For Oracle and SQL Server Admin station

CAD Sample Block Drawings

AutoCAD Samples

Optional Yes

MicroStation Samples

Optional Yes

Shell Library Optional Yes

List of SmartPlant Instrumentation Components

List of SmartPlant Instrumentation Components


Component Details Required or Optional License-Dependent

Notes

Standard Library

Optional Yes

Loop Blocks Library

Optional Yes

PSR Library Optional

Databases Template Database

Required Selects database software

Catalog Database

Optional

Demo Database

Optional

SmartPlant sample database

Optional

Empty Database

Optional

Enhanced Report Utility

SmartPlant Instrumentation Enhanced Report Utility

Optional See Enhanced Report Utility Installation Guide


S E C T I O N 6

This section describes how to set up your database and install SmartPlant Instrumentation and supporting software. Before you begin installing the software, verify that the computers on which the software components will be installed meet the requirements described in Hardware and Software Recommendations (on page 17).

When installing on Vista or Windows 7 with the User Account Control setting at the default level, you should run setup.exe as an Administrator user, even if you are not logged on as an Administrator. To do this, select setup.exe, right-click and then select the Run as administrator option. If not logged on as an Administrator, you will be prompted for Administrator credentials to allow you to continue the setup.

Installation Checklist For the recommended installation workflow, see the SmartPlant Instrumentation Installation Checklist:

(SPIInstall_Checklist.xls), delivered during product setup to the...\SmartPlant\Instrumentation\ folder.

Uninstall a Previous Version of SmartPlant Instrumentation

1. From the Windows Control Panel, select Add or Remove Programs.

2. Select Intergraph SmartPlant Instrumentation and then click Remove.

To uninstall a previous Service Pack, select the appropriate row in the Currently installed programs list.

3. In the Installation for SmartPlant Instrumentation wizard, on the Welcome page, select Remove and then click Next.

4. At the message prompt to confirm removal of the software, click OK.

5. At the Remove Existing Databases message prompt, click Yes or No as desired.

6. On the Maintenance Complete or Uninstall Complete page, click Finish.

Installing SmartPlant Instrumentation



Installation Prerequisite for Vista This does not apply if you are using Vista with the User Access Control option switched off.

When installing the software on Vista with the User Control option activated, system folders and the files they contain are copied to a user folder path; for example, if you install the files in the ..\SmartPlant\Instrumentation\ folder, they are copied to c:\users\\AppData\Local\VirtualStore\Program Files\SmartPlant\Instrumentation\... The software looks for various parameters in the copied files.

When you later install a service pack, the system does not copy the files again to the user folder unless the user folder is empty, and as a result you will not be prompted to upgrade your database. Therefore, prior to installing a service pack, you must delete the entire folder structure under the VirtualStore folder, with the exception of the Intools.xml file, which you should back up and, after installing the service pack, copy back to the appropriate sub-folder under the user folder.

Install a SmartPlant Instrumentation Service Pack 1. Open your computer's Control Panel.

2. In your installed programs, verify that you have Microsoft .NET Framework 3.5 Service Pack 1 or higher installed. Otherwise, install Microsoft .NET Framework 3.5 Service Pack 1.

3. Unpack the Zip file containing the installation files for the service pack.

4. Double-click Setup.exe.

5. On the Welcome to the InstallShield Wizard for Intergraph SmartPlant Instrumentation page, click Next.

6. On the Setup Options page, click (Service Pack Installation).

You may receive a message that Setup cannot find the software installation on your computer and a prompt to specify the target folder, even though you previously installed a main version of the software. Just click OK to continue.

7. On the Destination Folder page, click Next.

To choose an alternative destination, click Browse and navigate to the desired destination folder, and then click Next.

8. On the Database Installation Options page, do one of the following to determine what to do with your existing databases, such as In_demo.db (demonstration), Intools.db (empty), and Intoolsef.db (for SmartPlant integration):

Keep old databases Select this option to use your existing databases from the previous installation.

Back up old and install new databases Select this option to use new databases and preserve the existing databases if you are upgrading your software version. Setup renames the existing Intools.db to Intools (1).bk, In_demo.db to In_demo (1).bk, and Intoolsef.db to Intoolsef (1).bk, where (1) is the running number for the old database.

Overwrite old databases Select this option to use new databases and delete the existing databases.

If you overwrite your databases, you lose any user-defined data that you have in these files.



9. On the Select Program Folder page, select the program folder where you want Setup to install the program icons, and click Next to begin the installation.

10. On the Setup Complete page, if you want to view the Readme file, select the I would like to view the Readme.htm file check box.

11. Click Finish.


S E C T I O N 7

Because system configurations, database software, and individual company standards vary, use this section as a checklist instead of step-by-step instructions. Consult your Oracle software documentation for information as to which versions of Oracle database can be used with which versions of the Windows operating system.

Please contact Intergraph Customer Support (http://support.intergraph.com) for specific configuration questions.

Oracle Instances

If one server hosts the databases of several products, Intergraph recommends that each product's database be a separate instance, each of which can host multiple plants.

The advantage of placing each product's database its own instance is that only the affected application will be off-line during backup, performance tuning, and other database maintenance activities. Additionally, global tuning parameters that apply to one instance can be tailored to the specific product requirements.

According to Oracle documentation, the only limit to the number of instances you can have on any machine is the availability of resources. However, the number of instances on one database server should be minimized, because each additional instance puts additional load on the server.

Each instance adds redundant tablespaces, rollback segments, background processes, and memory requirements for each SGA (System Global Area). For this reason, you should start by putting the database of one product for several plants into a single instance. Then, when the number of plants increases, or a plant becomes very large, consider separating the database into new instances, adding server memory, or even adding database servers.

We recommend installing and configuring Oracle locally, not by remote desktop connection.

Oracle recommends that database activity on the database server consume no more than 50 percent of the available memory.

Oracle Installation Workflow The following workflow is necessary for installing Oracle for use with SmartPlant Instrumentation.

Depending on which version of Oracle you are using and on the operating system installed on your machine there may be differences in the required workflow. Consult your Oracle software documentation for information as to which versions of Oracle database can be used with which versions of the Windows operating system.

Please contact Intergraph Customer Support (http://support.intergraph.com) for specific configuration questions.

Installing Oracle Database Server (on page 30)

Create an Oracle Listener (on page 30)

Creating an Oracle Instance (on page 30)

Installing Oracle Client (on page 36)

Oracle Installation and Configuration



Installing Oracle Database Server The following editions of Oracle Database Server are available:

Standard Edition For department or workgroup level applications, or for small-to-medium sized enterprises (SMEs). It is engineered to provide core relational database management services and options. If you select this installation type, you must purchase additional licenses if you want to install extra Enterprise Edition options.

Enterprise Edition For enterprise-level applications. It is engineered for mission-critical, high-security online transaction processing (OLTP) and data warehousing environments. If you select this installation type, all separately licensable Enterprise Edition options are installed.

Personal Edition Not supported by SmartPlant Instrumentation.

You should refer to your Oracle Installation Guide for detailed instructions on installing Oracle.

Install Oracle Database Server 1. Double-click the Oracle setup icon..

2. On the Select Installation Method page, click Basic Installation, and from the Installation Type list, select the required installation.

Do not select Personal Edition. SmartPlant Instrumentation does not support this installation type.

3. Clear the Create Starter Database check box and then click Next.

4. On the Product-Specific Prerequisite Checks page, ignore the Checking Network Configuration requirements warning and click Next.

5. On the Warning dialog box, click Yes.

6. On the Summary page, click Install.

7. Complete the installation and then click Exit.

8. Restart the server machine.

9. Install the latest Oracle patch.

Create an Oracle Listener 1. On the Start menu, click All Programs > Oracle OraDb10g_home1 > Configuration and

Migration Tools > Net Configuration Assistant.

2. In the Oracle New Configuration Assistant Wizard, select Listener configuration and click Next.

3. Select Add, and click Next.

4. Define the listener name, for example, LISTENER and click Next.

5. On the Listener Configuration, Select Protocols page, select TCP and click Next.

6. On the remaining Wizard pages, click Next and then click Finish to complete the listener creation.

Creating an Oracle Instance The Oracle instance is a workspace on the Oracle database server where Oracle keeps a single database. You can create as many instances as required and, in this way, append as many



databases as you need on a single database server. However, note that appending instances on your Oracle database server can slow down your work in the SmartPlant Instrumentation database located on that server.

You need to create a new instance in Oracle if you have an existing Oracle database server whose parameters do not comply with the parameters required to use SmartPlant Instrumentation on Oracle. This way you can append the SmartPlant Instrumentation database to existing Oracle databases on your Oracle database server without losing your existing Oracle database information.

The instance creation process contains the following major steps:

1. Creating a new instance initialization file from an existing initialization file.

2. Modifying the database parameters in the new instance initialization file.

3. Modifying the Listener.ora file which Oracle will run when carrying out the instance creation process.

4. Creating a new instance using the Database Configuration Assistant.

When creating an instance, Oracle takes-up some disk space. Therefore, you must have enough free disk space on the hard disk where the Oracle database is located to be able to create the new instance. The disk usage is as follows:

Oracle instance environment 50 MB recommended

Oracle instance after running Oracle DB Setup 80 MB recommended

Oracle instance after initializing a domain 150 MB recommended

See your Oracle User Guide for additional information about limitations on creation of instances.

Requirements for Oracle Instance Creation

Before creating an Oracle instance, make sure that you have Administrator's access rights in both your Oracle server database and the operating system installed on the server machine. If you still need to create an instance from the account in which you do not have Administrator's rights, and if your company's policy allows you to change the Oracle security, you can do the following: in the Sqlnet.ora file, add the # symbol before the Sqlnet.Authentication_Services = (NTS) parameter to comment it out. The default location of the Sqlnet.ora file will look similar to the following path:

\\\Product\\db_1\Network\Admin\ (* An example of the 9.0.4 folder name is 10.2.0)

Before starting an Oracle database you need to ensure that the RAM that this database occupies does not exceed the available RAM on your server. You can calculate the amount of RAM needed for the database by using the following Oracle parameters:

SHARED_POOL_SIZE (at least 10 MB)

DB_BLOCK_SIZE

LOG_BUFFER

SORT_AREA_SIZE

JAVA_POOL_SIZE and LARGE_POOL_SIZE are additional parameters that affect the RAM that the Oracle database occupies. These parameters appear if you select certain options when running the Oracle Database Configuration Assistant using a custom installation type.

For the DB_BLOCK_SIZE parameter, make sure that the value is at least 8192. If your SmartPlant Instrumentation database has multiple specifications, we recommend that you use the values 16384 or 32768.

As an alternative to the above calculation, you can use the following target parameters to determine the maximum amount of RAM:



sga_target (at least 100 MB is recommended)

pga_aggregate_target (at least 20 MB is recommended)

Create a New Oracle Instance

Make sure that all passwords, user names, folders, and files of the new instance are different from those of any existing instance.

All user names and passwords must use ASCII / English characters. Oracle does not support non-ASCII / English characters in user names or passwords and will not work. This limitation is an Oracle limitation, not Intergraph's.

1. On the Start menu, click All Programs > Oracle OraDb10g_home1 > Configuration and Migration Tools > Database Configuration Assistant.

2. On the Welcome page, click Next.

3. In the Database Configuration Assistant Wizard, click Next until you reach the page Step 2 of 12: Database Templates.

4. Select Custom Database and click Next.

5. On the page Step 3 of 12: Database Identification, do the following:

a. In the Global Database Name box, define the database name, for example, SPI10gdb.

b. In the SID box, accept or modify the instance name that the software enters automatically as you type the database name.

The database name and the instance name do not have to be the same.

6. Click Next.

7. On the page Step 4 of 12: Management Options, clear Configure the Database with Enterprise Manager, and then, click Next.

8. On the page Step 5 of 12: Database Credentials, in the Password and Confirm Password boxes, type the password, for example, Oracle.

The following terms are reserved and cannot be used as passwords: manager (reserved for the SYSTEM user) and change_on_install (reserved for the SYS user).

9. Click Next until you reach the page Step 7 of 12: Database File Locations, and then do the following:

a. Select Use Common Location for All Database Files.

b. Specify the path and folder, for example, D:\oracle\.

c. Click Next.

10. On the page Step 8 of 12: Recovery Configuration, clear Specify Flash Recovery Data and click Next.

11. On the page Step 9 of 12: Database Content, do the following:

a. On the Database Components tab, clear all the check boxes.

b. Click Standard Database Components, and then, on the Standard Database Components dialog box, clear all the check boxes and click OK.

c. If prompted you to disable local database management, click Yes.

d. On the Custom Scripts tab, click No scripts to run.

e. Click Next.

12. On the page Step 10 of 12: Initialization Parameters, on the Memory tab, do the following:

a. Select Custom.

b. Beside Shared Memory Management, select Automatic.



c. In the SGA Size box, enter 160 M Bytes.

d. In the PGA Size box, enter 60 M Bytes.

The recommended total memory for one Oracle 10g instance is 260 M Bytes.

e. Click the Character Sets tab and do the following:

i. Under Database Character Set, select Use Unicode (AL32UTF8).

ii. Under National Character Set, select AL16UTF16 (the default)

The same database character set and national character set values should also be defined on your server.

The Default Language and Default Date Format values will reflect locale-specific information.

f. Accept the settings on the other tabs and click Next.



13. On the page Step 11 of 12: Database Storage, if you intend to create a SmartPlant Electrical or SmartPlant P&ID database in the current Oracle database, change the data file size of the TEMP and USERS tablespaces to 100 MB.

To change the size, double-click the field under Size.

14. Click Next.

15. On the page Step 12 of 12: Creation Options, click Finish.

16. On the Confirmation dialog box, click OK.

17. Restart the server machine.

Oracle System User Requirements In order to work successfully with SmartPlant Instrumentation, the following minimum Oracle roles and system user privileges need to be defined.

Roles

EXECUTE_CATALOG_ROLE

INTOOLS_ENGINEER with privileges:

CREATE VIEW

CREATE SYNONYM

CREATE SESSION



AUDIT ANY

CREATE TRIGGER

CREATE PROCEDURE

CREATE SEQUENCE

CREATE TABLE

SELECT_CATALOG_ROLE

Sys Admin User Privileges

ALTER SESSION

ALTER USER

ALTER TABLESPACE

ALTER SYSTEM

CREATE ANY VIEW

CREATE ANY TRIGGER

CREATE ANY PROCEDURE

CREATE ANY TABLE

CREATE ANY SYNONYM

CREATE ANY SEQUENCE

CREATE DATABASE LINK

CREATE PUBLIC DATABASE LINK

CREATE PUBLIC SYNONYM

CREATE ROLE

CREATE ROLLBACK SEGMENT

CREATE SESSION

CREATE SYNONYM

CREATE TABLESPACE

CREATE TRIGGER

CREATE USER

CREATE PUBLIC SYNONYM

CREATE SEQUENCE

CREATE TABLE

CREATE SEQUENCE

CREATE VIEW

CREATE CLUSTER

DROP ANY TRIGGER

DROP ANY VIEW

DROP TABLESPACE

DROP USER

DROP ANY TABLE

DROP ANY SYNONYM

EXECUTE ANY PROCEDURE

INSERT ANY TABLE

SELECT ANY DICTIONARY



SELECT ANY TABLE

UNLIMITED TABLESPACE

Installing Oracle Client The Oracle client provides SmartPlant Instrumentation with the means to interface with the Oracle database server. You install the Oracle client after you have completed the Oracle database server installation. You can install the Oracle client either on a file server or on the local station. If you install the Oracle client on a station, make sure you have the appropriate access rights to the Oracle database server.

After the Oracle client installation process is complete, you proceed by installing SmartPlant Instrumentation. Before you start the installation process, make sure that the machine (file server or local station) has access to a CD-ROM or DVD drive. If your machine does not have access to a suitable drive, you need to copy all the installation files from the installation media to your local hard disk.

Installing Oracle Client Prerequisites Make sure that your Oracle server version is 10.2.0.5. For details, see Compatibility of Oracle

and SmartPlant Instrumentation Versions.

Set up your client Windows regional and language options as you require. You can only set up these options before the client installation. If you want to change the regional and language options after the installation, you will have to reinstall the Oracle client for the changes to take effect

After the client installation, you must not change any of the default values of the NLS_LANG parameter on the client.

Install Oracle Client 1. Start the Oracle Universal Installer.

2. On the Select Installation Type page, from the list, select one of the following:

Administrator For users who need Administrator functions, such as the ability to create tablespaces.

Runtime For all other users.

3. On the Specify Home Details page, enter the name of the folder that will appear in the Start menu and the folder path for the installation.

The Start menu folder name is also the name given to the Oracle Home folder in the Registry.

4. Clear the Create Starter Database check box and then click Next.

5. On the Product-Specific Prerequisite Checks page, click Next.

6. On the Summary page, click Install.

7. On completion of the installation, when the Oracle Net Configuration Assistant opens, select the Perform typical configuration check box.

8. On the Welcome page, click Next.

9. On the Oracle Net Configuration Assistant: Done page, click Finish.

10. Complete the installation and then click Exit.

11. Restart the client machine.

12. Create an alias to the Oracle database on the client machine using Oracle Net Manager.



The alias name can contain any alphanumeric characters without spaces. After installing the Oracle client, the alias value appears in the Intools.ini file as a value of the ServerName parameter in the [Database] section.

13. Install the Oracle client 10.2.0.5. patch.

Check the Connection to Your Oracle Database Server It is recommended that you check the connection to the Admin schema of SmartPlant Instrumentation in your database server and make sure that you can establish a reliable connection to the database before running SmartPlant Instrumentation.

1. Click Start > Programs > Intergraph SmartPlant Instrumentation > Internal Setup Utility

.

2. On the menu bar, click File > Database Type Test and Query.

3. On the menu bar, click Actions > Use INI file to load the settings entered by SmartPlant Instrumentation Setup in the [Database] section of the Intools.ini file.

4. On the menu bar, click Actions > Connect .

5. Under Results, make sure the following information appears:

6. Result Code: 0 The number of rows affected: 0 Database vendor's error code: 0 The database vendor's error message. The database-vendor specific: Oracle

If you do not achieve these results, contact Intergraph Support.


S E C T I O N 8

SmartPlant Instrumentation is designed to use data stored in databases to construct and maintain your engineering data and domains. Before installing the multi-user SmartPlant Instrumentation version for Oracle, you need to perform some preliminary procedures such as installing the Oracle database server, Oracle client, and configuring SmartPlant Instrumentation for connection to the database server. To install Oracle, you must have some knowledge of the database installation procedures and basic conventions and features of your Windows environment.

When working on an Oracle platform, you maintain database-user relations by exchanging data with the database. To do this, Oracle maintains a multi-interface system which provides the desired connection along the data transfer path.

The systems described in the above figure can be physically located on the same computer or on different computers which are connected on a local network.

The entire installation process consists of the following major steps:

1. Installing the Oracle database server. You perform this step only if you have not already installed the Oracle database server on your system.

2. Installing the Oracle client and verifying the connection to the Oracle database server. You perform this step only if you have not already installed the appropriate Oracle client on your system.

3. Installing the appropriate SmartPlant Instrumentation components.

4. Connecting to the Oracle database and setting up the SmartPlant Instrumentation database for Oracle (by running the DB Setup Utility).

5. Creating a new SmartPlant Instrumentation domain.

First, you install and configure the database server where SmartPlant Instrumentation will store your data. Then you install the Oracle client through which SmartPlant Instrumentation interfaces with the Oracle database server. If you have already installed Oracle as your database server, you may need to modify your database server settings to adapt Oracle to support the SmartPlant Instrumentation database.

After installing the Oracle database server and the Oracle client, you install SmartPlant Instrumentation and configure the appropriate SmartPlant Instrumentation files. This way you will also be able to use third-party applications such as CAD interfaces.

Installing SmartPlant Instrumentation on Oracle



When Setup finishes installing the selected components, you need to configure SmartPlant Instrumentation to connect and work with Oracle. At this stage, you create the tablespace required for the Admin schema. For details, see the Administration User's Guide, Set Up a SmartPlant Instrumentation Database for Oracle.

The final stage is to initialize a new domain in Oracle and set the initial parameters of the domain. This way you prepare the database for creating the domain plant hierarchy and defining engineering data.

We recommend installing and configuring Oracle locally, not by remote desktop connection.

Ensure that you obtain the appropriate serial number for the desired type of SmartPlant Instrumentation installation (standard installation or special server installation for use with IDEAL).

The media for a multi-user version of SmartPlant Instrumentation only includes the runtime version of Sybase Adaptive Server Anywhere, which cannot be used as a database engine for SmartPlant Instrumentation. If you want to use SmartPlant Instrumentation in a stand-alone mode with Sybase Adaptive Server Anywhere as a database engine, you must obtain the media and a license (serial number) for SmartPlant Instrumentation Stand-Alone for Sybase.

In this document, whenever a string appears in brackets, type the desired value substituting the entire string, including the brackets. For example: instead of , type c:\orawin.

Install New Version of SmartPlant Instrumentation on an Oracle Platform

If you have not already installed and configured SmartPlant License Manager on your workstation, we recommend doing so before installing SmartPlant Instrumentation.

SmartPlant Instrumentation requires the SmartPlant License Manager software for concurrent licensing for both the core SmartPlant Instrumentation product and for each module. This licensing software is delivered on its own media. For more information about using and configuring concurrent licensing, refer to the SmartPlant License Manager Online Help.

1. Insert the SmartPlant Instrumentation product media into the CD-ROM or DVD drive. If the installation does not start automatically, double-click the Setup.exe file in the main folder.

2. Click SmartPlant Instrumentation Installation.


4. On the Customer Information page, type your name, company name, and serial number, and click Next.

If you are working with IDEAL, you must install SmartPlant Instrumentation Server, which requires a special serial number. For installation details, see the SmartPlant Instrumentation Server and IDEAL Installation and Configuration Guide.

The serial number is used for initial installation purposes only. A license key is required to run SmartPlant Instrumentation. For more information, refer to the SmartPlant License Manager Online Help.

5. On the Registration Confirmation dialog box, click Yes.

6. On the License Agreement page, click Display to read the software license agreement in a .pdf file, and then after closing the file, click Yes.



7. On the Database Platform page, select Oracle 10g and click Next.

8. On the Setup Type page, do one of the following:

Click (Full) to install all the SmartPlant Instrumentation components.

Click (Custom) to select and install specific SmartPlant Instrumentation components.

9. On the Destination Folder page, specify the SmartPlant Instrumentation folder location and click Next.

To choose an alternative destination, click Browse and navigate to the desired destination folder, and then click Next.

10. For a custom installation, on the Select Features page, select the desired SmartPlant Instrumentation components, and then click Next. To learn which components are required to work with SmartPlant Instrumentation, see List of SmartPlant Instrumentation Components (on page 23).

11. On the Oracle Server Information page, do the following:

a. In the Server box, type the communication alias name for your Oracle instance.

b. In the Database box, type the Oracle database name.

c. Click Next.

12. On the Select Program Folder page, select the program folder where you want Setup to install the program icons, and click Next.

13. On the Start Copying Files page, view the settings of the current Setup session, and then click Next to start copying the files to your hard disk.

After you click Next, Setup immediately starts copying all the components you selected to the SmartPlant Instrumentation home folder. To undo this operation you will have to uninstall SmartPlant Instrumentation. Therefore, if you need to make any modification to the current Setup selections, click Back before you start copying the files.

14. On the Setup Status page, view the progress of the file transfer.

15. When the file transfer is complete, on the Important Notes page, read the text carefully as it contains important information for the current version, and then click Next.

16. On the Readme dialog box, click Yes if you want to view the Readme file.

We recommend that you choose to view the Readme file, as it contains important information about SmartPlant Instrumentation. You can find this file, Readme.htm, in the SmartPlant Instrumentation home folder or in the root folder of the installation media.

17. On the Setup Complete page, click Yes if you want to restart your computer (before you can use the program you must restart your computer).

18. Click Finish to complete the setup and installation.

The driver used for printing the PDF files, SmartPlant PDF Converter 4.51, is included in the SmartPlant Instrumentation installation. This printer is used for PDF generation and should not be removed or used for any other purpose. If you are unable to generate PDF files because this driver is missing, restore the driver by running the executable file PDFInstall.exe, which is installed by default in the software installation folder path ..\SmartPlant\Instrumentation\.



Flowchart for Standard Installation on Oracle



Installing SmartPlant Instrumentation Over a Previous Installation

If Setup has detected an existing installation, you can install the new SmartPlant Instrumentation files in the existing folder or select another folder.

When installing the new SmartPlant Instrumentation files to the home folder of an existing installation that is prior to Version 2009, Setup does the following:

Overwrites the SmartPlant Instrumentation program files.

Prompts you to overwrite, backup, or keep the existing SmartPlant Instrumentation databases.

Prompts you to overwrite, backup or keep the existing STYLES.PBD file.

Overwrites the SmartPlant Instrumentation data files (sample and library .dwg, .psr, .dbf files, and so forth).

If you want to have several installations of SmartPlant Instrumentation 2009 on one machine, before running this procedure, you must perform a preliminary procedure. For details, see SmartPlant Instrumentation Configuration and Maintenance Guide, Installing Several Versions of SmartPlant Instrumentation on the Same Machine.

Install SmartPlant Instrumentation for Oracle Over a Previous Installation

1. Insert the SmartPlant Instrumentation product media into the CD-ROM or DVD drive. If the installation does not start automatically, double-click the Setup.exe file in the main folder.

2. Click SmartPlant Instrumentation Installation.


4. On the Customer Information page, enter your registration information and click Next.

5. On the Registration Confirmation dialog box, click Yes.

6. On the License Agreement page, click Display to read the software license agreement in a .pdf file, and then after closing the file, click Yes.

7. On the Database Platform page, select Oracle 10g and click Next.

8. On the Setup Type page, do one of the following:

Click (Full) to install all the SmartPlant Instrumentation components.

Click (Custom) to select and install specific SmartPlant Instrumentation components.

9. When Setup detects an existing installation, it opens the Choose the Destination Folder dialog box. Click Yes to install SmartPlant Instrumentation in the existing folder.

If you click No, the Destination Folder page opens. Click Browse and navigate to another destination folder, and then click Next.

10. On the SmartPlant Instrumentation Configuration dialog box, do one of the following:

Click Yes to keep the existing Intools.ini file and preserve all the previous preferences and configuration settings. If you choose this option, the software by-passes steps 12 and 13 below related to the input of data for the Oracle database platform.

Click No if your existing Intools.ini file has been corrupted and you want to replace it with a new default Intools.ini file.



If you click No, you lose all the previous preferences and configuration settings.

11. On the Database Installation Options page, do one of the following to determine what to do with your existing databases, such as In_demo.db (demonstration), Intools.db (empty), and Intoolsef.db (for SmartPlant integration):

Keep old databases Select this option to use your existing databases from the previous installation.

Back up old and install new databases Select this option to use new databases and preserve the existing databases if you are upgrading your software version. Setup renames the existing Intools.db to Intools (1).bk, In

Download - Schem SPI Installation Guide

Top Related