Page History

...

1. If you want to install on a Windows server, add the "precise" user to the ‘ora_dba’ group.
2. Verify that you have an Oracle DBA user name and password. For Oracle 9i and later, the The user should also have SYSDBA privileges.
   During  During the Oracle Tier installation, the installer creates a schema in the Oracle database. To do so, it is required to specify an Oracle DBA user. This user is used only during the installation. Precise products do not use or save the DBA user name or password for future use.
3. Set the Init.ora parameter.
   For all versions, set: timed_statistics = TRUE

Pre-installation tasks for the Oracle Tier on a UNIX server

To perform pre-installation tasks for an Oracle Tier on a UNIX server

1. If you want to install on a UNIX server, add the "precise" user to the same group as the Oracle software owner.
   The Precise for Oracle agent reads the Oracle SGA directly. To do so, the user must be in the same group as the Oracle user to have access to the Oracle shared memory.
2. If you are installing on a Sun Solaris operating system, verify that the /proc file system is available.
3. Verify that the file system where you plan to install the software is mounted with the SETUID option.
4. Verify that the shared library path variable (LD_LIBRARY_PATH, SHLIB_PATH, or LIB_PATH, depending on the operating system) is not set in the "precise" user application.
5. Verify that you have an Oracle DBA user name and password. For Oracle 9i and later, the user should also have SYSDBA privileges.
   During the Oracle Tier installation, installer creates a schema in the Oracle database. To do so, it is required to specify an Oracle DBA user. This user is used only during the installation. Precise products do not use or save the DBA user name or password for future use.
6. Set the Init.ora parameter.
   For all versions, set: timed_statistics = TRUE

Pre-installation tasks for an Oracle Tier on an AIX server

If you want to install a Precise for Oracle FocalPoint on an AIX server, first verify that the server on which the FocalPoint will run has Asynchronous I/O (AIO) available.

To check whether the AIO subsystem is available

• Perform the following command:
  lsdev -C | grep aio
  The result should be similar to:
  aio0 Available Asynchronous I/O
  If the result is:
  aio0 Defined Asynchronous I/O, then you need to make the AIO subsystem available.
  To make the AIO subsystem available:
• Perform the following command:
  /usr/sbin/mkdev -l aio0

To check whether the AIO subsystem is configured to be available upon the next system startup

1. Perform the following command:
   lsattr -El aio0
2. Check the value of the autoconfig parameter. It should be equal to available and not to defined.

...

1. When installing a new Oracle Agent on Windows with Oracle 12c and later where:
   • the listener is already installed
   • the Oracle service is running using Oracle home user who is a standard Windows user and not part of the Admin group
     1. Allow full access to the Oracle home user on the Precise root directory on the monitored machine (the machine where the Oracle Agent is being installed or the Oracle instance is running).
     2. Add the Oracle home user to the performance monitoring group.

Pre-installation tasks for the Oracle Tier on a UNIX server

To perform pre-installation tasks for an Oracle Tier on a UNIX server

1. If you want to install on a UNIX server, add the "precise" user to the same group as the Oracle software owner.
   The Precise for Oracle agent reads the Oracle SGA directly. To do so, the user must be in the same group as the Oracle user to have access to the Oracle shared memory.
2. If you are installing on a Sun Solaris operating system, verify that the /proc file system is available.
3. Verify that the file system where you plan to install the software is mounted with the SETUID option.
4. Verify that the shared library path variable (LD_LIBRARY_PATH, SHLIB_PATH, or LIB_PATH, depending on the operating system) is not set in the "precise" user application.
5. Verify that you have an Oracle DBA user name and password. For Oracle 9i and later, the user should also have SYSDBA privileges.
   During the Oracle Tier installation, installer creates a schema in the Oracle database. To do so, it is required to specify an Oracle DBA user. This user is used only during the installation. Precise products do not use or save the DBA user name or password for future use.
6. Set the Init.ora parameter.
   For all versions, set: timed_statistics = TRUE

Pre-installation tasks for an Oracle Tier on an AIX server

If you want to install a Precise for Oracle FocalPoint on an AIX server, first verify that the server on which the FocalPoint will run has Asynchronous I/O (AIO) available.

To check whether the AIO subsystem is available

• Perform the following command:
  lsdev -C | grep aio
  The result should be similar to:
  aio0 Available Asynchronous I/O
  If the result is:
  aio0 Defined Asynchronous I/O, then you need to make the AIO subsystem available.
  To make the AIO subsystem available:
• Perform the following command:
  /usr/sbin/chdev mkdev -l aio0 -P -a autoconfig=available

...

To check whether the AIO subsystem is configured to be available upon the next system startup

1. Perform the following command:
   lsattr -El aio0
2. Check the value of the autoconfig parameter. It should be equal to available and not to defined.

