rasti.hil@hilandco.com +41 79 367-9677

OracleAS Metadata Repository Creation Assistant

Initialization Parameters


alter system set aq_tm_processes=9 scope=both;
alter system set sessions=400 scope=both;
alter system set pga_aggregate_target=96M scope=both;
alter system set shared_pool_size=175M scope=both;
alter system set db_cache_size=144M scope=both;
alter system set query_rewrite_enabled=TRUE scope=both;



cd ultrasearch/admin
@wk0setup.sql "/u00/app/oracle/product/10.2.0" @SID SYS
password "as sysdba" wksys SYSAUX TEMP "" "" DATABASE ""
/u00/app/oracle/product/mrca/classes12.zip
/u00/app/oracle/product/mrca/orai18n.jar
/u00/app/oracle/product/mrca/jdk/bin/java
/u00/app/oracle/product/mrca/ctx/bin/ctxhx NOT_INITIALIZED
NOT_INITIALIZED /u00/app/oracle/product/mrca


conn / AS sysdba

CREATE TABLESPACE "XDB" DATAFILE 'xmldb01.dbf' SIZE 250M
AUTOEXTEND ON NEXT 10485760 MAXSIZE 2048M LOGGING
ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL
AUTOALLOCATE SEGMENT SPACE MANAGEMENT MANUAL;

spool xdb_install.lst

-- create functionality and repository

@rdbms/admin/catqm.sql oracle XDB TEMP


@ctx/admin/catctx.sql CTXSYS SYSAUX TEMP NOLOCK
@ctx/admin/defaults/drdefus.sql

sq
@ord/admin/ordinst.sql SYSAUX SYSAUX
@ord/im/admin/iminst.sql
@ord/im/admin/imchk.sql

create user MDSYS identified by password
default tablespace SYSAUX account lock;
@md/admin/mdprivs.sql
spool spatial_installation.lst
@md/admin/mdinst.sql
spool off




-- test spatial
execute validate_sdo;
select comp_id, control, schema, version, status, comp_name from dba_registry where comp_id='SDO';
select object_name, object_type, status from dba_objects where owner='MDSYS' and status <> 'VALID' order by object_name;