• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

Dumb Question Re: tnsnames.ora

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
"The Hood"
Posts: 8521
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic