oracle instance_name vs. service_name

#1

If I use sqlplus to connect to a database, I do it like that:

sqlplus user1/secret1 (AT) ora1 (DOT) mydomain.com:1583/db.prd1

where db.prd1 is the service_name.

If I do the connect through JDBC, the connection url is:

jdbc

racle:thin:@ora1.mydomain.com:1583:db1

SQLPLUS uses the service name, whereas JDBC uses the instance_name
(resp. sid).

How does this work? Is the oracle protocol so that either instance
name or service name can be used?

Martin

#2

J?ns M?rtin Schl?tt?r <KmoEfrUewEbx (AT) spammotel (DOT) com> wrote:

Quote:

If I use sqlplus to connect to a database, I do it like that:

sqlplus user1/secret1 (AT) ora1 (DOT) mydomain.com:1583/db.prd1

where db.prd1 is the service_name.

That's using the EZCONNECT syntax, ok.

Quote:

If I do the connect through JDBC, the connection url is:

jdbc

racle:thin:@ora1.mydomain.com:1583:db1

SQLPLUS uses the service name, whereas JDBC uses the instance_name
(resp. sid).

How does this work? Is the oracle protocol so that either instance
name or service name can be used?

I am surprised that this URL works, as indeed it does.

I cannot find this form under the supported Syntaxes in
http://download-uk.oracle.com/docs/c...s.htm#BEICDECB

According to the documentation, it should be

jdbc

racle:thin:@//ora1.mydomain.com:1583/db.prd1

Yours,
Laurenz Albe

#3

J?ns M?rtin Schl?tt?r <KmoEfrUewEbx (AT) spammotel (DOT) com> wrote:

Quote:

If I use sqlplus to connect to a database, I do it like that:

sqlplus user1/secret1 (AT) ora1 (DOT) mydomain.com:1583/db.prd1

where db.prd1 is the service_name.

That's using the EZCONNECT syntax, ok.

Quote:

If I do the connect through JDBC, the connection url is:

jdbc

racle:thin:@ora1.mydomain.com:1583:db1

SQLPLUS uses the service name, whereas JDBC uses the instance_name
(resp. sid).

How does this work? Is the oracle protocol so that either instance
name or service name can be used?

I am surprised that this URL works, as indeed it does.

I cannot find this form under the supported Syntaxes in
http://download-uk.oracle.com/docs/c...s.htm#BEICDECB

According to the documentation, it should be

jdbc

racle:thin:@//ora1.mydomain.com:1583/db.prd1

Yours,
Laurenz Albe

#4

J?ns M?rtin Schl?tt?r <KmoEfrUewEbx (AT) spammotel (DOT) com> wrote:

Quote:

If I use sqlplus to connect to a database, I do it like that:

sqlplus user1/secret1 (AT) ora1 (DOT) mydomain.com:1583/db.prd1

where db.prd1 is the service_name.

That's using the EZCONNECT syntax, ok.

Quote:

If I do the connect through JDBC, the connection url is:

jdbc

racle:thin:@ora1.mydomain.com:1583:db1

SQLPLUS uses the service name, whereas JDBC uses the instance_name
(resp. sid).

How does this work? Is the oracle protocol so that either instance
name or service name can be used?

I am surprised that this URL works, as indeed it does.

I cannot find this form under the supported Syntaxes in
http://download-uk.oracle.com/docs/c...s.htm#BEICDECB

According to the documentation, it should be

jdbc

racle:thin:@//ora1.mydomain.com:1583/db.prd1

Yours,
Laurenz Albe

#5

J?ns M?rtin Schl?tt?r <KmoEfrUewEbx (AT) spammotel (DOT) com> wrote:

Quote:

If I use sqlplus to connect to a database, I do it like that:

sqlplus user1/secret1 (AT) ora1 (DOT) mydomain.com:1583/db.prd1

where db.prd1 is the service_name.

That's using the EZCONNECT syntax, ok.

Quote:

If I do the connect through JDBC, the connection url is:

jdbc

racle:thin:@ora1.mydomain.com:1583:db1

SQLPLUS uses the service name, whereas JDBC uses the instance_name
(resp. sid).

How does this work? Is the oracle protocol so that either instance
name or service name can be used?

I am surprised that this URL works, as indeed it does.

I cannot find this form under the supported Syntaxes in
http://download-uk.oracle.com/docs/c...s.htm#BEICDECB

According to the documentation, it should be

jdbc

racle:thin:@//ora1.mydomain.com:1583/db.prd1

Yours,
Laurenz Albe

#6

Quote:

According to the documentation, it should be

jdbc

racle:thin:@//ora1.mydomain.com:1583/db.prd1

You are right, this also works. Thanks!

Martin

#7

Quote:

According to the documentation, it should be

jdbc

racle:thin:@//ora1.mydomain.com:1583/db.prd1

You are right, this also works. Thanks!

Martin

#8

Quote:

According to the documentation, it should be

jdbc

racle:thin:@//ora1.mydomain.com:1583/db.prd1

You are right, this also works. Thanks!

Martin

#9

Quote:

According to the documentation, it should be

jdbc

racle:thin:@//ora1.mydomain.com:1583/db.prd1

You are right, this also works. Thanks!

Martin

#10

On Nov 19, 5:32*am, Laurenz Albe <inv... (AT) spam (DOT) to.invalid> wrote:

Quote:

J?ns M?rtin Schl?tt?r <KmoEfrUew... (AT) spammotel (DOT) com> wrote:

If I use sqlplus to connect to a database, I do it like that:

sqlplus user1/secr... (AT) ora1 (DOT) mydomain.com:1583/db.prd1

where db.prd1 is the service_name.

That's using the EZCONNECT syntax, ok.

If I do the connect through JDBC, the connection url is:

jdbc

racle:thin:@ora1.mydomain.com:1583:db1

SQLPLUS uses the service name, whereas JDBC uses the instance_name
(resp. sid).

How does this work? Is the oracle protocol so that either instance
name or service name can be used?

I am surprised that this URL works, as indeed it does.

I cannot find this form under the supported Syntaxes inhttp://download-uk..oracle.com/docs/cd/B19306_01/java.102/b14355/urls....

According to the documentation, it should be

jdbc

racle:thin:@//ora1.mydomain.com:1583/db.prd1

Yours,
Laurenz Albe

http://download-west.oracle.com/docs...s.htm#g1073263
and scroll down a bit to "If you are using the Thin or OCI drivers,
note the following:"

Found in a google search of:
jdbc thin style syntax
which led to http://twit88.com/blog/2008/05/29/ne...g-jdbc-driver/
So, judging from googling, at least, it's just an older syntax.

jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/m...19simmons.html