Re: Getting started - No Oracle Intermedia

On Tue, Apr 27, 2004 at 04:17:32PM +0100, Denham, Martin wrote:
> Hi,
> 
> Solved my own problem.  It appears Intermedia was installed and one or all of the following were required:
> GRANT CTXAPP TO ccmUser
> GRANT EXECUTE ON ctx_ddl TO ccmUser
> unlock the ctxsys account

Yes, this is correct - the APLAWS+ Quick Start Install Guide details
this requirement in the section 'Installing an APLAWS+ development server':

<quote>
Create a new user, giving them 200MB of quota on the medium_data 
tablespace.

SQL> create user ccm identified by ccm_xyz
     default tablespace medium_data
          temporary tablespace temp profile default
       quota unlimited on medium_data;
       SQL> grant connect,resource,query rewrite, ctxapp, javasyspriv to ccm;
       SQL> revoke unlimited tablespace from ccm;
       SQL> alter user ccm quota 200m on medium_data;

Dan.

> 
> I am trying to install cms 6.1 on windows and Oracle 9 but do not have InterMedia installed.
> 
> I get the "CTX_DDL must be declared" intermedia error when executing:
> 	ccm.cmd load --interactive ccm-core ccm-cms ccm-cms-types-article ccm-cms-types-newsitem
> 
> Previous posts say this error can be ignored but it seems as if the rest of the sql initialisation script is not being run after the error because there is nothing in many tables such as SITE_NODES.
> 
> Is there a way to stop this error occurring without installing Oracle InterMedia.

Intermedia is required to be present for loading the data model - although
once up & running it is possible to switch to using Lucene for search indexing
instead. The 'ccm set waf.search.engine=lucene' or 'ccm set waf.search.engine=intermedia'
as appropriate. You can also disable search capabilities entirely by doing
'ccm set waf.search.engine=noop' - then all searchs will just return 0 rows.

Dan.
-- 
|=-             Daniel P. Berrange  -  [email protected]              -=|
|=-   Red Hat, 338 Euston Road, London, NW1 3BT.  +44 (0)7977 267 243   -=|
|=-                                                                     -=|
|=- GnuPG: 7D3B9505   F3C9 553F A1DA 4AC2 5648 23C1 B3DF F742 7D3B 9505 -=|

-- 
Redhat-ccm-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/redhat-ccm-list
Archives: https://www.redhat.com/pipermail/redhat-ccm-list/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQFAj+Aqs9/3Qn07lQURAqVDAKCaxkXV75ibTncFMmKYLcuxqmVzWwCgn07k
MS2IQh8wRHA/hAvhiVBuyNs=
=6/h7
-----END PGP SIGNATURE-----