Post-migration tasks - enabling text search feature on Oracle database

You can enable the test search feature on an Oracle database after you perform your migration.

About this task

To enable the Text Search feature on an Oracle Database, perform these tasks:

Procedure

  1. Ensure that the Oracle database is configured with the Oracle Text feature.
  2. Log in to the Oracle server with a user ID having the CTXAPP privilege.
  3. If upgrading in nonsharded mode, run the create.sql script and the update.sql script from the <INSTALL_DIR>/Migration/9.5/database/scripts/oracle/textsearch directory.

    -or-

    If upgrading in sharded mode, run the create.sql script and the update.sql script from the following directories for each colony:

    • <INSTALL_DIR>/Migration/9.5/database/scripts/oracle/textsearch/TRANSACTION
    • <INSTALL_DIR>/Migration/9.5/database/scripts/oracle/textsearch/MASTER
    • <INSTALL_DIR>/Migration/9.5/database/scripts/oracle/textsearch/CONFIGURATION
    • <INSTALL_DIR>/Migration/9.5/database/scripts/oracle/textsearch/STATISTICS

      The create.sql script creates the text search indices (if it contains any scripts) and the update.sql script updates the existing text search indices (if it contains any scripts).

  4. (Optional) For the Context type text search index, execute the following command or commands, depending on your upgrade mode, to enable the text search indices to be incrementally updated when a text search enabled column is modified.

    If upgrading in nonsharded mode, run the modify.sql script from the <INSTALL_DIR>/Migration/9.5/database/scripts/oracle/textsearch directory.

    -or-

    If upgrading in sharded mode, run the modify.sql script from the following directories for each colony:

    • <INSTALL_DIR>/Migration/9.5/database/scripts/oracle/textsearch/TRANSACTION
    • <INSTALL_DIR>/Migration/9.5/database/scripts/oracle/textsearch/MASTER
    • <INSTALL_DIR>/Migration/9.5/database/scripts/oracle/textsearch/CONFIGURATION
    • <INSTALL_DIR>/Migration/9.5/database/scripts/oracle/textsearch/STATISTICS
      Note: Perform step 5 only if the text search index creation is successful.
  5. Use the <INSTALL_DIR>/properties/customer_overrides.properties file to set the following property:

    yfs.db.textsearch to Y

  6. Ensure that the value of the yfs.db.textsearch.oracle.contexttype property in the yfs.properties file is set to "ctxcat" or "context" depending on the type of text search index.

    You can use the <INSTALL_DIR>/properties/customer_overrides.properties file to override the yfs.db.textsearch.oracle.contexttype property.

    Note: To drop the text search indices from the Oracle database, run the drop.sql script.