To configure the AIO subsystem to be available upon the next system startup

• Perform the following command:
  /usr/sbin/chdev -l aio0 -P -a autoconfig=available

Anchor
InstallinganOracleTierinstance InstallinganOracleTierinstance

Installing an Oracle Tier instance

This section describes the procedures that are needed to install an Oracle Tier instance. You have the option of adding a new instance, as well as adding a new application. For information on editing or removing an existing instance, see Editing or removing Tier instances or clusters on page 200.

Adding an Oracle Tier instance

On the AdminPoint Instances screen, you can add a new Tier instance.

To add a Tier instance

1. From StartPoint, click the AdminPoint tab.
2. Click the Installation tab. The list of Applications appears.
3. If the Application exists, click Edit to edit the Application. If this is a new Application, then click Add, and then follow the details for adding an application. 
4. Once the Application tab is opened, then click Oracle.
5. Select Add from the Oracle tab.

6. If the Oracle instance is new, then select Add. If the Oracle instance exists in an existing application, select Add Existing

...

This section describes the procedures that are needed to install an Oracle Tier instance. You have the option of adding a new instance, as well as adding a new application. For information on editing or removing an existing instance, see Editing or removing Tier instances or clusters on page 200.

Adding an Oracle Tier instance

On the AdminPoint Instances screen, you can add a new Tier instance.

To add a Tier instance

1. From StartPoint, click the AdminPoint tab.
2. Click the Setup tab.
3. From the drop-down menu, select Instances & Clusters.
4. Click the All instances tree item
5. At the bottom of the Display Instances & Clusters screen, click Add Instance. An Add New Instance dialog box appears.
6. Select the required technology from the list.
7. Select the application from the list. If the desired application is not on the list, follow steps a-d:
   1. Click Add.
   2. In the Application Name field, type in the new application name.
   3. On the Application System field, select the system application from the list.

   4. Click OK.

      Info
      To install an instance in an application, you must have ADMINISTRATE.INSTALL permission for the application in which you want to install the instance. If you only have permission for a specific technology, you will only be able to install in an application that is either empty, or is comprised of only the same technology.

8. Select a Tier from the list.

9. Click OK to view the next screen.

   Info
   Always refresh AdminPoint after adding an instance.

...

1. Click the drop-down menu and select the server with the Oracle instance. Click Add to enter the name of a server not on the list. For more information, see see Adding a new server.
2. Click the drop-down menu and select the Oracle SID from the listselect the Oracle SID from the list. If this is a Container Database, this must be the CDB name.
3. Enter the Oracle home folder. If it does not appear correctly, click the browse (...) button to search for the appropriate home folder.

4. Click the drop-down menu and select the Oracle version.

   Info
   This is the Oracle release version of the instance, which is either 9i, 10g10g, 11g, 12c R1, or 11g12c R2.

5. Click the drop-down menu and select the Oracle Listener port.

6. Enter the user name.

   Info
   The name of the Oracle user that has DBA privileges. This user is used for the initial connection with the Oracle database and to create a user named "precise" in the database. The DBA user is used only for the above tasks during the installation. Once it finishes its tasks, it is not used any more.

7. Enter the password.

   Info
   This is the password for the Oracle DBA user, encrypted using the Precise CLI utility. The DBA password is not saved by Precise.

8. Click the drop-down menu and select the method of connection.
   • The Oracle Tier installation requires creating objects (views and packages) in the SYS schema and therefore, a privileged access to the SYS schema is required. Use the "Connect As" option to allow connecting to your Oracle instance with a user that has SYSDBA privileges.
   • If you did not use the manual schema installation, it is required that you connect with a DBA user as 'SYSDBA'.
     For more information on using the manual schema, see Manually installing Precise for Oracle database schemas on page 107.
   • To connect as 'SYSDBA', you should enter the Oracle initialization parameter remote_login_passwordfile as a password file, meaning that this parameter must be set to share or exclusive, and grant SYSDBA privileges to the DBA user for the Oracle Tier installation.

9. Click Next to continue to the next screen.

   Info
   If a browse screen appears, select the file that appears in the "File of type" field, on the installation disk, in the folder Precise/distribution.

...

1. Select "Create new user."
2. Enter the user name. If this is installed in an Oracle Container Database, the user must be prefixed C##.
3. Enter the appropriate password.
4. Re-enter the password.
5. Click Next.

...

1. Select "Use an existing user."
2. Click Find User to locate an existing user name.
3. On the Find User dialog screen, click Find to filter for an existing (available) user name.
4. Select an available user name, and then click OK. If this is installed in an Oracle Container Database, the user must be prefixed C##.
   The selected user name now appears on the Oracle Schema credential screen.
5. On the Oracle Schema credential screen, enter the appropriate password for the existing user.
6. Click Next.

...