SQL> @/opt/oracle/product/10.2.0/db_1/rdbms/admin/initcdc.sql;
call sys.dbms_java.loadjava('-v -f -r -s -g public rdbms/jlib/CDC.jar')
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE而且我肯定是连接到了数据库。
call sys.dbms_java.loadjava('-v -f -r -s -g public rdbms/jlib/CDC.jar')
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE而且我肯定是连接到了数据库。
经典错误遇到这种情况,再开一个sqlplus重新运行试试,
还出现,检查代码,代码没有问题,就应该是oracle bug了
找个metalink帐号查下解决办法吧
http://dev.csdn.net/article/18/18628.shtm
SQL> begin
2 dbms_cdc_publish.create_change_table(
3 owner =>'cdcpub',
4 change_table_name =>'info_ct',
5 change_set_name =>'ybgba_info',
6 source_schema =>'ybgba',
7 source_table =>'info',
8 column_type_list =>'id int,name varchar2(20),sex int,age int',
9 capture_values =>'both',
10 rs_id =>'y',
11 row_id =>'n',
12 user_id =>'n',
13 timestamp =>'n',
14 object_id =>'n',
15 source_colmap =>'y',
16 target_colmap =>'y',
17 options_string =>'tablespace tbs_data');
18 end;
19 /
begin
*
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
java.lang.NullPointerException
ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 611
ORA-06512: at line 2