This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes End of TNS datachannel Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "End of TNS datachannel Error" Watch "End of TNS datachannel Error" New topic
Author

End of TNS datachannel Error

Sujatha, Chigullapalli
Greenhorn

Joined: Nov 16, 2001
Posts: 6
Hi,
I was trying to connect to the Oracle database from Sybase App. Server by giving the database address in the Connection Cache properties. I am using the type 4 driver and the URL I am giving in the properties is :
jdbc racle:thin:@Apollo:1526 rcl
I am getting 'End of TNS datachannel' error. I did go through the message posted by someone on this website and the reply from Carl Trusiak. I checked with my DBA and the network administrator about the URL and network configuration of the box from which I am doing this test. They said everything is fine and it has nothing to do with network settings. And I think I did not give anything wrong in the URL I mentioned above, the dbServer is 'Apollo' ,SID 'orcl' listening on port 1526.
I am able to connect to oracle database from 'sql worksheet' from the same box...ping to the database from dos prompt is also successful...
Please help me if there is anything else I would have missed.
Thanks a lot!
Sujatha
[This message has been edited by Sujatha, Chigullapalli (edited November 19, 2001).]
Sujatha, Chigullapalli
Greenhorn

Joined: Nov 16, 2001
Posts: 6
Hi there ...I am still waiting for someone to reply for my message. Please help me figuring out the problem below. I really appreciate your response. Let me know if you need more details.
Thankyou!
Sujatha
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

what is the ORA-XXXXX error number?
Jamie
Sujatha, Chigullapalli
Greenhorn

Joined: Nov 16, 2001
Posts: 6
There is no ORA - xxxxx error associated with this.
It says :
Ping of ats_thin connection cache failed. JCMCache.getConnection() could not acquire a connection. java.sql.SQLException:End of TNS datachannel
ats_thin is the name of the connection cache where I give the URL for the database with user name and password.
Please let me know if you need more details.
Thankyou,
Sujatha
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

If you use System.out.println(e.getMessage()); it should return an error number such as "ORA-00945" or something. This helps in the investigative process. I have not dealt with this error before so I would need the ORA-XXXXX number.
Jamie
 
 
subject: End of TNS datachannel Error
 
Similar Threads
FOR HELP: Failed to connect to oracle in servlet
how to start oracle from command line
Connect to the DB from Oracle forms 6i with existing Oracle 8.1.7.0.0 DB.
Problems with listeners
Oracle connection problems