免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
› 论坛 › 数据库技术 › Oracle › oracle817打补丁及更改字符集后exp、inter text问题经验 ...
最近访问板块 发新帖
查看: 2100 | 回复: 0
打印 上一主题 下一主题

oracle817打补丁及更改字符集后exp、inter text问题经验共享 [复制链接]

明月清风

论坛徽章:
0
跳转到指定楼层
1楼 [收藏(0)] [报告]
发表于 2004-01-07 13:01 |只看该作者 |倒序浏览
oracle817打补丁及更改字符集后exp、inter Media text问题解决经验共享
===========================================
环境:Solaris 5.8+Oracle8.1.7+pack3||4
更改字符集:建库时不小心建成ZHS16GBK，需要UTF8
操作：
$svrmgrl
SVRMGR>;connect internal
SVRMGR>;update props$ set value$='UTF8' where name='NLS_CHARACTERSET';
SVRMGR>;update props$ set value$='UTF8' where name='NLS_NCHAR_CHARACTERSET';
SVRMGR>;commit;
SVRMGR>;shutdown immediate
SVRMGR>;startup
SVRMGR>;exit

解决打补丁后exp无效列名错误
操作：
$svrmgrl
SVRMGR>;connect internal
SVRMGR>;@ORACLE_HOME/rdbms/admin/catexp.sql
SVRMGR>;shutdown immediate
SVRMGR>;startup
SVRMGR>;exit


解决更改字符集后exp错误:ORA-06553: PLS-561: 参数 'SHORTNAME' 的值的字符集不匹配
说明:rebuild jvm
操作：
$ svrmgrl
SVRMGR>; connect internal
SVRMGR>; @ORACLE_HOME/javavm/install/rmjvm.sql
SVRMGR>;shutdown immediate
SVRMGR>;startup
SVRMGR>;exit

解决更改字符集后全文索引错误:ORA-06553: PLS-561: 参数'NLS'的值的字符集不匹配
说明:重新设置全文索引
操作：
$sqlplus ctxsys/ctxsys @$ORACLE_HOME/ctx/admin/dr0drop.sql
$sqlplus ctxsys/ctxsys @$ORACLE_HOME/ctx/admin/dr0inst.sql
$sqlplus ctxsys/ctxsys @$ORACLE_HOME/ctx/admin/defaults/drdefeg.sql

========================================
实例:
更改字符集后exp错误.
$ exp founder/founder
Export: Release 8.1.7.3.0 - Production on 星期三 1月 7 12:44:30 2004
(c) Copyright 2000 Oracle Corporation.  All rights reserved.
连接到: Oracle8i Enterprise Edition Release 8.1.7.3.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.3.0 - 64bit Production
输入数组提取缓冲区大小: 4096 >;
导出文件: expdat.dmp>; founder0107.dmp
(1)E(完整的数据库)，(2)U(用户) 或 (3)T(表): (2)U >;
导出权限(yes/no)：yes>;
导出表数据(yes/no)：yes>;
压缩区(yes/no)：yes>;
已导出 ZHS16GBK 字符集和 UTF8 NCHAR 字符集
服务器使用 UTF8 字符集 (可能的字符集转换)

即将导出指定的用户...
要导出的用户: (RETURN 以退出) >; founder

要导出的用户: (RETURN 以退出) >;

. 正在导出 pre-schema 过程对象和操作
. 正在导出用户 FOUNDER 的外部函数程序库名称
. 正在导出用户 FOUNDER 的对象类型定义
即将导出 FOUNDER 的对象 ...
. 正在导出数据库链接
. 正在导出序号
. 正在导出群集定义
. 即将导出 FOUNDER 的表通过常规路径 ...
. . 正在导出表                     ADDRESS_KEY         53 行被导出
. . 正在导出表               ADDRESS_KEY_GROUP         10 行被导出
. . 正在导出表                     ASSIGN_RULE        206 行被导出
. . 正在导出表             ASSIGN_RULE_BAK_NEW        187 行被导出
. . 正在导出表              ATTR_TABLE_MAPPING         14 行被导出
... ...
. . 正在导出表            WORD_TABLES_CATEGORY       1323 行被导出
. 正在导出同义词
EXP-00008: ORACLE 错误 6553 出现
ORA-06553: PLS-561: 参数 'SHORTNAME' 的值的字符集不匹配
EXP-00000: 导出终止失败


