Additional Step for Loaders
Loaders require an extra installation step, in addition to the Server-side installation and the Servlet installation.
Loaders have their own install zip file: XXX_loader.zip or XXX_loader_VERSION.zip where XXX is the name of the loader e.g. WIP_loader_2.27.0.zip.
1. Copy File to Server
Copy the zip file (e.g. WIP_loader_2.27.0.zip) to your E-Business application server and unzip it. The installation scripts for the Loader will be in the "DBA Files" directory.
2. BOLINF Grants and Synonyms (OMCS only)
If you are an OMCS (Oracle Managed Cloud Service) installation then run the OOD_aiw_prepare_XXX.sql script in SQL*Plus as the APPS user (e.g. OOD_aiw_prepare_WIP.sql for the WIP Loader), otherwise go to Step 3. You will be prompted for the BOLINF password. This script generate grants for the BOLINF schema and synonyms for the APPS Schema.
run> sqlplus apps SQL*Plus: Release 10.1.0.5.0 - Production on Mon Apr 15 10:06:27 2024 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter password: xxxxxx Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> @OOD_aiw_prepare_WIP.sql ================================================================ More4Apps - ood_prepare.sql This script generates the APPS and BOLINF privileges and synonyms required by the More4Apps spreadsheet wizards in an Oracle On Demand site. It is re-runnable. Press Ctrl-C to quit, or Return to continue: Is this an Oracle On Demand site? (Y/N) [Y]: BOLINF password: xxxxxx Generating the required GRANT and SYNONYM statements for the APPS schema Please wait... Generating the required GRANT and SYNONYM statements for the APPS schema Please wait... Generating the required SYNONYM statements for the BOLINF schema Please wait... Connected. Synonyms and grants created. Press ENTER to continue... Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options run>
3. Loader Database Package
Connect to SQL*Plus as the APPS user and run aiw_install_XXX.sql. For example, aiw_install_WIP.sql for the WIP Loader.
| If you are an OMCS installation then connect to BOLINF instead of APPS and answer "Y" to the OMCS prompt. The example shows APPS. |
| Some Loaders have an Extension package that allows you to put your own custom PL/SQL code into the Loader processing. If you have already made use of this feature and you do not want the installation script to overwrite your custom package then ensure you have a backup of your custom package to re-install it after the script has been run. |
run> sqlplus apps SQL*Plus: Release 10.1.0.5.0 - Production on Mon Apr 15 10:29:00 2024 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter password: xxxxxx Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> @aiw_install_WIP.sql ================================================================ More4Apps - aiw_install.sql This script installs or upgrades the M4APS_AIW_WIP_DISCRETE_JOB and M4APS_AIW_WIP_DISCRETE_JOB_EXT package for the More4Apps Application Interface Wizard product. It is re-runnable and is non-destructive. Press Ctrl-C to quit or Return to continue: Is this an Oracle On Demand site? (Y/N) [N]: If you have any customization in M4APS_AIW_WIP_DISCRETE_JOB_EXT then exit the installation and take backup of the M4APS_AIW_WIP_DISCRETE_JOB_EXT package. Do you want to exit for backup? [N]: Creating packages..... No errors. No errors. No errors. No errors. Packages created Press ENTER to continue... Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
Repeat this step for each loader you are installing.