Oracle extractor is not working propery. ERROR ORA-31514

[GoogleCodeExporter]

What steps will reproduce the problem?
1. setupCDC.sh with below
**************************************************************************
#
# Define name of tungsten service to use per service name change sets
#
service=alpha
# Enter user that can connect as SYSDBA. Leave it empty if you
# can connect as / as sysdba
sys_user=system
# If sys_pass is left empty, it will be queried when the script
# is run, otherwise, it will be used.
sys_pass=imsi00
# Source schema user
export source_user=POLARIS
# Publisher user that will be created
pub_user=${source_user}_PUB
# Publisher password (will be used @ creation time)
pub_password=imsi00
# Subscriber user : this is the user that Tungsten Replicator
# will use to connect to Oracle and to get data from CDC views.
tungsten_user=tungsten
tungsten_pwd=imsi00
# should the publisher user be deleted ? (1 = delete)
delete_publisher=0
# should the subscriber user (tungsten_user) be deleted ? (1 = delete)
delete_subscriber=0
# Change CDC type as desired :
# - SYNC_SOURCE : synchronous capture
# - HOTLOG_SOURCE : asynchronous capture (HOTLOG)
cdc_type=HOTLOG_SOURCE
# Prepare for replication only the tables listed in tungsten.tables file? (0 = 
no, 1 = yes)
# Check tungsten.tables files for more details.
specific_tables=0
# Path where the tungsten.tables file is located.
# Warning, in case of RAC, it needs to be in a shared location
# If left empty, it will use the current directory as location.
specific_path=
********************************************************************************
***
2. execute tpm install with below
********************************************************************************
***
./tools/tpm install ALPHA \
--master=oracle1 \
--home-directory=/root/install \
--datasource-host=oracle1 \
--datasource-type=oracle \
--svc-table-engine=CDCASYNC \
--property=replicator.extractor.dbms.transaction_frag_size=10 \
--datasource-port=1521 \
--datasource-user=POLARIS \
--datasource-password=imsi00 \
--property=replicator.global.extract.db.user=tungsten \
--property=replicator.global.extract.db.password=imsi00 \
--datasource-oracle-service=ORCL \
--start
********************************************************************************
****
3. service was not started.
What is the expected output?
    - Service Start
...
What do you see instead?
    - SErvice was not started with error
********************************************************************************
****
 Caused by: java.sql.SQLException: ORA-31514: change set  disabled due to capture error
 ORA-06512: at "SYS.DBMS_CDC_SUBSCRIBE", line 37
 ORA-06512: at line 1
...
What version of the product are you using?
     tungsten-replicator 2.2
...
On what operating system?
     cent-os 5.2 x86
...
Please provide any additional information below.
Notes:
...

Original issue reported on code.google.com by nijin39 on 5 Feb 2014 at 10:28

[GoogleCodeExporter]

What is Oracle version?
Search for clues in the Oracle logs.

Original comment by linas.vi...@continuent.com on 5 Feb 2014 at 2:47

[GoogleCodeExporter]

ORACLE VERSION: 11.2.0.1.0

Original comment by nijin39 on 6 Feb 2014 at 2:29

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

[root@oracle1 bin]# ./trepctl -service ALPHA status
Processing status command...
NAME                     VALUE
----                     -----
appliedLastEventId     : NONE
appliedLastSeqno       : -1
appliedLatency         : -1.0
channels               : -1
clusterName            : default
currentEventId         : NONE
currentTimeMillis      : 1391654068161
dataServerHost         : oracle1
extensions             : 
host                   : oracle1
latestEpochNumber      : -1
masterConnectUri       : 
masterListenUri        : thl://oracle1:2112/
maximumStoredSeqNo     : -1
minimumStoredSeqNo     : -1
offlineRequests        : NONE
pendingError           : Replicator unable to go online due to error
pendingErrorCode       : NONE
pendingErrorEventId    : NONE
pendingErrorSeqno      : -1
pendingExceptionMessage: Unable to prepare plugin: class 
name=com.continuent.tungsten.replicator.extractor.ExtractorWrapper 
message=[Failed to execute query BEGIN 
DBMS_CDC_SUBSCRIBE.ACTIVATE_SUBSCRIPTION(subscription_name => 
'TUNGSTEN_SUB_ALPHA');END;]
pipelineSource         : UNKNOWN
relativeLatency        : -1.0
resourcePrecedence     : 99
rmiPort                : 10000
role                   : master
seqnoType              : java.lang.Long
serviceName            : ALPHA
serviceType            : unknown
simpleServiceName      : ALPHA
siteName               : default
sourceId               : oracle1
state                  : OFFLINE:ERROR
timeInStateSeconds     : 11.182
transitioningTo        : 
uptimeSeconds          : 17.163
useSSLConnection       : false
version                : Tungsten Replicator 2.2.0 build 292
Finished status command...

Original comment by nijin39 on 6 Feb 2014 at 2:35

[GoogleCodeExporter]

attach the trepsvc log file. 

Original comment by nijin39 on 6 Feb 2014 at 2:38

Attachments:

• trepsvc.log

[GoogleCodeExporter]

What do Oracle logs say? This is Oracle internal error.

Original comment by linas.vi...@continuent.com on 6 Feb 2014 at 6:32

[GoogleCodeExporter]

I have a same problem!! help!!!!!

Original comment by lichun.s...@gmail.com on 10 Apr 2014 at 7:25

[GoogleCodeExporter]

Oracle logs doesn't print error,I have a same problem! help!!!!!

Original comment by kimskee...@gmail.com on 8 Jul 2015 at 4:15

[Icarus0xff]

I have met this situation too, is there anyone can help me with this problem?