What is ServiceName in oracle connection string.

Posted by Jitendrasoft09 under Oracle on 7/7/2017 | Points: 10 | Views : 246 | Status : [Member] [MVP] | Replies : 2
I confused with the service name which is used in oracle. Can we use in sql server. Why we use service name in oracle.

Jitendra Kumar
If my post helps you, plz mark as an answer.



Responses

Posted by: A2H on: 7/11/2017 [Member] [MVP] Silver | Points: 25

Up
0
Down
AFAIK you wont be able to use service name in sql server.

Per official documentation
The connect descriptor specifies the database service name with which clients seek to establish a connection. The listener knows which services can handle connection requests because an Oracle database dynamically registers this information with the listener. This process of registration is called service registration. Registration also provides the listener with information about the database instances and the service handlers available for each instance. A service handler can be a dispatcher or dedicated server.

Thanks,
A2H
My Blog

Jitendrasoft09, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: A2H on: 7/11/2017 [Member] [MVP] Silver | Points: 25

Up
0
Down
You can find more details from this link
https://docs.oracle.com/cd/E11882_01/network.112/e41945/concepts.htm#NETAG1036

Thanks,
A2H
My Blog

Jitendrasoft09, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response