Page History

...

Anchor
PreparingtoinstallthePreciseFramework PreparingtoinstallthePreciseFramework

Preparing to install the Precise Framework

...

• The Oracle Partitioning option of Oracle Database Enterprise Edition is required and must be enabled in the database.
• If Precise will be monitoring SQL Server and/or Sybase performance, or an ERP system that is based on SQL Server or Sybase (such as SAP), an SQL Server PMDB is needed.
• If Precise will be monitoring Oracle and/or DB2 performance, or an ERP system that is based on Oracle or DB2, such as SAP or Oracle E-Business Suite, an Oracle PMDB is needed.
• If you will be monitoring mixed landscapes consisting of databases (SQL Server / Sybase, AND Oracle / IBM DB2) you will need to install two PMDB's PMDBs: one on Oracle and one on SQL Server.

...

The Precise agents typically reside on the monitored servers and need to be able to communicate with the Precise Framework. Verify that the network settings (such as firewall configurations etc.) will enable that. For more information, see Communication Requirements in the Precise Minimum Requirements for Installation Guide.

Anchor
PrerequisitesforinstallingthePreciseFramework PrerequisitesforinstallingthePreciseFramework

Prerequisites for installing the Precise Framework

...

• The Precise website was reviewed for a newer version of this document. If there is a newer version, download it and use it instead of this one. Visit the Precise website at https://preciseidera.secure.force.com/precise/.
• The Precise deployment architecture is well understood.
• Precise Support Matrix was reviewed regarding the framework server.
• A server for the Precise Framework is ready.
• Installation prerequisites have been met (See Prerequisites for installing the Precise Framework).
• A database for the Precise PMDB is ready according to all above requirements.
• Communication requirements for allowing communication between the Precise Framework and the Precise agents are met.
• The Precise website was reviewed for product updates. Visit the Precise website at https://preciseidera.secure.force.com/precise/.
• Downtime has been coordinated for the monitored instances.

...

1. Download the following:
   Precise v9.x.x - Precise v9.x.x is downloaded from https://preciseidera.secure.force.com/precise/.

2. Unzip the downloaded files for Precise v9.x.x into an empty folder.

   Info
   It is recommended to keep the Precise v9.x.x download (or DVD) available for use after finishing the Precise installation.

3. On a Windows server, open the folder with the unzipped Precise v9.x.x files (or DVD), open the Precise 9.x.x folder and double-click setup.exe. The Precise Framework installer will launch, and guide you through the Precise Framework installation.
   For step-by-step instructions regarding each framework installer screen, see Setting up the Precise Framework installation. Most of the screens require you to input details regarding your information systems. It is recommended to compile a list of all required user inputs before continuing.
4. Apply a valid license.
   When the Precise Framework installation process is complete, the “Precise Framework Installer - Finished” screen appears.
5. Select Launch AdminPoint to apply Precise license.

6. Click Finish. This launches the Precise administrative interface (“AdminPoint”), used to apply Precise licenses.

   Info
   Depending on your browser security settings, you may now be prompted to install a Precise component in the browser. In order for the Precise user interface to function properly, this component must be installed.

7. A login screen appears. The default administrative user is “admin” and the initial password for this user is “admin”. Log in as this user.
8. On the screen that appears, click Apply License and select the license file that you received when you bought Precise, for your installation. Should you not have received the license file, contact Precise Customer Support.
9. A pop-up window will appear, confirming that the license was successfully applied. Click OK.

...

To enter Microsoft SQL Server PMDB login information (using OS authentication)

1. In the SQL Server instance field, click the drop-down menu and select the SQL Server instance from the list, or type in a different instance.

   Info
   The selected Microsoft SQL Server instance will be used as the PMDB.

2. Enter the user name.

   Info
   The User name will be used both for the PMDB installation, as well as for connecting to the SQL server when using the PMDB.

