Preface

This preface contains the following topics:

Audience
Documentation Accessibility
Finding Information and Patches on My Oracle Support
Finding Oracle Documentation
How to Use AutoPatch
Oracle CPU Security Updates
Related Documents
Conventions

This book describes how to install Oracle Life Sciences Data Hub (Oracle LSH) Release 2.1.4.

Audience

This manual is written for people with the skill set and education described below. If your staff lacks these skills, Oracle recommends that you engage Oracle Consulting.

Required Course

Oracle recommends that you take the 5-day Oracle University course "11i Install, Patch, and Maintain Oracle Applications." This course provides students with a basic understanding of the architecture, database and file system used in Oracle Applications Release 11i. Students learn about the multi-tier architecture used to provide user access over the Internet or an intranet and the relationship between Oracle Applications and the Oracle database.

Students also learn how to:

Use Rapid Install to perform both single- and multi-node installations of Oracle Applications
Use the AD utilities to maintain Oracle Applications
Patch Oracle Applications using Autopatch
Use Rapid Clone to clone an Oracle Applications system

At the time of publication of this document, further information about this course was available at:

http://education.oracle.com/pls/web_prod-plq-dad/show_desc.redirect?dc=D17423GC51&p_org_id=1001&lang=US&source_call=

and from Oracle University by telephone at (USA) 800 529 0165.

Recommended Course for IT System Administrators

The person responsible for installing Oracle LSH needs support from IT/System Administrators. Oracle recommends that these administrators take the 5-day Oracle University course "11i System Administrator Fundamentals." In this course students learn concepts and functions that are critical to the System Administrator role, including information useful for implementing and managing the 11i E-Business Suite. Tasks covered include setting up security and user management, concurrent processing, profiles, and workflows; students also learn how to personalize Oracle E-Business Suite Forms and HTML pages. In addition, students learn how to monitor and audit an E-Business Suite system.

The System Administrator Fundamentals course provides the foundation needed to effectively control security and ensure smooth operations for an E-Business Suite installation. Demonstrations and hands-on practice reinforce the fundamental concepts.

At the time of publication of this document, further information about this course was available at:

http://education.oracle.com/pls/web_prod-plq-dad/show_desc.redirect?dc=D14411GC30&p_org_id=1001&lang=US&source_call=

and from Oracle University by telephone at (USA) 800 529 0165.

Required Skills

Installing Oracle LSH requires a level of knowledge equivalent to having mastered the material in Oracle's DBA Architecture and Administration courses.

You must be able to do the following in SQL*Plus:

Read and edit scripts
Run scripts and review log files for Oracle errors

You must be able to do the following in UNIX:

Install Oracle software and patches
Identify space on a file system for Oracle database tablespaces
Set and use environment variables
Edit files using vi or another editor
Run scripts and review log files

You also need expertise in:

Network administration
Cluster file systems—when not using Oracle Automated Storage Manager (ASM) or Oracle Cluster File System (OCFS)

Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible to all users, including users that are disabled. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/.

Accessibility of Code Examples in Documentation

Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/us/support/contact-068555.html or visit http://www.oracle.com/us/corporate/accessibility/support/index.html if you are hearing impaired.

Finding Information and Patches on My Oracle Support

Your source for the latest information about Oracle Life Sciences Data Hub is Oracle Support's self-service Web site My Oracle Support (formerly MetaLink).

Before you install and use an Oracle software release, always visit the My Oracle Support Web site for the latest information, including alerts, release notes, white papers, and patches.

Creating a My Oracle Support Account

You must register at My Oracle Support to obtain a user name and password account before you can enter the Web site.

To register for My Oracle Support:

Open a Web browser to https://support.oracle.com.
Click the Register link to create a My Oracle Support account. The registration page opens.
Follow the instructions on the registration page.

Signing In to My Oracle Support

To sign in to My Oracle Support:

Open a Web browser to https://support.oracle.com.
Click Sign In.
Enter your user name and password.
Click Go to open the My Oracle Support home page.

Searching for Knowledge Articles by ID

The fastest way to search for information, including alerts, White Papers, installation verification (smoke) tests, and bulletins is by the article ID number, if you know it.

To search by article ID:

Sign in to My Oracle Support at https://support.oracle.com.
Locate the Search box in the upper right corner of the My Oracle Support page.
Click the sources icon to the left of the search box, and then select Article ID from the list.
Enter the article ID number in the text box.
Click the magnifying glass icon to the right of the search box (or press the Enter key) to execute your search.

The Knowledge page displays the results of your search. If the article is found, click the link to view the abstract, text, attachments, and related products.

In addition to searching by article ID, you can use the following My Oracle Support tools to browse and search the knowledge base:

Product Focus — On the Knowledge page, you can drill into a product area through the Browse Knowledge menu on the left side of the page. In the Browse any Product, By Name field, type in part of the product name, and then select the product from the list. Alternatively, you can click the arrow icon to view the complete list of Oracle products and then select your product. This option lets you focus your browsing and searching on a specific product or set of products.
Refine Search — Once you have results from a search, use the Refine Search options on the right side of the Knowledge page to narrow your search and make the results more relevant.
Advanced Search — You can specify one or more search criteria, such as source, exact phrase, and related product, to find knowledge articles and documentation.

Searching by Product and Topic

You can use the following My Oracle Support tools to browse and search the knowledge base:

