Posted on 2001-06-25
I am working with an exisitng Oracle database. I am having problems connecting to the database using SQL Net. I can connect using IPC on the server. Checked the tnsnames.ora file, the listener.ora file, verified that the entries match, checked the status of the listener (it is up), and I am at a lost! TNSPING is not resolving the connect descriptor that I have in the tnsnames file...however, if I enter TNSPING CNL-OVCOLLECT1 (where CNL-OVCOLLECT1 is the name of the SERVER, not the name of the sid, or the name of the connect descriptor in the tnsnames file!), then I get a good reply. So, I finally deleted the tnsnames.ora file from the network/admin folder (just for grins), and the tnsping command listed above still works. How is it resolving it? HELP!!!