Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can't connect to Oracle server

Re: Can't connect to Oracle server

From: Thomas R. Hummel <tom_hummel_at_hotmail.com>
Date: 10 Feb 2003 06:52:05 -0800
Message-ID: <a2c0eeb8.0302100652.5f343595@posting.google.com>


Thanks for the suggestions. I checked the file syntax and everything looked ok, but your post gave me an idea which worked. I renamed the tsnames.ora file and then ran the Net8 Assistant thinking that it would probably create a file from scratch. After going through the wizard for a local name it worked properly. The only difference that I see in the entry that I had added and the one added by the wizard was that the wizard used a full computer name for the entry, including the domain name, while my entry just had the computer name. I thought that I remembered seeing something that said that there was a default domain for the client, but maybe that wasn't set right. It's also possible that one of the other entries was incorrect, which is what I'm leaning towards. In any event, it's working now.

   Thanks again!

       -Tom.

Karsten Farrell <kfarrell_at_belgariad.com> wrote in message news:<MPG.18add8d229705ff0989692_at_news.la.sbcglobal.net>...
> I assume you meant that you have Oracle client installed on the same
> server as you have SQL Server, so you're doing an Oracle to Oracle
> connection.
>
> When you said you "copied the appropriate entry" do you mean you
> manually did that, with an editor? If so, are you sure you copied the
> *entire* entry, all the left and right parens? Oracle is very finicky
> about this file, and often won't report any syntax errors (but will just
> ignore the entry). Since Net8 Assistant (much better at what you want to
> do than the Net8 Configuration Assistant) is acting like you say, it
> sounds like it's attempting to process the file, but doesn't know what
> to do with a syntax error. Carefully count the parens and compare the
> entry in your SQL Server server's tnsnames.ora to another *working*
> file.
>
> If you can't see a syntax error, maybe you could post the entry on this
> NG. Sometimes those of us who've looked at tnsnames.ora entries till
> we're blue in the face, might spot something amiss.
Received on Mon Feb 10 2003 - 08:52:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US