Oracle异常ORA-29538、ORA-29540
来源:互联网 发布:linux 查看服务列表 编辑:程序博客网 时间:2024/06/07 09:42
遇到的Oracle错误1:
ORA-29538: Java not installed
ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 1017
ORA-06512: at line 2
原因:Oracle数据库JVM组件(JServer JAVA Virtual Machine)没有安装
遇到的Oracle错误2:
ORA-29540: class oracle/CDC/PublishApi does not exist
ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 810
ORA-06512: at line 1
原因:卸载安装JVM以后,CDC也需要重新卸载安装
/****
题外话:
卸载Oracle JVM命令:
$ cd $ORACLE_HOME/javavm/install
$ sqlplus /nolog
SQL> conn / as sysdba
SQL> @rmjvm.sql
SQL> shutdown immediate
SQL> startup
****/
解决方案:
step1: 确认是否缺少JVM组件
$ sqlplus /nolog
SQL> conn / as sysdba
SQL> SELECT comp_name || ' : '||version|| ' : '|| status FROM dba_registry;
确认JServer JAVA Virtual Machine没有安装
step2: 安装Oracle JVM
$ cd $ORACLE_HOME/javavm/install
$ sqlplus /nolog
SQL> conn / as sysdba
SQL> @initjvm.sql
step3: 重新安装CDC
$ cd $ORACLE_HOME/rdbms/admin/
$ sqlplus /nolog
SQL> conn / as sysdba
SQL> @rmcdc.sql
SQL> @initcdc.sql
如果不执行step3,会报错Oracle错误2。
ORA-29538: Java not installed
ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 1017
ORA-06512: at line 2
原因:Oracle数据库JVM组件(JServer JAVA Virtual Machine)没有安装
遇到的Oracle错误2:
ORA-29540: class oracle/CDC/PublishApi does not exist
ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 810
ORA-06512: at line 1
原因:卸载安装JVM以后,CDC也需要重新卸载安装
/****
题外话:
卸载Oracle JVM命令:
$ cd $ORACLE_HOME/javavm/install
$ sqlplus /nolog
SQL> conn / as sysdba
SQL> @rmjvm.sql
SQL> shutdown immediate
SQL> startup
****/
解决方案:
step1: 确认是否缺少JVM组件
$ sqlplus /nolog
SQL> conn / as sysdba
SQL> SELECT comp_name || ' : '||version|| ' : '|| status FROM dba_registry;
确认JServer JAVA Virtual Machine没有安装
step2: 安装Oracle JVM
$ cd $ORACLE_HOME/javavm/install
$ sqlplus /nolog
SQL> conn / as sysdba
SQL> @initjvm.sql
step3: 重新安装CDC
$ cd $ORACLE_HOME/rdbms/admin/
$ sqlplus /nolog
SQL> conn / as sysdba
SQL> @rmcdc.sql
SQL> @initcdc.sql
如果不执行step3,会报错Oracle错误2。
阅读全文
0 0
- Oracle异常ORA-29538、ORA-29540
- Oracle异常:ORA-12505
- Oracle JOB异常ORA-06512
- ORACLE处理 ORA-01033异常
- Oracle异常 ORA-04068: ORA-04061: ORA-04065: ORA-06508 解决办法 (一)
- MyEclipse连接Oracle,出现ORA-00604和ORA-12705异常
- oracle-ora 各种sql异常描述
- oracle-ora 各种sql异常描述
- 转:oracle-ora 各种sql异常描述
- oracle SCN异常增长以及 ORA-19706
- oracle listener.ora sqlnet.ora tnsnames.ora
- Oracle sqlnet.ora, tnsnames.ora, listener.ora
- Oracle ORA-01034,ORA-27101,ORA-00600
- oracle ORA-01200&ORA-01110&ORA-01122
- Oracle ORA-29538错误解决
- ORACLE ORA-00132 ORA-00214
- oracle ora-39062,ORA-39107
- oracle ORA-00600,ORA-01033
- 2D(横版)游戏开发心得
- 页面跳转的几种方法
- 2131
- Hive的学习笔记
- 查看 Oracle数据库的版本、服务名、SID
- Oracle异常ORA-29538、ORA-29540
- “一带一路”与儿时的回忆
- MNIST机器学习入门
- C# 集合在OOP中的应用
- Intellij IDEA 设置字体加粗
- NIO与IO流
- 复数与相位(旋转)
- Invisible character on env file, cause programe abort abnormally
- mongodb小心得