IBM Security Access Manager for Enterprise Single Sign-On, Version 8.2

Preparing a database server with Oracle

Install the Oracle database server and configure it based on the IMS Server database server requirements and settings.

Installation

For the supported databases and versions, see "Hardware and software requirements" in the IBM® Security Access Manager for Enterprise Single Sign-On Planning and Deployment Guide.

This guide provides information about configuring databases for the IMS Server. For the detailed and up-to-date installation instructions, see the database product documentation.
  1. Prepare the Oracle installation media.
  2. Install and configure the Oracle database server.
  3. Install the latest service packs for the Oracle database server.
Important: WebSphere® Application Server fix packs 15 and 17 might have connectivity problems with Oracle. See this site for more details: http://www-01.ibm.com/support/docview.wss?uid=swg21497098.

As workaround, install the interim fix before running the IMS configuration wizard. See http://www-01.ibm.com/support/docview.wss?uid=swg24029891 for more details.

Database requirements and settings

Oracle automatically creates the database.

Ensure that you comply with these requirements and settings:
Oracle database requirements
  • You must have a database instance name.
  • Set database character to Unicode (AL32UTF8).
  • Set national character to UTF8 - Unicode 3.0 UTF-8 Universal character set, CESU-8 compliant, or AL16UTF16 - Unicode UTF-16 Universal character set.
Database user requirements
  • Set default tablespace to USERS.
  • Set temporary tablespace to TEMP.
  • Assign user with a Connect and Resource role.
  • Assign user with the following privileges:
    • Create Procedure
    • Create Session
    • Create Table
    • Create View
Parent topic: Preparing the database server

Feedback