Hello Everyone,
we work with a Oracle-DB behind a singeldb-Controller with a
oraclethin-Driver.
With our Testsystem it works, on our productive-System we got the
following error:
What could be the reasons? Can it be a not suitable- driver?
We double-checkt ou Firewall,
Startup-output:
Starting Sequoia14:42:08,513 INFO controller.core.Controller Sequoia
controlle
r (2.10.6)
14:42:08,571 INFO controller.core.Controller Loading configuration
file: ../con
fig/controller/loga_controller.xml
14:42:08,659 INFO controller.core.Controller JMX is enabled
14:42:08,682 INFO controller.core.Controller Starting JMX server on
host: 10.0.
3.10
14:42:09,018 INFO backend.DatabaseBackend.logaNode Adding connection
manager fo
r virtual user "apuser"
14:42:09,067 INFO controller.RequestManager.loga_vDB Request manager
will parse
requests with the following granularity: NO_PARSING
14:42:09,075 WARN controller.virtualdatabase.loga_vDB No recovery log
has been
configured, enabling backend without checkpoint.
14:42:09,265 ERROR backend.DatabaseBackend.logaNode Connection test
failed (java
.sql.SQLException: E/A-Exception: The Network Adapter could not
establish the co
nnection)
14:42:09,267 WARN controller.virtualdatabase.loga_vDB Error while
initalizing d
atabase backend logaNode (java.sql.SQLException: Unable to connect to
backend.)
java.sql.SQLException: Unable to connect to backend.
at
org.continuent.sequoia.controller.backend.DatabaseBackend.checkDriver
Compliance(DatabaseBackend.java:615)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.get
AndCheckBackend(VirtualDatabase.java:2101)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.for
ceEnableBackend(VirtualDatabase.java:1913)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.ena
bleAllBackends(VirtualDatabase.java:1797)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.ena
bleAllBackendsFromCheckpoint(VirtualDatabase.java:1817)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabase(
Controller.java:295)
at
org.continuent.sequoia.controller.xml.DatabasesParser.endElement(Data
basesParser.java:699)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1528)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at
org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at
org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442)
at
org.continuent.sequoia.controller.xml.DatabasesParser.readXML(Databas
esParser.java:287)
at
org.continuent.sequoia.controller.xml.DatabasesParser.readXML(Databas
esParser.java:336)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabases
(Controller.java:222)
at
org.continuent.sequoia.controller.core.Controller.loadXmlConfiguratio
n(Controller.java:552)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpV
irtualDatabase(ControllerConfiguration.java:446)
at
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtu
alDatabase(ControllerParser.java:645)
at
org.continuent.sequoia.controller.xml.ControllerParser.startElement(C
ontrollerParser.java:325)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1488)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at
org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at
org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(Contro
llerParser.java:127)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(Contro
llerParser.java:177)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(Contro
llerParser.java:206)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpB
yXml(ControllerConfiguration.java:277)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setup(
ControllerConfiguration.java:327)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.getCon
troller(ControllerConfiguration.java:353)
at
org.continuent.sequoia.controller.core.Controller.main(Controller.jav
a:742)
Caused by: java.net.ConnectException: E/A-Exception: The Network Adapter
could n
ot establish the connection
at
org.continuent.sequoia.controller.backend.DriverCompliance.compliance
Test(DriverCompliance.java:113)
at
org.continuent.sequoia.controller.backend.DatabaseBackend.checkDriver
Compliance(DatabaseBackend.java:607)
... 34 more
Caused by: java.sql.SQLException: E/A-Exception: The Network Adapter
could not e
stablish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
at
oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:369
5)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:352)
at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:362)
at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja
va:536)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:328)
at
org.continuent.sequoia.controller.connection.DriverManager.getConnect
ionForDriver(DriverManager.java:266)
at
org.continuent.sequoia.controller.connection.DriverManager.getConnect
ion(DriverManager.java:168)
at
org.continuent.sequoia.controller.backend.DriverCompliance.compliance
Test(DriverCompliance.java:103)
... 35 more
14:42:09,274 WARN controller.core.Controller Failed to automatically
enable bac
kends, manual resynchronization is probably needed
14:42:09,275 INFO controller.core.Controller Adding VirtualDatabase
loga_vDB
14:42:09,281 INFO controller.core.Controller Waiting for connections on
0.0.0.0
:1521
14:42:09,293 INFO controller.core.Controller Controller started on
2007.05.23 2
1 at 02:42:09 PM CEST
14:42:09,294 INFO controller.core.Controller Controller 10.0.3.10:1521
ready, l
istening to requests ...
this is our virtualdb-config:
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.3//EN"
"http://sequoia
.continuent.org/dtds/sequoia-2.10.3.dtd">
<SEQUOIA>
<VirtualDatabase name="loga_vDB" maxNbOfConnections="100"
poolThreads="true"
minNbOfThreads="0" maxNbOfThreads="100" maxThreadIdleTime="60"
sqlDumpLength="40
">
<AuthenticationManager>
<Admin>
<User username="aduser" password="xxx"/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="apuser" vPassword="xxx"/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="logaNode"
driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@x.x.x.x:1521:xyz" connectionTestStatement="SELECT
* FROM dual">
<DatabaseSchema dynamicPrecision="static"
gatherSystemTables="false"/>
<ConnectionManager vLogin="apuser" rLogin="xxx" rPassword="xxx">
<SimpleConnectionManager/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager caseSensitiveParsing="false" beginTimeout="60"
commitTimeo
ut="60" rollbackTimeout="60">
<RequestScheduler>
<SingleDBScheduler level="pessimisticTransaction"/>
</RequestScheduler>
<RequestCache>
<MetadataCache maxNbOfMetadata="1000" maxNbOfField="100"/>
<ParsingCache backgroundParsing="false" maxNbOfEntries="500"/>
</RequestCache>
<LoadBalancer transactionIsolation="databaseDefault">
<SingleDB/>
</LoadBalancer>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
controller.xml:
<?xml version="1.0" encoding="ISO-8859-1" ?>
<!DOCTYPE SEQUOIA-CONTROLLER PUBLIC "-//Continuent//DTD
SEQUOIA-CONTROLLER 2.10/
/EN" "http://sequoia.continuent.org/dtds/sequoia-controller-2.10.dtd";>
<!-- This file is changed according to the german sequoia tutorial-->
<SEQUOIA-CONTROLLER>
<Controller port="1521">
<Report/>
<JmxSettings>
<RmiJmxAdaptor port="1099">
</RmiJmxAdaptor>
</JmxSettings>
<VirtualDatabase configFile="loga_singledb.xml"
virtualDatabaseName="loga_vDB" autoEnableBackends="true"
checkpointName="Initial_empty_recovery_log"/>
</Controller>
</SEQUOIA-CONTROLLER>
Thanx for any help.
Greetings,
Sebastian
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
