Skip to Main Content

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

Panagiotis Konstantinidis
Answer

Hi Pamela,

Have your tried increasing the nodes text through skinning?

You could apply the following in your adf skin:

af|tree::node-stamp-text, af|tree::data-row:selected af|tree::node-stamp-text{

    font-size: x-large;

}

Regards

Marked as Answer by Pamela · Sep 27 2020
Amaan Junaid

Hi,

Try using this in the column of your table.

inlineStyle="line-height:40px;"

AJ

Pamela

It works great thanks!

Pamela

Perfect thanks!

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 30 2017
Added on May 26 2017
24 comments
60,305 views