What is instance connection and service connection in Oracle?

Question

I am setting up a WebLogic application server. I do not understand what a connection to an instance is and what a service connection is.

Also, in my SQL Developer, when I create a new connection, it asks for either the SID or the service name. What they?

+5

zihaoyu Oct 25 '10 at 21:48

2 answers

, , JDBC-URL, , (SID) .

+1

George 17 . '16 5:59

DCookie · Accepted Answer · 2010-10-25T22:22:14+0000

An instance connection is a TNS connection to a specific instance on a host.

A service connection refers to a specific service that the listener on the node knows about.

, SERVICE . , . , , .