Installing the Oracle Applications Bridge

There are two components to the Oracle Applications adapter. One component is the Oracle Applications adapter itself while the other part is a bridge component that provides a link between the adapter and the Oracle Applications program. The Oracle Applications adapter is part of the normal TA installation and does not require a separate installation. However, the Bridge component does require installation and the procedure to install it is described in this section.

The Oracle Applications Bridge is comprised of various PL/SQL stored procedures and forms used to pass job parameters to the Oracle database. The Bridge component of the Oracle Applications adapter is not part of the regular TA installation and requires a separate installation procedure.

Note: If you need to create a custom APPS user for TA, then you also need to use a different installation process for the Oracle Applications Bridge as described in Installing the Oracle Application Bridge Using a Custom APPS User.

Prerequisites for Installing the Oracle Applications Bridge

Before installing the Oracle Applications Bridge, check:

  • The user must be logged on to Windows/Unix as the application owner (usually applmgr).

  • Run the application environment file (usually Appsora.env under $APPL_TOP) in the current shell.

  • Grant the execute privilege on sys.dbms_obfuscation_toolkit file to the APPLSYSPUB user. This package is used by the Bridge to encrypt and decrypt the data. To grant this privilege, connect to the database as system (or SYSDBA) and from the SQL prompt, enter:

    SQL>grant execute on sys.dbms_obfuscation_toolkit to applsyspub; SQL>commit;

    Create tablespace for the Table and Index spaces before starting installation. To configure the tablespaces to autoextend:

    SQL>CREATE TABLESPACE sabdg_data DATAFILE '/do1/oracle/testdata/sabdg_data.dbf' SIZE 100M AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED;

    SQL>CREATE TABLESPACE sabdg_index DATAFILE '/do1/oracle/testdata/sabdg_idx.dbf' SIZE 50M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;

    SQL>commit;

  • Create the tablespace for the Table and Index spaces before starting installation. To configure the tablespaces to autoextend:

    SQL>CREATE TABLESPACE sabdg_data DATAFILE '/do1/oracle/testdata/sabdg_data.dbf' SIZE 100M AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED;

    SQL>CREATE TABLESPACE sabdg_index DATAFILE '/do1/oracle/testdata/sabdg_idx.dbf' SIZE 50M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;

    SQL>commit;

  • While no existing $APPL_TOP objects/files are modified when installing the Bridge, three new objects/files that start with

    SABDG are created.

    Note: The database schema names used above are only examples. You can use your own names for the database schemas.

Installing the Bridge for 11i or R12

The batch file that installs the Bridge requires these parameters:

  • APPS user (or equivalent) – The equivalent Apps user in the Oracle Applications program.

  • APPS password – The password of the Apps user used to access Oracle Applications.

  • Data tablespace – The name of the data tablespace (sabdg_data).

  • Index tablespace – The name of the index tablespace (sabdg_index).

  • TNS name – The TNS string to connect to the database (Windows only)

  • Temp tablespace – The temporary tablespace for the user SABDG.

  • System password – The database user system password. This is required for when the installation process creates the SABDG user in the database to own tables, sequences and indexes.

    Use these parameters when running the batch file to install the Bridge. The installation and upgrade procedures for Windows and Unix forms server are described next.

Initial Installation or Upgrade Windows Forms Server

To install the 11i or R12 Bridge (Windows):

  1. Copy the 11i or R12 Bridge files from the \OraAppsBridge\Windows directory in the installation DVD-ROM to a temporary directory on the forms server. The temporary directory must be on the same drive as the APPL_TOP.

  2. Enter on the command line, using the listed parameters:

    install_11i <APPS User> <APPS Password> <Data Tablespace> <Index Tablespace> <TNS Alias Name> <Temp Tablespace> <System Password>

    OR

    install_R12 <APPS User> <APPS Password> <Data Tablespace> <Index Tablespace> <TNS Alias Name> <Temp Tablespace> <System Password>

To upgrade the 11i or R12 Bridge (Windows):

  1. Enter on the command line, using the listed parameters:

    upgrade_11i <APPS User> <APPS Password> <Data Tablespace> <Index Tablespace> <TNS Alias Name> <Temp Tablespace> <System Password>

    OR

    upgrade_R12i <APPS User> <APPS Password> <Data Tablespace> <Index Tablespace> <TNS Alias Name> <Temp Tablespace> <System Password>

Initial Installation or Upgrade Unix Forms Server

Note: Copy the 11i or R12 Bridge TdlOraAppsBdg.tar file from the /OraAppsBridge/Unix directory in the installation DVD-ROM to a temporary directory on the forms server.

To install the 11i or R12 Bridge (Unix):

  1. Extract files from TdlOraAppsBdg.tar file tar xvf TdlOraAppsBdg.tar

  2. From the temporary directory where you copied the Bridge files, at the cursor, enter chmod 777*.

  3. Enter at the cursor, using the listed parameters:

    sh ./install_11i.sh <APPS User> <APPS Password> <Data Tablespace> <Index Tablespace> <Temp Tablespace> <System Password>

    OR

    sh ./install_R12.sh <APPS User> <APPS Password> <Data Tablespace> <Index Tablespace> <Temp Tablespace> <System Password>

