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
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
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.