解决该问题操作:
SVRMGR>; @/data/oracle/OraHome1/javavm/install/rmjvm.sql
服务器输出                ON
语句已处理。
JVMRMACTION
------------
FULL_REMOVAL
语句已处理。
drop role javauserpriv
drop role javaidpriv
drop role javasyspriv
drop role javadebugpriv
drop view javasnm
drop public synonym javasnm
drop table aurora$startup$classes$
drop table aurora$shutdown$classes$
语句已处理。
语句已处理。
delete from aurora$startup$classes$ where classname = 'oracle.aurora.net.Dynamic
Registration'
delete from aurora$shutdown where classname = 'oracle.aurora.net.DynamicRegistra
tion'
drop table AURORA$DYN$REG
drop table AURORA$CURRENT$DYN$REG
语句已处理。
drop package get_error$
drop public synonym get_error$
drop trigger AURORA$SERVER$SHUTDOWN
drop trigger AURORA$SERVER$STARTUP
drop package sqljutl
JVMRMACTION
------------
FULL_REMOVAL
语句已处理。
drop package dbms_java
drop PUBLIC SYNONYM dbms_java
drop FUNCTION dbj_long_name
drop function "NameFromLastDDL"
drop PUBLIC SYNONYM "NameFromLastDDL"
drop FUNCTION dbj_short_name
drop PUBLIC SYNONYM dbj_short_name
JVMRMACTION
------------
FULL_REMOVAL
ORA-06550: 第 14 行, 第 5 列:
PLS-00201: 必须说明标识符 'DBMS_JAVA.DISABLE_PERMISSION'
ORA-06550: 第 14 行, 第 5 列:
PL/SQL: Statement ignored
ORA-06550: 第 15 行, 第 5 列:
PLS-00201: 必须说明标识符 'DBMS_JAVA.DELETE_PERMISSION'
ORA-06550: 第 15 行, 第 5 列:
PL/SQL: Statement ignored
语句已处理。
drop TABLE java$policy$shared$table
drop ROLE java_deploy
语句已处理。
drop TABLE java$policy$
drop SEQUENCE java$policy$sequence$
drop VIEW dba_java_policy
drop PUBLIC SYNONYM dba_java_policy
drop VIEW user_java_policy
drop PUBLIC SYNONYM user_java_policy
drop ROLE java_admin
语句已处理。
JVMRMACTION
------------
FULL_REMOVAL
语句已处理。
drop package JAVA_XA
drop PUBLIC SYNONYM JAVA_XA
语句已处理。
alter rollback segment monster offline
drop rollback segment monster
create rollback segment monster storage (initial 100 k next 100 k maxextents unl
imited)
alter rollback segment monster online
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
insert into java$rmjvm$aux (select obj# from obj$ where type#=28 or type#=29 or
type#=30 or type#=56)
set transaction use rollback segment MONSTER
drop synonyms with java targets
delete from java$rmjvm$aux2
insert into  java$rmjvm$aux2 (select o1.name from obj$ o1,obj$ o2 where o1.type#
=5 and o1.name=o2.name and o2.type#=29)
delete from java$rmjvm$aux2
insert into  java$rmjvm$aux2 (select o1.name from obj$ o1,obj$ o2 where o1.type#
=5 and o1.name=o2.name and o2.type#=29)
flush shared_pool
set transaction use rollback segment MONSTER
delete from dependency$
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
delete from error$
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
delete from objauth$
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
delete from javasnm$
set transaction use rollback segment MONSTER
delete from idl_ub1$
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
delete from idl_ub2$
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
delete from idl_char$
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
delete from idl_sb4$
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
delete from obj$
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
set transaction use rollback segment MONSTER
All java objects removed
alter rollback segment monster offline
drop rollback segment monster
flush shared_pool
语句已处理。
SVRMGR>; exit


再次exp正常:
$ exp founder/founder
Export: Release 8.1.7.3.0 - Production on 星期三 1月 7 12:44:30 2004
(c) Copyright 2000 Oracle Corporation.  All rights reserved.
连接到: Oracle8i Enterprise Edition Release 8.1.7.3.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.3.0 - 64bit Production
输入数组提取缓冲区大小: 4096 >;
导出文件: expdat.dmp>; founder0107.dmp
(1)E(完整的数据库)，(2)U(用户) 或 (3)T(表): (2)U >;
导出权限(yes/no)：yes>;
导出表数据(yes/no)：yes>;
压缩区(yes/no)：yes>;
已导出 ZHS16GBK 字符集和 UTF8 NCHAR 字符集
服务器使用 UTF8 字符集 (可能的字符集转换)
即将导出指定的用户...
要导出的用户: (RETURN 以退出) >; founder
要导出的用户: (RETURN 以退出) >;
. 正在导出 pre-schema 过程对象和操作
. 正在导出用户 FOUNDER 的外部函数程序库名称
. 正在导出用户 FOUNDER 的对象类型定义
即将导出 FOUNDER 的对象 ...
. 正在导出数据库链接
. 正在导出序号
. 正在导出群集定义
. 即将导出 FOUNDER 的表通过常规路径 ...
. . 正在导出表                     ADDRESS_KEY         53 行被导出
. . 正在导出表               ADDRESS_KEY_GROUP         10 行被导出
. . 正在导出表                     ASSIGN_RULE        206 行被导出
... ...
. . 正在导出表            WORD_TABLES_CATEGORY       1323 行被导出
. 正在导出同义词
. 正在导出视图
. 正在导出存储的过程
. 正在导出运算符
. 正在导出引用完整性约束条件
. 正在导出触发器
. 正在导出索引类型
. 正在导出位图、功能性索引和可扩展索引
. 正在导出后期表活动
. 正在导出快照
. 正在导出快照日志
. 正在导出作业队列
. 正在导出刷新组和子组
. 正在导出维
. 正在导出 post-schema 过程对象和操作
. 正在导出统计
在没有警告的情况下成功终止导出。
$
返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号：11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们：huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP