Re: How to tell the HOST and PORT of oracle DB through SID?

On May 14, 5:46 pm, jacksu <jacks...@xxxxxxxxx> wrote:
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

BTW, that SID is not in any of the tnsnames.org file....

.

Relevant Pages

  • Re: How to tell the HOST and PORT of oracle DB through SID?
    ... because I have to use Thin JDBC, which requires hostname and port. ... That MYSID is not on local host 1521. ... that SID is not in any of the tnsnames.org file.... ...
    (comp.lang.java.databases)
  • Re: Basic corba help
    ... sid wrote: ... i had replaced ur host name "djb" with my host IP and ... the proper port which was given to me as the naming service port and i ... now i'll confirm whther the port given is a naming service port. ...
    (comp.object.corba)
  • How to tell the HOST and PORT of oracle DB through SID?
    ... I have one JDBC connection, which works with one particular SID ... because I have to use Thin JDBC, which requires hostname and port. ... That MYSID is not on local host 1521. ...
    (comp.lang.java.databases)
  • Re: A firewall wont stop this one
    ... On top of that I implement IPF on each host ... >> for further access control to limit NFS, ... By restricting access to the NFS server. ... >> via port filtering that only allowed specific hosts rather than all. ...
    (alt.computer.security)
  • Re: /etc/hosts.equiv & .rhosts
    ... want to login at another host, that host needs the first host's name ... best to allow key-only login so hackers can't ... on the port 22 as it WILL be messed with all day long. ... # Protocol 2 only ...
    (comp.os.linux.security)