Table of Contents

Search

  1. Preface
  2. Starting Data Archive
  3. System Configuration
  4. Database Users and Privileges
  5. Source Connections
  6. Target Connections
  7. Archive Store Configuration
  8. Datatype Mapping
  9. Database Optimization
  10. SAP Application Retirement
  11. z/OS Source Data Retirement
  12. Seamless Data Access
  13. Data Discovery Portal
  14. Security
  15. SSL Communication with Data Vault
  16. LDAP User Authentication
  17. Auditing
  18. Running Jobs from External Applications
  19. Salesforce Archiving Administrator Tasks
  20. Upgrading Oracle History Data
  21. Upgrading PeopleSoft History Data
  22. Data Archive Maintenance
  23. Storage Classifications
  24. Appendix A: Datetime and Numeric Formatting
  25. Appendix B: Data Archive Connectivity

Administrator Guide

Administrator Guide

Running the History Upgrade Scripts

Running the History Upgrade Scripts

To run the history upgrade scripts, copy the zip file to a directory on the history database server, unzip the file, create a link to the upgraded database, and run the scripts.
  1. Copy AM_DATA_MIGRATION.zip to a directory on the history database server and unzip it.
  2. Log in to the target history database as the Oracle owner.
  3. Create a database link on the history database that connects to the upgraded version of Oracle E-Business Suite.
    Use the following syntax:
    create database link <link name> connect to <database> identified by <database password> using <E-Business TNS entry>;
  4. Use SQL*Plus to connect to the history database as the administrator, and then run the following commands:
    Grant select on dba_extents to <history database schema name>; Grant select on dba_objects to <history database schema name>; Grant all on dbms_rowid to <history database schema name>; Exec dbms_stats.gather_table_stats('SYS','X$KTFBUE'); Exit
  5. Go to the directory where you extracted the zip file, and then run the following commands:
    chmod u+x install_common.sh chmod u+x alter.sh chmod u+x migrate.sh chmod u+x post_migration.sh
  6. Run the install_common.sh script:
    ./install_common.sh <user name>/<password>@<database name>
    For example:
    ./install_common.sh sarhist/amhistory@Ora11DB
  7. Run the alter.sh script:
    ./alter.sh <user name>/<password>@<database name> <modules to upgrade>
    For example:
    ./alter.sh sarhist/amhistory@Ora11DB GL,AP,AR,INV,WIP
  8. Run the R12_table_indexs.sh script and include the tablespace name:
    ./R12_table_indexes.sh <user name>/<password>@<database name> <tablespace name> <modules to upgrade>
    For example:
    ./R12_table_indexs.sh sarhist/amhistory@Ora11DB AM_HISTORY_INDEX GL,AP,AR,INV,WIP
  9. Run the migrate.sh script:
    ./migrate.sh <user name>/<password>@<database name> <number of batches> <degree of parallelism> <modules to upgrade>
    For example:
    ./migrate.sh sarhist/amhistory@Ora11DB 2 8 GL,AP,AR,INV,WIP
  10. Run the post_migration.sh script:
    ./post_migration.sh <user name>/<password>@<database name> <modules to upgrade>
    For example:
    ./post_migration.sh sarhist/amhistory@Ora11DB GL,AP,AR,INV,WIP

0 COMMENTS

We’d like to hear from you!