重装 11G(11.2.0.4) SDO组件

Spatial 组件重建

依赖关系,先要有 select comp_id,version,status fromdba_registry where comp_id in (‘JAVAVM’,’ORDIM’,’XDB’);这三个组件有效

1 Spatial 组件卸载

1.1 drop Spatical 用户:MDSYS

SQL>drop user MDSYS cascade;

SQL>drop user mddata cascade; 

SQL>drop user spatial_csw_admin_usr cascade; 
SQL>drop user spatial_wfs_admin_usr cascade; 

2 Oracle 11g 安装Spatial

在Oracle 10g/11g 中安装Spatial 组件,必须先保证如下三个组件已经存在:

select comp_id,version,status fromdba_registry where comp_id in
(‘JAVAVM’,’ORDIM’,’XDB’);


ps:安装ORDIM时,会创建MDSYS用户

–赋权:

grant the required privileges to MDSYS byrunning:

 SQL> connect / as sysdba

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

–安装:

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





转载自:https://blog.csdn.net/u013225189/article/details/77351703

You may also like...