Well, well, well!
It's Farren Minns! Hehe. I also upgraded from 8.1.7.4 to Oracle 10GR2 (10.2.0.1.0). Then I applied the patch making it 10.2.0.2.0. However, I had to install the Java stuff from the companion Database (DISK) (see DVD #1) before applying the patch. By installing the Java stuff from the Companion Database, I was upgrading InterMedia, CTX, etc. Also, did you check to see if you have any invalid objects?
Have a great Day!
Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Farren Minns [mailto:oracledba-ezmlmshield-x5413254.[Email address protected]
Sent: Wednesday, January 31, 2007 6:11 AM
To: LazyDBA Discussion
Subject: 8.1.7.4 to 10g and full text index question
Hello all
I have recently upgraded an 8.1.7.4 database to 10gR2 on Solaris 2.9. Now,
when it was 8.1.7.4 I updated a full text index with the following command
(once the correct envrinoment had been set).
begin
ctx_ddl.sync_index(idx_name=>'i_gav_ft');
end;
/
begin
ctx_ddl.optimize_index(idx_name=>'i_gav_ft',optlevel=>ctx_ddl.optlevel_fast);
end;
/
But now, on 10g I get the following error.
And I get the following error
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-11422: linguistic initialization failed
DRG-11446: supplied knowledge base file
/usr/local/oracle/product/dora10d/ctx/data/enlx/droldUS.dat not installed
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 539
ORA-06512: at line 2
Have things changed in 10g in the way I should refresh a full text index?
Many thanks
Farren
----------------------------------------------------------------------
The information contained in this e-mail and any subsequent
correspondence is private and confidential and intended solely
for the named recipient(s). If you are not a named recipient,
you must not copy, distribute, or disseminate the information,
open any attachment, or take any action in reliance on it. If you
have received the e-mail in error, please notify the sender and delete
the e-mail.
Any views or opinions expressed in this e-mail are those of the
individual sender, unless otherwise stated. Although this e-mail has
been scanned for viruses you should rely on your own virus check, as
the sender accepts no liability for any damage arising out of any bug
or virus infection.
John Wiley & Sons Limited is a private limited company registered in
England with registered number 641132.
Registered office address: The Atrium, Southern Gate, Chichester,
West Sussex, PO19 8SQ.
----------------------------------------------------------------------
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page