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而且我肯定是连接到了数据库。

解决方案 »

  1.   

    ORA-03113: end-of-file on communication channel 
    经典错误遇到这种情况,再开一个sqlplus重新运行试试,
    还出现,检查代码,代码没有问题,就应该是oracle bug了
    找个metalink帐号查下解决办法吧
      

  2.   

    看看这个也许有用
    http://dev.csdn.net/article/18/18628.shtm
      

  3.   

    还是会出现这样的问题,但是我在执行下面的语句会报这样的错,请指教:
    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