Issue 900 in tungsten-replicator: Unable to connect to query source tables

[tungsten-...@googlecode.com]

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

New issue 900 by wellyyan...@gmail.com: Unable to connect to query source
tables
http://code.google.com/p/tungsten-replicator/issues/detail?id=900

What steps will reproduce the problem?
1. setupCDC.sh with below
**************************************************************************
service=TEST
sys_user=sys
sys_pass=oracle
export source_user=TEST
pub_user=${source_user}_PUB
pub_password=test
tungsten_user=tungsten
tungsten_pwd=tungsten
delete_publisher=1
delete_subscriber=0
cdc_type=SYNC_SOURCE
specific_tables=0
specific_path=

***********************************************************************************
2. execute tpm install with below
***********************************************************************************
# Options for the test data service
tools/tpm configure test \
--install-directory=/opt/continuent/ \
--master=107.cdr \
--members=107.cdr \
--start=true
# Options for 107.cdr
tools/tpm configure test \
--hosts=107.cdr \
--datasource-oracle-service=orcl \
--datasource-type=oracle \
--property=replicator.extractor.dbms.transaction_frag_size=10 \
--property=replicator.global.extract.db.password=tungsten \
--property=replicator.global.extract.db.user=tungsten \
--replication-password=test \
--replication-port=1521 \
--replication-user=TEST_PUB \
--svc-applier-filters=optimizeupdates \
--svc-table-engine=CDCSYNC
************************************************************************************
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-00942: table or view does not exist
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744)
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:209)
oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:803)
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1048)
oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:844)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1153)
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1312)
com.continuent.tungsten.replicator.extractor.oracle.OracleCDCReaderThread.prepare(OracleCDCReaderThread.java:152)
...
What version of the product are you using?
tungsten-replicator 2.2
...
On what operating system?
cent-os 6.3
...
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 900 by linas.vi...@continuent.com: Unable to connect to

query source tables
http://code.google.com/p/tungsten-replicator/issues/detail?id=900

Please provide output of setupCDC.sh call, as well as tpm calls. Also,
increase number of lines included in the trepsvc.log.

[tungsten-...@googlecode.com]

Comment #2 on issue 900 by wellyyan...@gmail.com: Unable to connect to

query source tables
http://code.google.com/p/tungsten-replicator/issues/detail?id=900

1.The output of setupCDC.sh:

Configuring CDC for service 'TEST' for Oracle 11. Change Set
is 'TUNGSTEN_CS_TEST'
Removing old CDC installation if any (SYSDBA)
Done.
Deleting old publisher user 'TEST_PUB' (SYSDBA)
Done.
Setup tungsten_load (SYSDBA)
Done.
Creating publisher/subscriber and preparing table instantiation (SYSDBA)
Done.
Setting up SYNC_SOURCE (TEST_PUB)
Oracle version : 11.2.0.1.0
Setting Up Synchronous Data Capture TUNGSTEN_CS_TEST for Oracle 11
Processing TEST.USR -> 'CT_USR' : created at SCN 1121698
Processing TEST.DEPT_INFO -> 'CT_DEPT_INFO' : created at SCN 1121723
Processing TEST.DEPT -> 'CT_DEPT' : created at SCN 1121746

PL/SQL procedure successfully completed.

Done.
adding synonym if needed (tungsten)
Done.
Cleaning up (SYSDBA)
Done.


2.The output of ./tpm install test --hosts=107.cdr:
[tungsten@localhost tools]$ ./tpm install test --hosts=107.cdr
.....................................................................................
ERROR >> 107_cdr >> At least one replication service has experienced an
error
#####################################################################
# Commitment failed
#####################################################################
#####################################################################
# Errors for 107_cdr
#####################################################################
ERROR >> 107_cdr >> At least one replication service has experienced an
error

NOTE >> Check the status of all hosts before taking action
.................


