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