[redhat-ccm-list] Re: Installation problems - Error executing the .sql files

[Kevin C. Flaherty]

Hi guys, just about to post and I found this... may I ask what the issue was? I am having similar problems with Oracle9i (9.2.0):

############################################

SQL>  @/var/www/ccm-core-cms/dist/WEB-INF/sql/ccm-core-cms/oracle-se/search/sear
ch-create.sql

Table created.

   ctx_ddl.create_section_group('autogroup', 'AUTO_SECTION_GROUP');
   *
ERROR at line 2:
ORA-06550: line 2, column 4:
PLS-00201: identifier 'CTX_DDL' must be declared
ORA-06550: line 2, column 4:
PL/SQL: Statement ignored


CREATE INDEX xml_content_index ON search_content(xml_content) INDEXTYPE IS ctxsy
s.context
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-12203: section group autogroup does not exist
ORA-06512: at "CTXSYS.DRUE", line 157
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 186



Index created.

create table content_change_time (
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object


create table search_indexing_jobs (
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object


insert into  search_indexing_jobs
*
ERROR at line 1:
ORA-00001: unique constraint (SCOTT.SEARCH_INDEXING_JOBS_PK) violated



Package created.


Package body created.

No errors.

#########################################

Here's what Richard Li (richardl at redhat.com) had to say:

> You didn't install or configure Intermedia properly when you set up 
> Oracle. Consult the Oracle instructions for help, or ask your DBA.
> 
> You can ignore this error if you don't use full-text search.
> 
> Richard
> 
> vijay anandh wrote:
> 
> >Hi,
> >
> >Im getting the following errors when i execute the
> >"core-platform-create.sql" file.
> >
> >Im using WindowsNT with Oracle8.1.7. 
> >
> >please help me out in solving this.
> >
> >************************************
> >  ctx_ddl.create_section_group('autogroup',
> >'AUTO_SECTION_GROUP');
> >   *
> >ERROR at line 2:
> >ORA-06550: line 2, column 4:
> >PLS-00201: identifier 'CTXSYS.CTX_DDL' must be
> >declared
> >ORA-06550: line 2, column 4:
> >PL/SQL: Statement ignored
> >
> >
> >CREATE INDEX xml_content_index ON
> >search_content(xml_content) INDEXTYPE IS
> >ctxsys.context
> >*
> >ERROR at line 1:
> >ORA-29855: error occurred in the execution of
> >ODCIINDEXCREATE routine
> >ORA-20000: file not found
> >DRG-12203: file not found
> >ORA-06512: at "CTXSYS.DRUE", line 126
> >ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 78
> >ORA-06512: at line 1
> >
> >
> >CREATE INDEX raw_content_index ON
> >search_content(raw_content) INDEXTYPE IS
> >ctxsys.context
> >*
> >ERROR at line 1:
> >ORA-29855: error occurred in the execution of
> >ODCIINDEXCREATE routine
> >ORA-20000: file not found
> >DRG-11206: file not found; arguments:
> >[/opt/Ora817/OraHome1/ctx/bin/ctxhx]
> >ORA-06512: at "CTXSYS.DRUE", line 126
> >ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 78
> >ORA-06512: at line 1
> >
> >
> >
> >create index convert_to_html_index on
> >pre_convert_html(content) indextype is
> >*
> >ERROR at line 1:
> >ORA-29855: error occurred in the execution of
> >ODCIINDEXCREATE routine
> >ORA-20000: file not found
> >DRG-11206: file not found; arguments:
> >[/opt/Ora817/OraHome1/ctx/bin/ctxhx]
> >ORA-06512: at "CTXSYS.DRUE", line 126
> >ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 78
> >ORA-06512: at line 1
> >****************************************
> >
> >
> >thanks in advance
> >Vijay
> >
> >__________________________________________________
> >Do you Yahoo!?
> >New DSL Internet Access from SBC & Yahoo!
> >http://sbc.yahoo.com
> >
> >
> >
> >  
> >
> 
> 
> 

-- 
Kevin C. Flaherty			email:  kevin at roadstead.org
Roadstead Consulting			www:	www.roadstead.org
Badstuestraede 3			work:   +45 26 29 90 94
1207 Copenhagen K			IM:	roadstead_rap (YahooIM)
Denmark