Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference between Service Name and SID.

PsystecMay 26 2017 — edited Jun 2 2017

Hello Fellow Earthlings

I'm a bit new when it comes to creating Oracle drivers and I was the lucky winner assigned to make an oracle driver.

My driver works but, the connection string that the driver creates bypasses TNSnames, meaning its a bit of a manual string creation.

Currently my driver only replaces the SID variable and does not cater for Service_Names.

I know that Service Names are used in Cluster's and SID is a unique DB name usually, but beyond this is know nothing more.

Questions:

What is the difference between a Service Name and SID in the TNSnames? (technical answer if possible)

Can I use both in the TNSnames?

Kind Regards and thanks in advance.
This post has been answered by ddf_dba on May 26 2017
Jump to Answer

Comments

807591
does the program not print "executing cmd" ?
ok, first, what do you think should happen, and second, what is happening really?

you arent doing anything with the input and output streams of your program.. so i dont know what you expect
807591
I should have been thinking about it a little bit longer. After I added a 
waitFor()
and redirected the output as it is described in the article I posted the link to, everything worked as it should.
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 30 2017
Added on May 26 2017
#connection, #general-database-discussions
24 comments
60,302 views