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 : jdbcracle: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
posted
0
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
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
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
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.