Running UltraSearch americas cup win 2682133k1

Running UltraSearch

Oracle UltraSearch is a web-based search application based on Oracle Text. It can be used to index a wide variety of datasources like websites, databases, files etc. and to make these available for searching. It is available with a database, an application server or a collaboration suite installation. I’ll describe in this article how to get it up and running (as part of a database installation). This is a summary of the instructions on OTN.

When you install the 10g database, UltraSearch is automatically installed too, however it is not available immediately. Perform the following steps:

  1. Ugrade the (10g v1) database to version 10.1.0.4 (patch 4163362)
  2. Make sure that the executable ctxhx (on windows in the Oracle Home bin directory) is on the PATH environment variable. Now you can handle binary files
  3. Enable/unlock the database users wksys and wk_test.
  4. Add the following entry to the ORACLE_HOME/oc4j/j2ee/OC4J_SEARCH/config/data-sources.xml file (make sure to enter the correct url and password):


    This configures the jdbc datasource for the default search sample application
  5. Start the UltraSearch webapp: [Oracle install path]/BIN/searchctl start. This launches oc4j and deploys the admin and the example search webapp.

To perform a search you’ll first have to index your datasource(s). This is done with the admin application: http://[server]:5620/ultrasearch/admin/index.jsp. Check your portnumber in the database install info (portlist.ini), mine is 5620. Login with the wk_test user. During database install the wk_inst instance (as it’s called) has been installed. Select this and press the apply button. Now you can crawl a website or a directory or a database . You’ll find out how :-).
After this is done start the sample query application: http://[server]:5620/ultrasearch/query/search.jsp. Enter a search term and hit the button. Unfortunately, this failed with me 🙁 , but when I upgraded my 10.1.0.2 database it succeeded.

One Response

  1. Ian Timms January 5, 2006