jQuery in Action, 2nd edition*
The moose likes Beginning Java and the fly likes Dumb Question Re: tnsnames.ora Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "Dumb Question Re: tnsnames.ora" Watch "Dumb Question Re: tnsnames.ora" New topic
Author

Dumb Question Re: tnsnames.ora

Clay Lambert
Greenhorn

Joined: Dec 19, 2002
Posts: 1
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

Joined: Sep 29, 2000
Posts: 8521
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.


"JavaRanch, where the deer and the Certified play" - David O'Meara
Soumendu Munshi
Greenhorn

Joined: Jul 11, 2000
Posts: 12
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Dumb Question Re: tnsnames.ora