Problem Description ------------------- Trying to get full or user export it fails with the following errors: ORA-6553 PLS-561 character set mismatch on value for parameter 'SHORTNAME'
Check if Java option is installed: SELECT count(*) FROM dba_objects WHERE object_type LIKE 'JAVA%'; -> this select should return more than 4000 rows
Also issue as user SYS: SELECT dbms_java.longname(name) FROM obj$ WHERE type# = 29 and status != 1; -> this normally should return 0 rows, otherwise will fail with error ORA-6553 PLS-561.
The problem seems to be that Java Option was not installed properly. Even if removing Java Option by using script $ORACLE_HOME/javavm/install/rmjvm.sql Problem will persist. Solution Description -------------------- If you do not need Java Option, first remove it by script:
$ORACLE_HOME/javavm/install/rmjvm.sql (Notice that in 8.1.6 rmjvm.sql is wrong. Before running it you should change line: "call rmjvm.run(true)" to "execute rmjvm.run(true)" This is due to [BUG:1179670]. Be careful for having large rollback segments when running it. Then login from sqlplus as SYS user and issue the following commands: SQL> drop package dbms_java; SQL> drop public synonym dbms_java; If you need the Java Option check [NOTE:105472.1] for correct Java installation. Explanation ----------- Export tests whether the Synonym 'DBMS_JAVA' is defined. If it is defined, export assumes java has been installed and it us
问题描述 ------------ 在使用EXP工具用户级或者全库的导出时,出现以下错误: ORA-6553 PLS-561 设置了不恰当的参数值 如果JAVA选项已经安装,利用下面语句测试: SELECT count(*) FROM dba_objects WHERE object_type LIKE 'JAVA%'; ->这个选择应该能够返回超过4000行同样通过SYS用户测试下面语句: SELECT dbms_java.longname(name) FROM obj$ WHERE type# = 29 and status != 1;->正常情况下应该返回0行,否则将会报ORA-6553 PLS-561 错误这个问题好像是JAVA选项没有完全安装,使用一下脚本JAVA选项 $ORACLE_HOME/javavm/install/rmjvm.sql 问题依然存在解答描述: ------------------ 如果你不需要JAVA选项,使用下面的脚本移除。 $ORACLE_HOME/javavm/install/rmjvm.sql(注意:在8.1.6版本中该脚本是错误的,使用前必须修改一行"call rmjvm.run(true)" 到 "execute rmjvm.run(true)" 这是一个BUG:1179670使用SQLPLUS的sys用户登陆,运行一下语句: SQL> drop package dbms_java; SQL> drop public synonym dbms_java; 如果你需要JAVA选项,请检查是否真确安装JAVA注释: ------------------------- 通过EXPORT测试同义词'DBMS_JAVA' 是否被定义
导入是将数据库清空,不覆盖已有数据
-------------------
Trying to get full or user export it fails with the following errors: ORA-6553 PLS-561 character set mismatch on value for parameter 'SHORTNAME'
Check if Java option is installed: SELECT count(*) FROM dba_objects WHERE object_type LIKE 'JAVA%';
-> this select should return more than 4000 rows
Also issue as user SYS: SELECT dbms_java.longname(name) FROM obj$ WHERE type# = 29 and status != 1; -> this normally should return 0 rows, otherwise will fail with error ORA-6553 PLS-561.
The problem seems to be that Java Option was not installed properly. Even if removing Java Option by using script $ORACLE_HOME/javavm/install/rmjvm.sql Problem will persist.
Solution Description
--------------------
If you do not need Java Option, first remove it by script:
$ORACLE_HOME/javavm/install/rmjvm.sql (Notice that in 8.1.6 rmjvm.sql is wrong. Before running it you should change line:
"call rmjvm.run(true)" to "execute rmjvm.run(true)"
This is due to [BUG:1179670].
Be careful for having large rollback segments when running it. Then login from sqlplus as SYS user and issue the following commands:
SQL> drop package dbms_java; SQL> drop public synonym dbms_java;
If you need the Java Option check [NOTE:105472.1] for correct Java installation.
Explanation
-----------
Export tests whether the Synonym 'DBMS_JAVA' is defined. If it is defined, export assumes java has been installed and it us
------------
在使用EXP工具用户级或者全库的导出时,出现以下错误:
ORA-6553 PLS-561 设置了不恰当的参数值
如果JAVA选项已经安装,利用下面语句测试:
SELECT count(*) FROM dba_objects WHERE object_type LIKE 'JAVA%';
->这个选择应该能够返回超过4000行同样通过SYS用户测试下面语句:
SELECT dbms_java.longname(name) FROM obj$ WHERE type# = 29 and status != 1;->正常情况下应该返回0行,否则将会报ORA-6553 PLS-561 错误这个问题好像是JAVA选项没有完全安装,使用一下脚本JAVA选项 $ORACLE_HOME/javavm/install/rmjvm.sql
问题依然存在解答描述:
------------------
如果你不需要JAVA选项,使用下面的脚本移除。
$ORACLE_HOME/javavm/install/rmjvm.sql(注意:在8.1.6版本中该脚本是错误的,使用前必须修改一行"call rmjvm.run(true)" 到 "execute rmjvm.run(true)"
这是一个BUG:1179670使用SQLPLUS的sys用户登陆,运行一下语句:
SQL> drop package dbms_java; SQL> drop public synonym dbms_java;
如果你需要JAVA选项,请检查是否真确安装JAVA注释:
-------------------------
通过EXPORT测试同义词'DBMS_JAVA' 是否被定义