Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get Host:SID by Service Name?

68453Feb 3 2003 — edited Feb 4 2003
I am asking a user to enter name, password, and a service name in order to connect to Oracle. It works fine with OLEDB and SQLPlus connections.
Later I need to launch a Java program, which supposed to connect to the same DB through the thin JDBC driver.
As you probably know the JDBC driver requires HOST and SID names.
The question: Is there a feasible way for a regular user to get HOST and SID values knowing Oracle Net Service Name? Or, otherwise, I doomed ridiculously ask a user to enter: name, password, service name, host name, SID name to connect to each Oracle server?

I appreciate any help with the issue.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2003
Added on Feb 3 2003
3 comments
1,186 views