Page History

...

• Pre-installation tasks
• Installing an Oracle Applications Tier instance
• Post-installation action items

Anchor
Preinstallationtasks Preinstallationtasks

Pre-installation tasks

Most of the screens in this installation require you to input details regarding your information systems. Before installing an Oracle Applications Tier instance, compile a list of all required user inputs based on the screen names below.

...

• Use the Precise Framework Installer to install framework components.
• Verify that you have already installed an Oracle Collector.
• Verify that you can change the CUSTOM.pll and CUSTOM.plx forms library.
• Verify that there are no users logged on to the Oracle Applications server.
• Verify that there are no batch jobs or reports running on the Oracle Applications server.
• Verify that the Concurrent Manager is shut down.
• Log in to the Oracle DB with sysdba user and run:
  GRANT EXECUTE ON DBMS_PIPE TO <COLLECTOR_SCHEMA_USER>

Anchor
InstallinganOracleApplicationsTierinstance InstallinganOracleApplicationsTierinstance

Installing an Oracle Applications Tier instance

This section describes the procedures that are needed to install an Oracle Applications 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 Applications Tier instance

On the AdminPoint Instances screen, you can add a new 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.

Defining Oracle Applications property settings

You can install both an Interpoint for Oracle Applications and the Insight Savvy for Oracle Applications to monitor the Forms Tier of Oracle Applications. To use an Interpoint for Oracle Applications, the database instance must first be monitored by an Precise for Oracle Collector agent.

...

1. Select from the drop-down menu, the server where the Oracle Applications database is running.

2. Select from the drop-down menu, the Oracle Applications database instance name.

   Info
   The name of the Oracle instance or database used by Oracle Applications. If you also want to install an Interpoint for Oracle Applications, you need to install the Oracle Tier agents for the database SID previously installed. If this database is part of a Real Application Cluster (RAC), this is detected during the installation. In this case, you have to define the RAC later on.

3. Select from the drop-down menu, the Oracle Applications forms server. Click Add, to select a server that is not listed on the drop-down menu.

   Info
   This is the name or IP of the server where Oracle Applications forms are installed. This server is the Oracle Applications forms server, and it must be defined as a Precise Server.

4. Select from the drop-down menu, the Oracle Applications instance.

   Info
   The instance is usually auto-detected when the forms server is selected. In any event, you can select Other, from the drop-down menu.

5. The Oracle Applications instance ID textbox is auto-filled with the instance ID, when the instance is selected. You can manually change the value as well.

   Info
   Oracle Applications can have more than one forms server on one machine. The instance ID is a logical name that Insight uses to determine the specific forms server where you want to install this Oracle Applications Tier agent. If the Oracle Applications instance has been auto-detected this field is auto-filled.

6. Select from the drop-down menu, where the Oracle Applications works in. You can choose from the following:
   • Forms Listener Mode
   • Forms Listener Servlet Mode
     The Forms Listener Servlet Mode is enabled only if you have installed a J2EE instance on the forms server (as part of the Precise instance installation).

7. Click Next.

   Info
   Forms Listener Mode is also known as Forms Socket Mode and is the default configured mode for Oracle Applications 11i. Check with your Oracle Applications administrator to determine which configured mode is running for the Oracle Applications Forms server in your application.

Entering Forms Listener inputs

If you selected Forms Listener Mode, you can integrate Insight with the Oracle Applications instance. This enables you to correlate activities within your Oracle Applications domain with other activities in your application and measure Oracle Applications-related network time, and to do so, you need to configure the TCP/IP ports to be used by the Oracle Applications Forms Server Listener. This option is only relevant if your Oracle Applications Forms Server is running on a UNIX server that has the Insight Savvy for Network installed. The relevant port number is defined by the FORMS_PORT application variable in the adfrmctl.sh script (located in the Oracle Applications installation folder). This script is used to start up or shut down the Forms Listener. The default values for the ports are auto-detected.

...

1. Mark the "Integrate with Insight" box.
2. Select from the drop-down menu, the JVM in which the Oracle Applications listener servlet is running.
3. Click Next.

Defining the RAC cluster

If there is a RAC, the RAC Cluster dialog box will appear, with the left table listing all monitored Oracle instances. The right table lists only instances that are part of the RAC (not including the instance defined in the Oracle Applications Tier - Instance Properties dialog box).

...

1. In the Oracle Applications Tier - RAC Cluster dialog box, select the instances to be part of the Oracle Applications RAC cluster. Use the arrow buttons to move instances between the tables.
2. Click Next.

About the AdminPoint Tier installation preview screen

The preview screen signifies that the AdminPoint Tier installer has gathered enough information to begin the installation phase.

...

At this screen, you can still change any of the settings displayed. Click Back to change any of the displayed settings. Click Next to continue installation. Click Cancel to stop the installation process.

About the AdminPoint Tier installation progress screen

This screen appears when the AdminPoint Tier installer is actually performing installation. Installation may take several minutes.

The progress screen visually displays the progress of actual installation on selected servers.

About the AdminPoint Tier installation complete screen

This screen appears when the AdminPoint Tier Installer has completed installation of all Tier instances.

If there are no action items, click Finish (it will be the only option available) to complete the instance installation. If there are action items, click Next (it will be the only option available).

About the AdminPoint Tier Action Items screen

After a Tier instance is installed, you must perform post-installation tasks as may be required. Only after completing any post-installation tasks required can you start using the Tier instances you have just installed.

Perform any tasks displayed on this screen. Click Execute for Precise to perform the action items. Click Mark as done if you have performed the action items yourself.

