Re: Logging in into UltraSearch

From: Christian Antognini <christian.antognini_at_trivadis.com>
Date: Sat, 17 Jul 2004 00:04:39 +0200
Message-ID: <40f850ce$1@post.usenet.com>

Post for FREE via your newsreader at post.usenet.com ****

> I've done an Enterprise Installation of Oracle 10g, and created a
database.
> In the oracle doc. it says that there should be users wk_test and wk_sys.
> But I don't see either of them in em console.
> The ultrasearch directory is there, though. I can start ultrasearch and
get
> to the login screen as well, but how to log in? With which
> username/password?

The schema owner of UltraSearch is WKSYS. You can also get this information with the following query:

SQL> select schema_name
2 from v$sysaux_occupants
3 where occupant_name = 'ULTRASEARCH';

SCHEMA_NAME

WKSYS Both WKSYS or WK_TEST can be used to login. If you forgot the password, just set it with the ALTER USER statement. If WKSYS and WK_TEST doesn't exist, UltraSearch isn't installed. On my test system I installed it with the following commands:

connect SYS/sysPassword as SYSDBA
set echo on
spool /u00/app/oracle/admin/A1010/create/log/ultraSearch.log @/u00/app/oracle/product/10.1.0/ultrasearch/admin/wk0install.sql SYS sysPassword wksysPassword SYSAUX TEMP "" PORTAL false; spool off

Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Received on Fri Jul 16 2004 - 17:04:39 CDT