Oracle Ultra Search - Invalid Objects

Dear DBAs and experts,
I have a multitude of invalid objects in my database related to Oracle Ultra Search.
To clean up I tried to recompile these objects using the following commands:

execute dbms_utility.compile_schema ('PUBLIC');

Open in new window


and using the utlrp.sql script for all sys objects.

I still have the following objects left as invalid:

PUBLIC	WK$SYS_ADMIN_LIST	SYNONYM
PUBLIC	WK$INST_LIST	SYNONYM
PUBLIC	OUS_INSTANCES	SYNONYM
WKSYS	WK$IS_ADMIN	FUNCTION
WKSYS	OUS_INSTANCES	VIEW
WKSYS	WK$POST_OPTIMIZE_INDEX	PROCEDURE
WKSYS	WK$USERID	FUNCTION
WKSYS	WK_QUERYAPI	PACKAGE BODY
WKSYS	WK_SNAPSHOT	PACKAGE BODY
WKSYS	WK_LDAP	PACKAGE BODY
WKSYS	WK_UTIL	PACKAGE BODY
WKSYS	WK_ACL	PACKAGE BODY
WKSYS	WK_ADM	PACKAGE BODY
WKSYS	WK_CRW	PACKAGE BODY
WKSYS	WKDS_ADM	PACKAGE BODY
WKSYS	WK_JOB	PACKAGE BODY
WKSYS	WK$SYS_ADMIN_LIST	VIEW
WKSYS	WK$INST_LIST	VIEW
WKSYS	WK$PRE_OPTIMIZE_INDEX	PROCEDURE

Open in new window


Could you please give me an advice what I should do with these objects? I would favour to recompile them somehow instead of dropping them. However, the described methods did not work for me.

Many thanks for your help,

skahlert2010
skahlert2010Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

phoenixiorCommented:
Hi skahlert2010,

What exactly do you want to do ? If you're talking about dropping the objects, then maybe you could uninstall the Ultra Search module. You can follow Metalink note 337992.1.

++
0
skahlert2010Author Commented:
Hi phoenixior!

Thanks for you response!

Since the ultrasearch is already installed with uncompilable, invalid objects, I'd like to fix the invalid objects. I followed your hint and had a look at the metalink solution. However, the directory ultrasearch and wk0setup.sql are missing in my ORACLE_HOME. I made a complete search for the file with no hit.

Is there another solution you know?

Many thanks,

skahlert2010
0
phoenixiorCommented:
Hi skahlert2010,

Which Oracle version do you use ? The Metalink Note that I gave to you was for Oracle 10g (il you use Oracle 9i, then the note is the 222517.1).
I suggest you to reinstall it properly if you really need this option on your database.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

skahlert2010Author Commented:
Hi Phoenixior!
I use version 10.2.0.1.0!

Like I said, I would reinstall it properly if I had the requiered scripts in that respective ultrasearch directory, which is missing!

Thanks anyway!

Best regards,

skahlert2010
0
phoenixiorCommented:
Hi,

As noticed in the first Metalink Note, in Oracle 10g Release 2 (10.2), if you plan to use the Ultra Search product, then you must complete the Oracle Database 10g Products installation from the Companion CD (with or without DBCA).

Please ensure that Oracle Text and Oracle JVM are setup correctly too !

Only on 10.2.0.1 you must install Patch 4709052 before running DBCA.

++

Phoenixior
0
skahlert2010Author Commented:
Thanks for the additional info! I will give it a try! Good job!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.