Intermedia Installation Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Intermedia Installation

  1. #1
    Join Date
    Sep 2000
    I am trying to setup intermedia text in my database .When I ran the dr0inst.sql .I got this error .

    PROMPT ============== ConText Database Objects Installation ==============
    ORA-00900: invalid SQL statement
    MGR-00110: illegal SET option
    User is CTXSYS
    1 row selected.
    MGR-00110: illegal SET option
    whenever sqlerror continue
    ORA-00900: invalid SQL statement
    PROMPT ... creating tables and Oracle object types
    ORA-00900: invalid SQL statement

    Now I am trying to run the statement one by one ...I am trying to dr0lib.sql what should be the value that I should specify at ctxx_location ...

    PROMPT ... creating safe callout library
    define ctxx_location = "&1"

  2. #2
    Join Date
    May 2002
    California, USA


    Do not try to run the InterMedia scripts from svrmgrl. It does not understand SQL*Plus commands (SET, PROMPT, etc). It should be in the docs how to do that.

    Here is why you are getting errors:

    SVRMGR> prompt --------
    6> /
    prompt --------
    ORA-00900: invalid SQL statement
    SVRMGR> exit
    Server Manager complete.
    /home1/oracle $ sqlplus /

    SQL*Plus: Release - Production on Thu May 23 12:05:05 2002

    (c) Copyright 1999 Oracle Corporation. All rights reserved.

    Connected to:
    Oracle8i Enterprise Edition Release - Production
    With the Partitioning option
    JServer Release - Production

    SQL> prompt ---------
    > /
    -------- /

    Hope that helps,

    Senior Oracle DBA

    Oracle DBA forums at:

Posting Permissions

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

Click Here to Expand Forum to Full Width