datadeploy error

Hi All,
I am getting an error while data deploying from teamsite to 11G DB,
Below is the error:
please help me, whats the cause for this error.

DBD: Setting up TDbSchemaAgent.
DBD: url : jdbc Smiley Surprised

racle:thin:@dbhost:1546 Smiley Frustrated

ervicename
DBD: login : username
DBD: login timeout=3
DBD: Connecting to the database...
DBD: Try connecting using jdbc Smiley Surprised

racle:thin:@dbhost:1546 Smiley Frustrated

ervicename...
DBD: SQL failure
DBD: ERROR:ERROR: Could not connect to [jdbc Smiley Surprised

racle:thin:@dbhost:1546 Smiley Frustrated

ERVICENAME]
DBD:
DBD: *******************************************************
DBD: SQLException occured in JdbcCheckup:MakeConnection()
DBD: Exception Message: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186647040)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
DBD: Vendor Error Code: 17002
DBD: SQL state: null
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186647040)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
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:333)
at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:404)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at com.interwoven.dd100.dd.JdbcCheckup.MakeConnection(JdbcCheckup.java:447)
at com.interwoven.dd100.dd.JdbcCheckup.TryConnect(JdbcCheckup.java:586)
at com.interwoven.dd100.dd.TDbConnectionManager.GetConnection(TDbConnectionManager.java:78)

Find more posts tagged with

Comments

ISCBorisB

The core of your problem is ORA-17002 Error, "The Network Adapter could not establish Connection".
You may want to search the Net/Oracle Support for "ORA-17002".

If I were you I would start by double-checking JDBC URL (from DD Database Configuration) with my DB Admin.
The main culprit is "subname" ie, what you see as "dbhost:1546" in the Log. So...

- Is 1546 the correct Port?
- Is "dbhost" the correct name? Can you ping it from OD Base? Can you replace it with the IP? Does it
have "fully qualified" form? If it does, try to use one even if the simple name *should* work.
- Can you establish a SQL*Plus connection from OD Base to the same Oracle instance?

nipper

And are you using the correct JDBC driver to connect to 11G ?

anilapr24

Hi All,

After making changes to database.xml ,data deploy was working fine.
But suddenly, i am getting below error in OD logs when i deploy same DCR's again.

DBD: Setting up TDbSchemaAgent.
DBD: Validating cached connection...
DBD: ERROR:Exception4: java.lang.NegativeArraySizeException
DBD: ERROR:
java.lang.NegativeArraySizeException
at oracle.net.ano.CryptoDataPacket.decryptAndChecksum(CryptoDataPacket)
at oracle.net.ano.CryptoDataPacket.(CryptoDataPacket)
at oracle.net.ano.AnoNetInputStream.processPacket(AnoNetInputStream)
at oracle.net.ns.NetInputStream.getNextPacket(Unknown Source)
at oracle.net.ns.NetInputStream.read(Unknown Source)
at oracle.net.ns.NetInputStream.read(Unknown Source)
at oracle.net.ns.NetInputStream.read(Unknown Source)
at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:931)
at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:893)
at oracle.jdbc.ttc7.Oopen.receive(Oopen.java:105)
at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:586)
at oracle.jdbc.driver.OracleStatement.(OracleStatement.java:385)
at oracle.jdbc.driver.OracleConnection.privateCreateStatement(OracleConnection.java:772)
at oracle.jdbc.driver.OracleConnection.createStatement(OracleConnection.java:712)
at oracle.jdbc.OracleDatabaseMetaData.getCatalogs(OracleDatabaseMetaData.java:2335)
at com.interwoven.dd100.dd.TDbAgent.ValidateConnection(TDbAgent.java:587)
at com.interwoven.dd100.dd.TDbConnectionManager.GetConnection(TDbConnectionManager.java:64)
at com.interwoven.dd100.dd.TDbAgent.EstablishConnection(TDbAgent.java:549)
at com.interwoven.dd100.dd.TDbAgent.(TDbAgent.java:271)
at com.interwoven.dd100.dd.TDbSchemaAgent.(TDbSchemaAgent.java:64)
at com.interwoven.dd100.dd.TConsumerManager.getDbAgentBasedOnGroupUpdate(TConsumerManager.java:514)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumer(TConsumerManager.java:587)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumersForOneDeployment(TConsumerManager.java:192)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumersForMultiDeployment(TConsumerManager.java:150)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumers(TConsumerManager.java:129)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:105)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:582)
at com.interwoven.dd100.dd.TWorkItem.DoIt(TWorkItem.java:165)
at com.interwoven.dd100.dd.TLonelyWorker.run(TLonelyWorker.java:38)

Thank you,
Anil