在11g安装 XML DB 组件
来源:互联网 发布:java rs232c 编辑:程序博客网 时间:2024/06/03 10:14
昨晚做全库impdp导入时,发现有些表使用了xml的存放。导致导入的时候表都无法创建。
因dbca建库的只安装了jvm组件,所以需要安装XML DB组件。
安装步骤如下:
- Confirm XML DB is not already installed.
- SELECT username FROM DBA_USERS where username = 'XDB'; returns 0 rows.
- DESCRIBE RESOURCE_VIEW fails.
- As SYS, perform the XML DB installation - Note: this will not be a complete build due to Oracle Bug9818995:
- @?/rdbms/admin/catqm.sql xdb <xml db tablespace> <xdb temp tablespace> <use secure files yes|no>
- As SYS, grant the relevent permissions to the XDB user:
- GRANT EXECUTE ON utl_file TO xdb;
- GRANT EXECUTE ON dbms_lob TO xdb;
- As SYS, ensure their are no invalid objects:
- @?/rdbms/admin/utlrp.sql
- Assuming an spfile is in use, as SYS configure the XDB dispatcher:
- ALTER SYSTEM SET DISPATCHERS="(PROTOCOL=TCP)(SERVICE=<SID>XDB)" SCOPE=both;
- If init.ora is in use, edit the init.ora file instead.
- As SYS, install the missing contents caused by Oracle Bug 9818995:
- SHUTDOWN IMMEDIATE;
- STARTUP UPGRADE
- @?/rdbms/admin/xsdbmig.sql
- SHUTDOWN IMMEDIATE;
- STARTUP
- As SYS, ensure their are no invalid objects:
- @?/rdbms/admin/utlrp.sql
- As SYS, confirm the XML DB is now fully installed by running the following query and returning the following output:
SELECT object_valueFROM xdb.xs$securityclassWHERE EXTRACTVALUE(object_value, '/securityClass/@targetNamespace')='http://xmlns.oracle.com/plsql'AND EXTRACTVALUE(object_value, '/securityClass/@name')='network'/ OBJECT_VALUE--------------------------------------------------------------------------------<securityClass xmlns="http://xmlns.oracle.com/xs" xmlns:dav="DAV:" xmlns:plsql="
原文地址:http://blog.csdn.net/xionglang7/article/details/38034555
0 0
- 在11g安装 XML DB 组件
- 在11g安装 XML DB 组件
- Oracle 安装组件xml-db
- DB - Oracle 11g在安装不到文件em.ear
- DB - Oracle 11g在安装不到文件em.ear
- 在11g安装oracle text组件
- 安装 Oracle 11g DB
- Oracle 11g db soft的静默安装
- oracle 11g 安装text 组件
- 11g安装oracle text组件
- oracle 10g 组件translate gateway在solaris上安装
- 修改db编码的办法:(在oracle 11g上通过测试)
- 管理11g RAC之DB实验
- 在ubuntu 下安装Oracle 11g
- oracle10g ,11g在windows下安装
- 在CentOS上安装Oracle 11g
- 在RHEL5上安装oracle 11g
- 在Linux 安装 oracle 11g
- php如何上传文件名为中文的文件
- bundle install时报错Could not fetch specs from http://ruby.taobao.org/
- 延迟渲染的一些思考
- 将0,1,3,4,5,6等转化成0~1点,3点,4~6点
- Android之android studio如何把项目分享到github并提修改的代码到Github
- 在11g安装 XML DB 组件
- MFC里多文档多视图+多线程动态计算、绘制曲线
- 10795 - A Different Task
- YII 2 配置
- 工厂模式简单理解
- explicit关键字
- 胡玉洋《三分钟学会JUnit单元测试》
- 将form表单序列化
- RedHat 安装和配置samba服务器