Forum Stats

  • 3,741,756 Users
  • 2,248,473 Discussions
  • 7,861,976 Comments

Discussions

Which SID to use when connecting

463365
463365 Member Posts: 2
I though I'd post this here because it was not obvious to me. Some tools require that you enter a SID. Simply use XE as the SID.

A typical JDBC string will look like this

jdbc:oracle:thin:jack/*****@192.168.1.87:1521:XE

with the SID XE specified at the very end.

Hope this helps,
Jack

Comments

  • 38528
    38528 Member Posts: 243
    I found that too - it wasn't obvious at all. I guessed by the service name. I think the quickstart guide or developer guide should include it more prominently.

    Even after searching, I barely found an obscure reference under "Connecting Remotely with SQL*Plus".
  • A discussion of which SID to use is in the 2 Day DBA, which, unfortunately, didn't make it into the online help for beta. This book is available on OTN in both HTML and PDF form.

    http://www.oracle.com/pls/xe102/homepage
This discussion has been closed.