How to get Host:SID by Service Name?
68453Feb 3 2003 — edited Feb 4 2003I 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.