Re: Oracle Context Cartridges

From: Joel R. Kallman <jkallman_at_us.oracle.com>
Date: Mon, 08 Mar 1999 18:40:28 GMT
Message-ID: <36e51782.16481869@newshost.us.oracle.com>

Are you starting the ConText server by specifying the CTXSYS userid and it's corresponding password?

On a system (Oracle8 8.0.5, Solaris 2.6) where I have ConText correctly installed and configured, if I attempt to start a ConText server with a user other than CTXSYS, I get the following:

> ctxsrv -user scott/tiger -personality qdml
NLS_LANG not set - using defaults.

Oracle ConText Option: Release 2.4.5.0.0 - Production on Mon Mar 8 13:32:58 1999

13:32:58 03/08/99 === OCO server startup ===
13:32:58 03/08/99 Initialized CORE
13:33:00 03/08/99 Connected to database.
13:33:02 03/08/99 === Server failure ===
13:33:02 03/08/99 DRG-00100: internal error, arguments :

[50804],[drasm.c],[153]
13:33:02 03/08/99 ORA-06550: line 1, column 7: PLS-00201: identifier 'DRASERM.ADD' must be declared ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

13:33:02 03/08/99 === Server shutting down ===

Look familiar? I know this sequence of error messages isn't necessarily intuitive, but you should be starting up the ConText server as the CTXSYS user.

(BTW...there are two steps in installing ConText, namely 1) installing the software using the Oracle installer, and 2) installing ConText into your database, using the scripts $ORACLE_HOME/ctx/admin/drcrsyst.sql and $ORACLE_HOME/ctx/admin/dr0inst.sql. ).

On Sat, 6 Mar 1999 22:14:32 -0800, "WS" <ws1_at_netcom.com> wrote:

>Does anyone have some general guidance on getting Oracle8 Context Cartridges
>up and running? We are on 8.0.5 Sun Solaris 2.6.
>
>The approriate tablespaces and users have been created (per the install
>documentation), the proper_names table data has been imported and I still
>can't seem to get it up and running.
>
>These are the error messages that I receive:
>
>11:26:05 03/06/99 === OCO server startup ===
>11:26:05 03/06/99 Initialized CORE
>11:26:05 03/06/99 Connected to database.
>11:26:05 03/06/99 === Server failure ===
>11:26:05 03/06/99 DRG-00100: internal error, arguments :
>[50804],[drasm.c],[153],[],[]
>11:26:05 03/06/99 ORA-06550: line 1, column 7:
>PLS-00201: identifier 'DRASERM.ADD' must be declared
>ORA-06550: line 1, column 7:
>PL/SQL: Statement ignored
>
>
>Are there stored procedures that need to be run? I notice in the ctx/admin
>directory there are a bunch of .sql and package procedures, but am not sure
>what if any need to be run. There is little help in the install
>documentation, and I haven't found anything in the on-line documentation
>either.
>
>I have called Oracle support, the suggestion was to import the proper_names
>data, which did not work.
>
>Any suggestions?
>Thanks!
>
>

Thanks!

Joel

Joel R. Kallman Oracle Service Industries

Columbus, OH            
jkallman@us.oracle.com                   http://www.oracle.com

The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Received on Mon Mar 08 1999 - 12:40:28 CST