We include the Windows 2000 or Windows 2003 version of the Patch Set on the B30940-01 Oracle (R) Life Sciences 4.6 – Disk 2 of 3 at: patches\p4163445_92070_WINNT.zip.

Extract this zip file to a location that is accessible to the back end.

Step 3: Create Database Instance

Create a database suitable for the Metadata Repository and the AERS application. This is pre-requisite for Middle Tier Repository.

In general, you create a database for the middle-tier application server Metadata Repository and the AERS and TMS applications. Collect information such as host name and domain name for the computer on which the database resides, the database SID and port.

Use DBCA for creating the new database instance and set the parameters.

Step 4: Bounce the database

Stop and restart the database in order to acquire the new parameter settings after DBCA.

Step 5: Post-Database Creation Steps

The CTXSYS & XDB accounts in the Oracle database are locked by default after initial installation of the Database.

Complete the following pre-installation tasks before installing the patch set:

· Review Known Pre-installation Issues

· Creating a Database with Database Configuration Assistant

· Identify the Oracle9i Installation

· Download and Extract the Installation Software

· Shut Down Oracle Databases

· Stop All Processes

· Back Up the System

Shut Down Oracle Databases

Shut down any existing Oracle database instances with normal or immediate priority.

Stop All Processes

Stop all listener and other processes running in the Oracle home directory where you want to install the patch set.

Back Up the System

Installing the Patch Set Interactively

Follow the procedure to install the patch set interactively:

1. Log on as a member of the Administrators group to the computer on which to install Oracle components or if you are installing on a Primary Domain Controller (PDC) or a Backup Domain Controller (BDC), log on as a member of the Domain Administrators group.

2. Start Oracle Universal Installer release 10.1.0.4 located in the unzipped area of the patch set. For example,

Oracle_patch\setup.exe.

Installation Prompt

Action

Welcome Screen

Click Next

Specify File locations Screen

Click Browse and Select products.xml from stage directory

E.g. : Oracle_patch\stage\products.xml

Destination Section Screen

Select the appropriate Oracle home to Update & Click Next

Selected Nodes Screen

Click Next if installing on RAC Cluster

Summary Screen

Click Install

Step 7: Post Installation Task

Post Installation of Database after applying the Patch.

1. shutdown the database in normal

2. Connect as sysdba

SQL> STARTUP MIGRATE

SQL> SPOOL patch. log

SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\catpatch.sql

SQL> SPOOL OFF

3. Check for any errors in the log file and if needed rerun the catpatch.sql.

4. Shutdown

5. Startup

6. check invalid objects

7. Recompile all the invalid PL/SQL objects using utlrp.sql

8. Execute following SQL statement to check the version and status in the registry

select comp_name, status, version from dba_registry;

9. mod_plsql Postinstallation Steps

Complete the following steps only if mod_plsql is installed.The following steps should be repeated with all the database instances associated with this 9.2.0.7 Oracle home.

Run owa_patch.sql to update owa packages from mod_plsql patch directory:

Change to the ORACLE_BASE\ORACLE_HOME\Apache\modplsql\patch directory. For example,

C:\> cd ORACLE_BASE\ORACLE_HOME\Apache\modplsql\patch

Connect to the database instance as sysdba:

C:\> sqlplus ” / as sysdba”

SQL> @@owa_patch.sql

Check owa_patch_sid.log file for any errors.

Run the utlrp.sql script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.

Architecture

Oracle Life science Applications consist of 3-tier architecture. The first tier is the database tier where oracle 9i database is installed and oracle 10g AS metadata Repository is installed, Second Tier Application Tier consist of Application need to be deployed on the application server.