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

Rajagopalan-Oracle
Answer

Java JNLP is not certified / supported to work with Forms 10g --->
Forms 11.1.2.2 client and Java Web Start, JNLP (Doc ID 2081779.1)
Running the Oracle Forms applet via Java Web Start and/or JNLP is ** NOT ** supported in Forms 11.1.2.2. However, Web Start and/or JNLP is supported from Oracle Forms version 12.2.1.
More details about the 12.2.1 forms client deployment options can be found in Document:2066505.1

Marked as Answer by Suresh Sangaran-Oracle · Sep 27 2022
User_WPTHP

Thank you for your comments Sir.
I try to run my form in Java web start through JNLP File its works fine my form is running successfully but the report is not running, when on internet explorer i run my form and report both working fine but in JNLP File only forms work.

Jiju Mathew

I try to run my form in Java web start through JNLP File its works fine my form is running successfully but the report is not running, when on internet explorer i run my form and report both working fine but in JNLP File only forms work.

I also facing same issue. please help me.

1 - 3
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,098 views