search

tejeswarp / tungsten-replicator

Automatically exported from code.google.com/p/tungsten-replicator
0 stars 0 forks source link

setupCDC.sh: error is misleading if tungsten.tables files is missing #524

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?

Try ./setupCDC.sh with tungsten.tables being a symlink.

What is the expected output?

Success or human understandable error that symlink is unsupported.

What do you see instead?

This is what ones get if there's no tungsten.tables file, or if it is a 
symlink. The error doesn't even remotely mention that the problem is with 
tungsten.tables: 

* Undescriptive error *

[oracle@qa scripts]$ ./setupCDC.sh setupCDC.conf.DEMO
Using configuration setupCDC.conf.DEMO

Configuring CDC for service 'fromdemo'. Change Set is 'TUNGSTEN_CS_fromdemo'
Removing old CDC installation if any (SYSDBA)
Done.
Deleting old publisher user 'DEMO_PUB' (SYSDBA)
Done.
Deleting old tungsten user 'tungsten' (SYSDBA)
Done.
Setup tungsten_load (SYSDBA)
Done.
Creating publisher/subscriber and preparing table instantiation (SYSDBA)
Done.
Setting up SYNC_SOURCE (DEMO_PUB)
ERROR:
ORA-01017: invalid username/password; logon denied

* With debug on *

[oracle@qa scripts]$ ./setupCDC.sh setupCDC.conf.DEMO
Using configuration setupCDC.conf.DEMO

Configuring CDC for service 'fromdemo'. Change Set is 'TUNGSTEN_CS_fromdemo'
Removing old CDC installation if any (SYSDBA)
Done.
Deleting old publisher user 'DEMO_PUB' (SYSDBA)
Done.
Deleting old tungsten user 'tungsten' (SYSDBA)
Done.
Setup tungsten_load (SYSDBA)
Done.
Creating publisher/subscriber and preparing table instantiation (SYSDBA)
old 6: v_user varchar2(30) := '&1';
new 6: v_user varchar2(30) := 'DEMO';
old 7: v_pub_user varchar2(30) := '&2';
new 7: v_pub_user varchar2(30) := 'DEMO_PUB';
old 8: v_password varchar2(30) := '&3';
new 8: v_password varchar2(30) := 'DEMO_PUB';
old 11: v_tungsten_user varchar2(30) := '&4';
new 11: v_tungsten_user varchar2(30) := 'tungsten';
old 12: v_tungsten_pwd varchar2(30) := '&5';
new 12: v_tungsten_pwd varchar2(30) := 'secret';
old 14: v_cdc_type varchar(30) := '&6';
new 14: v_cdc_type varchar(30) := 'SYNC_SOURCE';
DECLARE
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04001: error opening file
/home/oracle/downloads/continuent-tungsten-replication-2.0.7-119/tungsten-replic
ator/scripts/tungsten.tables
ORA-06512: at "SYS.ORACLE_LOADER", line 52
ORA-06512: at line 21

Done.
Setting up SYNC_SOURCE (DEMO_PUB)
ERROR:
ORA-01017: invalid username/password; logon denied

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

What is the possible cause?

Possibly, not enough error catching logic.

What is the proposed solution?

./setupCDC.sh should tell the user that tungsten.tables file is missing and/or 
symlink is unsupported.

Original issue reported on code.google.com by linas.vi...@continuent.com on 22 Mar 2013 at 11:55

GoogleCodeExporter commented 9 years ago 
Scheduling for later release

Original comment by stephane...@continuent.com on 26 Mar 2013 at 9:48

GoogleCodeExporter commented 9 years ago 
We'll use 2.1.0 instead of 2.0.8, hence moving the issues.

Original comment by linas.vi...@continuent.com on 27 Mar 2013 at 3:13

GoogleCodeExporter commented 9 years ago 
Moving to 2.1.2

Original comment by linas.vi...@continuent.com on 21 Aug 2013 at 12:59

GoogleCodeExporter commented 9 years ago

Original comment by linas.vi...@continuent.com on 26 Aug 2013 at 1:54

GoogleCodeExporter commented 9 years ago 
There won't be a 2.1.3.

Original comment by linas.vi...@continuent.com on 17 Sep 2013 at 10:13

GoogleCodeExporter commented 9 years ago

Original comment by linas.vi...@continuent.com on 23 Dec 2013 at 9:51

GoogleCodeExporter commented 9 years ago 
postponing

Original comment by stephane...@continuent.com on 30 Jan 2014 at 9:21

GoogleCodeExporter commented 9 years ago

Original comment by stephane...@continuent.com on 30 Jan 2014 at 9:22

GoogleCodeExporter commented 9 years ago

Original comment by linas.vi...@continuent.com on 19 Jun 2014 at 12:20

GoogleCodeExporter commented 9 years ago

Original comment by linas.vi...@continuent.com on 19 Jun 2014 at 1:28

GoogleCodeExporter commented 9 years ago 
As part of Issue 826 logging level in create_publisher_subscriber.sql has been 
increased and now there's a descriptive error if there's a problem with 
tungsten.tables file:

ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04001: error opening file
/home/oracle/downloads/current/tungsten-replicator/scripts/tungsten.tables
ORA-06512: at "SYS.ORACLE_LOADER", line 52
ORA-06512: at line 27

Original comment by linas.vi...@continuent.com on 20 Jun 2014 at 8:53