3.The error in trepsvc.log, full in attachment:
INFO | jvm 1 | 2014/05/09 09:24:56 | 2014-05-09 09:24:56,256 [ -
WrapperSimpleAppMain] ERROR management.OpenReplicatorManager Online
operation failed
INFO | jvm 1 | 2014/05/09 09:24:56 |
com.continuent.tungsten.replicator.management.ReplicatorStateException:
State transition failed causing emergency recovery: state=OFFLINE:NORMAL
transition=OFFLINE-GO-ONLINE-1 event=GoOnlineEvent
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.management.OpenReplicatorManager.getStateMachineException(OpenReplicatorManager.java:562)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.management.OpenReplicatorManager.onCompletion(OpenReplicatorManager.java:528)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.fsm.event.EventProcessor.run(EventProcessor.java:108)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
java.util.concurrent.FutureTask.run(FutureTask.java:262)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
java.lang.Thread.run(Thread.java:744)
INFO | jvm 1 | 2014/05/09 09:24:56 | Caused by:
com.continuent.tungsten.fsm.core.TransitionFailureException: Replicator
unable to go online due to error
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.management.OpenReplicatorManager$OfflineToSynchronizingAction.doAction(OpenReplicatorManager.java:1251)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.fsm.core.StateMachine.applyEvent(StateMachine.java:220)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.fsm.event.EventProcessor.run(EventProcessor.java:78)
INFO | jvm 1 | 2014/05/09 09:24:56 | ... 5 more
INFO | jvm 1 | 2014/05/09 09:24:56 | Caused by:
com.continuent.tungsten.replicator.ReplicatorException: Unable to prepare
plugin: class
name=com.continuent.tungsten.replicator.extractor.ExtractorWrapper
message=[Unable to connect to query source tables]
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.conf.ReplicatorRuntime.preparePlugin(ReplicatorRuntime.java:1240)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.pipeline.StageTaskGroup.prepare(StageTaskGroup.java:183)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.pipeline.Stage.prepare(Stage.java:272)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.pipeline.Pipeline.prepare(Pipeline.java:274)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.conf.ReplicatorRuntime.prepare(ReplicatorRuntime.java:634)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.management.tungsten.TungstenPlugin.online(TungstenPlugin.java:391)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.management.OpenReplicatorManager$OfflineToSynchronizingAction.doAction(OpenReplicatorManager.java:1242)
INFO | jvm 1 | 2014/05/09 09:24:56 | ... 7 more
INFO | jvm 1 | 2014/05/09 09:24:56 | Caused by:
com.continuent.tungsten.replicator.ReplicatorException: Unable to connect
to query source tables
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.extractor.oracle.OracleCDCReaderThread.prepare(OracleCDCReaderThread.java:168)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.extractor.oracle.OracleCDCReaderExtractor.prepare(OracleCDCReaderExtractor.java:185)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.extractor.ExtractorWrapper.prepare(ExtractorWrapper.java:283)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.conf.ReplicatorRuntime.preparePlugin(ReplicatorRuntime.java:1236)
INFO | jvm 1 | 2014/05/09 09:24:56 | ... 13 more
INFO | jvm 1 | 2014/05/09 09:24:56 | Caused by: java.sql.SQLException:

ORA-00942: table or view does not exist

INFO | jvm 1 | 2014/05/09 09:24:56 |
INFO | jvm 1 | 2014/05/09 09:24:56 | at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:209)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:803)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1048)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:844)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1153)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1312)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.extractor.oracle.OracleCDCReaderThread.prepare(OracleCDCReaderThread.java:152)
INFO | jvm 1 | 2014/05/09 09:24:56 | ... 16 more
INFO | jvm 1 | 2014/05/09 09:24:56 | 2014-05-09 09:24:56,259 [ -
WrapperSimpleAppMain] ERROR management.OpenReplicatorManager Start
operation failed
INFO | jvm 1 | 2014/05/09 09:24:56 | java.lang.Exception: Online
operation failed (Unable to connect to query source tables)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.management.OpenReplicatorManager.online2(OpenReplicatorManager.java:2129)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.management.OpenReplicatorManager.online(OpenReplicatorManager.java:2098)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.management.OpenReplicatorManager.start(OpenReplicatorManager.java:2053)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.management.ReplicationServiceManager.startReplicationService(ReplicationServiceManager.java:674)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.management.ReplicationServiceManager.go(ReplicationServiceManager.java:162)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.management.ReplicationServiceManager.main(ReplicationServiceManager.java:251)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
java.lang.reflect.Method.invoke(Method.java:606)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:290)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
java.lang.Thread.run(Thread.java:744)
INFO | jvm 1 | 2014/05/09 09:24:56 | 2014-05-09 09:24:56,260 [ -
WrapperSimpleAppMain] ERROR management.ReplicationServiceManager Unable to
start replication service 'test'
INFO | jvm 1 | 2014/05/09 09:24:56 | java.lang.Exception: Start
operation failed: Online operation failed (Unable to connect to query
source tables)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.management.OpenReplicatorManager.start(OpenReplicatorManager.java:2060)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.management.ReplicationServiceManager.startReplicationService(ReplicationServiceManager.java:674)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.management.ReplicationServiceManager.go(ReplicationServiceManager.java:162)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
com.continuent.tungsten.replicator.management.ReplicationServiceManager.main(ReplicationServiceManager.java:251)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
java.lang.reflect.Method.invoke(Method.java:606)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:290)
INFO | jvm 1 | 2014/05/09 09:24:56 | at
java.lang.Thread.run(Thread.java:744)


