Can this URL help create the TNSNAMES,ORA file?

I have Instant Client 11_2 and I am trying to create the TNSNAMES.ORA file.

When I log into Oracle 9.0, with the URL of "JDEPROD.XXX.COM" the URL in JDE shows:

Is 9418 the port? Or is it still 1521?

Can this information be used in my TNSNAMES.ORA file? Like this:

ORA11 =
     (ADDRESS = (PROTOCOL = TCP)(HOST = = 9418))
   (SID = ORA11

At the command prompt, if I run ping on JDEPROD.XXX.COM I see a different IP address than I do when I run ping on

Should I use one instead of the other?
Who is Participating?
JacobfwConnect With a Mentor Commented:
No the SID is determined by the DBA when the database is created.

you must have access to the Oracle database server but here are a view examples to find the SID

select * from global_name;

select sys_context('USERENV','INSTANCE_NAME') from dual;

select instance_name from v$instance;
c:\  tnsping server_name

c:\ echo $ORACLE_SID
The default port for Oracle is 1521.
You would normally just use the host name for your Oracle Server.
jkasavanAuthor Commented:
So host name "JDEPROD.XXX.COM". OK.

Do you know what the ":9418" is?
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

9418 is the web application port used for your JDE application?
jkasavanAuthor Commented:
Does any of this show the SID?
jkasavanAuthor Commented:
I really appreciate your input on this!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.