Can this URL help create the TNSNAMES,ORA file?

Posted on 2011-10-14
Last Modified: 2012-05-12
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?
Question by:jkasavan
    LVL 7

    Expert Comment

    The default port for Oracle is 1521.
    You would normally just use the host name for your Oracle Server.
    LVL 2

    Author Comment

    So host name "JDEPROD.XXX.COM". OK.

    Do you know what the ":9418" is?
    LVL 7

    Expert Comment

    9418 is the web application port used for your JDE application?
    LVL 2

    Author Comment

    Does any of this show the SID?
    LVL 7

    Accepted Solution

    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
    LVL 2

    Author Closing Comment

    I really appreciate your input on this!

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    sysaux tablespace 3 34
    jobsrunning 3 56
    Extract only part of data 5 76
    Add 0 to end of Number 21 58
    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now