Table of Contents
- Title and Copyright Information
- Preface
- 1 Before You Begin
- 2 System Requirements and Technology Stack
-
3
Installing and Patching Oracle Applications and Oracle Database
- Install Oracle Applications 12.2.0
- Upgrade Oracle Applications from 12.2.0 to 12.2.9
- Upgrade the Oracle Database from 12c to 19c
- Perform Oracle Database 19c Post-Upgrade Tasks
- Apply the Additional EBS Patches
- Clone the Environment (Optional)
- Create Tablespace CDR_BLOB_DATA_TS
- Ensure Enough Space is Available in Tablespace APPS_TS_MEDIA
- 4 Installing the Oracle TMS Database Tier
-
5
Installing Oracle Life Sciences Data
Hub
- Provide Required Grants to the APPS Schema
- Apply the Oracle Life Sciences Data Hub AD Splicer Patch
- Create Tablespace CDR_BLOB_DATA_TS
- Install Oracle LSH 3.4
- Install the CdrRuntime.jar File
- Install Online Help
- Check Non-Default Service
- Set CDR_DB_SERVICE_NAME
- Set CDR_SCAN_HOST_NAME
- Set CDR_SCAN_PORT_NUM
- Add clovi.gif to the EBS R12.2 File System
- Create Oracle LSH UI JAR File
- Set Profile at the Site-Level
- Create System Administrator and Security Administrator Users
- Run the Post-Installation Programs
- Gather Statistics on Schemas
- Schedule the Context Index Refresh Program
- Start Journaling Internal Tables
- Increase Memory Available for MetaData Reports
- Grant Security Rights to Seeded Adapters
- Create Auditing Process
- Create CDR_USER Role
- Regenerate the JAR Files
- Set Up Resource Capping
- Turn off EXE DEBUG
- Set the Profile Value for DMW_SEND_BATCHSIZE
- Set Up the Notification Mailer
- Set Up the Distributed Processing Server
- Set Up Client Computers
- Run the Health Check Scripts
-
6
Integrating Other Systems
- Integrating Oracle Clinical with the Oracle Life Sciences Data Hub
- Integrating SAS with the Oracle Life Sciences Data Hub
- Integrating Oracle SQL Developer or Oracle SQL*Plus with the Oracle Life Sciences Data Hub
- Integrating Oracle Business Intelligence Enterprise Editions (OBIEE) for Visualizations
- 7 Supported Upgrade Paths
- 8 Upgrade the Thesaurus Management System Database (TMS) to Release 5.4
-
9
Upgrading to Oracle LSH Release 3.4
- Run the Start Maintenance Script
- Stop Server Processes
- Back Up the Oracle E-Business Suite Database
- Upgrade to Oracle LSH 3.4
- Run the Post-Installation Programs
- Post-Upgrade Database Tasks
-
Set Up the Distributed Processing Server
- Create the Distributed Processing Server User Account
- Install the Distributed Processing Server
- Secure Distributed Processing Server Files
- Set NLS_LANG to UTF8
- Copy and Edit Files
- Define Service Locations and Services
- Start the Distributed Processing Server
- Start the Message Queue
- Restart and Enable the Job Queue
- Run the Stop Maintenance Script
- Start Server Processes
- Run the Health Check Scripts
-
Migrate Secure File
- Initiate the Secure File Migration of CDR_INSTALLATION_LOG
- Monitor the Secure File Migration of CDR_INSTALLATION_LOG
- Post Secure File Migration Task for CDR_INSTALLATION_LOG
- Initiate the Secure File Migration of CDR_OUTPUT_BLOBS
- Monitor the Secure File Migration of CDR_OUTPUT_BLOBS
- Post Secure File Migration Task for CDR_OUTPUT_BLOBS
- Initiate the Secure File Migration of CDR_OUTPUT_CLOBS
- Monitor the Secure File Migration of CDR_OUTPUT_CLOBS
- Post Secure File Migration Task for CDR_OUTPUT_CLOBS
- Initiate the Secure File Migration of CDR_INSTALL_SCRIPTS
- Monitor the Secure File Migration of CDR_INSTALL_SCRIPTS
- Post Secure File Migration Task for CDR_INSTALL_SCRIPTS
- Migrate Secure File for DME_DISC_CSV_FILES
- 10 What's Next
- 11 Revision History
- A Architecture Overview