Product Focus — On the Knowledge page under Select Product, type part of the product name and the system immediately filters the product list by the letters you have typed. (You do not need to type "Oracle.") Select the product you want from the filtered list and then use other search or browse tools to find the information you need.
Advanced Search — You can specify one or more search criteria, such as source, exact phrase, and related product, to find information. This option is available from the Advanced link on almost all pages.

Finding Patches on My Oracle Support

Be sure to check My Oracle Support for the latest patches, if any, for your product. You can search for patches by patch ID or number, or by product or family.

To locate and download a patch:

Sign in to My Oracle Support at https://support.oracle.com.
Click the Patches & Updates tab. The Patches & Updates page opens and displays the Patch Search region. You have the following options:
- In the Patch ID or Number field, enter the number of the patch you want. (This number is the same as the primary bug number fixed by the patch.) This option is useful if you already know the patch number.
- To find a patch by product name, release, and platform, click the Product or Family link to enter one or more search criteria.
Click Search to execute your query. The Patch Search Results page opens.
Click the patch ID number. The system displays details about the patch. In addition, you can view the Read Me file before downloading the patch.
Click Download. Follow the instructions on the screen to download, save, and install the patch files.

Finding Oracle Documentation

The Oracle Web Site contains links to all Oracle user and reference documentation. You can view or download a single document or an entire product library.

Finding Oracle Health Sciences Documentation

To get user documentation for Oracle Health Sciences applications, go to the Oracle Health Sciences documentation page at:

http://www.oracle.com/technetwork/documentation/hsgbu-154445.html

Note:

Always check the Oracle Health Sciences Documentation page to ensure you have the latest updates to the documentation.

Finding Other Oracle Documentation

To get user documentation for other Oracle products:

Go to the following Web page:

http://www.oracle.com/technology/documentation/index.html

Alternatively, you can go to http://www.oracle.com, point to the Support tab, and then click Documentation.
Scroll to the product you need and click the link.
Click the link for the documentation you need.

How to Use AutoPatch

For complete information on using AutoPatch and an explanation of the Oracle Applications patching system and terminology, see:

Oracle Applications Maintenance Utilities Release 11i (11.5.10.2)
Oracle Applications Maintenance Processes Release 11i (11.5.10.2)

AutoPatch has a command prompt interface.

The basic steps required to apply a patch using AutoPatch are as follows. See the books mentioned above for detailed instructions.

Set the environment. You must set the environment to apply the configuration parameters that define your system. See Oracle Applications Maintenance Utilities Release 11i (11.5.10.2) for further information.
Unzip patches. Create a patch top directory, if it doesn't already exist. Download the patch and unzip it into this directory.
Review information in the readme file. The readme file contains instructions for applying the patch, including any prerequisite patches and/or manual steps.
Shut down services. If you are applying the patch to a node that contains the Concurrent Processing Server, Web Server, or Forms Server, you must shut down the Concurrent Managers, Web Server Listeners, or Forms Server Listeners respectively.
Enable Maintenance Mode. Use the Change Maintenance Mode option in AD Administration to enable maintenance mode. See "Change Maintenance Mode" in Oracle Applications Maintenance Utilities.

Note:
Maintenance mode enhances patching performance but restricts users' access to Oracle Applications.
Start AutoPatch. AutoPatch is located in the AD_TOP/bin directory. However, you start it from the directory that contains the unzipped patch files. Use the following command:

$ adpatch

You can customize the way AutoPatch runs by adding arguments to the command line. See "Command Line Arguments" in Oracle Applications Maintenance Utilities.
Respond to prompts. Respond to the AutoPatch prompts for information about your system.
Apply driver. Patches contain a single unified driver (u).
Exit AutoPatch. When the patching process is complete, AutoPatch displays a message informing you that the process has been completed successfully. If the process did not run to completion, check the log file(s) and determine what caused the problem.

The primary log file is located in APPL_TOP/admin/Oracle SID/log default name adpatch.log. In addition, some patch tasks may create separate log files in the same directory. If the patching process used multiple workers, each worker creates its own log file.
Disable Maintenance Mode. Use the Change Maintenance Mode menu of AD Administration to disable maintenance mode. See "Change Maintenance Mode" in Oracle Applications Maintenance Utilities.
Restart server processes. After verifying that the patch was applied successfully, start all server processes and allow users to access the system.
Pre-allocate space for packages, functions, and sequences (optional). If AutoPatch has modified Oracle Applications database objects, you may want to run ADXGNPIN.sql and ADXGNPNS.sql to allocate space ("pin") for new packages and sequences in the Oracle System Global Area. These scripts are located in AD_TOP/sql. See "Pre-allocating Space for Packages and Functions" in Oracle Applications Maintenance Processes.
Delete or archive AutoPatch backup files. Once you have tested the patched system, you can delete the backup copies of files from the patch top directories to recover disk space, as necessary. Oracle recommends archiving these files if you have space available.

Oracle CPU Security Updates

Oracle Corporation publishes a CPU Security Update patch quarterly. Install these patches on every computer with an Oracle Home. Check My Oracle Support's Oracle Clinical Knowledge page for information on the latest patch tested with Oracle Health Sciences applications.

Conventions

The following text conventions are used in this document:

Convention	Meaning
boldface	Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.
italic	Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.
`monospace`	Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.