Infrastructure Technology Group – APPSINFODB

Finding solutions for DBA's to smile…….!!!!!!! DBA its just not Administration, its core of customer’s Data Integrity

  • Blog Stats

    • 43,301 hits
  • Visitors

    free counters
  • Vistors Access

  • Calendar

    June 2019
    M T W T F S S
    « Apr    
  • Archives

  • Authors

Archive for the ‘Oracle Life Sciences’ Category

Oracle Life Science Installation

Posted by appsinfo on April 4, 2009

Oracle Life Sciences Installtion on 2-Node Server

Step 1:

Install Oracle 9i database with the following components

  • Oracle9i Database
  • Oracle9i
  • Enterprise Edition Options
  • Oracle OLAP
  • Oracle Net Services
  • Oracle Net Listener (This is required)
  • Oracle9i Development Kit
  • Oracle C++ Call Interface
  • Oracle Call Interface (OCI)
  • Oracle Programmer
  • Oracle XML Developer’s Kit

Step 2:

Patching the Oracle 9i RDBMS

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\

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.

Unlock CTXSYS database account and reset password (The default for the AERS / TMS installation is ‘ctxsys’).

Unlock XDB account.


In SQL*Plus, logged in as SYS “as sysdba”, add the following parameter to SPFILE:


SQL> alter system set “_system_trig_enabled”=true;


Add a folder/directory named “shadow_view” to the RDBMS server and note the path as you are prompted during the installation for this path. This is required for AERS Database install.

Examples: windows = d:\shadow_view” , for unix/linux = “/u01/shadow_view”

Add shared folders d:\e2b_output, d:\e2b_input, d:\e2b_output_temp. These are folders used by E2B as defined by the utl_file_dir parameter.

For Metadata installation only (may be changed after installed), ensure init.ora parameter for “remote_login_passwordfile” is set to either EXCLUSIVE or SHARED.

Step 6: Upgrade Database ( –

The AERS database server requires Oracle Enterprise Edition, plus Oracle patch set Enterprise Edition at publication time. The upgrade is achieved using standard oracle patching.

Pre-Installation Tasks

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 located in the unzipped area of the patch set. For example,




Installation Prompt


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> SPOOL patch. log

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


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 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.

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


Posted in Oracle Life Sciences | Leave a Comment »

Oracle Life Sciences Applications Overview

Posted by appsinfo on April 4, 2009



In next post I will discuss more on Oracle Life Sciences, AERS and TMS.

Oracle Life Sciences Applications


Note: This document provides detail steps for installing & preparation of Oracle Life Science Application Ver 4.6 in a windows environment.


The procedure consists of the following technology stack


·         Oracle 9i Database,

·         Oracle Middle Tier 10g AS,

·         TMS 4.6

·         AERS 4.6




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.


For more information on architecture and installation refer oracle metalink Note 405777.1: Abstract – Oracle Adverse Event Reporting System Installation Guide 4.6.


Posted in Oracle Life Sciences | 1 Comment »