4.I try to use JDBC for testing.It is OK, results are correct:
Class.forName("oracle.jdbc.OracleDriver");
Connection conn =
DriverManager.getConnection("jdbc:oracle:thin:@192.168.3.108:1521:orcl", "TEST_PUB", "test");
System.out.println(conn.getMetaData().getDatabaseMajorVersion());
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM TUNGSTEN_SOURCE_TABLES");
while (rs.next())
{
String srcSchema = rs.getString("SOURCE_SCHEMA_NAME");
String srcTable = rs.getString("SOURCE_TABLE_NAME");
System.out.println(srcSchema + "." + srcTable);
}

Attachments:
trepsvc.log 25.7 KB

[tungsten-...@googlecode.com]

Comment #3 on issue 900 by wellyyan...@gmail.com: Unable to connect to

query source tables
http://code.google.com/p/tungsten-replicator/issues/detail?id=900

Sorry, "jdbc:oracle:thin:@192.168.3.108:1521:orcl" is
actually "jdbc:oracle:thin:@192.168.3.107:1521:orcl".

[tungsten-...@googlecode.com]

Comment #4 on issue 900 by 777...@gmail.com: Unable to connect to query
source tables
http://code.google.com/p/tungsten-replicator/issues/detail?id=900

Fixes needed to configuration:

1. We usually use this in the first tpm call:

--enable-heterogenous-service=true \

2. "107.cdr" should be exactly what OS `hostname` call returns.

Then:

q1. What are you trying to achieve with this setup where there is no slave
defined?

q2. Oracle version and edition?

[tungsten-...@googlecode.com]

Comment #5 on issue 900 by wellyyan...@gmail.com: Unable to connect to

query source tables
http://code.google.com/p/tungsten-replicator/issues/detail?id=900

1.I used this and the question still happened.

2.Yes, the hostname is correct.
[tungsten@107 bin]$ hostname
107.cdr

q1. I deployed with a slave previously and the question was the same.So I
tried to deploy only a master to check whether the slave caused it.It
seemed that the slave did not.

q2.Both the master and the slave:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production


I read the 2.2 manual again and find that centos 6 is not mentioned in OS
support.Does it cause this question?

[tungsten-...@googlecode.com]

Updates:
Labels: Oracle

Comment #6 on issue 900 by linas.vi...@continuent.com: Unable to connect to

query source tables
http://code.google.com/p/tungsten-replicator/issues/detail?id=900

Remove this as it has no effect on master:

--svc-applier-filters=optimizeupdates \

It doesn't look OS related, rather configuration. What is the output
of "SELECT * FROM TUNGSTEN_SOURCE_TABLES" if you execute it from `sqlplus
TEST_PUB/test` console?

Also, output of `./trepctl properties -filter user`?

[tungsten-...@googlecode.com]

Comment #7 on issue 900 by wellyyan...@gmail.com: Unable to connect to

query source tables
http://code.google.com/p/tungsten-replicator/issues/detail?id=900

I removed it and updated the master.It still happened.

1.the output of "SELECT * FROM TUNGSTEN_SOURCE_TABLES"

[oracle@107 ~]$ sqlplus TEST_PUB/test

SQL*Plus: Release 11.2.0.1.0 Production on Mon May 12 11:54:26 2014

Copyright (c) 1982, 2009, Oracle. All rights reserved.


Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

SQL> SELECT * FROM TUNGSTEN_SOURCE_TABLES;

SOURCE_SCHEMA_NAME SOURCE_TABLE_NAME
------------------------------ ------------------------------
TEST_PUB HEARTBEAT
TEST DEPT_INFO
TEST USR
TEST DEPT

SQL>

