50,530
社区成员
发帖
与我相关
我的任务
分享Databus2与oracle链接失败，求解答
2017-11-10 16:44:11,034 +1289 [main] (INFO) {ServerContainer} Changing container config
2017-11-10 16:44:11,047 +1302 [main] (INFO) {RelayEventProducersRegistry} registering relay event producer for scheme mock: com.linkedin.databus2.producers.MockEventProducerServiceProvider@5d0957b1
2017-11-10 16:44:11,049 +1304 [main] (INFO) {RelayEventProducersRegistry} registering relay event producer for scheme or: com.linkedin.databus2.producers.OpenReplicatorEventProducerServiceProvider@361b9546
2017-11-10 16:44:11,051 +1306 [main] (INFO) {DatabusRelayMain} initializing producers
2017-11-10 16:44:11,051 +1306 [main] (INFO) {MultiServerSequenceNumberHandler} creating sequence number handler for server name:{"id":1,"name":"person"}
2017-11-10 16:44:11,052 +1307 [main] (INFO) {FileMaxSCNHandler} creating file:/databus2-gradle/build/databus2-example-relay-pkg/distributions/./maxScn/MaxSCN_person
2017-11-10 16:44:11,052 +1307 [main] (INFO) {FileMaxSCNHandler} Trying to read initial SCN from file: /databus2-gradle/build/databus2-example-relay-pkg/distributions/./maxScn/MaxSCN_person
2017-11-10 16:44:11,052 +1307 [main] (INFO) {FileMaxSCNHandler} Starting from MAX SCN:0
2017-11-10 16:44:11,053 +1308 [main] (INFO) {DatabusRelayMain} Starting server container with maxScnReaderWriter:/databus2-gradle/build/databus2-example-relay-pkg/distributions/./maxScn/MaxSCN_person:0
2017-11-10 16:44:11,054 +1309 [main] (INFO) {OracleEventProducerFactory} Loading schema for source id 101: {"type":"record","name":"Person_V1","namespace":"com.linkedin.events.example.person","fields":[{"name":"txn","type":["long","null"],"meta":"dbFieldName=TXN;dbFieldPosition=0;"},{"name":"key","type":["long","null"],"meta":"dbFieldName=KEY;dbFieldPosition=1;"},{"name":"firstName","type":["string","null"],"meta":"dbFieldName=FIRST_NAME;dbFieldPosition=2;"},{"name":"lastName","type":["string","null"],"meta":"dbFieldName=LAST_NAME;dbFieldPosition=3;"},{"name":"birthDate","type":["long","null"],"meta":"dbFieldName=BIRTH_DATE;dbFieldPosition=4;"},{"name":"deleted","type":["string","null"],"meta":"dbFieldName=DELETED;dbFieldPosition=5;"}],"meta":"dbFieldName=sy$person;pk=key;"}
2017-11-10 16:44:11,063 +1318 [main] (INFO) {OracleAvroGenericEventFactory} com.linkedin.events.example.person.Person_V1: using primary key override:key
2017-11-10 16:44:11,145 +1400 [main] (INFO) {OracleEventProducer_person} Registered source statistics mbean: com.linkedin.databus2:name=com.linkedin.events.example.person.Person,type=SourceStatistics
2017-11-10 16:44:11,147 +1402 [main] (INFO) {person} EventQuery=select /*+ first_rows LEADING(tx) */ person.sync_core.getScn(tx.scn, tx.ora_rowscn) scn, tx.ts event_timestamp, src.* from person.sy$person src, person.sy$txlog tx where src.txn=tx.txn and tx.scn > ? and tx.ora_rowscn > ?
2017-11-10 16:44:11,147 +1402 [main] (INFO) {person} Generated events query. source: com.linkedin.events.example.person.Person (id=101) ; eventQuery: select /*+ first_rows LEADING(tx) */ person.sync_core.getScn(tx.scn, tx.ora_rowscn) scn, tx.ts event_timestamp, src.* from person.sy$person src, person.sy$txlog tx where src.txn=tx.txn and tx.scn > ? and tx.ora_rowscn > ?
2017-11-10 16:44:11,147 +1402 [main] (INFO) {person} Generated Chunked Txn events query. source: com.linkedin.events.example.person.Person (id=101) ; chunkTxnEventQuery: SELECT scn, event_timestamp, src.* FROM person.sy$person src, ( SELECT /*+ first_rows LEADING(tx) cardinality(tx,1) */ person.sync_core.getScn(tx.scn, tx.ora_rowscn) scn, tx.ts event_timestamp, tx.txn, row_number() OVER (ORDER BY TX.SCN) r FROM person.sy$txlog tx WHERE tx.scn > ? AND tx.ora_rowscn > ? AND tx.scn < 9999999999999999999999999999) t WHERE src.txn = t.txn AND r<= ? ORDER BY r
2017-11-10 16:44:11,147 +1402 [main] (INFO) {person} Generated Chunked Scn events query. source: com.linkedin.events.example.person.Person (id=101) ; chunkScnEventQuery: SELECT /*+ first_rows LEADING(tx) */ sync_core.getScn(tx.scn, tx.ora_rowscn) scn, tx.ts event_timestamp, src.* FROM sy$person src, sy$txlog tx WHERE src.txn=tx.txn AND tx.scn > ? AND tx.ora_rowscn > ? AND tx.ora_rowscn <= ?
2017-11-10 16:44:11,147 +1402 [main] (INFO) {OracleEventProducerFactory} Created OracleEventProducer for config: name=person;part={"id":1,"name":"person"};uri=jdbc:oracle:thin:*/*@127.0.0.1:1521:orcl;role=MASTER;rsKey=;#src=1 with slowSourceQueryThreshold = 2000
2017-11-10 16:44:11,150 +1405 [main] (INFO) {MonitoringEventProducer} Reading source: _schema = |person.|
2017-11-10 16:44:11,152 +1407 [main] (INFO) {MonitoringEventProducer} Monitoring Query: select scn from person.sy$txlog where txn = ( select max(txn) from person.sy$person )
2017-11-10 16:44:11,153 +1408 [main] (INFO) {DBStatistics} Registered DB statistics statistics mbean: com.linkedin.databus2:name=person,type=DBStatistics
2017-11-10 16:44:11,153 +1408 [main] (INFO) {SourceDBStatistics} Registered DB source statistics statistics mbean: com.linkedin.databus2:name=com.linkedin.events.example.person.Person,type=SourceDBStatistics
2017-11-10 16:44:11,153 +1408 [main] (INFO) {MonitoringEventProducer} Created dbMonitor.person:1 producer
2017-11-10 16:44:11,154 +1409 [main] (INFO) {DatabusRelayMain} done initializing producers
2017-11-10 16:44:11,184 +1439 [main] (INFO) {ServerContainer} Saving port number in /databus2-gradle/build/databus2-example-relay-pkg/distributions/./containerPortNum_1322419623
2017-11-10 16:44:11,184 +1439 [main] (INFO) {ServerContainer} Serving container 1322419623 HTTP listener on port 11115
2017-11-10 16:44:11,184 +1439 [main] (INFO) {DatabusRelayMain} Starting. Producers are :{{"id":1,"name":"person"}=com.linkedin.databus2.producers.db.OracleEventProducer@529ad1e0}
2017-11-10 16:44:11,184 +1439 [main] (INFO) {DatabusRelayMain} starting db puller: person
2017-11-10 16:44:11,184 +1439 [main] (INFO) {OracleEventProducer_person} OracleEventProducer.start: sinceScn = -1restartScnOffset = 0
2017-11-10 16:44:11,185 +1440 [main] (INFO) {OracleEventProducer_person} attempting to read persistent event producer checkpoint
2017-11-10 16:44:11,185 +1440 [main] (INFO) {OracleEventProducer_person} Proposed sinceSCN = 0
2017-11-10 16:44:11,185 +1440 [main] (INFO) {OracleEventProducer_person} Starting EventProducerThread from SCN: 0
2017-11-10 16:44:11,189 +1444 [main] (INFO) {OracleEventProducer_person} person started.
2017-11-10 16:44:11,189 +1444 [main] (INFO) {DatabusRelayMain} db puller started: person
2017-11-10 16:44:11,190 +1445 [main] (INFO) {ServerContainer} Databus service started!
2017-11-10 16:44:11,190 +1445 [main] (INFO) {ServerContainer} waiting for shutdown request for container id: 1322419623
2017-11-10 16:44:11,239 +1494 [EventProducerThread_person] (ERROR) {DBHelper} Invoking a rollback after the connection is closed
2017-11-10 16:44:11,240 +1495 [EventProducerThread_person] (ERROR) {person} readEventsFromAllSources exception:The Network Adapter could not establish the connection
java.sql.SQLException: The Network Adapter could not establish the connection
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:480)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:275)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:206)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:156)
at com.linkedin.databus2.producers.db.OracleTxlogEventReader.resetConnections(OracleTxlogEventReader.java:606)
at com.linkedin.databus2.producers.db.OracleTxlogEventReader.readEventsFromAllSources(OracleTxlogEventReader.java:193)
at com.linkedin.databus2.producers.db.OracleEventProducer.readEventsFromAllSources(OracleEventProducer.java:120)
at com.linkedin.databus2.producers.AbstractEventProducer$EventProducerThread.run(AbstractEventProducer.java:273)
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:328)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:421)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:630)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:206)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)
... 11 more
Caused by: java.net.ConnectException: 拒绝连接
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at java.net.Socket.<init>(Socket.java:425)
at java.net.Socket.<init>(Socket.java:208)
at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:127)
at oracle.net.nt.ConnOption.connect(ConnOption.java:126)
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:306)
... 16 more
2017-11-10 16:44:11,047 +1302 [main] (INFO) {RelayEventProducersRegistry} registering relay event producer for scheme mock: com.linkedin.databus2.producers.MockEventProducerServiceProvider@5d0957b1
2017-11-10 16:44:11,049 +1304 [main] (INFO) {RelayEventProducersRegistry} registering relay event producer for scheme or: com.linkedin.databus2.producers.OpenReplicatorEventProducerServiceProvider@361b9546
2017-11-10 16:44:11,051 +1306 [main] (INFO) {DatabusRelayMain} initializing producers
2017-11-10 16:44:11,051 +1306 [main] (INFO) {MultiServerSequenceNumberHandler} creating sequence number handler for server name:{"id":1,"name":"person"}
2017-11-10 16:44:11,052 +1307 [main] (INFO) {FileMaxSCNHandler} creating file:/databus2-gradle/build/databus2-example-relay-pkg/distributions/./maxScn/MaxSCN_person
2017-11-10 16:44:11,052 +1307 [main] (INFO) {FileMaxSCNHandler} Trying to read initial SCN from file: /databus2-gradle/build/databus2-example-relay-pkg/distributions/./maxScn/MaxSCN_person
2017-11-10 16:44:11,052 +1307 [main] (INFO) {FileMaxSCNHandler} Starting from MAX SCN:0
2017-11-10 16:44:11,053 +1308 [main] (INFO) {DatabusRelayMain} Starting server container with maxScnReaderWriter:/databus2-gradle/build/databus2-example-relay-pkg/distributions/./maxScn/MaxSCN_person:0
2017-11-10 16:44:11,054 +1309 [main] (INFO) {OracleEventProducerFactory} Loading schema for source id 101: {"type":"record","name":"Person_V1","namespace":"com.linkedin.events.example.person","fields":[{"name":"txn","type":["long","null"],"meta":"dbFieldName=TXN;dbFieldPosition=0;"},{"name":"key","type":["long","null"],"meta":"dbFieldName=KEY;dbFieldPosition=1;"},{"name":"firstName","type":["string","null"],"meta":"dbFieldName=FIRST_NAME;dbFieldPosition=2;"},{"name":"lastName","type":["string","null"],"meta":"dbFieldName=LAST_NAME;dbFieldPosition=3;"},{"name":"birthDate","type":["long","null"],"meta":"dbFieldName=BIRTH_DATE;dbFieldPosition=4;"},{"name":"deleted","type":["string","null"],"meta":"dbFieldName=DELETED;dbFieldPosition=5;"}],"meta":"dbFieldName=sy$person;pk=key;"}
2017-11-10 16:44:11,063 +1318 [main] (INFO) {OracleAvroGenericEventFactory} com.linkedin.events.example.person.Person_V1: using primary key override:key
2017-11-10 16:44:11,145 +1400 [main] (INFO) {OracleEventProducer_person} Registered source statistics mbean: com.linkedin.databus2:name=com.linkedin.events.example.person.Person,type=SourceStatistics
2017-11-10 16:44:11,147 +1402 [main] (INFO) {person} EventQuery=select /*+ first_rows LEADING(tx) */ person.sync_core.getScn(tx.scn, tx.ora_rowscn) scn, tx.ts event_timestamp, src.* from person.sy$person src, person.sy$txlog tx where src.txn=tx.txn and tx.scn > ? and tx.ora_rowscn > ?
2017-11-10 16:44:11,147 +1402 [main] (INFO) {person} Generated events query. source: com.linkedin.events.example.person.Person (id=101) ; eventQuery: select /*+ first_rows LEADING(tx) */ person.sync_core.getScn(tx.scn, tx.ora_rowscn) scn, tx.ts event_timestamp, src.* from person.sy$person src, person.sy$txlog tx where src.txn=tx.txn and tx.scn > ? and tx.ora_rowscn > ?
2017-11-10 16:44:11,147 +1402 [main] (INFO) {person} Generated Chunked Txn events query. source: com.linkedin.events.example.person.Person (id=101) ; chunkTxnEventQuery: SELECT scn, event_timestamp, src.* FROM person.sy$person src, ( SELECT /*+ first_rows LEADING(tx) cardinality(tx,1) */ person.sync_core.getScn(tx.scn, tx.ora_rowscn) scn, tx.ts event_timestamp, tx.txn, row_number() OVER (ORDER BY TX.SCN) r FROM person.sy$txlog tx WHERE tx.scn > ? AND tx.ora_rowscn > ? AND tx.scn < 9999999999999999999999999999) t WHERE src.txn = t.txn AND r<= ? ORDER BY r
2017-11-10 16:44:11,147 +1402 [main] (INFO) {person} Generated Chunked Scn events query. source: com.linkedin.events.example.person.Person (id=101) ; chunkScnEventQuery: SELECT /*+ first_rows LEADING(tx) */ sync_core.getScn(tx.scn, tx.ora_rowscn) scn, tx.ts event_timestamp, src.* FROM sy$person src, sy$txlog tx WHERE src.txn=tx.txn AND tx.scn > ? AND tx.ora_rowscn > ? AND tx.ora_rowscn <= ?
2017-11-10 16:44:11,147 +1402 [main] (INFO) {OracleEventProducerFactory} Created OracleEventProducer for config: name=person;part={"id":1,"name":"person"};uri=jdbc:oracle:thin:*/*@127.0.0.1:1521:orcl;role=MASTER;rsKey=;#src=1 with slowSourceQueryThreshold = 2000
2017-11-10 16:44:11,150 +1405 [main] (INFO) {MonitoringEventProducer} Reading source: _schema = |person.|
2017-11-10 16:44:11,152 +1407 [main] (INFO) {MonitoringEventProducer} Monitoring Query: select scn from person.sy$txlog where txn = ( select max(txn) from person.sy$person )
2017-11-10 16:44:11,153 +1408 [main] (INFO) {DBStatistics} Registered DB statistics statistics mbean: com.linkedin.databus2:name=person,type=DBStatistics
2017-11-10 16:44:11,153 +1408 [main] (INFO) {SourceDBStatistics} Registered DB source statistics statistics mbean: com.linkedin.databus2:name=com.linkedin.events.example.person.Person,type=SourceDBStatistics
2017-11-10 16:44:11,153 +1408 [main] (INFO) {MonitoringEventProducer} Created dbMonitor.person:1 producer
2017-11-10 16:44:11,154 +1409 [main] (INFO) {DatabusRelayMain} done initializing producers
2017-11-10 16:44:11,184 +1439 [main] (INFO) {ServerContainer} Saving port number in /databus2-gradle/build/databus2-example-relay-pkg/distributions/./containerPortNum_1322419623
2017-11-10 16:44:11,184 +1439 [main] (INFO) {ServerContainer} Serving container 1322419623 HTTP listener on port 11115
2017-11-10 16:44:11,184 +1439 [main] (INFO) {DatabusRelayMain} Starting. Producers are :{{"id":1,"name":"person"}=com.linkedin.databus2.producers.db.OracleEventProducer@529ad1e0}
2017-11-10 16:44:11,184 +1439 [main] (INFO) {DatabusRelayMain} starting db puller: person
2017-11-10 16:44:11,184 +1439 [main] (INFO) {OracleEventProducer_person} OracleEventProducer.start: sinceScn = -1restartScnOffset = 0
2017-11-10 16:44:11,185 +1440 [main] (INFO) {OracleEventProducer_person} attempting to read persistent event producer checkpoint
2017-11-10 16:44:11,185 +1440 [main] (INFO) {OracleEventProducer_person} Proposed sinceSCN = 0
2017-11-10 16:44:11,185 +1440 [main] (INFO) {OracleEventProducer_person} Starting EventProducerThread from SCN: 0
2017-11-10 16:44:11,189 +1444 [main] (INFO) {OracleEventProducer_person} person started.
2017-11-10 16:44:11,189 +1444 [main] (INFO) {DatabusRelayMain} db puller started: person
2017-11-10 16:44:11,190 +1445 [main] (INFO) {ServerContainer} Databus service started!
2017-11-10 16:44:11,190 +1445 [main] (INFO) {ServerContainer} waiting for shutdown request for container id: 1322419623
2017-11-10 16:44:11,239 +1494 [EventProducerThread_person] (ERROR) {DBHelper} Invoking a rollback after the connection is closed
2017-11-10 16:44:11,240 +1495 [EventProducerThread_person] (ERROR) {person} readEventsFromAllSources exception:The Network Adapter could not establish the connection
java.sql.SQLException: The Network Adapter could not establish the connection
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:480)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:275)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:206)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:156)
at com.linkedin.databus2.producers.db.OracleTxlogEventReader.resetConnections(OracleTxlogEventReader.java:606)
at com.linkedin.databus2.producers.db.OracleTxlogEventReader.readEventsFromAllSources(OracleTxlogEventReader.java:193)
at com.linkedin.databus2.producers.db.OracleEventProducer.readEventsFromAllSources(OracleEventProducer.java:120)
at com.linkedin.databus2.producers.AbstractEventProducer$EventProducerThread.run(AbstractEventProducer.java:273)
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:328)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:421)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:630)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:206)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)
... 11 more
Caused by: java.net.ConnectException: 拒绝连接
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at java.net.Socket.<init>(Socket.java:425)
at java.net.Socket.<init>(Socket.java:208)
at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:127)
at oracle.net.nt.ConnOption.connect(ConnOption.java:126)
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:306)
... 16 more
...全文
请发表友善的回复…
发表回复
