Manual installation ultrasearch in Oracle database

Manual installation of database component ultrasearch in an Oracle database:

set echo on
spool ultrasearch.log
@$ORACLE_HOME/ultrasearch/admin/wk0setup.sql [ORACLE_HOME] "" SYS [PASSWORD SYS] "as sysdba" wksys SYSAUX TEMP "" "FALSE" DATABASE "" [ORACLE_HOME]/jdbc/lib/classes12.zip [ORACLE_HOME]/jlib/orai18n.jar [ORACLE_HOME]/jdk/bin/java /appl/oracle/db_10.2.0.4.0/ctx/bin/ctxhx [DB_HOSTNAME]:[DB_PORT]:[DB_SID] [DB_HOSTNAME]:[DB_PORT]:[DB_SID] [ORACLE_HOME]
spool off
exit

Check if the option is installed:

select comp_name, version, status from dba_registry
where COMP_ID='WK';

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.