• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 423
  • Last Modified:

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:

http://xxx-yyyynn.zzz.net:9418/jde/E1Menu.maf?jdeowpBackButtonProtect=PROTECTED

Is 9418 the port? Or is it still 1521?

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

***********************************
ORA11 =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = xxx-yyyynn.zzz.net)(PORT = 9418))
   )
 (CONNECT_DATA =
   (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 xxx-yyyynn.zzz.net.

Should I use one instead of the other?
0
jkasavan
Asked:
jkasavan
  • 3
  • 3
1 Solution
 
JacobfwCommented:
The default port for Oracle is 1521.
You would normally just use the host name for your Oracle Server.
0
 
jkasavanAuthor Commented:
So host name "JDEPROD.XXX.COM". OK.

Do you know what the ":9418" is?
0
 
JacobfwCommented:
9418 is the web application port used for your JDE application?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
jkasavanAuthor Commented:
Does any of this show the SID?
0
 
JacobfwCommented:
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
0
 
jkasavanAuthor Commented:
I really appreciate your input on this!
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now