 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Java Forum / Databases / February 2006Need help regarding JDBC
Hi, I'm using Oracle 8.0 as database..for which i have created a new TNS entry with my own SID. I tried a demo run of my app, which was running fine..and was able to connect to the database as well. Bu recently i have subscribed to a broadband service...and after the same i try to run the app...its not connectin to the DB. It is giving the following message on the console... ORA-12203: TNS:unable to connect to destination My TNS entry goes as such ORACLE.SWEETHEART = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sweetheart)(PORT = XXXX)) (CONNECT_DATA = (SID = ORCL)) ) Plz help > Hi, > [quoted text clipped - 16 lines] > > Plz help In a command shell from a window on the machine you want your application to work, do a 'tracert sweetheart' to see if your network can find that machine. You should use the thin driver, which doesn't need any TNS file... HTH, Joe Weinstein at BEA Systems I pologise that i didn't mentioned that sweetheart is my local system's name, where i have my application and the Oracle Server. So any how tracert would find my machine. Thanks for responding to my message Regards, Mradul > Hi, > [quoted text clipped - 16 lines] > > Plz help This looks more like a networking issue rather than a java problem. What opertaing system are you using? I'm using Window 2000 Pro. I don't agree that this could happen due to a network issue. coz before subscription to broadband service...i was able to logon to the java application that i created. but after the subscription, i don't know what happened. Regards, Mradul Mradul schrieb am 05.02.2006 20:33: > I'm using Window 2000 Pro. I don't agree that this could happen due to > a network issue. coz before subscription to broadband service...i was [quoted text clipped - 4 lines] > > Mradul maybe your new isp blocks traffic on some ports. try a "telnet <ip> <port>" on the command line with ip of your server and the port your database is listening to, and see if you get an answer. > I'm using Window 2000 Pro. I don't agree that this could happen due to > a network issue. coz before subscription to broadband service...i was > able to logon to the java application that i created. but after the > subscription, i don't know what happened. I'm guessing that before you subscribed to broadband, your machine probably did hostname-to-IP address lookup via a static table. Now, however, your machine has DNS servers allocated dynamically by your broadband ISP using DHCP, and hostname-to-IP address lookups are referred to them instead. They don't know which machine the name "sweetheart" points to, because it's a name that you allocated to a machine within your own private network, not a name that can be used on the global Internet. Open a "Command Prompt" window and type ping sweetheart If you see a message which says Ping request could not find host sweetheart. Please check the name and try again then this is indeed your problem. David Harper Cambridge, England Hi David, Thanks for the solution, this could be the case. Coz when i'm pinging my system, it is showing the IP address assigned to me by my ISP. Thanks again Regards, Mradul Kaushik > Hi David, > > Thanks for the solution, this could be the case. Coz when i'm pinging > my system, it is showing the IP address assigned to me by my ISP. Your Oracle server may only be listening on IP address 127.0.0.1. Try changing the hostname in the TNS entry: ORACLE.SWEETHEART = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = XXXX)) (CONNECT_DATA = (SID = ORCL)) ) David Harper Cambridge, England > Hi, > [quoted text clipped - 16 lines] > > Plz help Perhaps a network problem? Perhaps firewall related? I've recently read a thread similar to this one, have a look at it: http://groups.google.com/group/comp.databases.oracle.server/browse_thread/th read/c194bc73905f5e6b/20a8867ff670b29d#20a8867ff670b29d This might be the same problem you're faced with. Good luck! JC -- http://jcsnippets.atspace.com a collection of source code, tips and tricks Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.