IBM Support

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

News


Abstract

IBM FileNet Image Services now support remote Oracle 21.3 multi-tenant, pluggable databases (PDB) and container databases (CDB) on platforms HP-Itanium and Windows from 4.1.2 fix pack 28 (4.1.2.28) and 4.2.0 fix pack 18 (4.2.0.18).

Content

The remote Oracle 21.3 multitenant, pluggable, and container databases are supported on the following platforms:
  • Image Services 4.1.2: HP Itanium and Windows
  • Image Services 4.2.0: HP Itanium and Windows
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 21.3 and create the required container and pluggable databases.image 12780image 12803image 12805
  2. Set the ORACLE_HOME variable to the Oracle home path, and set the ORACLE_SID to the container database or global database name.
  3. Connect to the database by using the command: Sqlplus “/as sysdba”image 12806
  4. Check your connection by using the command: Show con_nameimage 12807
  5. Check the container database exists by using the command: Select name from v$containers; image 12808
  6. Alter the session to work with your pluggable database by using the command: Alter session set container=pdb1; image 12810
  7. Ensure you are connected to the pluggable database by using the command: Show con_name

    image 12811

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

    image 12812

  9. 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;
  10. 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 12813

    image 12814

  11. 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/21.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/21.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)
        )
      )
  12. Start the listener using the following commands:

          a) lsnrctl
          b) LSNRCTL> start

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

    image 12816

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 21.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/21.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 12817

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

    For example: sqlplus f_sw/password

    image 12818

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

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 12822

    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 12823

  7. Create database tables using this command: fn_util initrdb

    image 12824

  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":"a8m50000000CdyTAAS","label":"FileNet Image Services-\u003EImage Service"}],"Platform":[{"code":"PF033","label":"Windows"},{"code":"PF057","label":"HP"}],"Version":"4.1.2;4.2.0"}]

Document Information

Modified date:
15 December 2023

UID

ibm16767617

Page Feedback