Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2002
    Location
    Vienna
    Posts
    9

    Post Unanswered: Get better error code

    I've got a problem with creating a certain index, where I get the error message: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine.

    Is there a way to get a better detailed error code or error message? I want to know which process in ODCIINDEXCREATE has failed.

    Thanks in advance,
    Robert

  2. #2
    Join Date
    Sep 2002
    Location
    Ohio
    Posts
    204

    Re: Get better error code

    Unfortunately, I don't think you can get a better error message, at least I don't know of a way. What you can do is look for the cause of this error and/or provide more information to this group. For unstance:
    What OS, What version of Oracle, special database options.

    After a little research, I would guess that you are trying to create a special type of index, Intermedia Text or Spacial, and that's whats failing. If so, you could check that your environment variables are set correctly. One solution is to make sure that the folowing items are in set properly:

    add $ORACLE_HOME/ctx/lib to your PATH environment variable
    add $ORACLE_HOME/ctx/lib to your LD_LIBRARY_PATH environment variable

    If these are already set correctly, please provide more details.

    HTH,
    Patrick


    Originally posted by Thalion
    I've got a problem with creating a certain index, where I get the error message: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine.

    Is there a way to get a better detailed error code or error message? I want to know which process in ODCIINDEXCREATE has failed.

    Thanks in advance,
    Robert

  3. #3
    Join Date
    Oct 2002
    Location
    Kansas City
    Posts
    7

    Thumbs up Re: Get better error code

    Try using the oerr facility error command:

    $oerr ora 2985
    29855, 00000, "error occurred in the execution of ODCIINDEXCREATE routine"
    // *Cause: Failed to successfully execute the ODCIIndexCreate routine.
    // *Action: Check to see if the routine has been coded correctly.

    Mark

    Originally posted by Thalion
    I've got a problem with creating a certain index, where I get the error message: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine.

    Is there a way to get a better detailed error code or error message? I want to know which process in ODCIINDEXCREATE has failed.

    Thanks in advance,
    Robert

  4. #4
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118

    DBMS_UTILITY

    You can use dbms_utility to use a more sophisticated error stack:

    BEGIN
    DBMS_OUTPUT.PUT_LINE(DBMS_UTILITY.FORMAT_CALL_STAC K);

    END;
    /

    Good Luck!!

    Pay me a visit as http://ora-0000.com/
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

  5. #5
    Join Date
    Aug 2004
    Posts
    14

    Intermedia text problem setup

    Hi,
    I am facing a similar problem.

    I have created a table an filled it with data:

    create table ctxsys.quick
    (
    quick_id number
    constraint quick_pk primary key,
    text varchar(80)
    );

    I tried to create and index but I am getting the following "group of errors":

    create index quick_text on ctxsys.quick ( text )
    indextype is ctxsys.context;

    ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
    ORA-20000: interMedia Text error:
    DRG-11422 linguistic initialization failed
    DRG-00100: internal error, arguments : [52100],[drxs.c],[553],[gxtopen],[1]
    DRG-11208: ORACLE_HOME is not set.
    ORA-06512: at "CTXSYS.DRUE", line 126
    ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 78
    ORA-06512: at line 1

    I am using win2k with oracle personal 8.1.7.
    Any ideas what might be setup wrong?!

    Thanks,
    Kostas.

  6. #6
    Join Date
    Jul 2003
    Posts
    2,296
    Quote Originally Posted by kostas88
    Hi,
    I am facing a similar problem.

    I have created a table an filled it with data:

    create table ctxsys.quick
    (
    quick_id number
    constraint quick_pk primary key,
    text varchar(80)
    );

    I tried to create and index but I am getting the following "group of errors":

    create index quick_text on ctxsys.quick ( text )
    indextype is ctxsys.context;

    Any ideas what might be setup wrong?!

    Thanks,
    Kostas.

    sounds like Intermedia is not configured properly.
    has the user been granted the CTXAPP role????
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  7. #7
    Join Date
    Aug 2004
    Posts
    14
    Quote Originally Posted by The_Duck
    sounds like Intermedia is not configured properly.
    has the user been granted the CTXAPP role????
    The user unfortunately has been granted the CTXAPP role :-(

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •