Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Connecting
Also, just in case, see how many Tnsnames.ora files you have on your client. Sometimes when there are multiples, the third-party software may not be using the one you think it's using.
Van
"Joseph Ranseth" <webmaster_at_NOSPAM.worldcupfishing.com> wrote in message
news:U_Dd6.3524$wb7.86039_at_news1.mts.net...
> I assume that the connection is being done to a local database....right?
> Oracle applications will default to the local database, perhaps the third
> party tool you are using does not.
> Check to see that the SID is in your CONNECT_DATA in your tnsnames.ora
file.
> hth,
> --
> Joseph Ranseth - Webmaster
> World Cup Fishing
> http://www.worldcupfishing.com
>
> "Waldo Ricketts" <wricketts_at_mncppc.state.md.us> wrote in message
> news:t7dgess7fk0734_at_corp.supernews.com...
> > I'm having problems connecting, I get the error ORA-12504:TNS:Listener
was
> > not given the SID in connection, I have no problems win I run tnsping,
or
> > when I run SQL+ I only get this error when I try to connect using a
third
> > party application, is this a problem with the way I have Oracle setup or
> > do you think it is with the third party application. Thanks
> >
> > --
> > Posted via CNET Help.com
> > http://www.help.com/
>
>
Received on Tue Jan 30 2001 - 18:46:39 CST