IBM Support

Image Services: Added support for remote Oracle 19.3 multitenant, pluggable and container databases

Release Notes


Abstract

IBM FileNet Image Services now support remote Oracle 19.3 multi-tenant, pluggable databases (PDB) and container databases (CDB) on all the supported platforms from 4.1.2 fix pack 28 (4.1.2.28) and 4.2.0 fix pack 16 (4.2.0.16) except Solaris and HP-UX on Image Services 4.1.2.

Content

The remote Oracle 19.3 multitenant, pluggable, and container databases are supported on the following platforms:
  • Image Services 4.1.2: AIX, HP-Itanium, Windows (does not support HP-UX and Solaris)
  • Image Services 4.2.0: All the supported platforms (AIX, Solaris, HP-Itanium, Windows)
The Oracle 19.3 multitenant, pluggable, and container databases are not supported on the local Servers.
A. Creating and configuring container database (CDB) and pluggable database (PDB) on Oracle server

You need to be an Oracle database administrator (DBA) to create a container and pluggable databases on Oracle servers.

  1. As an Oracle DBA, install Oracle 19.3 or later on a 64-bit AIX server.
  2. As an Oracle DBA, use the Database Configuration Assistant (DBCA) tool, to create the required container and pluggable databases.

    Image 1

    Image 2

    Image 3

  3. Set the ORACLE_HOME variable to the Oracle home path, and set the ORACLE_SID to the container database or global database name.
  4. Connect to the database using the command: sqlplus “/as sysdba”

    Image 4

  5. Check your connection using the command: show con_name

    Image 5

  6. Check the container database exists using the command: select name from v$containers; 

    Image 6

  7. Alter the session to work with your pluggable database using the command: alter session set container=pdb1;

    Image 7

  8. Ensure you are connected to the pluggable database using the command: show con_name

    Image 8

  9. By default, the pluggable database is in a mounted state. Enable read and write mode on the database using the command: alter pluggable database pdb1 open;

    Image 9

  10. To create the required table spaces and Image Services (IS) database users in the pluggable database, refer to  Guidelines for Installing and Configuring Oracle Software on UNIX Servers (Site-Controlled).

    The following example illustrates how to create table spaces and Image Services database users:

    1. CREATE TABLESPACE fnsys_ts LOGGING
      DATAFILE '/home/oracle/app/oracle/tablespace/fnsys_ts.dbf'
      SIZE 200M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED
      EXTENT MANAGEMENT LOCAL;
    2. CREATE TABLESPACE fnidx_ts LOGGING
      DATAFILE '/home/oracle/app/oracle/tablespace/fnidx_ts.dbf'
      SIZE 200M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED
      EXTENT MANAGEMENT LOCAL;
    3. CREATE TABLESPACE fnusr_ts LOGGING
      DATAFILE '/home/oracle/app/oracle/tablespace/fnusr_ts.dbf'
      SIZE 200M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED
      EXTENT MANAGEMENT LOCAL;
    4. CREATE TEMPORARY TABLESPACE fntmp_ts
      TEMPFILE '/home/oracle/app/oracle/tablespace/fntmp_ts.dbf'
      SIZE 400M REUSE
      EXTENT MANAGEMENT LOCAL UNIFORM SIZE 16M;
    5. create user f_sw identified by fnsw;
    6. grant create session to f_sw;
    7. create user f_sqi identified by fnsw;
    8. grant create session to f_sqi;
    9. create user f_open identified by fnsw;
    10. grant create session to f_open;
    11. create user f_maint identified by fnsw;
    12. grant create session to f_maint;
  11. Copy files from the Image Services server to the Oracle server. The files are available at /fnsw/oracle/FileNet.sql and /fnsw/local/oracle/ora_users.sql.

    Run the following scripts within the SQL prompt to provide required permissions to users:
          a) FileNet.sql
          b) ora_useres.sql

    For example, SQL> @/xxx/xxx/FileNet.sql and SQL> @/xxx/xxx/ora_users.sql
        

    Image 10

    Image 11

  12. Create or modify the listener.ora and tnsnames.ora files in the $ORACLE_HOME/network/admin directory. You can also use the netmgr Oracle tool to create these configuration files.

    For example:
    listener.ora
    # listener.ora Network Configuration File:
    /home/oracle/app/oracle/product/19.3.0/dbhome_1/network/admin/listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = “xx.xx.xx.xx”)(PORT = 1521))
      )
    ADR_BASE_LISTENER = /home/oracle/app/oracle

    tnsnames.ora
    # tnsnames.ora Network Configuration File: /home/oracle/app/oracle/product/19.3.0/dbhome_1/network/admin/tnsnames.ora
    # Generated by Oracle configuration tools.
    ORCL =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = “xx.xx.xx.xx”)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = ORCL)
        )
      )
  13. Start the listener using the following commands:

          a) lsnrctl
          b) LSNRCTL> start

  14. Ensure your connection is working. From the command prompt use the command: tnsping <CDB name / Global DB name>

    Image 12

    B. Establishing the connection between the Oracle client and server

    Perform these steps on the Oracle client. You must be an Oracle database administrator (DBA) to create the container database and pluggable database.

    1. As an Oracle dba user, install the Oracle 32-bit 19.3.0 client or later on the Image Services server.
    2. Copy tnsnames.ora from Oracle server to $ORACLE_HOME/network/admin directory.
    3. Add an entry for the pluggable database (example, pdb1) in tnsnames.ora. See the highlighted text below.
          # tnsnames.ora Network Configuration File:
      /home/oracle/app/oracle/product/19.3.0/dbhome_1/network/admin/tnsnames.ora
          # Generated by Oracle configuration tools.
          ORCL =
            (DESCRIPTION =
              (ADDRESS_LIST =
                (ADDRESS = (PROTOCOL = TCP)(HOST = “xx.xx.xx.xx”)(PORT = 1521))
              )
              (CONNECT_DATA =
                (SERVICE_NAME = ORCL)
              )
            )

          PDB1 =
            (DESCRIPTION =
              (ADDRESS_LIST =
                (ADDRESS = (PROTOCOL = TCP)(HOST = “xx.xx.xx.xx”)(PORT = 1521))
              )
              (CONNECT_DATA =
                (SERVICE_NAME = PDB1)
              )
            )

    4. Set ORACLE_HOME to the home directory of the installed Oracle client. Set ORACLE_SID, TWO_TASK to the pluggable database name (example, pdb1).
    5. Ensure the client connection to the server is active using the command: tnsping <PDB name>

      Image 13

    6. Connect to the pluggable database using the command: sqlplus <username/password>

      For example: sqlplus f_sw/password

      Image 14

    7. Ensure the connection to the pluggable database is functioning.

      Image 15

    C. Configuring Image Services server for database migration

    1. Stop Image Services (IS) using these commands:
      1. initfnsw -y stop
      2. killfnsw -ADyS
    2. Take a backup of the database.
    3. Change the Oracle system ID (Oracle SID) in fn_edit tool using these commands:
      1. fn_edit
      2. Change the Oracle SID field in Relational Databases tab with your PDB name configured on Oracle server.

        For example, pdb1 is PDB name as shown below.

        Image 16
      3. Save the changes and exit from fn_edit tool.
    4. Run this command to reflect the above changes in the configuration: fn_build -a
    5. Make sure the following variables are set properly:
      1. ORACLE_HOME to the home directory of installed Oracle client.
      2. ORACLE_SID to PDB name.
      3. TWO_TASK to PDB name.
    6. Run the following commands to validate Oracle Home, Oracle SID, Oracle version, Oracle users and grant required permissions on your existing IS Server:
      1. fn_setup_rdb -u
      2. Enter required input as Oracle Home, Oracle SID, Oracle Version.
        Image 17

        For example:

        Image 18

    7. Create database tables using this command: fn_util initrdb

      Image 19

    8. Restore Oracle backup.
    9. Start Image Services using this command: initfnsw start
    10. Check the elogs for any errors.

    D. Configuring Image Services server for fresh installation

    1. Run fn_edit
    2. Add the database version, Oracle Home path, and the ORACLE_SID (set to the pluggable database name).
    3. Save the changes and exit fn_edit.
    4. Run the following command to pick up the configuration changes: fn_build -a
    5. Make sure the following variables are set correctly:
      1. ORACLE_HOME to the home directory of the installed Oracle client.
      2. ORACLE_SID to the pluggable database name.
      3. TWO_TASK to the pluggable database name.
    6. Run the following commands to validate the ORACLE_HOME, ORACLE_SID, and TWO_TASK settings, and to grant the required permissions on the Image Services server: fn_setup_rdb -f
    7. Create the Multi-Keyed File (MKF) and relational database tables using this command: fn_util init

[{"Type":"MASTER","Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSNVUD","label":"FileNet Image Services"},"ARM Category":[{"code":"a8m50000000Cdy8AAC","label":"FileNet Image Services"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF057","label":"HP"}],"Version":"4.1.2;4.2.0"}]

Document Information

Modified date:
13 July 2023

UID

ibm11114959

Page Feedback