Connecting to Oracle Database Server

To configure the basic settings of the plug-in, you must connect the Oracle Database Server by executing two SQL scripts, create_user.sql and common_all.sql.

Note: You must have an Oracle Database system administrator’s account to create a plug-in user and an Oracle E-Business Suite application administrator’s account to grant privileges to the plug-in user.

TIBCO ActiveMatrix BusinessWorks Plug-in for Oracle E-Business Suite adds support for Oracle E-Business Suite 12.2.x. Different create_user.sql scripts and common_all.sql scripts are required if you use the plug-in with different versions of Oracle E-Business Suite. When connecting to Oracle Database Server, select the corresponding scripts according to the version of Oracle E-Business Suite you are using.

  • The two scripts for Oracle E-Business Suite 12.2.x are located in the TIBCO_HOME\bw\palettes\oracleebs\version_number\config\12.2 directory.
  • The two scripts for Oracle E-Business Suite 12.1.x and 12.0.x are located in the TIBCO_HOME\bw\palettes\oracleebs\version_number\config\12.1 directory.

See Oracle E-Business Suite SQL Scripts for more details about the SQL scripts.

Procedure

  1. Log on to Oracle SQL*Plus:
    1. On the command line, enter sqlplus.
    2. Enter the Oracle Database system administrator’s user name and password.

    The following figure shows a sample logon screen:

    Log on to Oracle SQL*Plus
  2. Create a plug-in user.
    The plug-in requires a user that can access various schemas, objects, and data in the Oracle E-Business Suite system. Run the create_user.sql file that is located in the TIBCO_HOME\bw\palettes\oracleebs\version_number\config\version_number directory. Enter the user name and password on the command line.
    Create a plug-in user.
  3. Initialize the plug-in user.

    Run the common_all.sql file that is located in the TIBCO_HOME\bw\palettes\oracleebs\version_number\config\version_number directory to initialize the plug-in user. You are prompted to enter values for the following parameters:

    • dba_username: typically system
    • dba_password: typically manager
    • db_connectstring: net service name
    • plug-in username: as created in Step 2
    • plug-in password: as created in Step 2
    • apps_username: typically apps
    • apps_password: typically apps

    The following figure shows the script execution screen:

    Initialize the plug-in user
Contents
Search Results