To upgrade the 11i or R12 Bridge (Unix):

  1. Extract files from TdlOraAppsBdg.tar file tar xvf TdlOraAppsBdg.tar

  2. From the temporary directory where you copied the Bridge files, at the cursor, enter chmod 777*.

  3. Enter at the cursor, using the listed parameters:

    sh ./upgrade_11i.sh <APPS User> <APPS Password> <Data Tablespace> <Index Tablespace> <Temp Tablespace> <System Password>

    OR

    sh ./upgrade_R12.sh <APPS User> <APPS Password> <Data Tablespace> <Index Tablespace> <Temp Tablespace> <System Password>

    Note: If you have a multi-tier architecture of Oracle Applications containing multiple form servers, then the Bridge for Oracle Applications must be installed on only one forms server and upgraded on the rest of the form servers to ensure distribution of the Bridge forms.

Verifying Successful Bridge Installation or Upgrade

Installation and upgrade procedures can be verified by checking a log file that is created when the Bridge is installed. This log file, called Verify_post.log, is created in the same directory where the Bridge was installed.

Open the Verify_post.log file.

There are three values displayed in the log file:

  • TOT(Total Objects)

  • VAL(Valid Objects)

  • INV(Invalid Objects)

The TOT and VAL values should read 36. The INV value should read 0.

If the values displayed in the log file are the proper values, then installation/upgrade was successful. Any deviation from these values indicates that the installation/upgrade was unsuccessful.

Uninstalling the Bridge

To uninstall the Bridge component of the Oracle Applications adapter, you must delete all of the Bridge objects, the Bridge owner and all of the forms on the forms server. The procedures to delete the Bridge owner and its objects are the same for the Windows and Unix platforms but the procedures for deleting forms from the forms server differ for each platform.

To delete the Bridge objects (Windows and Unix):

  1. Login as Apps to the apps database.

  2. Run the sabdg_drobj.sql script that is found in the \OraAppsBridge\Windows\sabdg_obj.sql file in the Windows directory on the installation DVD-ROM.

To delete the Bridge owner (Windows and Unix):

  1. Login as system to the apps database.

  2. Drop user sabdg cascade.

To delete all forms on the forms server:

Windows:

rm %AU_TOP%\forms\US\SABDG\*.fmb rm -r %FND_TOP%\forms\US\sabdg
rm -r %APPL_TOP%\sabdg

Unix:

rm $AU_TOP/forms/US/SABDG/*.fmb rm -r $FND_TOP/forms/US/sabdg rm -r $APPL_TOP/sabdg

Installing the Oracle Application Bridge Using a Custom APPS User

If your security policy does not allow the APPS user the authority to access Oracle Applications jobs from TA , then you can create a custom APPS user and then use it to install the Oracle Applications Bridge. The custom APPS user can then be used to allow TA to access the Oracle Applications database jobs.

To install the Oracle Applications Bridge using a custom APPS user

  1. Create these table spaces in the Oracle Applications server:

    CREATE SMALLFILE TABLESPACE "SABDG_DATA" DATAFILE '+DATA_ERPCRP2/sabdg_data01.dbf' SIZE 100M AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
    CREATE SMALLFILE TABLESPACE "SABDG_INDEX" DATAFILE '+DATA_APS/sabdg_idx01.dbf' SIZE 100M AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
    sqlplus '/ as sysdba'
    SQL> grant execute on sys.dbms_obfuscation_toolkit to applsyspub; Grant succeeded.
    SQL> commit;
    Commit complete.
    SQL>
  2. Install the Bridge using the custom APPS user named TIDAL:

    1. Create the TIDAL user using this script:

      CREATE USER “TIDAL" PROFILE "DEFAULT" IDENTIFIED BY "tidal12345" DEFAULT TABLESPACE "SABDG_DATA" TEMPORARY TABLESPACE "TEMP" QUOTA UNLIMITED ON "SABDG_DATA" QUOTA UNLIMITED ON "SABDG_INDEX" ACCOUNT UNLOCK;
    2. Run the tidal.sql as the sys user from tidal.sql Commands in Appendix A.

    3. Run the sys_grant.sql as the sys user from sys_grant.sql Commands in Appendix A.

    4. Run the tidal_syn.sql from tidal_syn.sql Commands in Appendix A as the TIDAL user created in step a.

    5. Copy the TdlOraAppsBdgUnix.tar / TdlOraAppsBdgWindows.zip to any location in the OracleApps server and unzip it.

    6. Install the Bridge using this command:

      $ ./install_R12.sh ADT_TIDAL adt123 SABDG_DATA SABDG_INDEX TEMP1 <system user (system) password >

      Installation Output:

      TNS Ping Utility for Linux: Version 10.1.0.5.0 - Production on 10-SEP-2013 09:38:04 Copyright (c) 1997, 2003, Oracle. All rights reserved.

      Used parameter files:

      Used TNSNAMES adapter to resolve the alias
      Attempting to contact (DESCRIPTION= (ADDRESS_LIST= (LOAD_BALANCE=YES) (FAILOVER=YES) (ADDRESS=(PROTOCOL=tcp)(HOST=Tidalsoft.com)(PORT=1541)) (ADDRESS=(PROTOCOL=tcp)(HOST=Tidalsoft.com)(PORT=1541))) (CONNECT_DATA= (SERVICE_NAME=erpcrp2)))
      OK (0 msec)
      Installing Tidal OraApps Bridge
      ************* Installing Oracle Bridge *************** Unable to install Tidal OraApps Bridge
      INS:21 All objects did not get created
    7. Install the custom sabdg_global package as the TIDAL user using the sabdg_global_new.sql in Appendix–sabdg_global Package.

    8. Make the OracleApps connection from TA master using the custom Apps user.