Installing Oracle Text Search Option

About Installing Oracle Text Search Option

The Installing Oracle Text Search allows you to install the Oracle Text Search feature. If your database already has text indexes, these indexes are dropped when you install this feature. The topics covered are:

To execute the Text Search option, these conditions must be met:

  • On UNIX, you belong to the dba group.

  • On Windows, you belong to the ORA_DBA group.

This task explains how to install Oracle Text Search Option:

  1. In the Database Selection window, select the database profile.

  2. In the navigation pad, select Build > Install Text Search Option, OR From the menu bar, select Build > Install Text Search Option.

  3. You are prompted for the CTXSYS password. Type the password.

  1. Enter the password and confirm it in the CTXSYS Password and Confirm fields respectively.

  2. In the navigation pad, select Build > Install Text Search Option. The Install Text Search Option window appears.

    The Size of Database, the Tablespace Name and Size, Datafile Name (with the path), Datafile Size and the Storage Management Parameters defined are displayed. You can do the following:

    • Click Add to add a new data file. You are prompted for the destination directory (on Windows only) and Datafile Size.
    • After entering these details, click OK to add this datafile to the selected tablespace.
    • Select a datafile, and then click Change to modify it. You can modify only the Destination Directory (on Windows only) and Datafile Name.
    • Select a datafile, and then click Delete to remove the file. You can delete any new datafiles, but each tablespace should have at least one data file.

      Make sure that the TNS listener port number is correct and listener is up and running. Otherwise, errors will be displayed.
  3. Click Finish to install the Text Search. If text indexes exist, a message that existing text indexes would be dropped, appears.

  4. Click Yes to proceed with the installation. The installation steps are displayed in the Progress page.

Progress

The Progress page displays the sequence of actions that are performed during Text Search installation.

As each action is completed, a check mark appears. All the actions taking place are also displayed in the bottom panel. When the installation process is completed, click Cancel to return to the main page.

Ignoring Errors

You can ignore the following errors that occur while installing Text Search:


ORA-01432: public synonym to be dropped does not exist

ORA-04043: object <object_name> does not exist

ORA-29807: specified operator does not exist

ORA-02289: sequence does not exist

ORA-00942: table or view does not exist

ORA-01418: specified index does not exist

ORA-01918: user CTXSYS does not exist

ORA-01919: role CTXAPP does not exist