Intermedia Installation

[omegamark]

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

[clio_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 --------
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
----------------------------------------------------------