Which SID to use when connecting

463365

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

38528

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".

Stevefogel-Oracle

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