DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Intermedia Installation

  1. #1
    Join Date
    Sep 2000
    Posts
    384
    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
    'USERISCTXSYS'
    --------------
    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"
    @@dr0lib.sql
    Radhakrishnan.M

  2. #2
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175

    Cool

    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 --------
    2>
    3>
    4>
    5>
    6> /
    prompt --------
    *
    ORA-00900: invalid SQL statement
    SVRMGR> exit
    Server Manager complete.
    /home1/oracle $ sqlplus /

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

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

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

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

    Hope that helps,



    --clio_usa
    Senior Oracle DBA

    Oracle DBA forums at:
    http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi
    ----------------------------------------------------------

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