pat98's always & forever

Steps for Manual Installation / Verification of Spatial 10g / 11g (문서 ID 270588.1)

Manual installation of Spatial 10g / 11g

- 3가지가 사전 설치되어 있어야 함

JServer JAVA Virtual Machine
Oracle interMedia   
Oracle XML Database

- 확인

SQL> select comp_id,version,status from dba_registry where comp_id in ('JAVAVM','ORDIM','XDB');  

To (re-)install JServer see: Note:276554.1
To (re-)install XDB see: Note:1292089.1
To (re-)install interMedia: Note:337415.1

Installation of Spatial

MDSYS 계정이 없으면 생성한다.

SQL> create user MDSYS identified by <password> default tablespace SYSAUX account lock;

SQL> @?/md/admin/mdprivs.sql

SQL> connect / as sysdba
SQL> spool spatial_installation.lst
SQL> @?/md/admin/mdinst.sql
SQL> spool off

SQL> alter user MDSYS account lock;

- 제대로 설치되었는지 확인

SQL> connect / as sysdba 
SQL> set serveroutput on
SQL> execute validate_sdo;
SQL> select comp_id, control, schema, version, status, comp_name from dba_registry where comp_id='SDO';
SQL> select object_name, object_type, status from dba_objects where owner='MDSYS' and status <> 'VALID' order by object_name;

    A sample valid 10.2.0.4.0 installation shows the following output:

SQL> execute validate_sdo;

    PL/SQL procedure successfully completed.

    SQL> select comp_id, control, schema, version, status, comp_name from dba_registry where comp_id='SDO';

    COMP_ID                        CONTROL
    ------------------------------ ------------------------------
    SCHEMA                         VERSION                        STATUS
    ------------------------------ ------------------------------ -----------
    COMP_NAME
    --------------------------------------------------------------------------------
    SDO                            SYS
    MDSYS                          10.2.0.4.0                     VALID
    Spatial            

    no rows selected