Unable to connect to the database

using TS5.5.2 on Soalris and datadeploy is 5.6

DataDeploy Version 5.6.0 Build 14707 Interwoven 20021211
Database Vendor set to oracle
Max Identifier length set to 28 characters.
SQL datatype for column PROGNAME is VARCHAR2(100)
SQL datatype for column SUBHEADLINE is VARCHAR2(200)
SQL datatype for column PROGTIME is VARCHAR2(40)
SQL datatype for column LANGUAGE is VARCHAR2(10)
Area VPath:/default/main/StarHub2/WORKAREA/CMPTEST/templatedata/cabletv/cabletv
Setting up consumer TDbAgent
>>> Loading drivers <<<
url : 10.6.13.16:1521:HR83DMO
login : system
login timeout=3
Connecting to the database...
Try connecting using jdbc Smiley Surprised

racle

ci8:@10.6.13.16:1521:HR83DMO...
SQL failure
ERROR:ERROR: Could not connect to [jdbc Smiley Surprised

racle

ci8:@10.6.13.16:1521:HR83DMO]

*******************************************************
SQLException occured in JdbcCheckup:MakeConnection()
Exception Message: ORA-06401: NETCMN: invalid driver designator

Vendor Error Code: 6401
SQL state: 66000
*******************************************************

*******STACK TRACE*************
java.sql.SQLException: ORA-06401: NETCMN: invalid driver designator

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:1597)
at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:354)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:246)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja
va:365)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at com.interwoven.dd100.dd.JdbcCheckup.MakeConnection(JdbcCheckup.java:3
61)
at com.interwoven.dd100.dd.JdbcCheckup.TryConnect(JdbcCheckup.java:458)
at com.interwoven.dd100.dd.TDbConnectionManager.GetConnection(TDbConnect
ionManager.java:75)
at com.interwoven.dd100.dd.TDbAgent.EstablishConnection(TDbAgent.java:51
3)
at com.interwoven.dd100.dd.TDbAgent.<init>(TDbAgent.java:238)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumer(TConsumerManag
er.java:601)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumersForOneDeployme
nt(TConsumerManager.java:191)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumers(TConsumerMana
ger.java:133)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:97)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:487)
at com.interwoven.dd100.dd.IWDataDeploy.runDeploy(IWDataDeploy.java:527)
at com.interwoven.dd100.dd.IWDataDeploy.main(IWDataDeploy.java:508)
ERROR:Could not connect to [10.6.13.16:1521:HR83DMO]
ERROR:Unable to connect to 10.6.13.16:1521:HR83DMO
Error occured in TDbAgent
Rollback database [10.6.13.16:1521:HR83DMO]...
Deployment[member] Table[CABLE4]
-----------------------------------
Tuples inserted : 0
Tuples updated : 0
Tuples deleted : 0
Tuples failed : 0
Tuples rolled back : 0
Tuples skipped : 0
-----------------------------------
ERROR:TDbAgent create failure
Started : Fri Nov 01 06:24:18 GMT-06:00 2002
Finished: Fri Nov 01 06:24:18 GMT-06:00 2002

### IWDataDeploy FAILED ###

Find more posts tagged with

Comments

iwovGraduate

A few checks:
The Oracle DB you are trying to connect to, is it on the same box ? OS ?
Do you have Oracle client installed on the TeamSite box ?
If so, are you able to connect to the DB using sqlplus or something similar ?

Also check: http://www.experts-exchange.com/Databases/Oracle/Q_20571411.html
(May not be relevant)

ramam77

yaa ..Oracle is installed on the same solaris box. OS is solaris.
i m able to connect to the databse using sqlplus....and FYI..i m able to deploy content to the other oracle databse installed on a windows machine using the same datadeploy on solaris machine

Migrateduser

Back up the classes12.zip in your ddhome/lib directory and replace it with the one from Oracle installation. Check if that works and you might want to file a support case.