Issue 819 in tungsten-replicator: Oracle extractor is not working propery. ERROR ORA-31514

[tungsten-...@googlecode.com]

Status: New
Owner: ----
Labels: Type-Defect Priority-Medium FoundIn

New issue 819 by nijin39: Oracle extractor is not working propery. ERROR
ORA-31514
http://code.google.com/p/tungsten-replicator/issues/detail?id=819

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:
...

--
You received this message because this project is configured to send all
issue notifications to this address.
You may adjust your notification preferences at:
https://code.google.com/hosting/settings

[tungsten-...@googlecode.com]

Comment #1 on issue 819 by linas.vi...@continuent.com: Oracle extractor is

not working propery. ERROR ORA-31514
http://code.google.com/p/tungsten-replicator/issues/detail?id=819

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

[tungsten-...@googlecode.com]

Comment #2 on issue 819 by nijin39: Oracle extractor is not working

propery. ERROR ORA-31514
http://code.google.com/p/tungsten-replicator/issues/detail?id=819

ORACLE VERSION: 11.2.0.1.0

[tungsten-...@googlecode.com]

Comment #3 on issue 819 by nijin39: Oracle extractor is not working

propery. ERROR ORA-31514
http://code.google.com/p/tungsten-replicator/issues/detail?id=819

[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 : 1391653834522
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.thl.THL
message=[java.sql.SQLException: ORA-31514: change set TUNGSTEN_CS_ALPHA

disabled due to capture error

ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 725
ORA-06512: at line 1
]
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 : 848.429
transitioningTo :
uptimeSeconds : 855.587
useSSLConnection : false
version : Tungsten Replicator 2.2.0 build 292
Finished status command...

[tungsten-...@googlecode.com]

Comment #4 on issue 819 by nijin39: Oracle extractor is not working

propery. ERROR ORA-31514
http://code.google.com/p/tungsten-replicator/issues/detail?id=819

[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

[tungsten-...@googlecode.com]

Comment #5 on issue 819 by nijin39: Oracle extractor is not working

propery. ERROR ORA-31514
http://code.google.com/p/tungsten-replicator/issues/detail?id=819

attach the trepsvc log file.

Attachments:
trepsvc.log 155 KB

[tungsten-...@googlecode.com]

Comment #6 on issue 819 by linas.vi...@continuent.com: Oracle extractor is

not working propery. ERROR ORA-31514
http://code.google.com/p/tungsten-replicator/issues/detail?id=819

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

[tungsten-...@googlecode.com]

Comment #7 on issue 819 by lichu...@sina.com: Oracle extractor is not

working propery. ERROR ORA-31514
http://code.google.com/p/tungsten-replicator/issues/detail?id=819

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

[tungsten-...@googlecode.com]

Comment #8 on issue 819 by kimskee...@gmail.com: Oracle extractor is not
working propery. ERROR ORA-31514
https://code.google.com/p/tungsten-replicator/issues/detail?id=819

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