3. Enter the password for the login name specified.
4. Enter the Domain or Server name.
5. Enter the name of the database you want the PMDB to use. If a database with that name exists, it will be used. If not, a new database will be created. For a new database, fill the “data path" and "log path" fields.
6. By default, the PMDB schema is automatically installed. To install the schema manually, see Manually installing the SQL Server PMDB schema on page 31.
7. Click Next.

Filling new database properties

...

1. In the PMDB Instance Parameters screen, click Advanced.
2. In the New Database Properties tab, fill in the following fields:
   • Collation. Choose a case sensitive collation
   • Data Size. Enter the initial size in MB
   • Data Growth. Enter the auto growth in MB
   • Log Size. Enter the initial size in MB
   • Log Growth. Enter the auto growth in percent
3. Click OK.

Anchor
ManuallyinstallingtheSQLServerPMDBschema ManuallyinstallingtheSQLServerPMDBschema

Manually installing the SQL Server PMDB schema

To manually install the PMDB schema

1. On the PMDB Instance Parameters screen, click Advanced.
2. In the Schema tab, mark the Disable automatic schema installation check box.
3. If the database contains partitioning, mark the Database contains partitioning check box.
4. Click the Database version drop-down menu and select the database version.
5. Click OK.
6. Perform the action items as provided.

...

To enter Oracle Server PMDB login information

1. In the Oracle database server field, click the drop-down menu and select the Oracle server from the list or type in a different server.
2. In the Oracle SID field, click the drop-down menu and select the Oracle SID, or type it in.
3. Enter the Oracle Listener port number.
4. If you want to use RAC, select the Use Oracle RAC service name box.
5. By default, the PMDB schema is automatically installed. To install the schema manually, see Manually installing the SQL Server PMDB schema on page 31.

6. Enter the user name of the Oracle DBA user.

   Info
   This user name will be used only in the Framework installation, and will not be used again. This field is not required and will be grayed out if the schema installation mode is set to manual.

7. Enter the password for the Oracle DBA user.

   Info
   This field is not required and will be grayed out if the schema installation mode is set to manual.

8. Click Next.

...

• Datafiles storage folder location. The Datafiles storage folder location is where all datafiles are created (storage parameters). The folder must exist in the file system.
• Update the tablespaces definitions (optional). See Updating the tablespaces definitions on page 31.

To enter Oracle Server PMDB schema information

1. In the User name field, type a new Precise user name, or click the drop-down menu to select an existing Oracle schema user name.

   Info
   This is the name of the Precise user to be created in the Oracle instance to hold the PMDB schema. You can create a new Precise user, or select an existing user from the list.

2. Enter a new password to be assigned to the new user, or an existing password if you have chosen an existing user.
3. Confirm password.

4. Next to the Store datafiles in this location field, click the browse button and select the folder for storing datafiles.

   Info
   For Oracle ASM, specify the ASM disk group. (For example: +DISKGRP1/ora11asm/).

5. Click Next.

Anchor
Updatingthetablespacesdefinitions Updatingthetablespacesdefinitions

Updating the tablespaces definitions

The PMDB schema defines 8 eight tablespaces. 5 Five tablespaces are used for tables and 3 three are used for indexes. The tables and indexes have 3 three different sized tablespaces: small, medium, and large. The tables also have additional sts and infra tablespaces.

Each tablespace has a corresponding datafile. Based on this, 8 eight datafiles will be created. The filenames have the following format: <table_space_name>.DBF.

...

1. Open the Advanced dialog box. The Advanced dialog box displays the following values currently defined for each tablespace: Tablespace name, initial size, uniform size, and extent size.
2. In the tablespaces definition table, click on a value to update it.
3. In the Temporary tablespace name field, click the drop-down menu and select a temporary tablespace.
4. In the Stored in datafile field, enter the datafile in which the temporary tablespace will be storied.

5. Click OK.

   Info
   By default, the tablespaces are created as bigfiles. To create the tablespaces as regular tablespaces, clear the Create tablespaces as bigfiles check-box.

...

This screen appears when Precise Framework Installer has completed the Framework installation. If the manual schema option was chosen, you will be asked to run the schema creation script and the required action item to finish the installation.

IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal

Save