20.2 Identifying and Copying Oracle Text Files to a New Oracle Home

To upgrade Oracle Text, use this procedure to identify and copy required files from your existing Oracle home to the new release Oracle home. Complete this task after you upgrade Oracle Database.

Certain Oracle Text features rely on files under the Oracle home that you have configured. After manually upgrading to a new Oracle Database release, or after any process that changes the Oracle home, you must identify and move these files manually. These files include user filters, mail filter configuration files, and all knowledge base extension files. After you identify the files, copy the files from your existing Oracle home to the new Oracle home.

To identify and copy required files from your existing Oracle home to the new release Oracle home:
  1. Log in with the SYS, SYSTEM, or CTXSYS system privileges for the upgraded database.
  2. Under the Oracle home of the upgraded database, run the $ORACLE_HOME/ctx/admin/ctx_oh_files.sql SQL script.

    For example:

    sqlplus / as sysdba
connected
SQL> @?/ctx/admin/ctx_oh_files
  3. Review the output of the ctx_oh_files.sql command, and copy the files to the new Oracle home.