configdb出现的问题

mxg1104

java.sql.SQLException: ORA-29855: error occurred in the execution of ODCIINDEXC
EATE routine
ORA-20000: Oracle Text error:
DRG-10700: preference does not exist: global_lexer
ORA-06512: at \"CTXSYS.DRUE\", line 160
ORA-06512: at \"CTXSYS.TEXTINDEXMETHODS\", line 364

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.jav
:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
        at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatem
nt.java:1168)
        at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.j
va:1687)
        at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1653

        at psdi.configure.CommonShell.doSql(CommonShell.java:339)
        at psdi.configure.ConfigDB.alterTable(ConfigDB.java:1452)
        at psdi.configure.ConfigDB.configureTables(ConfigDB.java:550)
        at psdi.configure.ConfigDB.process(ConfigDB.java:255)
        at psdi.configure.ConfigDB.main(ConfigDB.java:2564)
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10700: preference does not exist: global_lexer
ORA-06512: at \"CTXSYS.DRUE\", line 160
ORA-06512: at \"CTXSYS.TEXTINDEXMETHODS\", line 364
Thu Nov 13 12:46:34 CST 2008
ConfigDB completed with errors  Thu Nov 13 12:46:34 CST 2008
RestoreFromBackup completed  Thu Nov 13 12:46:34 CST 2008




修改了几个字段的属性configdb报的错，数据库是oracle,请大侠帮忙一下！

Allen.yang

这要看你的数据库是什么版本的,如果是9i的话你需要升级到9.2.0.6以上,如果是10的话,你可以先看看你对maximo用户的授权.

mxg1104

oracle 10.2
权限
create user maximo identified by maximo;
alter user maximo default tablespace maximo quota unlimited on maximo;
alter user maximo temporary tablespace temp;
grant create trigger to maximo;
grant create session to maximo;
grant create sequence to maximo;
grant create synonym to maximo;
grant create table to maximo;
grant create view to maximo;
grant create procedure to maximo;
grant alter session to maximo;
grant execute on ctxsys.ctx_ddl to maximo;

grant create job to maximo;

Allen.yang

几个办法,
1 你尝试一下这个,grant dba to maximo; 然后在配置数据库;
2 你去maximo/tools/maximo/log下面把configdb的log日志打开看一下,看看是执行什么语句时出错

Allen.yang

如果觉得dba的权限太大就执行下面的;
grant create any table to maximo;
grant create any index to maximo;
grant create any sequence to maximo;

mxg1104

好的，我试试，多谢！

uof

首先确定数据库安装时，进行imp是否出现过类似的错误
首要解决imp的问题

从DRG-10700: preference does not exist: global_lexer
这个错误，有可能是oracle text出了问题，如果你用em或安装oracle时直接建库，那oracle text一般都正常，grant execute on ctxsys.ctx_ddl to maximo;执行就会正常

如果不正常，就重装oracle text吧
完了还不行，就不知道了

Allen.yang

call ctx_ddl.drop_preference('global_lexer');
call ctx_ddl.drop_preference('default_lexer');
call ctx_ddl.drop_preference('english_lexer');
call ctx_ddl.drop_preference('chinese_lexer');
call ctx_ddl.drop_preference('japanese_lexer');
call ctx_ddl.drop_preference('korean_lexer');
call ctx_ddl.drop_preference('german_lexer');
call ctx_ddl.drop_preference('dutch_lexer');
call ctx_ddl.drop_preference('swedish_lexer');
call ctx_ddl.drop_preference('french_lexer');
call ctx_ddl.drop_preference('italian_lexer');
call ctx_ddl.drop_preference('spanish_lexer');
call ctx_ddl.drop_preference('portu_lexer');
call ctx_ddl.create_preference('default_lexer','basic_lexer');
call ctx_ddl.create_preference('english_lexer','basic_lexer');
call ctx_ddl.create_preference('chinese_lexer','chinese_lexer');
call ctx_ddl.create_preference('japanese_lexer','japanese_lexer');
call ctx_ddl.create_preference('korean_lexer','korean_morph_lexer');
call ctx_ddl.create_preference('german_lexer','basic_lexer');
call ctx_ddl.create_preference('dutch_lexer','basic_lexer');
call ctx_ddl.create_preference('swedish_lexer','basic_lexer');
call ctx_ddl.create_preference('french_lexer','basic_lexer');
call ctx_ddl.create_preference('italian_lexer','basic_lexer');
call ctx_ddl.create_preference('spanish_lexer','basic_lexer');
call ctx_ddl.create_preference('portu_lexer','basic_lexer');
call ctx_ddl.create_preference('global_lexer', 'multi_lexer');
call ctx_ddl.add_sub_lexer('global_lexer','default','default_lexer');
call ctx_ddl.add_sub_lexer('global_lexer','english','english_lexer','en');
call ctx_ddl.add_sub_lexer('global_lexer','simplified chinese','chinese_lexer','zh');
call ctx_ddl.add_sub_lexer('global_lexer','japanese','japanese_lexer',null);
call ctx_ddl.add_sub_lexer('global_lexer','korean','korean_lexer',null);
call ctx_ddl.add_sub_lexer('global_lexer','german','german_lexer','de');
call ctx_ddl.add_sub_lexer('global_lexer','dutch','dutch_lexer',null);
call ctx_ddl.add_sub_lexer('global_lexer','swedish','swedish_lexer','sv');
call ctx_ddl.add_sub_lexer('global_lexer','french','french_lexer','fr');
call ctx_ddl.add_sub_lexer('global_lexer','italian','italian_lexer','it');
call ctx_ddl.add_sub_lexer('global_lexer','spanish','spanish_lexer','es');
call ctx_ddl.add_sub_lexer('global_lexer','portuguese','portu_lexer',null);

Allen.yang

刚有个同事遇到一样的问题，帮忙解决了一下。ibm有官方的文档，用maximo用户执行
2遍上面的sql就可以了。
不过很抱歉，ibm官方发布的文档地址我记不清了，电脑坏了一次，收藏的地址都没了。唉。

wangjinya163

上面的很好用，呵呵。