Anchor
Postinstallationactionitems Postinstallationactionitems

Post-installation action items

When the Oracle Applications Tier Collectors have been installed, post-installation tasks are required. Depending on your application settings, you may need to stop all Insight Savvies that are currently running on the respective server and restart them. In addition, you need to grant permissions to schema user as described below and activate an Interpoint for Oracle Applications, as well as configure the Interpoint for Oracle Applications for the purpose of data collection.

Granting permissions to schema user

Connect to the Oracle instance on which the corresponding collector is installed as DBA user and run query:

grant execute on DBMS_PIPE to <collector_schema_user>

Activating the Interpoint for Oracle Applications

To activate an Interpoint for Oracle Applications

1. Log in to the server and run the following script to install the Interpoint:
   • Windows
     \products\oracle\SID\schema\install_oracle_apps.bat
   • UNIX
     ./products/oracle/SID/schema/install)_oracle_apps.sh
     where <Precise_root> is the name of the Precise root folder.
2. To verify that the installation was successful, run the following script:
   • Windows
     verify_install_oracle_apps.bat
   • UNIX
     verify install oracle apps.sh
3. Configure the Oracle Applications application.
   For more information on how to configure the Oracle Applications application, see Configuring an Interpoint for Oracle Applications for data collection on page 156.
4. Restart the Precise for Oracle Collector agent for this instance.

Configuring an Interpoint for Oracle Applications for data collection

The Interpoint for Oracle Applications identifies activities of Oracle Applications by monitoring the events that are called by forms. Configuring an Interpoint for Oracle Applications to collect the relevant data involves these tasks:

• Manually updating the customization library
• Manually updating Oracle Applications’ system profile (Oracle applications 11.5 or higher)

Manually updating the customization library

To have the Interpoint for Oracle Applications collect forms data, you must manually add some information to the customization library of the Oracle Applications forms. This information includes user, form, and application names.

...

1. Find the CUSTOM.pll and CUSTOM.plx files, usually located in your Oracle Applications folder.
2. Back up the CUSTOM.pll and CUSTOM.plx files.
3. Verify that no Oracle Applications user is currently logged on to the database or any other database using the CUSTOM.pll and CUSTOM.plx files.

4. Run the %ORACLE_HOME%\bin\if60gen.exe tool (sometimes called ifbld60.exe).

   Info
   For Oracle Applications version R12 replace f60gen command with frmcmp.exe.

5. In the welcome wizard, select Open an existing form, followed by OK.
6. Choose CUSTOM.pll and click Open.
7. Under PL/SQL Libraries > Custom > Program Units right-click on Package body and select the PL/SQL Editor.
8. Find the EVENT procedure, locate the first BEGIN after the commented sample code, and insert the following code, starting with BEGIN.
   Verify that the script was not inserted into commented sample code. You can easily mistake sample code for real code.
        begin
     if (event_name='WHEN-NEW-FORM-INSTANCE') then declare
     cursor_name integer; rows_processed integer; del char(1) :=
     substr(get_application_property(CURRENT_FORM),1,1);
     begin
     if (del != '/') then del := '\';
     end if;
     cursor_name := dbms_sql.open_cursor;
     dbms_sql.parse(cursor_name,
     'begin VERITAS_APPS_LOG( ''F'' , :username ,
     :application , :form , NULL) ; end ;' ,1); dbms_sql.bind_variable(cursor_name,':username' , FND_PROFILE.VALUE('USERNAME')); dbms_sql.bind_variable(cursor_name,':application' ,
     substr(get_application_property(CURRENT_FORM), instr(get_application_property(CURRENT_FORM),del
     ,
     -1)+1, length(substr( get_application_property(CURRENT_FORM), instr(get_application_property(CURRENT_FORM), del,-1)+1))-4)); dbms_sql.bind_variable(cursor_name,':form' , Name_In('system.current_form'));
     rows_processed := dbms_sql.execute(cursor_name);
     dbms_sql.close_cursor(cursor_name);
     exception
     when others then begin dbms_sql.close_cursor(cursor_name); exception
     when others then null;
     end; end; end if;
     exception
     when others then null;
     end;
9. Click File > Save.
10. Run %ORACLE_HOME%\bin\ifcmp60.exe.
11. Fill in the following fields:
    1. File                        CUSTOM.PLL (that we changed before)
    2. Userid                   APPS
    3. Password              APPS password
    4. Database              database name
    5. Module Type         LIBRARY
    6. Module Access     FILE
12. Click OK.

Anchor
ManuallyupdatingOracleApplications ManuallyupdatingOracleApplications

Manually updating Oracle Applications system profile (Oracle applications 11.5 or higher)

To have an Interpoint for Oracle Applications identify interactive forms in Oracle Applications 11.5 or higher, you must manually update the system profile of Oracle Applications with site-specific initialization code. As a result, Oracle Applications forwards the required information - the user, form, and application name for interactive work and the concurrent program and application name for batch work - to an Interpoint for Oracle Applications.

...

If an issue occurs, verify again that the Interpoint for Oracle Applications was installed successfully. If it was installed successfully, most likely the issue was caused by erroneous text in the system profile. If the issue persists, contact Precise Customer Support.

Correcting problematic profiles

When the Interpoint for Oracle Applications does not correlate some of its information with the Collector agent, the following scenario may be applicable:

...

This query shows all relevant profiles affecting the code.

Correcting typing errors in the system profile

Typing errors in the system profile may prevent Oracle Applications forms from opening, including the system profile form. To validate that there is no other definition that overrides your profile definition and to correct any typing errors, you need to log in to the Oracle database externally using SQL*Plus.

...