Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Context Cartridges

Re: Oracle Context Cartridges

From: <ws1_at_netcom.com>
Date: Mon, 08 Mar 1999 18:25:19 -0800
Message-ID: <36E4868F.C01B4764@netcom.com>


Joel, yes I am trying to start the server with the ctxsys users.
>ctxsrv -user ctxsys/ctxsys is how I am trying to start it.
Doesn't appear to be a database problem, because as you can see in the error message it connects.
What I am curious about, is the last error message of PL/SQL statement being ignored.
When you set yours up, did you just basically install the software, create the database users and not much else?

Thanks!

"Joel R. Kallman" wrote:

> 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
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> 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 - 20:25:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US