2.output of `./trepctl properties -filter user`
[tungsten@107 bin]$ ./trepctl properties -filter user
{
"replicator.applier.dbms.user": "TEST_PUB",
"replicator.filter.pkey.user": "",
"replicator.global.db.user": "TEST_PUB",
"replicator.store.thl.user": "TEST_PUB",
"replicator.extractor.dbms.user": "tungsten",
"replicator.global.extract.db.user": "tungsten"

[tungsten-...@googlecode.com]

Comment #8 on issue 900 by zippy0...@gmail.com: Unable to connect to query
source tables
http://code.google.com/p/tungsten-replicator/issues/detail?id=900

You are installing as tungsten user, but examples above are executed by
oracle user. Does your tungsten user has Oracle environment initialized?
It's not visible which user you have used during swtupCDC call.
Alternatively, you can change the OS user used for the master in configure
call and reinstall:

--user=oracle

[tungsten-...@googlecode.com]

Comment #9 on issue 900 by linas.vi...@continuent.com: Unable to connect to

query source tables
http://code.google.com/p/tungsten-replicator/issues/detail?id=900

Also, please try again with the latest official version 2.2.1-403:

http://code.google.com/p/tungsten-replicator/wiki/Downloads?tm=2

[tungsten-...@googlecode.com]

Comment #10 on issue 900 by wellyyan...@gmail.com: Unable to connect to

query source tables
http://code.google.com/p/tungsten-replicator/issues/detail?id=900

I resolved this problem and did not use 2.2.1.I do not know whether 2.2.1
has fixed it.

My steps are:

1.In the first, I executed the setupCDC.sh with delete_subscriber=1 and
specific_tables=0.Then the output like this:
[tungsten@107cdr setupCDC]$ ./setupCDC.sh
Configuring CDC for service '' for Oracle 11. Change Set
is 'TUNGSTEN_CHANGE_SET'

Removing old CDC installation if any (SYSDBA)
Done.

Deleting old publisher user 'AEGIS_PUB' (SYSDBA)
Done.
Deleting old subscriber/Tungsten user 'tungsten' (SYSDBA)
WARN: [126] sqlplus statement failed (Tungsten user did not exist?) -
ignoring

Done.
Setup tungsten_load (SYSDBA)
Done.
Creating publisher/subscriber and preparing table instantiation (SYSDBA)
Done.

Setting up HOTLOG_SOURCE (AEGIS_PUB)
Oracle version : 11.2.0.1.0
Setting Up Asynchronous Data Capture TUNGSTEN_CHANGE_SET
Enabling change set : TUNGSTEN_CHANGE_SET
DECLARE
*
ERROR at line 1:
ORA-01917: user or role 'tungsten' does not exist
ORA-06512: at line 416

Done.
adding synonym if needed (tungsten)

ERROR:
ORA-01017: invalid username/password; logon denied\

SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus
ERROR: [1] sqlplus statement failed

2.I read issue 825 and created tungsten user by hand.Then I executed
setupCDC.sh with delete_subscriber=0 and specific_tables=0.The output had
no errors.But after I deployed the master,the problem happened like the
title.

3.Then I read issue 648.
Firstly I executed setupCDC.sh with delete_subscriber=1 and
specific_tables=1.The output is:
[tungsten@107cdr setupCDC]$ ./setupCDC.sh

Configuring CDC for service 'TEST' for Oracle 11. Change Set
is 'TUNGSTEN_CS_TEST'
Removing old CDC installation if any (SYSDBA)
Done.
Deleting old publisher user 'TEST_PUB' (SYSDBA)
Done.

Deleting old subscriber/Tungsten user 'tungsten' (SYSDBA)

Done.
Setup tungsten_load (SYSDBA)
Done.
Creating publisher/subscriber and preparing table instantiation (SYSDBA)
Done.
Setting up SYNC_SOURCE (TEST_PUB)

ERROR:
ORA-01017: invalid username/password; logon denied


SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus
ERROR: [1] sqlplus statement failed
---------------------------------
Then I executed it with delete_subscriber=1 and specific_tables=0.It was
OK, no errors.I deployed the master and it worked fine.

Why?

[tungsten-...@googlecode.com]

Updates:
Labels: -FoundIn FoundIn-2.2.0

Comment #11 on issue 900 by linas.vi...@continuent.com: Unable to connect

to query source tables
http://code.google.com/p/tungsten-replicator/issues/detail?id=900

It seems, you have changed source user from AEGIS to TEST and back a few
times. As it stands currently, this confuses setupCDC, hence cleanup must
be performed. It's logged in Issue 739. This could have been at the root of
misbehavior.

Incidentally, we are planning to improve the setup process for Oracle for
the next release to make it easier and avoid issues like yours.

[tungsten-...@googlecode.com]

Updates:
Status: Accepted
Owner: linas.vi...@continuent.com
Labels: FixedIn-3.0.0

Comment #12 on issue 900 by linas.vi...@continuent.com: Unable to connect

to query source tables
http://code.google.com/p/tungsten-replicator/issues/detail?id=900

I was able to reproduce it once. The fix was to change from
delete_publisher=1 to 0 and re-run setupCDC.sh. There must be a race
condition depending on when the subscriber user is created.
Regardless, this will be addressed.

[tungsten-...@googlecode.com]

Updates:
Status: Fixed

Comment #13 on issue 900 by linas.vi...@continuent.com: Unable to connect

to query source tables
http://code.google.com/p/tungsten-replicator/issues/detail?id=900

This issue should have been addressed as part of Issue 825. There was a
bug: subscriber user was not being created if specific_tables=0. It is
fixed now.