Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Dumb Question Re: tnsnames.ora

 
Clay Lambert
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
I'm new to this forum, and am enjoying the vast amount of good information here! I'd like to pick your brains with a stupid question, if I could: I am able to log into my database schema using a product called Golden32, from Benthic Software, locally using a connect string of TEAMS (please see my tnsnames.ora file, below). I have not been able to log into my database using that connect string from other machines, however, even though they're all on the same subnet. Can someone please tell me what I need to do or configure to get this to work? I would appreciate any help you could provide. Here's the tnsnames.ora file:
----------
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
TEAMS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ace-2ks-6650)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TEAMS.RRD.NET)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ace-2ks-6650)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = TEAMS.RRD.NET)
(PRESENTATION = http://admin)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
----------
Again, thanks for your help and patience...
Clay
 
Cindy Glass
"The Hood"
Sheriff
Posts: 8521
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Did you check the Windows Registry under Software/Oracle to make sure that you are updating the CORRECT tnsnames.ora file? You would be suprised how many machines have multiple versions installed and only one being looked at.
In addition there is another file that is paired with the tnsnames.ora file (I can't for the life of me remember the name, and I don't have Oracle installed at home to look it up). This other file defines the reference to use as a prefix in the tnsnames file.
A hint might be to see if any of the other connections on the other machines have prefixes on them.
Not much help . . . sorry.
 
Soumendu Munshi
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try with copying or appending the same Tnsnames.ora (which works) to other workstation. This MIGHT be due to not defining instance name properly also try this if above method doesn't work to check if connect string is correct and able to connect oracle server.
tnsping <oracle instance name>
Soum.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic