 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Java Forum / Databases / May 2007How to tell the HOST and PORT of oracle DB through SID?
I have one JDBC connection, which works with one particular SID jdbc:oracle:oci8:@MYSID I need to find out what's the host and the port of that instance, because I have to use Thin JDBC, which requires hostname and port. That MYSID is not on local host 1521. I am kind of confused how does Oracle JDBC find out where to connect just through the SID. Thanks in adavnce. -- Jack > I have one JDBC connection, which works with one particular SID > [quoted text clipped - 11 lines] > > -- Jack BTW, that SID is not in any of the tnsnames.org file.... >> I have one JDBC connection, which works with one particular SID >> [quoted text clipped - 9 lines] > > BTW, that SID is not in any of the tnsnames.org file.... How about looking at listener.ora on the database server?  SignatureRegards, Richard On May 15, 6:46 am, Richard Senior <nos...@r-senior.demon.co.uk> wrote: > >> I have one JDBC connection, which works with one particular SID > [quoted text clipped - 16 lines] > > Richard I don't know where is the server, and that's what I am trying to find out..... I just have the SID name, and I am able to connect to the server from client machine. Thanks. > BTW, that SID is not in any of the tnsnames.org file.... The file you want is tnsnames.ora. What is your ORACLE_HOME environment variable set to? Oracle clients can't use your SID to connect without finding it's host and port in the tnsnames.ora file, so the info you want *is* in a file somewhere on your box. Joe Weinstein at BEA Systems > Oracle clients can't use your SID > to connect without finding it's host and port in the tnsnames.ora > file, so the info you want *is* in a file somewhere on your box. Unless it's using Host Naming or Oracle Names, in which case it wouldn't necessarily be in the tnsnames.ora on the client. SignatureRegards, Richard 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.